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 | 1 | 41,587.6 | |
| Residual Error | 7 | ||
| Total | 8 | 51,984.6 | |
a. How many apartment buildings were in the sample?
b. Write the estimated regression equation (to
2 decimals if necessary).
ŷ = ________ + ___________x
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?
p-value is Select less than .01
between .01 and .025
between .025 and .05
between .05 and .10
greater than .10
What is your conclusion?
Select Conclude that the selling price is related to annual gross
rents.
Cannot conclude that the selling price is related to annual gross rents.
e. Predict the selling price of an apartment
building with gross annual rents of $50,000 (to 1 decimal).
$ ________thousands.
Answer to the question is as follows. Please write back in case of doubts:
a . Since total df = n-1 and df = 8 we have n = 9, which is the number of apartment buidlings in the sample
b. Y =20.0 + 7.21*X is the estimated regression equation
c.Value of sB1 is basically SE for X: 1.3628
d. Fstatistic = MS regression/MS residual error = ( (41.587.6/1)/( 51.9846-41.5876)/7) 27.999 or 28.00 to 2 decimals.
The p-value for P(F,df1,df2) = P(28, 1,7) = .001134. The result is significant at p < .05
e. The selling price of an apartments with gross annual rents of
$50,000 is $360,5 or $360 thousand dolalrs
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.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...
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...
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 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. 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...
A regression model relating x, 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 n total=26. a. Write the estimated regression equation (to whole number). y=_____+_____x b. Compute the F statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals) F-value ____ p-value is _______, we _________ h0 c. Compute the...
ensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage (hours) 15 12 Annual Maintenance Expense 18 23 30 34 19 26 38 48 32 34 40 53 42 a. Develop the estimated regression cquation...
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...