Question: The attached Excel File contains information regarding the returns (%) on the S&9 500 Market Index and the returns (%) on Amazon Stocks over a

The attached Excel File contains information regarding the returns (%) on the S&9 500 Market Index and the returns (%) on Amazon Stocks over a period of time.

  1. Please run a regression with the returns on Amazon Stocks as the dependent variable and the returns on the S&P 500 as the independent variable and present your regression output.
  2. Are the intercept and slope coefficients statistically different from O at the 1%, 5%, and 10% levels?
  3. What does the R-square imply?
  4. Based on the regression results, what is the predicted return on Amazon Stock if the return on the S&P 500 is 10% (0.1)?
The attached Excel File contains information regarding the returns (%) on

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!

Q:

The attached Excel File contains information regarding the returns (%) on the S&9 500 Market Index and the returns (%) on Amazon Stocks over a period of time. S&P500 Amazon 0.030 0.042 0.030 0.052...

Q:

The attached Excel sheet contains data on annual returns on IBM and 3M stocks over the period 1990-2002, as well as annual returns on S&P 500 Index and one-year U.S. Treasury bills for this period....

Q:

For this exercise you would need to use the spreadsheet mini-case.xls posted on Blackboard The file contains information about monthly returns of ten momentum portfolios. The portfolios are formed as...

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

Read the case then answer the questions in Excel -- Marriott Corporation: The Cost of Capital (Abridged) In April 1988, Dan Cohrs, vice president of project finance at the Marriott Corporation, was...

Q:

Help Needed! Really struggling with this project and it is due in 6 days. AutoSave . Off) H Project 1_2020 Fall - Saved to this PC O Search Andrew Warren AW X File Home Insert Draw Design Layout...

Q:

Read this case and answer the following Questions in Excel using WACC Marriott Corporation: The Cost of Capital (Abridged) In April 1988, Dan Cohrs, vice president of project finance at the Marriott...

Q:

Directions are copy and pasted in here as well as attached. Excel sheets with information are attached as well. Please help. Deadline is 9pm tonight. The objectives of this exercise: 1. To perform...

Q:

Assume that there are no corporate taxes (i.e. = 0). You may also assume that debt is riskless (i.e., D =0). All tables are provided. Please show steps. Question 1. Compute the a sset beta and cost...

Q:

Hello ther, I need help with my finance case study (Ramsey Co. Case study). Please see the attachments for details and instructions. Thanks, Ramsey Inc. 2013 Purchase Order Register March 1, 2013 -...

Q:

The following table gives the total payroll (in millions of dollars) on the opening day of the 2011 season and the percentage of games won during the 2011 season by each of the American League...

Q:

Discuss how the FDA is funded and how this could impact the FDA.

Q:

which of these accounts would be closed at year - end? retained earnings, purchase discounts

Q:

Use the following dataset to find Euclidian, Manhattan and Minkowski Distance between object A and B. Assume lambda (h) is 3. Object / Attribute Cost Time Weight Incentive Object A 0 3 4 5 Object B 7...