Use the following Excel output to fill in the following blanks (do NOT round, fill in the number as it appears in the output): 1. The R square is:
2. The SSM (sum of squares of the model) is:
3. The SST (total sum of squares) is:
4. The MSE (mean square of error) is:
5. The F test statistic is calculated as:
6. The regression coefficient for X variable 3 is:
7. At significance level of 5%, I need to drop X variable: (fill in 1, 2, 3, or 4) from the regression model as its coefficient is not significant from 0.
Regression Statistics
Multiple R 0.608561172
R Square 0.3703467
Adjusted R Square0.343834982
Standard Error13727.82894
Observations 100
ANOVA
df SS MS F Significance F
Regression410530144186263253604713. 969170215.32886E-09
Residual 9517903062297188453287.3
Total 9928433206483
CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept-11838.79498580.401941-1.3 79748290.170903015-28873.046475195. 45666-28873.04655195.456661
X Variable 12975.504877562.98179485.2852594967 .98106E-071857.8447044093.165051857 .8447044093.16505
X Variable 2-11024.579072761.137846-3.99276663 50.000128667-16506.13074-5543.0274- 16506.1307-5543.02739
X Variable 3318.4684669122.8495762.592344860.0 1103721874.58122284562.35571174.581 22284562.355711
X Variable 45201.8546683163.1576931.6445132280 .103375496-1077.80731711481.5167-10 77.8073211481.51665