Stock price regression model | Business & Finance homework help

Stock price regression model | Business & Finance homework help.


Watch the video about how to download stock price data from Yahoo! Finance into an Excel spreadsheet and complete the functions in this assignment. Then download your own copies of the prices for the S&P 500 (^GSPC) and for two equities using your first and last names. Again, watch my video(s) to see how this is done.

  1. Download the weekly ending prices for the last 52 weeks for each of these, and use the trading symbols as the column headings.
  2. Run a separate regression function for each equity against the S&P 500 (^GSPC).
  3. Run a multiple regression function using both equities against the S&P 500.
  4. Use the resulting three equations to plot expected values of S&P 500 (^GSPC) using the intercepts and equity values in the three regression equations.
  5. Using the X/Y (scatter) chart function in Excel, plot the actual ^GSPC values against the projected values.
  6. Post the final Excel file showing all price data, regression functions, plot data and the X/Y (scatter) chart.
  7. Include a brief (25 word) discussion of your conclusion(s) when you upload the file (format: xls or xlsx only).

You must use Excel for this exercise. Do not use SAS, SPSS or another spreadsheet or statistical package.

Stock price regression model | Business & Finance homework help

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
All your data is secure and will never be disclosed to third parties. Your essay or assignment is treated as your intellectual property and can never be shared or provided as a sample to aspiring customers.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
You will never have to worry about deadlines – 98% of our assignments are completed on time.
Money Back
We give refunds anytime you feel the work did not meet your expectations. However, we have not refunded any papers in the last 6 months as our team keeps improving their quality and customer service.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of writers and tutors. We are here for you.
Power up Your Study Success with Experts We’ve Got Your Back.