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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!