Question: how to calculate regression data in Excel the data given below, formulas too, please? Date Mkt-RF SMB HML RF 2/28/2017 0.0357 -0.0202 -0.0168 0.0004 3/31/2017
how to calculate regression data in Excel the data given below, formulas too, please?
| Date | Mkt-RF | SMB | HML | RF |
| 2/28/2017 | 0.0357 | -0.0202 | -0.0168 | 0.0004 |
| 3/31/2017 | 0.0017 | 0.0114 | -0.0332 | 0.0003 |
| 4/28/2017 | 0.0109 | 0.0072 | -0.021 | 0.0005 |
| 5/31/2017 | 0.0106 | -0.0252 | -0.0378 | 0.0006 |
| 6/30/2017 | 0.0078 | 0.0223 | 0.0148 | 0.0006 |
| 7/31/2017 | 0.0187 | -0.0146 | -0.0024 | 0.0007 |
| 8/31/2017 | 0.0016 | -0.0167 | -0.0209 | 0.0009 |
| 9/29/2017 | 0.0251 | 0.0446 | 0.0312 | 0.0009 |
| 10/31/2017 | 0.0225 | -0.0193 | 0.0021 | 0.0009 |
| 11/30/2017 | 0.0312 | -0.0058 | -0.0008 | 0.0008 |
| 12/29/2017 | 0.0106 | -0.0132 | 0.0005 | 0.0009 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
