Question
This question requires you to run regression in excel and estimate the beta coefficient for Wells Fargo using the monthly total returns of Wells Fargo
This question requires you to run regression in excel and estimate the beta coefficient for Wells Fargo using the monthly total returns of Wells Fargo and S&P 500 Index with a sample period of 5 years. You are required to show the regression output including R-square and ANOVA (Analysis of Variance) table. Use the table provided below.
| Date | S&P 500 Index | Wells Fargo stock price |
| 01/12/2017 | 16209.1 | 60.22 |
| 01/01/2018 | 15951.7 | 61.18 |
| 01/02/2018 | 15442.7 | 61 |
| 01/03/2018 | 15367.3 | 60.27 |
| 01/04/2018 | 15607.9 | 59.44 |
| 01/05/2018 | 16061.5 | 62.99 |
| 01/06/2018 | 16277.7 | 63.32 |
| 01/07/2018 | 16434 | 64.22 |
| 01/08/2018 | 16262.9 | 66.03 |
| 01/09/2018 | 16073.1 | 65.89 |
| 01/10/2018 | 15027.3 | 61.31 |
| 01/11/2018 | 15197.8 | 62.3 |
| 01/12/2018 | 14322.9 | 57.47 |
| 01/01/2019 | 15540.6 | 62.67 |
| 01/02/2019 | 15999 | 64.54 |
| 01/03/2019 | 16102.1 | 62.03 |
| 01/04/2019 | 16580.7 | 65.37 |
| 01/05/2019 | 16037.5 | 63.84 |
| 01/06/2019 | 16382.2 | 66.1 |
| 01/07/2019 | 16406.6 | 66.65 |
| 01/08/2019 | 16442.1 | 62.97 |
| 01/09/2019 | 16658.6 | 67.38 |
| 01/10/2019 | 16483.2 | 65.6 |
| 01/11/2019 | 17040.2 | 67.48 |
| 01/12/2019 | 17063.4 | 64.17 |
| 01/01/2020 | 17318.5 | 64.44 |
| 01/02/2020 | 16263.1 | 61.45 |
| 01/03/2020 | 13378.8 | 53.25 |
| 01/04/2020 | 14780.7 | 51.76 |
| 01/05/2020 | 15192.8 | 53.2 |
| 01/06/2020 | 15515.2 | 54.65 |
| 01/07/2020 | 16169.2 | 53.46 |
| 01/08/2020 | 16514.4 | 59.47 |
| 01/09/2020 | 16121.4 | 56.34 |
| 01/10/2020 | 15580.6 | 53.72 |
| 01/11/2020 | 17190.3 | 64.12 |
| 01/12/2020 | 17433.4 | 66.56 |
| 01/01/2021 | 17337 | 67.06 |
| 01/02/2021 | 18060.3 | 72.16 |
| 01/03/2021 | 18700.7 | 76.66 |
| 01/04/2021 | 19108.3 | 79.04 |
| 01/05/2021 | 19731 | 82.06 |
| 01/06/2021 | 20165.6 | 82.03 |
| 01/07/2021 | 20287.8 | 78.33 |
| 01/08/2021 | 20582.9 | 78.08 |
| 01/09/2021 | 20070.3 | 79.91 |
| 01/10/2021 | 21037.1 | 85.61 |
| 01/11/2021 | 20660 | 86.71 |
| 01/12/2021 | 21222.8 | 93.28 |
| 01/01/2022 | 21098.3 | 97.93 |
| 01/02/2022 | 21126.4 | 99.26 |
| 01/03/2022 | 21890.2 | 96.26 |
| 01/04/2022 | 20762 | 90.05 |
| 01/05/2022 | 20729.3 | 94.65 |
| 01/06/2022 | 18861.4 | 82.66 |
| 01/07/2022 | 19692.9 | 81.45 |
| 01/08/2022 | 19330.8 | 83.63 |
| 01/09/2022 | 19987.2 | 83.86 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Real Estate Development Principles And Process
Authors: Mike E. Miles, Laurence M. Netherton, Adrienne Schmitz
5th Edition
0874203430, 978-0874203431
