I have attached a screenshot of what my excel workbook looks like

• This Excel file reports several financial entries for firms in SP500 index
• There are multiple sheets, each one associated with a given fiscal year; the year’s range from 2001-2017 (17 fiscal year’s total)
• This screenshot displays the 2001 worksheet; every other worksheet such as 2002 2003 and so on, display the same first row (the only difference in each worksheet is all the other rows, from row 2 and beyond)

I need to answer the following questions using this worksheet…

# Question 2: Using pd.pivot_table function to get the Average 'Revenue - Total' for each ticker. # Which ticker has the highest average ‘Revenue – Total’`
Code
Error message

# Question 3: Using pd.pivot_table function to get the Total of 'Revenue - Total' for each Year. # Which year has the highest total Revenue`
Code
Error

# Question 4: Using pd.pivot_table function to get the Total Net Income (Loss) for each Year and Ticker. # Which Ticker and year has the highest total Net Income (Loss)
# If it is WMT in 2015, please put WMT2015 in the answer
Code
Error

# Question 6: Outlier detection # Identify row (ticker, year and quarter) with the worst Income and Revenue No code; unsure how to do

# Question 7: # What is the correlation coefficient for ‘Assets – Total’ and ‘Revenue – Total’ No code; unsure how to do

# Question 8: Run a regression of Revenue - Total on Research and Development Expense # What is the coefficient for Research and Development Expense No code; unsure how to do

# Question 9: Run a regression of Net Income (Loss) on: Revenue - Total and Assets - Total # What is the coefficient for Revenue – Total“
`No code; unsure how to do