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. Download the weekly ending prices for the last 52 weeks for each of these, and use the trading symbols as the column headings. Run a separate regression function for each equity against the S&P 500 (^GSPC). Run a multiple regression function using both equities against the S&P 500. 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. Using the X/Y (scatter) chart function in Excel, plot the actual ^GSPC values against the projected values. Post the final Excel file showing all price data, regression functions, plot data and the X/Y (scatter) chart. 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.
Looking for a solution written from scratch with No plagiarism and No AI?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |