Show transcribed image text Use the following scenario to answer the question. Scenaio: Consider the following summary output from Microsoft Excel for a simple regression of company XYZ weekly stock prices vs the S&P5D0 stock index, for the period January 2004 through August 2006 Consider XYZ's stock price to be the dependent variable and the S&P500 index to be the independent variable SUMMARY OUTPUT Regression Statistics Multiple R R Square AdjustedR Standard Error Observations 0.93 0.87 0.86 3.20 140 ANOVA MS Residual Total 138 139 9067.88 9067.8 884.90 6.84E-62 XXXXXX 1024 10482.0 Coefficients Standard tStat P-value Lower 95% Upper Intercept S&P500 Index 121.65 0.122 4.914 24.74 1.37E-52 0.004 29.75 6,84E-62 131.37 0.11 111.93 0.13 What is the SSE value from the MS Excel output? Approximately 2014 Approximately 1414 O Approximately 2414 Not possible to detenmine
Use the following scenario to answer the question. Scenaio: Consider the following summary output from Microsoft Excel for a simple regression of company XYZ weekly stock prices vs the S&P5D0 stock index, for the period January 2004 through August 2006 Consider XYZ's stock price to be the dependent variable and the S&P500 index to be the independent variable SUMMARY OUTPUT Regression Statistics Multiple R R Square AdjustedR Standard Error Observations 0.93 0.87 0.86 3.20 140 ANOVA MS Residual Total 138 139 9067.88 9067.8 884.90 6.84E-62 XXXXXX 1024 10482.0 Coefficients Standard tStat P-value Lower 95% Upper Intercept S&P500 Index 121.65 0.122 4.914 24.74 1.37E-52 0.004 29.75 6,84E-62 131.37 0.11 111.93 0.13 What is the SSE value from the MS Excel output? Approximately 2014 Approximately 1414 O Approximately 2414 Not possible to detenmine