Please write the test and F test equation for the below data. Data Set 1 f Multi
ID: 3221888 • Letter: P
Question
Please write the test and F test equation for the below data.
Data Set 1 f Multiple R 0.715146224 R Square 0.511434122 Adjusted R Square 0.50146339 Standard Error 10056.07999 Observations 51 ANOVA df SS MS F Significance F Regression 1 5187045843 5187045843 51.2935371 3.72434E-09 Residual 49 4955112489 101124744.7 Total 50 10142158332 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 32508.21337 8663.053482 3.752512142 0.000464102 15099.15562 49917.27113 15099.15562 49917.27113 Median Household Income 0.959364257 0.133952928 7.161950649 3.72434E-09 0.690175771 1.228552744 0.690175771 1.228552744 Data Set 2 Regression Statistics Multiple R 0.755471073 R Square 0.570736542 Adjusted R Square 0.552850565 Standard Error 9523.718148 Observations 51 ANOVA df SS MS F Significance F Regression 2 5788500379 2894250190 31.90972065 1.53241E-09 Residual 48 4353657953 90701207.36 Total 50 10142158332 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 33936.8764 8233.601399 4.121753623 0.000147974 17382.11124 50491.64155 17382.11124 50491.64155 Middle Class Lower Bound 11845.50053 4593.964895 2.578491739 0.013045848 2608.715037 21082.28602 2608.715037 21082.28602 Middle Class Upper Bound -3948.030918 1531.325872 -2.57817816 0.013056221 -7026.967941 -869.0938949 -7026.967941 -869.0938949Explanation / Answer
This is the ANOVA F-test
The F Value is calculated using the formula
F = (SSE1 – SSE2 / m) / (SSE2 / n-k),
where
SSE = residual sum of squares,
m = number of restrictions,
k = number of independent variables
You can see the significance level of F = 1.53241E-09
The value of F itself is 31.90972065