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.

  1. Write down 95% confidence interval for the slope of the relationship between price and size.
  2. 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.
  3. 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

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!