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.
a. How many apartment buildings were in the sample? b.
Write the estimated regression equation (to 2 decimals if
necessary). c. What is the value of sb1 (to 4 decimals)? d. Use the F statistic to test the significance of the relationship at a .05 level of significance. Compute the F test statistic (to 2 decimals). What is the
p-value? What is your
conclusion? e.
Predict the selling price of an apartment building with gross
annual rents of $60,000 (to 1 decimal). |
(a) 9
(b) Y =20.0 + 7.24 X
(c) 1.3625
(d) F test statistic = 28
p-value is less than .01
Conclude that the selling price is related to annual gross rents.
SOURCE | DF | SS | MS | F | p-value |
Regression | 1 | 41,587.8 | 41587.8 | 28.00 | 0.0011 |
Residual Error | 7 | 10,396.5 | 1485.21 | ||
Total | 8 | 51,984.3 |
(e) Y =20.0 + 7.24*6
Y = 63.4
Please give me a thumbs-up if this helps you out. Thank you!
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...
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 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 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...
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...
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...
The data from exercise 3 follow. xi 2 6 9 13 20 yi 7 18 9 26 23 The estimated regression equation is = 7.6 + .9x. What is the value of the standard error of the estimate (to 4 decimals)? What is the value of the t test statistic (to 2 decimals)? What is the p-value? Use Table 1 of Appendix B. Selectless than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and...
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. y=17.6+3.8x1-2.3x2+7.6x3+2.7x4 For this estimated regression equation SST= 1805 and SSR=1756. a. At a= 0.05 , test the significance of the relationship 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)? _______________ What is the p-value? - Select your answer -less than .01,between...
15. {Exercise 12.23 (Algorithmic)} Given are five observations for two variables, x and y. xi 1 2 3 4 5 yi 3 8 6 12 14 The estimated regression equation is ŷ = 0.8 + 2.6x. Compute the mean square error using the following equation (to 3 decimals). Compute the standard error of the estimate using the following equation (to 3 decimals). Compute the estimated standard deviation b1 using the following equation (to 3 decimals). Use the t test to...
With double-digit annual percentage increases in the cost of health insurance, more and more workers are likely to lack health insurance coverage (USA Today, January 23, 2004). The following sample data provide a comparison of workers with and without health insurance coverage for small, medium, and large companies. For the purposes of this study, small companies are companies that have fewer than 100 employees. Medium companies have 100 to 999 employees, and large companies have 1000 or more employees. Sample...