Question

The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual grossc. Use the t statistic to test the significance of the relationship at a .05 level of significance. What is the p-value? Use

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)number of buildings =totaldf+1 =8+1 =9

b)

yhat =20+7.21x

c) p value =0.0011 (p value <0.01)

conclusion: there is a relationship between two variables

d)

F test statistic =(MSR/MSE)=(41587.4/1)/((51984.5-41587.4)/7)=28.00

p value =0.0011 (p value <0.01)

conclusion: there is a relationship between two variables

e)

predicted value =20+7.21*60 =452.6 thousands

Add a comment
Know the answer?
Add Answer to:
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between 2, annual gross rents (in thousands of dollars), and y selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y=20.0 +7.22 X Predictor Constant Coef 20.000 7.220 SE Coef 3.2213 1.3625 T 6.21 SS Analysis of Variance SOURCE Regression Residual Error 41,587.3 Total 51,984.4...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y =20.0 + 7.21 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X 7.210 1.3628 5.29 Analysis of Variance SOURCE DF SS Regression...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y = 20.0 + 7.23 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X   7.230 1.3625 5.29 Analysis of Variance SOURCE DF SS...

  • Is this right?, if not, please answer A-E correctly. Thanks The commercial division of a real estate firm is conducting...

    Is this right?, if not, please answer A-E correctly. Thanks The commercial division of a real estate firm is conducting a regression analysis of the relationship between annual gross rents (in thousands dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were callected an several propertics recently sold and the following computer output was obtained. n equaton a Coaf SE Cacef T Predictor Constent 7.210 1.3624 5 29 Analysis of Varience SOURCE п ss 41,587.2 Regression...

  • Please show me how to do it on excell too The commercial division of a real...

    Please show me how to do it on excell too The commercial division of a real estate firm is conducting a regression analysis of the relationship between z, annual gross rents (in thousands of dollars), and y, seling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y=20.0 + 7.26 X Coef SE Coef T 20.000 3.2213 6.21 7.260 1.3622 5.29 Predictor...

  • In a regression analysis involving 30 observations, the following estimated regression equation was obtained. = 17.6...

    In a regression analysis involving 30 observations, the following estimated regression equation was obtained. = 17.6 +3.821 -2.3x2 + 7.603 + 2.724 For this estimated regression equation SST = 1805 and SSR = 1,756. a. At a = 0.05, test the significance of the relashionship among the variables. SSE (to 1 decimal, if necessary) MSR (to 1 decimal, if necessary) MSE (to 2 decimals, if necessary) What is the value of the F test statistic (to 1 decimal)? Use Table...

  • eBook Video In a regression analysis involving 30 observations, the following estimated regression equation was obtained....

    eBook Video In a regression analysis involving 30 observations, the following estimated regression equation was obtained. 17.6+3.8z-2.3z +7.6z, +2.7z For this estimated regression equation SST- 1805 and SSR- 1,764. a. At a 0.05, test the significance of the relashionship among the variables. SSE (to 1 decimal, if necessary) MSR (to 1 decimal, if necessary) MSE (to 2 decimal if necessary) What is the value of the F test statistic (to 1 decimal)? Use Table 4 in Appendix B. What is...

  • Given are five observations for two variables, r and y. 3 4 5 1 2 7 6 11 14 4 The estimated regression equation is...

    Given are five observations for two variables, r and y. 3 4 5 1 2 7 6 11 14 4 The estimated regression equation is y = 1.2 + 2.4r Compute the mean square error using the following equation (to 3 decimals). a. SSE s2=MSE n- 2 decimals). b. Compute the standard error of the estimate using the following equation (to SSE VMSE Vn-2 SE c. Compute the estimated standard deviation bi using the following equation (to 3 decimals). Sp...

  • A regression model relating 2, number of salespersons at a branch office, to y, annual sales...

    A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where Miotal = 30. 0 ANOVA 0 MSF Significance F SS 6361.5 Regression Residual Total 8844.6 P-value 85.0 5.418 Coefficients Standard Error Stat Intercept 10.553 Number of 43.0 Salespersons a. Write the estimated regression equation (to whole number). y= + b. Compute the F statistic...

  • A regression model relating number of salespersons at a branch office, to y, annual sales at...

    A regression model relating number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where th =26. ANOVA SS MS F Significance F u Significance Regression Residual Total 8756.4 p-value 510 s.com Coefficients Standard Error Stat Intercept 7 7.0 10.723 Number of 5.609 Salespersons Write the estimated regression equation (to whole number). V= b. Compute the statistic and test the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT