Question
We want to study the relationship between size (sq. m) and the price of houses. We randomly chose 12 houses and recorded the size and
We want to study the relationship between size (sq. m) and the price of houses. We randomly chose 12 houses and recorded the size and price of them. The excel output for the data is given below:
SUMMARY OUTPUT
Regression Statistics
Multiple R: 0.663699154
R Square; 0.440496567
Adjusted R Square; 0.384546224
Standard Error; 28627.20695
Observations: 12
ANOVA df ss ms f Significance F
Regression 1 6452050047 6.45E+09 7.872991 0.0186058
Residual 10 8195169778 8.2E+08
Total 11 14647219825
Intercept size
Coefficients 65284.40907 1003.986278
Standard Error 59053.93212 357.8144631
t Stat 1.105505 2.805885
P.value 0.294828 0.018606
Lower 95% -66295.951 206.72597
Upper 95% 196864.77 1801.24658
Lower 95.0%% -66295.951 206.72597
Upper 95.0% 196864.7 1801.24658
Write down your answers to (a)-(c) in the box below. Give your answers to 4 decimal places.
- Write down 95% confidence interval for the slope of the relationship between price and size.
- We want to study whether there is any relationship between price and size of a house at 0.05 significance level.Write down the p-value of the test.
- We expect that bigger the house the higher the price. We want to do this test at 0.05 significance level. Write down the p-value of the test the p-value of the test?
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