have the example with other question, i just want answer just like in those steps.

this is the question that i want answer to:

A real estate agency collects the data concerning the sales price of a house (in thousands of dollars), using the basis of home size (in hundreds of square feet) and rating (an overall "niceness rating" for the house expressed on a scale from 1[worst] to 10[best], and provided by the real estate agency). Let

Y = sales price of a house (in thousands of dollars)

X1 = home size (in hundreds of square feet)

X2 = rating (an overall "niceness rating" for the house expressed on a scale from 1[worst] to 10[best], and provided by the real estate agency)

The Real Estate Sales Price Data:

y

X1

X2

180

23

5

98.1

11

2

173.1

20

9

136.5

17

3

141

15

8

165.9

21

4

193.5

24

7

127.8

13

6

163.5

19

7

172.5

25

2

A). Describe what are the response and the independent variables and what you have to predict?

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.995049

R Square

0.990123

Adjusted R Square

0.987301

Standard Error

3.241636

Observations

10

ANOVA

df

SS

MS

F

Significance F

Regression

2

7373.952

3686.976

350.8665

9.58E-08

Residual

7

73.55741

10.5082

Total

9

7447.509

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

29.34681

4.891442

5.999624

0.000542

17.78039

40.91323

17.78039

40.91323

x1

5.612806

0.228521

24.56147

4.73E-08

5.07244

6.153171

5.07244

6.153171

x2

3.834422

0.433201

8.851371

4.75E-05

2.810065

4.85878

2.810065

4.85878

(B).Find the equation of the regression model:

(C ).Determine the predicted value of y for x1 = 18, and x2 = 8

(D ). Use F test of overall significance of the multiple regression model at

alpha = 0.05, and also test the model by using the p value:

The test of the null hypothesis by using F test.

Steps:

(1)Identify :

:

( 2) df(N) = df(D) =

( 3)Find the critical value of F:

(4)Identify the rejection region:

( 5)Find the standardized F statistic(Calculated F) :

(6)Make decision:

(7)Interpret the decision in the context of the original claim.

(8) The test of the null hypothesis by using p value:

9. Develop the equation of the regression model for the following data. of y. Determine the predicted value of y for x1 = 33, x2 = 29, and x3 = 13. Use F test of overall significance of the multiple regression model at alpha =0.05, and also test by using p value. Y x1 X2 x3 114 21 6 5 94 43 25 8 87 56 42 25 98 19 27 101 29 20 85 34 45 94 40 33 107 32 14 11 119 16 4 7 93 18 31 16 108 27 12 10 117 31 3 8 * The equation of the regression model Regression Statistics Multiple R 0.987399 is : A R Square 0.974957 * = 118: 56- 0. 079X, - 0.884X2+ 0.3769 X3 Adjusted R Square 0.965566 Ans Standard Error 2.134122 Observations 12 ANOVA Significance df 55 MS F F Regression 1418.481 472.8269 103.8158 9.58E-07 Residual 36.43582 4.554478/ 10 75% * The equation of the regression modelt Regression Statistics Multiple R 0.987399 is : A R Square 0.974957 4= 118 56- 0.079X, - 0.884X 2+ 0:3769 X3 Adjusted R Square 0.965566 Ans Standard Error 2.134122 Observations 12 ANOVA Significance MS F Regression 1418.481 472.8269 103.8158 9.58E-07 Residual 00 W 36.43582 4.554478 Total 1454.917 Standard Upper Lower Uppe Coefficients Error t Stat P-value Lower 95% 95% 95.0% 95.0 Intercept 118.5595 1.857982 63.81089 4.05E-12 114.275 122.844 114.275 122.844 X1 -0.0794 0.068484 -1.15943 0.279713 -0.23733 0.078522 0.23733 0.0785 X2 -0.88428 0.086312 -10.2452 7.08E-06 -1.08332 -0.68525 -1.08332 -0.6857 X3 0.37691 0.219729 1.715342 0.124623 -0.12979 0.883605 -0.12979 0.8836( The Predicted value of y at X1 = 33, X2 = 29, X3 = 13 is ! y' = 118.56 - 0. 079 (33) - 0.884( 29) +0.3769(13) = 95, 2167 295.22 Aus. The test of the null hypothesis by using F test. Steps: (1) Identify H. : B = R= B= O H.: At least one of the Partial coefficients is not equal, (2) a = 0.05 df(N) = 3 df(D) = 8 tozero (#0 )The test of the null hypothesis by using F test. Steps: (1) Identify H. : B = R = B= O H. : At least one of the Partial coefficients is not equal tozero ( to (2) a = 0.05 df(N) = 3 df(D) = 8 ( 3) Find the critical value of F: F ( 105 , 3, 8 ) = 4.07 (4) Identify the rejection region: F > 4.07 ( calculated ) Fe= 4. 07 (5) Find the standardized F statistic(Calculated F) : Ful = 103. 816 (6) Make decision: Since the calculated value of F _ the table value of F. ( critical ) the decision is reject Ho. (7) Interpret the decision in the context of the original claim. At 5% level of significance, there is a significant change in at least one of the regression coefficients those are adding a significant Value in the model of yory . The test of the null hypothesis by using p value: Ho: B, = BZ = By = 0 Ha: At least one of the partial coefficients is $ 0. 2 = 0. 05, P-value = 9.58x10 = 0.00000 0958 Since the P-value I the alpha, therefore, the decision is reject Ho