Question

Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Selling Prices of Houses Price Sqft Wood (1 if wood, 0 if otherwise) 185821 2004 1 246288 3691 1 224158 2975 1 247893 3339 0 205153 2649 0 168477 1566 0 231917 3324 1 177916 1768 1 201064 2336 1 161010 1386 0 225514 3026 1 222100 3384 0 217999 3119 1 174755 1939 0 210379 2861 0 196333 2400 0 177035 1513 1 171289 1831 0 159158 1763 0 229969 3361 1 Answer How to enter your answer Selecting a checkbox will replace the entered answer value(s) with the checkbox value. If the checkbox is not selected, the entered answer is used

Answer 1

The data was entered in MS Excel as follows:

Following is the regression output obtained using MS Excel:

Since p-value corresponding to Wood (0.09) is greater than 0.05, there is not enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance.

There is not enough evidence