TABLE 17-1
A real estate builder wishes to determine how house size (House)is influenced by family income (Income),family size (Size),and education of the head of household (School).House size is measured in hundreds of square feet,income is measured in thousands of dollars,and education is in years.The builder randomly selected 50 families and ran the multiple regression.Microsoft Excel output is provided below:
-Referring to Table 17-1,what is the value of the calculated F test statistic that is missing from the output for testing whether the whole regression model is significant?
A)0.0001
B)0.0299
C)0.726
D)45.5340

Question

TABLE 17-1
A real estate builder wishes to determine how house size (House)is influenced by family income (Income),family size (Size),and education of the head of household (School).House size is measured in hundreds of square feet,income is measured in thousands of dollars,and education is in years.The builder randomly selected 50 families and ran the multiple regression.Microsoft Excel output is provided below: 
-Referring to Table 17-1,what is the value of the calculated F test statistic that is missing from the output for testing whether the whole regression model is significant?
A)0.0001 
B)0.0299 
C)0.726 
D)45.5340

Quizplus · Accepted Answer

The F test statistic for testing whether the whole regression model is significant is missing from the output in Table 17-1. Therefore, the value should be found elsewhere or calculated using the provided information. From the table, we can see that the p-value for the F test for the whole model is less than 0.0001. This indicates that we can reject the null hypothesis that all regression coefficients are zero, and conclude that there is a significant linear relationship between house size and the predictors. The calculated F test statistic can be found using the formula F = (SSR / k) / (SSE / (n - k - 1)), where SSR is the regression sum of squares, SSE is the error sum of squares, k is the number of predictors, and n is the sample size. Using the values provided in the table, we have SSR = 2356.5625, SSE = 1860.3375, k = 3, and n = 50. Plugging these values into the formula, we get F = (2356.5625 / 3) / (1860.3375 / 46) = 45.5340. Therefore, the answer is D.

TABLE 17-1 A Real Estate Builder Wishes to Determine How House Size