Question: 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

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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

a. Multiple regression : Use the Regression tool to determine a regression equation using the following two independent variables(1) units produced and (2) number of production batches and using...

Excel Dataset: https://docs.google.com/spreadsheets/d/1GAK-5oTUXyLSNTdSzZrs7MEXWtocYMC2jXcl0jbqW2I/edit?usp=sharing A new report says closing the digital divide between Indigenous and other...

ONLY QUESTION 1A Task 0.A (2 points) In a code chunk, load the wooldridge, lmtest, sandwich, and AER packages. If you have not yet installed all of them, then do so. Remember, you never ever use...

ONLY TASK 1.A Task 0.A (2 points) In a code chunk, load the wooldridge, lmtest, sandwich, and AER packages. If you have not yet installed all of them, then do so. Remember, you never ever use...

This is an individual assignment. Please download the dataset ( Week - 1 - Homework.xlsx ) and do the following work: 1 ) Use New Drug data ( Hint: Please copy and paste the data on worksheet New...

I need help with step one not sure if I'm doing this right. I have done Q1 and Q2 of step one but I'm a little lost and need some direction. Lab Exercise: Markowitz 3 Asset Portfolio Efficient...

I need help completing Step 1, I've started it and answered Q1 and Q2... but I need some direction and my work checked. Also, how to compute the tangent portfolio and line. Lab Exercise: Markowitz 3...

Answer all the questions Given the discussions we had during lecture one, use your understanding and knowledge gained from such lecture and answer the following questions. Kindly submit online, your...

Use pivot table, privot chart, and basic excel functions to answer the following questions for data in "econ" tab. 1. For each of the variables in the next tab "econ": what is the average, the...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Daniel Jackson, CEO of OCH, has approached you to work on 2 investment proposals that the company is considering: Buying coffee roaster plant in Mexico. The Reconstruction of coffee shops to add the...

U.S. Government-wide Annual Report. Obtain the most recent audited annual financial report of the U.S. government. It is available from the Government Accountability Office (GAO). Required a. Did the...

You are considering the investment project summarized by the cash flows and timeline below. If the discount rate is 9 % , what is the net present value of this project? Would you accept or reject the...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...