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.01 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."

Suppose the following data were collected relating the selling price of a house to square footage and whether or not the hous

Selling Prices of Houses Wood (1 if wood, 0 if otherwise) Price Sqft 202811 2402 1 228434 3413 1 196739 2414 0 211351 2761 15

212126 2827 0 222680 3067 0 193288 2012 1 186073 1832 157059 1459 1 0 192158 2165 1 253527 3536 0 167611 1411 1 218069 2877 1

Tables Кeypad Answer How to enter your answer Selecting a checkbox will replace the entered answer value(s) with the checkbox

0 0
Add a comment Improve this question Transcribed image text
Answer #1

We will perform regression analysis in R-Studio. We will check the following hypothesis:

Ho: Wood houses are not more expensive than other types of houses i.e Coefficient <= 0

Ha: The coefficient of wood is significantly greater than zero

Run the following code in R:

Price = c(202811,228434,196739,211351,156012,196376,157448,199109,230693,223887,192221,212126,222680,193288,186073,157059,192158,253527,167611,218069)
> Sqft=c(2402,3413,2414,2761,1718,2304,1425,2477,3320,3046,2353,2827,3067,2012,1832,1459,2165,3536,1411,2877)
> Wood = c(1,1,0,1,0,1,0,0,1,0,0,0,0,1,1,0,1,0,1,1)
> Model = lm(Price~Sqft+Wood)
> summary(Model)

The results are:

Call:
lm(formula = Price ~ Sqft + Wood)

Residuals:
     Min       1Q   Median       3Q      Max 
-13477.8  -1956.4     45.4   2249.0  13804.2 

Coefficients:
             Estimate Std. Error t value Pr(>|t|)
(Intercept) 1.031e+05  5.799e+03  17.784 2.02e-12
Sqft        3.863e+01  2.232e+00  17.311 3.13e-12
Wood        4.930e+03  2.885e+03   1.709    0.106
               
(Intercept) ***
Sqft        ***
Wood           
---
Signif. codes:  
0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 6451 on 17 degrees of freedom
Multiple R-squared:  0.9469,    Adjusted R-squared:  0.9407 
F-statistic: 151.7 on 2 and 17 DF,  p-value: 1.446e-11

We can see that the coefficient of wood has a p-value of 0.106 which means that it is not significant at 0.01 level of significance. Hence, we cannot reject the null hypothesis

Correct answer: Not enough evidence

Add a comment
Know the answer?
Add Answer to:
Suppose the following data were collected relating the selling price of a house to square footage...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 equ...

    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.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 from a sample of 15 CEOs relating annual salary to...

    Suppose the following data were collected from a sample of 15 CEOs relating annual salary to years of experience and the economic sector their company belongs to. Use statistical software to find the following regression equation: SALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+ei . Is there enough evidence to support the claim that on average, CEOs in the industrial sector have lower salaries than CEOs in the financial sector at the 0.05 level of significance? If yes, write the regression equation in the spaces provided with...

  • 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.11 + 52.06Sqft; SSE = 56,244; 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.82 + 40.84Sqft + 10.34Beds + 16.65Baths; SSE = 48,681; n = 50 Calculate the value of the test statistic. (Round...

  • please help thank you! Selling Information For Real Estate Value Price SqFt Brick (1 if brick,...

    please help thank you! Selling Information For Real Estate Value Price SqFt Brick (1 if brick, if othewise) $241,255 3,392 0 $184,518 2,038 1 $176,488 1,906 0 $240,068 3,329 0 $169,760 1,828 0 $185,335 2,081 0 $172,735 1, 9260 $224,281 3,4250 $172,589 1,676 1 $214,635 2,735 1 $199,666 2,373 1 $208,348 2,662 1 $218,360 2, 8341 $230,160 3, 2540 $164,812 1,431 0 $191,560 1,839 1 $203,255 2, 4561 $173,325 1,530 $168,073 1.381 1 $179,620 1,4571 TABLE 4 Industrial CEO Salary...

  • 1/11 Question 2 of 10, Step 1 of 1 Correct Suppose the following data were collected...

    1/11 Question 2 of 10, Step 1 of 1 Correct Suppose the following data were collected from a sample of 5 car manufacturers relating monthly car sales to the number of dealerships and the quarter of the year. Use statistical software to find the following regression equation bo+b DEALERSHIPS, + bQUARTERI, + byQUARTER2, +b,QUARTER3, + e SALES, Is there enough evidence to support the claim that on average, car sales are higher in the 4th quarter than in the 1st...

  • Solve 4-23 Please 4-22 The following data give the selling price, square footage, number of bedrooms,...

    Solve 4-23 Please 4-22 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? SELLING PRICE (S) SQUARE FOOTAGE BEDROOMS AGE (YEARS) 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...

  • One of the biggest factors in determining the value of a home is the square footage....

    One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price​ (in thousands of​dollars) for a random sample of homes for sale in a certain region. Complete all parts below (A.) Which variable is the explanatory variable? a. selling price b. square footage Square Footage, x Selling Price ($000s), y 2221 382.7 3046 353.4 1175 197.2 1938 332.2 3166 630.2 2857    383.9 4086 623.6...

  • Excel Problem 2 - Chapter 12: PART B:   The following data give the selling price, square...

    Excel Problem 2 - Chapter 12: PART B:   The following data give the selling price, square footage, and age of houses that have sold in a Bend, OR in the past 6 months (note that this is the same base data as Part A, above, with new variables added). Selling Price ($) Square Footage Age (Years) 84,000 1,670 30 79,000 1,339 25 91,500 1,712 30 120,000 1,840 40 127,500 2,300 18 132,500 2,234 30 145,000 2,311 19 164,000 2,377 7...

  • House Selling Price Data for 100 homes relating y = selling price (in dollars) to x...

    House Selling Price Data for 100 homes relating y = selling price (in dollars) to x = size of the house (in square feet) results in the regression line that is shown below. y= 9161 + 77.008x the slope estimate has standard error 6.262 Show all steps of a two-sided significance test of independence. Could the sample association between these two variables by explained by random variation? a) Assumptions b) Hypotheses: c) Test Statistics: d) p-value: e) Conclusion:

  • A Realtor is interested in modeling the selling price of houses based on the square footage, the ...

    A Realtor is interested in modeling the selling price of houses based on the square footage, the age of the house, and the style. The data was collected in the two largest cities in Arkansas and is presented in an excel file. We need two indicator variables for the style of the house. I will choose Traditional as the base category lif the house is a rambler lif the house is victorian rambler Oif not Now use Minitab output to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT