TABLE 11.3.18 Monthly Percentage Changes for Stock Market Indexes and for Micros
ID: 3318024 • Letter: T
Question
TABLE 11.3.18 Monthly Percentage Changes for Stock Market Indexes and for Microsoft Date 4/1/2010 3/1/2010 2/1/2010 1/4/2010 12/1/2009 11/2/2009 10/1/2009 9/1/2009 8/3/2009 7/2/2009 6/1/2009 5/1/2009 4/1/2009 3/2/2009 2/2/2009 1/2/2009 12/1/2008 11/3/2008 1 0/2/2008 9/1/2008 8/1/2008 7/2/2008 6/2/2008 5/1/2008 4/1/2008 Hang Seng Index (%) FTSE 100 Index (%) S&P; 500 Index (96) Microsoft (%) 2.56 6.07 3.20 5.39 4.32 3.06 2.42 8.00 0.23 0.32 3.81 6.24 5.88 2.85 3.70 2.21 7.55 3.66 6.51 7.81 4.34 5.39 4.28 2.90 5.74 4.58 3.57 6.52 3.36 13.74 3.78 10.28 13.79 -4.93 12.06 3.81 -8.85 -16.33 2.20 6.51 -6.50 2.86 -0.33 3.82 17.07 14.33 5.97 3.51 8.09 2.51 7.70 -6.42 5.31 9.39 8.54 10.99 -8.57 0.78 3.59 0.58 22.47 15.27 6.46 2.85 9.91 4.75 12.72 2.04 10.71 13.02 16.94 9.08 1.22 -0.99 -8.60 1.07 4.75 -0.56 6.76Explanation / Answer
a). Let us fit a simple regression model between Microsoft and S&P500 Index, using Excel Analysis Tool Pack.
The resulting Regression Coefficients, t-values and p-values are given below:
Since the P-value for the regression coefficient is < 0.01, the regression is significant at 99% confidence level.
Hence Microsoft is significantly related to S&P 500.
b) Similarly let us fit a simple regression model between Microsoft and FTSE 100 Index.
The results are given below:
Here also, since the P-value for the regression coefficient is < 0.01, the regression is significant at 99% level.
Hence Microsoft is significantly related to FTSE 100.
c) Let us next fit a simple regression model between Microsoft and Hang Seng Index.
The results are given below:
Again, since the P-value for the regression coefficient is < 0.01, the regression is significant at 99% level.
Hence Microsoft is significantly related to the Hang Seng Index.
d) The coefficientf determination of Microsoft against each of the above indices is given below:
S&P 500 0.5573
FTSE 100 0.3111
Hang Seng 0.2973
From the above values it clear that Microsoft significantly depends on all 3 major indices of the global economy.
However, the dependence on S&P 500 (US Economy) is much higher than the other 2 Indices.
Coefficients Standard Error t Stat P-value Intercept 0.886227345 1.027973293 0.862111254 0.397526177 X Variable 1 0.83465037 0.155111911 5.380956013 1.82214E-05Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.