Question

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 Constant Analysis of Variance SOURCE Regression Residual Error Total DF 1 41,587.2 8 51,984.7 a. How many apartment buildings were in the sample? b. Write the estimated regression equation (to 2 decimals if necessary). c. Use the t statistic to test the significance of the relationship at a 05 level of significance. What is the p-value? Use Table 1 of Appendix B. p-value is Select your answer What is your conclusion? -Select your answer 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? p-value is-Select your answer- What is your conclusion? Select your answer- e. Predict the selling price of an apartment building with gross annual rents of $50,000 (to 1 decimal). thousands.

Answer 1