Question

In: Statistics and Probability

11.29) A builder wants to predict the relationship between house size (as measured by number of...

11.29) A builder wants to predict the relationship between house size (as measured by number of rooms). and selling price. Two difference neighbourhoods are compare. A random sample of 215 houses is selected, with the results as follows.

House Number of rooms Selling Price ($000) Neighbourhood
1 8 345 0
2 8 360 1
3 6 325 0
4 8 400 1
5 7 350 1
6 9 360 0
7 13 405 0
8 6 299 0
9 8 405 1
10 9 365 0
11 10 520 1
12 8 330 0
13 14 600 1
14 9 370 0
15 7 395 1

(a) Is there a relationship between selling price and two independent variables at the 0.05 level of significance?
(b) Does the independent variable make a contribution to the regression model?
(c) Add an interaction term to the model and at the 0.05 level of significance determine whether it makes a significant contribution to the model.0

Solutions

Expert Solution

Solution:

(a) Is there a relationship between selling price and two independent variables at the 0.05 level of significance?

Accessing relationship between Selling price and Number of rooms :

r = correlation coefficient = 0.7679632

critical correlation coefficient at the 0.05 level of significance (n = 15) = 0.514

Since r > 0.514, there is significant linear relation ship between Selling price and Number of rooms

Accessing relationship between Selling price and neighbourhood :

r = correlation coefficient = 0.55288

critical correlation coefficient at the 0.05 level of significance (n = 15) = 0.514

Since r > 0.514, there is significant linear relation ship between Selling price and neighbourhood

b ) Does the independent variable make a contribution to the regression model?

Fro the regression model

selling_price ~ number_of_rooms + neighbourhood

Coefficients:
Estimate Std. Error t value Pr(>|t|)    
(Intercept) 137.504     36.754 3.741 0.00282 **
number_of_rooms 24.985      4.081 6.122 5.16e-05 ***
neighbourhood 74.059 17.839 4.152 0.00134 **

The p value of the coefficients of the independent variables in the regression model is < 0.05

Therefore independent variable make a significant contribution to the regression model.

(c) Add an interaction term to the model and at the 0.05 level of significance determine whether it makes a significant contribution to the model.

After adding the interaction term in the model , the regression equation becomes

selling_price ~ number_of_rooms + neighbourhood + neighbourhood * number_of_rooms

Coefficients:
Estimate Std. Error t value Pr(>|t|)    
(Intercept) 231.750     35.398   6.547 4.15e-05 ***
number_of_rooms 13.897      4.047   3.434 0.00558 **
neighbourhood -110.781     50.178 -2.208 0.04941 *  
number_of_rooms:neighbourhood 21.316      5.611   3.799 0.00295 **

The p value of the coefficient of the interaction variable (number_of_rooms*neighbourhood ) is 0.00295 << 0.05 significance level, Therefore this interaction term makes a significant contribution to the model


Related Solutions

A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table.] Property Taxes Size 21859 2454 17451 2442 18270 1886 15603 1089 43934 5673 33682 2503 15285 2285 16712 1984 18287 2014 16751 1380 15183...
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table. Property Taxes Size 21985 2428 17448 2413 18247 1847 15636 1061 43943 5672 33618 2525 15255 2216 16784 1916 18153 2003 16759 1316 15192...
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table.] Property Taxes Size 21983 2438 17449 2409 18152 1854 15624 1089 43968 5622 33616 2589 15285 2230 16752 1932 18177 2052 16795 1385 15132...
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes owed by the owner. He collects the following data on six homes in an affluent suburb 30 miles outside of Chicago. Use Table 2. Square Feet Property Taxes ($)   Home 1 4,150 12,527             Home 2 2,780 9,263             Home 3 5,289 22,703             Home 4 2,123 6,450             Home 5 1,581 5,231             Home 6 3,023 7,850           a-1. Construct a scatterplot....
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table.] Property Taxes Size 21892 2498 17421 2419 18170 1877 15679 1011 43962 5607 33657 2575 15300 2248 16789 1984 18108 2021 16794 1311 15113...
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. Property Taxes Size 21872 2434 17403 2423 18286 1875 15608 1043 43950 5637 33649 2524 15224 2214 16748 1926 18248 2006 16722 1339 15144 1379 36037 3043 31004 2866 42122 3304 14368 1504 38994...
A realtor studies the relationship between the size of a house (in square feet) and the...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table.] Property Taxes Size 21892 2498 17421 2419 18170 1877 15679 1011 43962 5607 33657 2575 15300 2248 16789 1984 18108 2021 16794 1311 15113...
A real estate builder wishes to determine how house size (House) is influenced by family income...
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: Which of the independent variables in the model are significant at the 5% level?
A real estate agent wants to study the relationship between the size of an apartment and...
A real estate agent wants to study the relationship between the size of an apartment and its monthly rent price. The table below presents the size in square feet and the monthly rent in dollars, for a sample of apartments in a suburban neighborhood. Rent ($) 720 595 915 760 1000 790 880 845 650 748 685 755 815 745 715 885 Size (Square Feet) 1000 900 1200 810 1210 860 1135 960 800 960 650 970 1000 1000 1000...
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the number of acres burned, in hundreds of thousands. Based on this data, decide if the correlation is significant at alpha = 0.05. Number of fires x 73 74 58 48 80 65 54 49 Number of acres burned y 64 46 22 23 51 12 29 10 5. When x = 61 what is y and what does it mean I this context. 6....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT