Question

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
Regression 1 41,587.4
Residual Error 7
Total 8 51,984.2

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? Use Table 1 of Appendix B.
p-value is Selectless than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 6

What is your conclusion?
SelectConclude that the selling price is related to annual gross rents.Cannot conclude that the selling price is related to annual gross rents.Item 7

e. Predict the selling price of an apartment building with gross annual rents of $60,000 (to 1 decimal).
$ thousands.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
ANOVA
df SS MS F
Regression 1 41587.4 41587.4 28.00013
Residual 7 10396.8 1485.257
Total 8 51984.2

a. 9 apartment buildings were in the sample?

b. the estimated regression equation
ŷ =20.00 +7.23  x

c. the value of sb1 is 1.3625

d) the F test statistic = 28.00

the p-value.
p-value is less than .01

Conclude that the selling price is related to annual gross rents

e. the selling price of an apartment building with gross annual rents of $60,000

ŷ =20.00 +7.23*60 =453.8 $ 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 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.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...

    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...

    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...

    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...

    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 w...

    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...

  • {Exercise 13.07} Three different methods for assembling a product were proposed by an industrial engineer. To...

    {Exercise 13.07} Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected and randomly assigned to the three proposed methods in such a way that each method was used by 10 workers. The number of units assembled correctly was recorded, and the analysis of variance procedure was applied to the resulting data set. The following results were obtained: SST = 10,800;...

  • Four different paints are advertised as having the same drying time. To check the manufacturer's claims,...

    Four different paints are advertised as having the same drying time. To check the manufacturer's claims, five samples were tested for each of the paints. The time in minutes until the paint was dry enough for a second coat to be applied was recorded. The following data were obtained. Click on the datafile logo to reference the data. At the  = .05 level of significance, test to see whether the mean drying time is the same for each type of paint....

  • The following data are from an experiment designed to investigate the perception of corporate ethical values...

    The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals who are in marketing. Three groups are considered: management, research and advertising (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 6 10 6 5 10 7 4 9 6 5 9 5 6 10 6 4 9 6 Compute the values identified below (to 1 decimal, if necessary). Sum of Squares, Treatment Sum of Squares, Error Mean Squares, Treatment...

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