I need HELP with my Statistics Project ( See attached files )
Sam88716
mgt2217-project.docxDescriptive Statistics: Price, SQ Ft, Bdrms, Land, Baths, Age
Variable Mean StDev Minimum Q1 Median Q3 Maximum
Price 238648 134736 47500 155438 190450 286175 679900
SQ Ft 1999 840 414 1368 1859 2633 4380
Bdrms 3.283 0.846 1.000 3.000 3.000 4.000 6.000
Land 0.834 2.491 0.022 0.133 0.165 0.255 16.380
Baths 2.233 0.890 1.000 2.000 2.000 3.000 5.000
Age 1974.4 29.2 1901.0 1953.0 1977.5 1998.0 2014.0
Regression Analysis: Price versus SQ Ft, Bdrms, Land, Baths, Garage, Age
The regression equation is
Price = - 904501 + 110 SQ Ft - 27174 Bdrms + 30997 Land + 6236 Baths
+ 16216 Garage + 477 Age
Predictor Coef SE Coef T P VIF
Constant -904501 620541 -1.46 0.151
SQ Ft 110.09 17.14 6.42 0.000 3.138
Bdrms -27174 13776 -1.97 0.054 2.052
Land 30997 3435 9.02 0.000 1.108
Baths 6236 14099 0.44 0.660 2.382
Garage 16216 11360 1.43 0.159 1.105
Age 477.0 315.8 1.51 0.137 1.287
S = 62455.7 R-Sq = 80.7% R-Sq(adj) = 78.5%
Analysis of Variance
Source DF SS MS F P
Regression 6 8.64337E+11 1.44056E+11 36.93 0.000
Residual Error 53 2.06738E+11 3900711965
Total 59 1.07108E+12
①
H0: B1=B2=B3=B4=B5=B6≠0
H1: At least one B=0
Since P-value < 0.05, Model is significant
Assumption is met (No pattern)
Since P-value < 0.05, so the assumption is met
H0: B1=B2=B3=B4=B5=B6≠0
H1: At least one B=0
Constant Variance (Assumption is met)
Normality Test (Assumption is met)
Test of Model (Significant)
R2= 80.7% (High)
No MC (No VIF > 5)
Overall, this is a good model also has high explanatory power, but one of the assumptions is not met.
Correlations: Price, SQ Ft, Bdrms, Land, Baths, Age
Price SQ Ft Bdrms Land Baths
SQ Ft 0.695
0.000
Bdrms 0.449 0.678
0.000 0.000
Land 0.623 0.133 0.217
0.000 0.311 0.096
Baths 0.497 0.709 0.474 0.002
0.000 0.000 0.000 0.987
Age 0.194 0.240 0.015 -0.157 0.407
0.138 0.065 0.911 0.231 0.001
Cell Contents: Pearson correlation
P-Value
7
0
0
0
0
0
6
0
0
0
0
0
5
0
0
0
0
0
4
0
0
0
0
0
3
0
0
0
0
0
2
0
0
0
0
0
1
0
0
0
0
0
0
3
2
1
0
-
1
-
2
-
3
F
i
t
t
e
d
V
a
l
u
e
S
t
a
n
d
a
r
d
i
z
e
d
R
e
s
i
d
u
a
l
V
e
r
s
u
s
F
i
t
s
(
r
e
s
p
o
n
s
e
i
s
P
r
i
c
e
)
2
0
0
0
0
0
1
0
0
0
0
0
0
-
1
0
0
0
0
0
-
2
0
0
0
0
0
9
9
.
9
9
9
9
5
9
0
8
0
7
0
6
0
5
0
4
0
3
0
2
0
1
0
5
1
0
.
1
R
E
S
I
1
P
e
r
c
e
n
t
M
e
a
n
2
.
8
5
2
1
7
5
E
-
1
0
S
t
D
e
v
5
9
1
9
5
N
6
0
K
S
0
.
1
3
4
P
-
V
a
l
u
e
<
0
.
0
1
0
P
r
o
b
a
b
i
l
i
t
y
P
l
o
t
o
f
R
E
S
I
1
N
o
r
m
a
l
