TABLE 14-4
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 14-4, 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 14-4
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 14-4, 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 missing value for the calculated F test statistic for testing whether the whole regression model is significant is 45.5340. This is determined from the entry under "F" in the ANOVA table, which has a value of 45.5340 and a corresponding p-value of less than 0.0001, indicating that the model is significant at a high level of confidence. Therefore, D is the correct choice.

TABLE 14-4 A Real Estate Builder Wishes to Determine How House Size