Question
United Park City Properties real estate investment firm took a random sample of five condominium units that recently sold in the city. The sales prices
United Park City Properties real estate investment firm took a random sample of five condominium units that recently sold in the city. The sales prices Y (in thousands of dollars) and the areas X (in hundreds of square feet) for each unit are as follows
Y= Sales Price ( * $1000) | 36 | 80 | 44 | 55 | 35 |
X = Area (square feet) (*100) | 9 | 15 | 10 | 11 | 10 |
The owner wants to forecast sales on the basis of the area. Which variable is the dependent variable? Which variable is the independent variable?
Determine the regression equation.
Interpret the values of the slope and the intercept.
Test the significance of the slope at 1% level of significance.
Determine the coefficient of correlation between the sales price and the area.
Interpret the strength of the correlation coefficient.
Determine the coefficient of determination and present its interpretation.
Determine the coefficient of non-determination.
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.969217713 | |||||||
R Square | 0.939382976 | |||||||
Adjusted R Square | 0.919177301 | |||||||
Standard Error | 5.284339356 | |||||||
Observations | 5 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 1298.227 | 1298.227 | 46.49105 | 0.006453 | |||
Residual | 3 | 83.77273 | 27.92424 | |||||
Total | 4 | 1382 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -34.5 | 12.61619 | -2.73458 | 0.071664 | -74.6503 | 5.650339 | -74.6503 | 5.650339 |
Area | 7.681818182 | 1.126625 | 6.818434 | 0.006453 | 4.096395 | 11.26724 | 4.096395 | 11.26724 |
Step by Step Solution
3.39 Rating (146 Votes )
There are 3 Steps involved in it
Step: 1
Y dependent variable X Independent variable on the ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started