Question

In: Statistics and Probability

Suppose the following data were collected relating the selling price of a house to square footage...

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 brick. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average brick houses are more expensive than other types of houses at the 0.050.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 Brick (1 if brick, 0 if otherwise)
233345 3526 0
244243 3427 1
210353 2717 1
215363 2919 0
166225 1342 0
212661 2838 1
205273 2507 1
222408 2884 1
151125 1650 0
167933 1908 0
242592 3516 1
240660 3399 1
192820 2080 1
199901 2497 0
170040 1515 0
238768 3503 1
226069 3263 0
186387 2258 0
204800 2495 1
214960 2772 0

how do you arrived to the answer?

Correct Answer:PRICEi=106558.07+36.61SQFTi+7398.16BRICKi+ei

Solutions

Expert Solution

Solution:-

The regression equation is Y = 106558.0743 + 36.61*X1 + 7398.16*X2

State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.

Null hypothesis: u1> u2
Alternative hypothesis: u1 < u2

Note that these hypotheses constitute a one-tailed test.

Formulate an analysis plan. For this analysis, the significance level is 0.05. Using sample data, we will conduct a two-sample t-test of the null hypothesis.

Analyze sample data. Using sample data, we compute the standard error (SE), degrees of freedom (DF), and the t statistic test statistic (t).

SE = sqrt[(s12/n1) + (s22/n2)]
SE = 10860.772
DF = 18

t = [ (x1 - x2) - d ] / SE

t = - 2.61

where s1 is the standard deviation of sample 1, s2 is the standard deviation of sample 2, n1 is thesize of sample 1, n2 is the size of sample 2, x1 is the mean of sample 1, x2 is the mean of sample 2, d is the hypothesized difference between population means, and SE is the standard error.

The observed difference in sample means produced a t statistic of -2.61

Therefore, the P-value in this analysis is 0.009.

Interpret results. Since the P-value (0.009) is less than the significance level (0.05), we have to reject the null hypothesis.

From the above test we have sufficient evidence in the favor of the claim that that on average brick houses are more expensive than other types of houses at the 0.05 level of significance.


Related Solutions

Suppose the following data were collected relating the selling price of a house to square footage...
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,...
Suppose the following data were collected relating the selling price of a house to square footage...
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,...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of houses that have sold in a neighborhood in the last six months. Selling price Square footage Bedrooms Age 64,000 1,670 2 30 59,000 1,339 2 25 61,500 1,712 3 30 79,000 1,840 3 40 87,500 2,300 3 18 92,500 2,234 3 30 95,000 2,311 3 19 113,000 2,377 3 7 115,000 2,736 4 10 138,000 2,500 3 1 142,500 2,500 4 3 144,000 2,479...
A real estate analyst estimates the following regression, relating a house price to its square footage...
A real estate analyst estimates the following regression, relating a house price to its square footage (Sqft): PriceˆPrice^ = 48.21 + 52.11Sqft; SSE = 56,590; n = 50 In an attempt to improve the results, he adds two more explanatory variables: the number of bedrooms (Beds) and the number of bathrooms (Baths). The estimated regression equation is PriceˆPrice^ = 28.78 + 40.26Sqft + 10.70Beds + 16.54Baths; SSE = 48,417; n = 50 [You may find it useful to reference the...
A real estate analyst estimates the following regression, relating a house price to its square footage...
A real estate analyst estimates the following regression, relating a house price to its square footage (Sqft): PriceˆPrice^ = 48.36 + 52.50Sqft; SSE = 56,018; n = 50 In an attempt to improve the results, he adds two more explanatory variables: the number of bedrooms (Beds) and the number of bathrooms (Baths). The estimated regression equation is PriceˆPrice^ = 28.71 + 40.44Sqft + 10.58Beds + 16.44Baths; SSE = 48,937; n = 50 [You may find it useful to reference the...
The following data gives the selling price, square footage, number of bedrooms, and the age of...
The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000 2,500...
The following data give the selling price and square footage of houses that have sold in...
The following data give the selling price and square footage of houses that have sold in Bend, OR in the past 6 months. Selling Price ($) Square Footage 84,000 1,670 79,000 1,339 91,500 1,712 120,000 1,840 127,500 2,300 132,500 2,234 145,000 2,311 164,000 2,377 155,000 2,736 168,000 2,500 172,500 2,500 174,000 2,479 175,000 2,400 177,500 3,124 184,000 2,500 195,500 4,062 195,000 2,854 Graph the data to see whether a linear equation might describe the relationship between selling price and the...
The data is the square footage and selling price of single-family homes for the month of...
The data is the square footage and selling price of single-family homes for the month of February and the first week of March. Square Footage Selling Price 1746 129320 1764 97000 676 35000 2788 400000 1944 68000 1960 117000 1056 148400 1564 35000 1100 165000 1120 114480 4080 175000 1442 65000 1937 60000 1900 18000 1150 258000 1650 134800 1953 30000 2424 69100 512 63000 1540 82500 1200 50000 1316 37500 1840 69000 3500 270000 5000 485000 1564 27000 1018...
2) The following data gives the selling price, square footage, number of bedrooms, and the age...
2) The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000...
The following data give the selling price, square footage, number of bedrooms, and age of houses...
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past 6 months. Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best? use 1 for yes and 0 for no develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT