Boost your Grades with us today!

Business & Finance homework help

Business & Finance homework help. Watch the video https://youtu.be/KEFpqExg6UA 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.

Business & Finance homework help

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.