Scribd
Upload
6 views3 pages

Assignment Coefficient

The analysis reveals a moderate positive correlation (r = 0.361, p = 0.009) between House Age and Market Value, indicating that older houses tend to have higher market values. The model explains 13.1% of the variance in Market Value, suggesting a weak fit with significant contributions from other factors. The regression model indicates that for each additional year in House Age, the Market Value increases by approximately 1570.434 units.

Uploaded by

huynguyen.31241022970
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views3 pages

Assignment Coefficient

The analysis reveals a moderate positive correlation (r = 0.361, p = 0.009) between House Age and Market Value, indicating that older houses tend to have higher market values. The model explains 13.1% of the variance in Market Value, suggesting a weak fit with significant contributions from other factors. The regression model indicates that for each additional year in House Age, the Market Value increases by approximately 1570.434 units.

Uploaded by

huynguyen.31241022970
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

the relationship of HA –> MV

Step 1: Correlation

Correlations
House Age Market Value
Pearson Correlation House Age 1,000 ,361
Market Value ,361 1,000
Sig. (1-tailed) House Age . ,009
Market Value ,009 .
N House Age 42 42
Market Value 42 42
R=0,361, p = 0,009 <0,05
There is a moderate positive relationship between House Age and Market Value with r = 0,361 and it is
significant at 0,009 (p=0,009<0,05)

Step 2: Model Summary

Model Summary
Adjusted R Std. Error of the
Model R R Square Square Estimate
1 ,361a ,131 ,109 2,293
a. Predictors: (Constant), Market Value

R^2= 0,131

Adjusted R^2 = 0,109

The independent variable, House Age, explains 13.1% of the variance in the
dependent variable , Market Value with R^2= 0,131. Therefore, the model has
a weak fit. About 87% of the variation is explained by other factors not included in
the model.
Step 3: ANOVA

ANOVAa
Model Sum of Squares df Mean Square F Sig.
1 Regression 596424728,923 1 596424728,923 6,010 ,019b
Residual 3969645032,982 40 99241125,825
Total 4566069761,905 41
a. Dependent Variable: Market Value
b. Predictors: (Constant), House Age

H0: population slope coefficient equals 0

H1: population slope coefficient is different to 0

F= 6,010 p= 0,019<0,05 -> Reject H0, Accept H1  Regression line

H1: population slope coefficient is different to 0

Step 4: Coefficient Assessment

Coefficientsa
Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics
Model B Std. Error Beta t Sig. Tolerance VIF
1 (Constant) 45217,761 19172,989 2,358 ,023
House Age 1570,434 640,601 ,361 2,452 ,019 1,000 1,000
a. Dependent Variable: Market Value

Constant t=2,358, p<0,05


β : t= 2,452, p=0,019< 0,05 -> β is sig
Step 5 regression model

* Unstandardized Regression Model (Forecasting)

DV = β 0+ β 1∗IV −→MV = 45217,761+ 1570,434* HA

* Standardized Regression Model (Relationship)


MV = 0,361 HA (unit in Std Deviation)

You might also like