Share
Explore BrainMass

Questions Regarding Regressions

You are interested in the prediction of apartment rent from square footage. You sample 25 apartments in the Glendale area and record the apartment rent costs and square footage. When you put this into Excel, you get the following output:

Regression Analysis
Regression Statistics
Multiple R 0.850060796
R Square 0.722603356
Adjusted R Square 0.710542633
Standard Error 194.5953946
Observations 25
ANOVA
df SS MS F Significance F
Regression 1 2268776.545 2268776.545 59.91376452 7.51833E-08
Residual 23 870949.4547 37867.3676
Total 24 3139726

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 177.1208202 161.0042766 1.100100096 0.282669853 -155.9414484 510.1830889
Size 1.065143906 0.137608412 7.740398215 7.51833E-08 0.780479605 1.349808208

1. What is the regression equation for these data?
2. How much of the variance in rent can be predicted by knowing the square footage?
3. Is this a significant regression equation?
4. What does this mean?

Wages in the construction industry average $11.90 per hour with a standard deviation of $1.40.

5. What percent of workers make less than $10.50 per hour (z = -1.00)?
6. What percent of workers make more than $15 per hour (z = 2.21)?

Solution Summary

This solution involves various questions regarding a regression analysis.

$2.19