Please help, what are the answers to part B & C? A real estate analyst estimates

Question

Please help, what are the answers to part B & C?

A real estate analyst estimates the following regression, relating a house price to its square footage (Sqft): Use Table4 Price 48.58+52.73Sqft SSE 56,969, 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 28.40+40.73Sqft + 10.77Beds+ 16.79Baths; SSE 48,413, n 50 a. Choose the appropriate hypotheses to determine whether Beds and Baths are jointly significant in explaining Price. O H0: ?2-6,-0; HA: At least one of the coefficients is greater than zero. ? H0: ?2-?3-0; HA: At least one of the coefficients is nonzero. O HO: ?1-?2-?3-0; HA: At least one of the coefficients is nonzero. b. Calculate the value of the test statistic. (Round your intermediate calculations to 4 decimal places and final answer to 2 decimal places.) Test statistic C. At the 5% significance level, find the critical value. (Use the appropriate Excel function to calculate the critical value. Round your answer to 2 decimal places.) Critical value d. What is the conclusion to the test? Are Beds and Baths jointly significant in explaining Price? Reject Ho; Beds and Baths are jointly significant in explaining Price. Reject Hoi Saft, Beds and Baths are jointly significant in explaining Price. Do not reject Ho: Sqft, Beds and Baths are not jointly significant in explaining Price. Do not reject Ho: Beds and Baths are not jointly significant in explaining Price. Hints ReferenceseBook & Resources Hint #1 Check my work

Explanation / Answer

a) here in the model we have three independent variables, so null hypothesis is all variables are equall, so 3 option is coreect.

2?) the formula for the calculation of the test statistics as ,
t=b/se(b),

so for t statistics fir the sqrt is

t=40.73/48.413=0.8413

similarlly t for beds and baths are 0.2224 and 0.346808 respectivelly .
c) for the calculation of the critical value we use t.dist in the excel command where the (x=calculated t value, df=n-k-1,false)

so the critical values for 0.277 for sqrt , 0.38 for beds, 0.37 for baths

d) as camparing the calculated t values above all values we can say that the 3 option is correct

thanks

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---