Question

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
1389	2	2	127800
1477	3	2	146900
1870	3	3	150800
1882	3	4	154000
1970	3	4	155500
1994	3	4	202600
2573	3	8	219900
2685	4	13	253500
3077	5	14	293400

Find the p-value for the regression equation that fits the given data. Round your answer to four decimal places.

Answer 1

We can directly use here Excel for regression,

Step1) Enter data in Excel.

Step 2) Data >>data analysis >>Regression >> select Input range y and input range x(all three columns data of (i.e. x1, x2, x3) >>ok

P value for regression equation is =0.0018