3.the spreadsheet file" chapter 5 problem 3.XLsx" (to find the student spreadsheet for financial analysis with Microsoft excel, eight edition go to www.cengagebrain .com)contains monthly total returns for the S&P 500 index, Apple ,Inc (AAPL),and fidelity contrafund (FCNTX)from September 2011 to august 2016(60 months)

a. create a scatter plot to show the relationship between the returns on AAPL and the S&P 500.Decribe, in words, the relationship between the returns of AAPL and the S&P 500. Estimate the slope of a regression equation of this data. repeat for FCNTX

b. Add a linear trend line to the chart ,and place the equation and R^2on the chart .does this equation confirm your guess from part a? how much of the variability in AAPL returns can be explained by variability in the broad market? repeat for FCNTX