Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

(1) I already downloaded and formatted the data for estimating a Fama-french 3 -factor model for MSPT (2) Add the Data Analysis Excel add-in (7)

image text in transcribed
image text in transcribed
(1) I already downloaded and formatted the data for estimating a Fama-french 3 -factor model for MSPT (2) Add the "Data Analysis" Excel add-in (7) Learn how to do "Excel multivariate regression" on the internet (4) Regress the data in column SH on the data in columns SE, SF, and SG (S) Send the output of the Riegresslon into a new workshet (6) interpres the value of the 3 betas (coefficients) you estimated (6.a) What does a positive or negative beta means (6. b) Oiscuss the value for the Market beta(coefficient) and what it means. (5.c) Discuss the value of the SMB beta coefficient and what it means (6.d) Oiscuss the value of the HMt beta coeflicient and what is means \begin{tabular}{|c|c|c|c|c|c|} \hline date & & Mkt-RF & SMB & HML & if \\ \hline & 7/1/26 & 0.0127 & -0.0105 & -0.0120 & 0.0010 \\ \hline & 8/1/26 & 0.0113 & -0.0064 & 0.0176 & 0.0011 \\ \hline & 9/1/26 & 0.0016 & -0.0061 & 0.0005 & 0.0010 \\ \hline & 10/1/26 & -0.0143 & -0.0006 & 0.0028 & 0.0014 \\ \hline & 11/1/26 & 0.0109 & -0.0007 & -0.0017 & 0.0013 \\ \hline & 12/1/26 & 0.0112 & -0.0001 & 0.0000 & 0.0012 \\ \hline & 1/1/27 & -0.0003 & -0.0022 & 0.0201 & 0.0011 \\ \hline & 2/1/27 & 0.0178 & -0.0011 & 0.0140 & 0.0011 \\ \hline & 3/1/27 & 0.0006 & -0.0083 & -0.0113 & 0.0013 \\ \hline & 4/1/27 & 0.0020 & 0.0021 & 0.0031 & 0.0011 \\ \hline & 5/1/27 & 0.0230 & 0.0063 & 0.0211 & 0.0013 \\ \hline & 6/1/27 & -0.0103 & 0.0022 & -0.0067 & 0.0011 \\ \hline 3 & 7/1/27 & 0.0304 & -0.0143 & -0.0050 & 0.0013 \\ \hline 4 & 8/1/27 & 0.0085 & -0.0030 & -0.0166 & 0.0012 \\ \hline 15 & 9/1/27 & 0.0202 & -0.0161 & -0.0027 & 0.0009 \\ \hline 26 & 10/1/27 & -0.0191 & 0.0091 & -0.0192 & 0.0011 \\ \hline 27 & 11/1/27 & 0.0277 & 0.0117 & -0.0012 & 0.0009 \\ \hline 28 & 12/1/27 & 0.0090 & 0.0042 & -0.0049 & 0.0010 \\ \hline 29 & 1/1/28 & -0.0030 & 0.0181 & -0.0033 & 0.0011 \\ \hline 30 & 2/1/28 & -0.0074 & -0.0090 & -0.0028 & 0.0014 \\ \hline 31 & 3/1/28 & 0.0367 & -0.0011 & -0.0053 & 0.0013 \\ \hline 32 & 4/1/28 & 0.0180 & 0.0169 & 0.0147 & 0.0010 \\ \hline 33 & 5/1/28 & 0.0066 & 0.0122 & -0.0144 & 0.0014 \\ \hline 34 & 6/1/28 & -0.0216 & -0.0156 & -0.0001 & 0.0013 \\ \hline 35 & 7/1/28 & 0.0027 & -0.0058 & -0.0022 & 0.0014 \\ \hline 36 & 8/1/28 & 0.0281 & -0.0090 & -0.0094 & 0.0014 \\ \hline 37 & 9/1/28 & 0.0123 & 0.0103 & 0.0037 & 0.0012 \\ \hline 38 & 10/1/28 & 0.0057 & 0.0095 & -0.0095 & 0.0018 \\ \hline 39 & 11/1/28 & 0.0485 & -0.0078 & 0.0116 & 0.0016 \\ \hline 40 & 12/1/28 & 0.0016 & -0.0038 & -0.0028 & 0.0003 \\ \hline 41 & 1/1/29 & 0.0198 & -0.0157 & -0.0054 & 0.0015 \\ \hline 42 & 2/1/29 & -0.0015 & -0.0017 & 0.0072 & 0.0016 \\ \hline 43 & 3/1/29 & -0.0039 & -0.0210 & 0.0068 & 0.0015 \\ \hline 44 & 4/1/29 & 0.0062 & -0.0042 & 0.0026 & 0.0016 \\ \hline 45 & 5/1/29 & -0.0287 & -0.0240 & -0.0062 & 0.0019 \\ \hline 46 & 6/1/29 & 0.0402 & -0.0095 & 0.0123 & 0.0023 \\ \hline 47 & 7/1/29 & 0.0190 & -0.0171 & 0.0114 & 0.0014 \\ \hline 48 & 8/1/29 & 0.0341 & -0.0434 & 0.0000 & 0.0017 \\ \hline 49 & 9/1/29 & -0.0244 & 0.0051 & -0.0027 & 0.0015 \\ \hline 50 & 10/1/29 & -0.0976 & -0.0178 & 0.0325 & 0.0020 \\ \hline 51 & 11/1/29 & -0.0592 & -0.0079 & 0.0221 & 0.0016 \\ \hline 52 & 12/1/29 & 0.0057 & -0.0199 & -0.0026 & 0,0016 \\ \hline 53 & 1/1/30 & 0.0237 & 0.0151 & -0.0040 & 0.0006 \\ \hline 4 & D & FF-3factor & MSFT & 6. D & ussion \\ \hline \end{tabular} (1) I already downloaded and formatted the data for estimating a Fama-french 3 -factor model for MSPT (2) Add the "Data Analysis" Excel add-in (7) Learn how to do "Excel multivariate regression" on the internet (4) Regress the data in column SH on the data in columns SE, SF, and SG (S) Send the output of the Riegresslon into a new workshet (6) interpres the value of the 3 betas (coefficients) you estimated (6.a) What does a positive or negative beta means (6. b) Oiscuss the value for the Market beta(coefficient) and what it means. (5.c) Discuss the value of the SMB beta coefficient and what it means (6.d) Oiscuss the value of the HMt beta coeflicient and what is means \begin{tabular}{|c|c|c|c|c|c|} \hline date & & Mkt-RF & SMB & HML & if \\ \hline & 7/1/26 & 0.0127 & -0.0105 & -0.0120 & 0.0010 \\ \hline & 8/1/26 & 0.0113 & -0.0064 & 0.0176 & 0.0011 \\ \hline & 9/1/26 & 0.0016 & -0.0061 & 0.0005 & 0.0010 \\ \hline & 10/1/26 & -0.0143 & -0.0006 & 0.0028 & 0.0014 \\ \hline & 11/1/26 & 0.0109 & -0.0007 & -0.0017 & 0.0013 \\ \hline & 12/1/26 & 0.0112 & -0.0001 & 0.0000 & 0.0012 \\ \hline & 1/1/27 & -0.0003 & -0.0022 & 0.0201 & 0.0011 \\ \hline & 2/1/27 & 0.0178 & -0.0011 & 0.0140 & 0.0011 \\ \hline & 3/1/27 & 0.0006 & -0.0083 & -0.0113 & 0.0013 \\ \hline & 4/1/27 & 0.0020 & 0.0021 & 0.0031 & 0.0011 \\ \hline & 5/1/27 & 0.0230 & 0.0063 & 0.0211 & 0.0013 \\ \hline & 6/1/27 & -0.0103 & 0.0022 & -0.0067 & 0.0011 \\ \hline 3 & 7/1/27 & 0.0304 & -0.0143 & -0.0050 & 0.0013 \\ \hline 4 & 8/1/27 & 0.0085 & -0.0030 & -0.0166 & 0.0012 \\ \hline 15 & 9/1/27 & 0.0202 & -0.0161 & -0.0027 & 0.0009 \\ \hline 26 & 10/1/27 & -0.0191 & 0.0091 & -0.0192 & 0.0011 \\ \hline 27 & 11/1/27 & 0.0277 & 0.0117 & -0.0012 & 0.0009 \\ \hline 28 & 12/1/27 & 0.0090 & 0.0042 & -0.0049 & 0.0010 \\ \hline 29 & 1/1/28 & -0.0030 & 0.0181 & -0.0033 & 0.0011 \\ \hline 30 & 2/1/28 & -0.0074 & -0.0090 & -0.0028 & 0.0014 \\ \hline 31 & 3/1/28 & 0.0367 & -0.0011 & -0.0053 & 0.0013 \\ \hline 32 & 4/1/28 & 0.0180 & 0.0169 & 0.0147 & 0.0010 \\ \hline 33 & 5/1/28 & 0.0066 & 0.0122 & -0.0144 & 0.0014 \\ \hline 34 & 6/1/28 & -0.0216 & -0.0156 & -0.0001 & 0.0013 \\ \hline 35 & 7/1/28 & 0.0027 & -0.0058 & -0.0022 & 0.0014 \\ \hline 36 & 8/1/28 & 0.0281 & -0.0090 & -0.0094 & 0.0014 \\ \hline 37 & 9/1/28 & 0.0123 & 0.0103 & 0.0037 & 0.0012 \\ \hline 38 & 10/1/28 & 0.0057 & 0.0095 & -0.0095 & 0.0018 \\ \hline 39 & 11/1/28 & 0.0485 & -0.0078 & 0.0116 & 0.0016 \\ \hline 40 & 12/1/28 & 0.0016 & -0.0038 & -0.0028 & 0.0003 \\ \hline 41 & 1/1/29 & 0.0198 & -0.0157 & -0.0054 & 0.0015 \\ \hline 42 & 2/1/29 & -0.0015 & -0.0017 & 0.0072 & 0.0016 \\ \hline 43 & 3/1/29 & -0.0039 & -0.0210 & 0.0068 & 0.0015 \\ \hline 44 & 4/1/29 & 0.0062 & -0.0042 & 0.0026 & 0.0016 \\ \hline 45 & 5/1/29 & -0.0287 & -0.0240 & -0.0062 & 0.0019 \\ \hline 46 & 6/1/29 & 0.0402 & -0.0095 & 0.0123 & 0.0023 \\ \hline 47 & 7/1/29 & 0.0190 & -0.0171 & 0.0114 & 0.0014 \\ \hline 48 & 8/1/29 & 0.0341 & -0.0434 & 0.0000 & 0.0017 \\ \hline 49 & 9/1/29 & -0.0244 & 0.0051 & -0.0027 & 0.0015 \\ \hline 50 & 10/1/29 & -0.0976 & -0.0178 & 0.0325 & 0.0020 \\ \hline 51 & 11/1/29 & -0.0592 & -0.0079 & 0.0221 & 0.0016 \\ \hline 52 & 12/1/29 & 0.0057 & -0.0199 & -0.0026 & 0,0016 \\ \hline 53 & 1/1/30 & 0.0237 & 0.0151 & -0.0040 & 0.0006 \\ \hline 4 & D & FF-3factor & MSFT & 6. D & ussion \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions