Question

In: Statistics and Probability

The following data was collected to explore how the number of square feet in a house,...

The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1) is the square footage, the second independent variable (x2) is the number of bedrooms, and the third independent variable (x3) is the age of the house. Effects on Selling Price of Houses Square Feet Number of Bedrooms Age Selling Price 2460 3 15 296700 2261 4 7 101700 1748 3 7 201000 2743 4 6 207400 1702 5 4 129300 1756 4 2 147600 1728 3 3 184600 1384 5 12 163400 1551 2 15 160900 Step 1 of 2: Find the p-value for the regression equation that fits the given data. Round your answer to four decimal places

Solutions

Expert Solution

square Feet No of Bed room Age Selling Price
2460 3 15 296700
2261 4 7 101700
1748 3 7 201000
2743 4 6 207400
1702 5 4 129300
1756 4 2 147600
1728 3 3 184600
1384 5 12 163400
1551 2 15 160900

#we fit multiple linear regression in Excell

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.656631
R Square 0.431165
Adjusted R Square 0.089864
Standard Error 53479.83
Observations 9
ANOVA
df SS MS F p-value
Regression 3 1.08E+10 3.61E+09 1.263297 0.381163858
Residual 5 1.43E+10 2.86E+09
Total 8 2.51E+10
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 98679.04 126846.9 0.777938 0.471794 -227391.3554 424749.4 -227391 424749.4
square Feet 51.04441 41.69754 1.224159 0.275422 -56.14252356 158.2313 -56.1425 158.2313

Hence,

p - Value = 0.3815

Since the relationship is not significant, do not put any values in the equation. Just click the check box and it will be correct.


Related Solutions

The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1x1) is the square footage, the second independent variable (x2x2) is the number of bedrooms, and the third independent variable (x3x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1) is the square footage, the second independent variable (x2) is the number of bedrooms, and the third independent variable (x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1x1) is the square footage, the second independent variable (x2x2) is the number of bedrooms, and the third independent variable (x3x3) is the age of the house. Square Feet   Number of Bedrooms   Age  ...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1x1) is the square footage, the second independent variable (x2x2) is the number of bedrooms, and the third independent variable (x3x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1) is the square footage, the second independent variable (x2) is the number of bedrooms, and the third independent variable (x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1) is the square footage, the second independent variable (x2) is the number of bedrooms, and the third independent variable (x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1) is the square footage, the second independent variable (x2) is the number of bedrooms, and the third independent variable (x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how the number of square feet in a house,...
The following data was collected to explore how the number of square feet in a house, the number of bedrooms, and the age of the house affect the selling price of the house. The dependent variable is the selling price of the house, the first independent variable (x1x1) is the square footage, the second independent variable (x2x2) is the number of bedrooms, and the third independent variable (x3x3) is the age of the house. Effects on Selling Price of Houses...
The following data was collected to explore how a student's age and GPA affect the number...
The following data was collected to explore how a student's age and GPA affect the number of parking tickets they receive in a given year. The dependent variable is the number of parking tickets, the first independent variable (x1x1 ) is the student's age, and the second independent variable (x2x2 ) is the student's GPA. Effects on Number of Parking Tickets Age GPA Number of Tickets 1717 22 11 1818 22 22 2121 33 33 2121 33 44 2222 33...
The following data was collected to explore how a student's age and GPA affect the number...
The following data was collected to explore how a student's age and GPA affect the number of parking tickets they receive in a given year. The dependent variable is the number of parking tickets, the first independent variable (x1) is the student's age, and the second independent variable (x2) is the student's GPA. Effects on Number of Parking Tickets Age GPA Number of Tickets 23 3 7 22 3 6 21 2 5 21 2 4 20 2 2 19...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT