Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Your real estate agent recently stated that houses in the suburb typically had an average price around 1200 ($000), but have recently changed. Test his claim at the 5% level of significance. Show all...

1 answer below »
Your real estate agent recently stated that houses in the suburb typically had an average price around 1200 ($000), but have recently changed. Test his claim at the 5% level of significance. Show all your calculations XXXXXXXXXXMarks) 2. Run a simple linear regression using the House prices and the size data and a) Interpret the coefficients. b) Show the output from Excel including a scatter plot. (3 Marks) 3. What is the value of correlation coefficient? Interpret the correlation coefficient. (2 Marks) 4. Is the coefficient estimate for the Size statistically different than zero at the 5% level of significance? Set-up the correct hypothesis test using the results found in the table in question 2 using both the critical value and p-value approach. Interpret the coefficient estimate of the slope XXXXXXXXXXMarks)
Answered Same Day Oct 05, 2020 ECON1248

Solution

Pooja answered on Oct 06 2020
140 Votes
1)
Null hypothesis, ho: an average price is 1200 ($000). V/s Alternative Hypothesis, h1: an average price is not 1200 ($000),
Mean= 321,858
sd= sqrt(var) 49578.87486
u= 1,200,000
n= 50.00
alpha= 5%
Critical value, z(a/2)
z(0.05/2)
1.960
Test statistic, z = (mean-u)/(sd/sqrt(n))
= (321858-1200000)/(49578.8748627181/sqrt(50))
-125.2429
P-value
2*(1-P(z<|z|)
2*(1-P(znormsdist(abs(-125.2429))
0.0000
With z=125.24, p<5%, i reject null hypothesis and conclude that an average price is not 1200 ($000), hence i can say that average prices have recently changed. Darlington, R. B., & Hayes, A. F. (2016). 
2)
a) Intercept, bo = 317992.4. The initial price is $317992.4 when size is zero.
Slope, b1 = 1.48. As the value of size increases by 1 unit. There is a 1.48$ increase in price.
) Regression output:
    SUMMARY OUTPUT
    Â 
    Â 
    Regression Statistics
    Multiple R
    0.102367
    R Square
    0.010479
    Adjusted R Square
    -0.01014
    Standard E
o
    49829.51
    Observations
    50
 
    ANOVA
    Â 
    Â 
    Â 
    Â 
    Â 
    Â 
    df
    SS
    MS
    F
    Significance...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here