SCENARIO 18-2 One of the Most Common Questions of Prospective House Buyers

Multiple Choice

SCENARIO 18-2
One of the most common questions of prospective house buyers pertains to the cost of heating in dollars (Y) . To provide its customers with information on that matter, a large real estate firm used the following 4 variables to predict heating costs: the daily minimum outside temperature in degrees of Fahrenheit ( X₁ ) , the amount of insulation in inches ( X ₂ ) , the number of windows in the house ( X₃ ) , and the age of the furnace in years ( X ₄ ) . Given below are the EXCEL outputs of two regression models.


-Referring to Scenario 18-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