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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!