Answered step by step
Verified Expert Solution
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)
(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
Get Instant Access with AI-Powered 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