Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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