2. Use the data given in the tab "Monthly returns" to answer the following questions

A) Create a scatter plot to show that the relationship between the returns on AAPL and the S&P50. Describe, in words, the relationship between the returns of AAPL and the S&P500. 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 R2 on the chart. Does this equation confirm your guess from part a? How much of the variability in AAPL returns can be explained byvariability in the broad market? Repeat for FCNTX.

C) Using the Analysis ToolPak add-in, run a regression analysis on this data. Your dependent variable is the AAPL returns, and the independent variable is the S&P 500 returns. Does this confirm the earlier results? The slope coefficient is AAPLs beta. Is the beta of this stock statistically significant? Explain.

D) Repeat part C using the returns on FCNTX and the S&P 500. Compare the R2 from both regressions. What conclusions can you draw from the difference