Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need guidance for a Excel multivariate regression based on the info below. Regress the data in Column H on the data in Column E, F,

Need guidance for a "Excel multivariate regression" based on the info below.

Regress the data in Column H on the data in Column E, F, G

What does the beta mean?

What does the Market beta mean?

What does the SMB beta mean?

What does the HML beta mean?

image text in transcribed
A B C D E F G H 1 Date Adj Close Log-return Fama-French 3 factors MSFT 2 5/1/2017 65.19458 rf Mkt-RF SMB HML R-rf 6/1/2017 64.71392 -0.007399996 0.00026 0.003374 0.009578 0.006423 -0.00766 4 7/1/2017 68.25334 0.053250059 0.000304 0.008046 -0.00639 -0.00096 0.052946 5 8/1/2017 70.19672 0.028075129 0.000391 0.000694 -0.00723 -0.00908 0.027684 6 9/1/2017 70.30644 0.001561901 0.000391 0.010766 0.018908 0.013217 0.001171 7 10/1/2017 78.50841 0.110342297 0.000391 0.009663 -0.00846 0.000954 0.109952 8 11/1/2017 79.44279 0.011831375 0.000347 0.013343 -0.00244 -0.00022 0.011484 9 12/1/2017 81.14134 0.021155408 0.000391 0.004579 -0.00577 0.00013 0.020765 10 1/1/2018 90.12434 0.104997717 0.000477 0.023582 -0.01403 -0.00595 0.10452 11 2/1/2018 88.94811 -0.01313704 0.000477 -0.01615 0.001128 -0.0045 -0.01361 12 3/1/2018 86.98335 -0.022336525 0.000521 -0.01033 0.017284 -0.001 -0.02286

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Interest Theory

Authors: Leslie Jane, James Daniel, Federer Vaaler

3rd Edition

147046568X, 978-1470465681

More Books

Students also viewed these Mathematics questions