Question
Consider the partially completed Excel regression analysis shown below between the independent variable rental property area 'X' (in square feet) and the dependent variable monthly
Consider the partially completed Excel regression analysis shown below between the independent variable rental property area 'X' (in square feet) and the dependent variable monthly rent 'Y' (in 1000s of $) and answer the following questions.
Regression Statistics | ||||||
Multiple R | ||||||
R Square | ||||||
Adjusted R Square | ||||||
Standard Error | 5.93 | |||||
Observations | 13 | |||||
ANOVA | ||||||
df | SS | MS | F | |||
Regression | 3312.54 | |||||
Error (Residual) | ||||||
Total | 12 | 3699.45 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 12.67 | 6.97 | ||||
X (Sq.Ft) | 0.07 | 0.01 |
1. What is the slope(b1) and what is its statistical interpretation? (10 points)
2. Perform the test of hypothesis (t-test) on the following and state your statisticaldecision. Use = 0.05.Please show all the relevant calculations.(10 points)
H0:1= 0
H1: 1 0
3. Perform the test of hypothesis (F-test) on the following and state your statisticaldecision. Use = 0.05. Please show all the relevant calculations.(10 points)
H0:1= 0
H1: 1 0
4. What is the coefficient of determination (R2) i.e., the percentage of variability in the monthly rent explained by the independent variablerental property area? Please show all the relevant calculations. (10 points)
5. What is the 95% confidence interval for the population slope (1)? Please show all the relevant calculations. (10 points)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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