Is this right?, if not, please answer A-E correctly. Thanks
a) number of apartment buildings =9
b) yhat =20.00+7.21x
c)p value =0.0011
Conclusion: there is a significant linear relationship
d)F =41587.2/((51984.3-41587.2)/7)=28.00
p value =0.0011
Conclusion: there is a significant linear relationship
e)
predicted value =20+7.21*50 =380.5
Is this right?, if not, please answer A-E correctly. Thanks The commercial division of a real estate firm is conducting...
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 Constant Coef 20.000 7.210 SE Coef 3.2213 1.3625 T 6.21 5.29 Analysis of Variance SOURCE Regression Residual Error Total SS...
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 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 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.24 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X 7.240 1.3625 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 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...
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...