Stepwise Regression Analysis of Price
Stepwise Regression Analysis of Price
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT price
/METHOD=STEPWISE carat table y z cut_Good cut_Ideal cut_Premium cut_VeryGood
color_E color_F
color_G color_H color_I color_J clarity_IF clarity_SI1 clarity_SI2 clarity
_VS1 clarity_VS2
clarity_VVS1 clarity_VVS2 x depth
/RESIDUALS HISTOGRAM(ZRESID) NORMPROB(ZRESID).
Regression
a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
1 carat . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
2 clarity_SI2 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
Page 1
a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
3 color_J . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
4 clarity_SI1 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
5 color_I . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
6 color_H . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
7 x . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
Page 2
a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
8 depth . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
9 table . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
10 clarity_VVS2 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
11 clarity_IF . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
12 clarity_VVS1 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
Page 3
a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
13 clarity_VS1 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
14 clarity_VS2 . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
15 color_G . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
16 color_F . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
17 color_E . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
Page 4
a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
18 cut_Ideal . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
19 cut_Premium . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
20 cut_VeryGood . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
21 cut_Good . Stepwise
(Criteria:
Probability-of-
F-to-enter <=
.050,
Probability-of-
F-to-remove
>= .100).
Page 5
v
Model Summary
Adjusted R Std. Error of the
Model R R Square Square Estimate
a
1 .922 .849 .849 1548.5619
b
2 .930 .864 .864 1469.3635
c
3 .934 .873 .873 1422.8377
d
4 .938 .881 .881 1378.4036
e
5 .941 .886 .886 1349.8389
f
6 .943 .889 .889 1328.9494
g
7 .945 .893 .893 1306.9757
h
8 .946 .895 .895 1295.0167
i
9 .947 .896 .896 1284.6707
j
10 .947 .898 .897 1277.3233
k
11 .948 .899 .899 1268.4414
l
12 .949 .901 .901 1257.6910
m
13 .950 .902 .902 1248.1280
n
14 .958 .918 .918 1145.1255
o
15 .958 .918 .918 1139.7006
p
16 .958 .919 .919 1138.5498
q
17 .959 .919 .919 1137.1274
r
18 .959 .919 .919 1136.3081
s
19 .959 .919 .919 1135.4578
t
20 .959 .919 .919 1133.2135
u
21 .959 .920 .920 1130.0979
Page 6
l. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1
m. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1
n. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2
o. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G
p. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F
q. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E
r. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal
s. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium
t. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium, cut_VeryGood
u. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium, cut_VeryGood, cut_Good
v. Dependent Variable: price
Page 7
a
ANOVA
Sum of
Model Squares df Mean Square F Sig.
b
1 Regression 7.291E+11 1 7.291E+11 304050.906 .000
Page 8
a
ANOVA
Sum of
Model Squares df Mean Square F Sig.
m
12 Regression 7.732E+11 12 6.443E+10 40733.061 .000
Page 9
d. Predictors: (Constant), carat, clarity_SI2, color_J
e. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1
f. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I
g. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H
h. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x
i. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth
j. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table
k. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2
l. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF
m. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1
n. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1
o. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2
p. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G
q. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F
r. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E
s. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal
t. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium
u. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium, cut_VeryGood
v. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, cut_Ideal,
cut_Premium, cut_VeryGood, cut_Good
Page 10
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) -2256.361 13.055 -172.830 .000
carat 7756.426 14.067 .922 551.408 .000
2 (Constant) -2254.833 12.388 -182.022 .000
carat 8042.760 13.852 .956 580.625 .000
clarity_SI2 -1349.405 17.461 -.127 -77.280 .000
3 (Constant) -2280.453 12.003 -189.989 .000
carat 8195.527 13.654 .974 600.241 .000
clarity_SI2 -1400.832 16.930 -.132 -82.742 .000
color_J -1681.092 28.073 -.094 -59.884 .000
4 (Constant) -2110.867 11.973 -176.303 .000
carat 8307.315 13.360 .987 621.790 .000
clarity_SI2 -1689.828 17.107 -.159 -98.782 .000
color_J -1701.410 27.198 -.095 -62.556 .000
clarity_SI1 -860.686 14.477 -.092 -59.451 .000
5 (Constant) -2093.986 11.730 -178.513 .000
carat 8426.373 13.316 1.001 632.796 .000
clarity_SI2 -1733.350 16.777 -.163 -103.319 .000
color_J -1847.516 26.807 -.103 -68.918 .000
clarity_SI1 -867.096 14.178 -.093 -61.158 .000
color_I -948.127 19.736 -.071 -48.040 .000
6 (Constant) -2034.180 11.639 -174.776 .000
carat 8508.966 13.261 1.011 641.638 .000
clarity_SI2 -1744.729 16.519 -.164 -105.618 .000
color_J -2004.686 26.665 -.112 -75.181 .000
clarity_SI1 -854.663 13.962 -.092 -61.215 .000
color_I -1094.101 19.749 -.082 -55.401 .000
color_H -675.074 16.326 -.061 -41.351 .000
7 (Constant) 1754.907 89.317 19.648 .000
carat 10761.433 54.249 1.279 198.372 .000
Page 11
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
clarity_SI2 -1697.735 16.283 -.160 -104.263 .000
color_J -2068.936 26.267 -.115 -78.766 .000
clarity_SI1 -795.999 13.799 -.085 -57.684 .000
color_I -1142.970 19.456 -.086 -58.747 .000
color_H -700.091 16.066 -.063 -43.575 .000
x -976.510 22.829 -.275 -42.776 .000
8 (Constant) 10289.074 283.798 36.255 .000
carat 11176.768 55.331 1.328 201.998 .000
clarity_SI2 -1681.909 16.142 -.159 -104.194 .000
color_J -2059.935 26.028 -.115 -79.142 .000
clarity_SI1 -767.237 13.703 -.082 -55.990 .000
color_I -1135.753 19.279 -.086 -58.911 .000
color_H -689.649 15.923 -.062 -43.312 .000
x -1154.958 23.312 -.325 -49.544 .000
depth -127.213 4.019 -.046 -31.649 .000
9 (Constant) 17027.968 362.311 46.998 .000
carat 11235.279 54.925 1.335 204.558 .000
clarity_SI2 -1648.304 16.053 -.155 -102.676 .000
color_J -2049.279 25.823 -.114 -79.359 .000
clarity_SI1 -737.652 13.630 -.079 -54.118 .000
color_I -1136.654 19.125 -.086 -59.432 .000
color_H -689.612 15.795 -.062 -43.659 .000
x -1153.995 23.126 -.324 -49.901 .000
depth -164.397 4.181 -.059 -39.318 .000
table -78.465 2.655 -.044 -29.549 .000
10 (Constant) 16610.734 360.627 46.061 .000
carat 11197.942 54.631 1.331 204.974 .000
clarity_SI2 -1579.231 16.200 -.149 -97.486 .000
color_J -2030.629 25.686 -.113 -79.056 .000
clarity_SI1 -664.834 13.863 -.071 -47.958 .000
color_I -1125.173 19.021 -.085 -59.153 .000
color_H -681.705 15.708 -.062 -43.398 .000
x -1130.140 23.013 -.318 -49.108 .000
depth -162.117 4.158 -.058 -38.987 .000
Page 12
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
table -76.887 2.641 -.043 -29.113 .000
clarity_VVS2 490.982 19.667 .036 24.964 .000
11 (Constant) 15715.404 359.591 43.704 .000
carat 11131.527 54.305 1.323 204.983 .000
clarity_SI2 -1535.760 16.164 -.145 -95.010 .000
color_J -2027.025 25.508 -.113 -79.467 .000
clarity_SI1 -615.093 13.884 -.066 -44.301 .000
color_I -1125.338 18.889 -.085 -59.576 .000
color_H -689.659 15.602 -.062 -44.204 .000
x -1089.894 22.900 -.306 -47.594 .000
depth -155.644 4.136 -.056 -37.631 .000
table -72.276 2.628 -.040 -27.503 .000
clarity_VVS2 554.639 19.667 .041 28.202 .000
clarity_IF 862.389 31.305 .039 27.548 .000
12 (Constant) 14681.717 358.156 40.992 .000
carat 11018.373 53.973 1.309 204.147 .000
clarity_SI2 -1455.837 16.241 -.137 -89.641 .000
color_J -2012.454 25.296 -.112 -79.556 .000
clarity_SI1 -523.754 14.090 -.056 -37.173 .000
color_I -1133.831 18.731 -.085 -60.532 .000
color_H -701.759 15.475 -.063 -45.349 .000
x -1018.413 22.827 -.286 -44.615 .000
depth -148.933 4.107 -.053 -36.264 .000
table -68.724 2.608 -.038 -26.349 .000
clarity_VVS2 668.119 19.853 .049 33.653 .000
clarity_IF 986.900 31.308 .044 31.522 .000
clarity_VVS1 697.799 22.920 .044 30.444 .000
13 (Constant) 14154.816 355.903 39.772 .000
carat 11037.796 53.566 1.311 206.058 .000
clarity_SI2 -1266.235 17.408 -.119 -72.737 .000
color_J -2029.443 25.111 -.113 -80.820 .000
clarity_SI1 -329.429 15.524 -.035 -21.221 .000
color_I -1152.161 18.600 -.087 -61.946 .000
color_H -709.269 15.359 -.064 -46.179 .000
Page 13
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
x -1018.746 22.653 -.286 -44.971 .000
depth -145.370 4.078 -.052 -35.651 .000
table -66.957 2.589 -.038 -25.860 .000
clarity_VVS2 867.341 20.880 .063 41.540 .000
clarity_IF 1189.811 31.858 .053 37.348 .000
clarity_VVS1 899.793 23.802 .057 37.804 .000
clarity_VS1 509.034 17.663 .046 28.819 .000
14 (Constant) 7282.951 333.588 21.832 .000
carat 11285.665 49.208 1.341 229.348 .000
clarity_SI2 2859.082 43.974 .269 65.018 .000
color_J -2085.882 23.045 -.116 -90.513 .000
clarity_SI1 3831.089 43.706 .411 87.656 .000
color_I -1178.887 17.067 -.089 -69.076 .000
color_H -701.125 14.092 -.063 -49.754 .000
x -1062.676 20.788 -.299 -51.119 .000
depth -113.065 3.755 -.041 -30.112 .000
table -53.676 2.379 -.030 -22.561 .000
clarity_VVS2 5073.712 45.958 .371 110.398 .000
clarity_IF 5419.572 51.176 .243 105.901 .000
clarity_VVS1 5121.005 47.269 .323 108.336 .000
clarity_VS1 4697.829 44.646 .422 105.224 .000
clarity_VS2 4424.467 43.942 .465 100.690 .000
15 (Constant) 7228.070 332.016 21.770 .000
carat 11296.349 48.977 1.342 230.648 .000
clarity_SI2 2847.579 43.768 .268 65.060 .000
color_J -2185.747 23.354 -.122 -93.593 .000
clarity_SI1 3823.031 43.500 .411 87.885 .000
color_I -1276.734 17.524 -.096 -72.857 .000
color_H -795.189 14.624 -.072 -54.375 .000
x -1053.648 20.694 -.296 -50.916 .000
depth -110.947 3.738 -.040 -29.680 .000
table -54.590 2.368 -.031 -23.051 .000
clarity_VVS2 5101.983 45.758 .373 111.500 .000
clarity_IF 5484.719 51.014 .246 107.514 .000
Page 14
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
clarity_VVS1 5154.799 47.069 .325 109.516 .000
clarity_VS1 4725.937 44.452 .425 106.316 .000
clarity_VS2 4426.505 43.733 .465 101.215 .000
color_G -296.438 13.055 -.030 -22.706 .000
16 (Constant) 7211.486 331.685 21.742 .000
carat 11285.398 48.938 1.341 230.604 .000
clarity_SI2 2839.109 43.732 .268 64.921 .000
color_J -2246.136 24.030 -.125 -93.473 .000
clarity_SI1 3814.991 43.463 .410 87.775 .000
color_I -1336.524 18.410 -.101 -72.596 .000
color_H -854.045 15.649 -.077 -54.573 .000
x -1044.499 20.691 -.294 -50.480 .000
depth -110.318 3.735 -.040 -29.537 .000
table -54.667 2.366 -.031 -23.107 .000
clarity_VVS2 5102.511 45.711 .373 111.624 .000
clarity_IF 5499.150 50.981 .247 107.866 .000
clarity_VVS1 5160.812 47.025 .325 109.746 .000
clarity_VS1 4725.967 44.407 .425 106.424 .000
clarity_VS2 4421.575 43.692 .464 101.199 .000
color_G -355.673 14.212 -.036 -25.027 .000
color_F -154.581 14.734 -.015 -10.491 .000
17 (Constant) 7311.053 331.380 22.062 .000
carat 11286.546 48.877 1.341 230.916 .000
clarity_SI2 2832.240 43.681 .267 64.839 .000
color_J -2371.325 26.291 -.132 -90.194 .000
clarity_SI1 3807.315 43.414 .409 87.698 .000
color_I -1461.735 21.293 -.110 -68.649 .000
color_H -978.889 18.945 -.089 -51.670 .000
x -1044.128 20.665 -.294 -50.525 .000
depth -110.281 3.730 -.040 -29.564 .000
table -54.258 2.363 -.030 -22.960 .000
clarity_VVS2 5102.846 45.654 .373 111.771 .000
clarity_IF 5499.383 50.918 .247 108.006 .000
clarity_VVS1 5165.055 46.968 .325 109.970 .000
Page 15
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
clarity_VS1 4725.465 44.351 .425 106.546 .000
clarity_VS2 4418.184 43.638 .464 101.246 .000
color_G -481.298 17.819 -.049 -27.010 .000
color_F -279.497 18.202 -.027 -15.356 .000
color_E -209.926 18.002 -.020 -11.661 .000
18 (Constant) 6011.749 362.052 16.605 .000
carat 11290.249 48.844 1.341 231.150 .000
clarity_SI2 2835.791 43.651 .267 64.965 .000
color_J -2368.542 26.274 -.132 -90.146 .000
clarity_SI1 3809.686 43.383 .409 87.814 .000
color_I -1461.815 21.278 -.110 -68.702 .000
color_H -976.575 18.933 -.088 -51.580 .000
x -1044.646 20.651 -.294 -50.587 .000
depth -103.129 3.814 -.037 -27.042 .000
table -40.093 2.850 -.022 -14.067 .000
clarity_VVS2 5095.546 45.629 .373 111.674 .000
clarity_IF 5482.712 50.916 .246 107.682 .000
clarity_VVS1 5155.174 46.947 .325 109.808 .000
clarity_VS1 4722.020 44.321 .424 106.541 .000
clarity_VS2 4415.636 43.608 .464 101.258 .000
color_G -479.522 17.807 -.049 -26.928 .000
color_F -276.727 18.191 -.026 -15.212 .000
color_E -207.848 17.990 -.020 -11.553 .000
cut_Ideal 109.932 12.385 .013 8.876 .000
19 (Constant) 5517.658 365.883 15.080 .000
carat 11287.106 48.809 1.341 231.253 .000
clarity_SI2 2832.310 43.620 .267 64.931 .000
color_J -2369.099 26.255 -.132 -90.235 .000
clarity_SI1 3808.059 43.351 .409 87.842 .000
color_I -1463.356 21.262 -.110 -68.824 .000
color_H -980.512 18.924 -.089 -51.813 .000
x -1044.826 20.635 -.294 -50.633 .000
depth -95.585 3.901 -.034 -24.503 .000
table -40.350 2.848 -.023 -14.167 .000
Page 16
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
clarity_VVS2 5097.371 45.595 .373 111.796 .000
clarity_IF 5482.973 50.877 .246 107.768 .000
clarity_VVS1 5155.193 46.912 .325 109.891 .000
clarity_VS1 4719.687 44.289 .424 106.566 .000
clarity_VS2 4410.272 43.579 .463 101.201 .000
color_G -483.532 17.800 -.049 -27.165 .000
color_F -276.779 18.178 -.026 -15.226 .000
color_E -206.954 17.977 -.020 -11.512 .000
cut_Ideal 159.655 13.542 .020 11.790 .000
cut_Premium 119.215 13.182 .013 9.044 .000
20 (Constant) 3953.445 380.438 10.392 .000
carat 11268.050 48.729 1.339 231.237 .000
clarity_SI2 2792.387 43.619 .263 64.017 .000
color_J -2369.325 26.203 -.132 -90.422 .000
clarity_SI1 3763.348 43.373 .404 86.767 .000
color_I -1464.626 21.220 -.110 -69.019 .000
color_H -982.587 18.887 -.089 -52.024 .000
x -1036.696 20.602 -.292 -50.321 .000
depth -81.090 4.017 -.029 -20.187 .000
table -31.695 2.903 -.018 -10.917 .000
clarity_VVS2 5043.390 45.654 .369 110.470 .000
clarity_IF 5436.106 50.878 .244 106.847 .000
clarity_VVS1 5102.226 46.958 .321 108.654 .000
clarity_VS1 4672.051 44.320 .420 105.415 .000
clarity_VS2 4362.101 43.617 .458 100.009 .000
color_G -483.944 17.765 -.049 -27.242 .000
color_F -275.517 18.142 -.026 -15.187 .000
color_E -208.796 17.942 -.020 -11.637 .000
cut_Ideal 361.564 19.299 .044 18.734 .000
cut_Premium 301.366 18.099 .033 16.651 .000
cut_VeryGood 267.540 18.255 .028 14.655 .000
21 (Constant) 2366.086 390.351 6.061 .000
carat 11256.968 48.600 1.338 231.626 .000
clarity_SI2 2702.077 43.812 .255 61.674 .000
Page 17
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
color_J -2369.504 26.131 -.132 -90.678 .000
clarity_SI1 3664.905 43.627 .394 84.005 .000
color_I -1466.182 21.162 -.111 -69.283 .000
color_H -980.122 18.836 -.089 -52.035 .000
x -1029.478 20.549 -.289 -50.098 .000
depth -66.769 4.091 -.024 -16.322 .000
table -26.457 2.911 -.015 -9.089 .000
clarity_VVS2 4950.168 45.847 .362 107.972 .000
clarity_IF 5344.338 51.015 .240 104.761 .000
clarity_VVS1 5007.061 47.152 .315 106.190 .000
clarity_VS1 4577.589 44.535 .411 102.786 .000
clarity_VS2 4266.612 43.847 .448 97.308 .000
color_G -481.943 17.716 -.049 -27.204 .000
color_F -272.834 18.093 -.026 -15.080 .000
color_E -209.237 17.893 -.020 -11.694 .000
cut_Ideal 833.260 33.396 .102 24.951 .000
cut_Premium 762.759 32.225 .083 23.670 .000
cut_VeryGood 726.820 32.212 .076 22.564 .000
cut_Good 580.240 33.572 .042 17.283 .000
Page 18
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
b
1 table -.042 -24.623 .000 -.105 .967
b
y -.124 -22.872 .000 -.098 .094
b
z -.191 -34.856 .000 -.148 .091
b
cut_Good -.032 -19.118 .000 -.082 .999
b
cut_Ideal .055 32.864 .000 .140 .973
b
cut_Premium -.012 -6.885 .000 -.030 .986
b
cut_VeryGood -.002 -1.331 .183 -.006 1.000
b
color_E .028 16.482 .000 .071 .981
b
color_F .031 18.752 .000 .080 .996
b
color_G .035 21.228 .000 .091 .999
b
color_H -.036 -21.265 .000 -.091 .990
b
color_I -.053 -31.638 .000 -.135 .974
b
color_J -.087 -52.525 .000 -.221 .968
b
clarity_IF .057 34.013 .000 .145 .987
b
clarity_SI1 -.049 -29.489 .000 -.126 .996
b
clarity_SI2 -.127 -77.280 .000 -.316 .928
b
clarity_VS1 .048 29.160 .000 .125 .996
b
clarity_VS2 .035 20.917 .000 .090 .998
b
clarity_VVS1 .061 36.345 .000 .155 .972
b
clarity_VVS2 .075 45.484 .000 .192 .981
b
x -.289 -38.848 .000 -.165 .049
b
depth -.037 -22.041 .000 -.094 .999
c
2 table -.036 -22.118 .000 -.095 .965
c
y -.112 -21.826 .000 -.094 .094
c
z -.180 -34.544 .000 -.147 .091
c
cut_Good -.028 -17.507 .000 -.075 .998
c
cut_Ideal .047 29.352 .000 .125 .969
c
cut_Premium -.007 -4.307 .000 -.019 .985
c
cut_VeryGood -.002 -1.222 .222 -.005 1.000
c
color_E .033 20.894 .000 .090 .979
c
color_F .033 20.894 .000 .090 .996
c
Page 19
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
c
color_G .031 19.321 .000 .083 .998
c
color_H -.037 -23.015 .000 -.099 .989
c
color_I -.059 -37.221 .000 -.158 .972
c
color_J -.094 -59.884 .000 -.250 .965
c
clarity_IF .050 31.494 .000 .134 .984
c
clarity_SI1 -.091 -56.651 .000 -.237 .916
c
clarity_VS1 .027 16.779 .000 .072 .963
c
clarity_VS2 .005 3.157 .002 .014 .939
c
clarity_VVS1 .051 31.951 .000 .136 .965
c
clarity_VVS2 .062 38.984 .000 .166 .968
c
x -.263 -37.274 .000 -.158 .049
c
depth -.037 -23.269 .000 -.100 .999
d
3 table -.035 -22.409 .000 -.096 .965
d
y -.123 -24.605 .000 -.105 .094
d
Page 20
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
d
z -.187 -37.182 .000 -.158 .091
d
cut_Good -.027 -17.436 .000 -.075 .998
d
cut_Ideal .046 29.545 .000 .126 .969
d
cut_Premium -.007 -4.559 .000 -.020 .985
d
cut_VeryGood -.001 -.762 .446 -.003 1.000
d
color_E .026 16.470 .000 .071 .971
d
color_F .024 15.672 .000 .067 .986
d
color_G .020 12.836 .000 .055 .983
d
color_H -.048 -31.447 .000 -.134 .975
d
color_I -.071 -45.902 .000 -.194 .959
d
clarity_IF .050 32.429 .000 .138 .984
d
clarity_SI1 -.092 -59.451 .000 -.248 .916
d
clarity_VS1 .030 19.187 .000 .082 .962
d
clarity_VS2 .006 4.098 .000 .018 .939
d
clarity_VVS1 .050 32.224 .000 .137 .965
d
clarity_VVS2 .060 39.078 .000 .166 .968
d
x -.284 -41.563 .000 -.176 .049
d
depth -.035 -22.961 .000 -.098 .999
e
4 table -.030 -19.686 .000 -.084 .961
e
y -.104 -21.568 .000 -.092 .094
e
z -.164 -33.494 .000 -.143 .090
e
cut_Good -.021 -14.049 .000 -.060 .993
e
cut_Ideal .037 24.720 .000 .106 .959
e
cut_Premium -.005 -3.035 .002 -.013 .984
e
cut_VeryGood .002 1.246 .213 .005 .999
e
color_E .028 18.679 .000 .080 .971
e
color_F .023 15.312 .000 .066 .986
e
color_G .011 7.536 .000 .032 .974
e
color_H -.046 -31.090 .000 -.133 .974
e
color_I -.071 -48.040 .000 -.203 .959
e
clarity_IF .040 26.414 .000 .113 .970
e
Page 21
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
e
clarity_VS1 .003 1.710 .087 .007 .873
e
clarity_VS2 -.036 -21.619 .000 -.093 .786
e
clarity_VVS1 .035 22.991 .000 .099 .936
e
clarity_VVS2 .043 27.640 .000 .118 .922
e
x -.247 -36.990 .000 -.157 .048
e
depth -.032 -21.253 .000 -.091 .997
f
5 table -.030 -20.499 .000 -.088 .961
f
y -.113 -23.892 .000 -.102 .094
f
z -.171 -35.731 .000 -.152 .090
f
cut_Good -.021 -14.146 .000 -.061 .993
f
cut_Ideal .038 25.851 .000 .111 .959
f
cut_Premium -.005 -3.645 .000 -.016 .984
f
cut_VeryGood .002 1.188 .235 .005 .999
f
color_E .018 12.085 .000 .052 .950
f
color_F .012 8.016 .000 .034 .961
f
color_G -.002 -1.449 .147 -.006 .939
f
color_H -.061 -41.351 .000 -.175 .943
f
clarity_IF .040 27.076 .000 .116 .970
f
clarity_VS1 .005 3.138 .002 .014 .872
f
clarity_VS2 -.038 -23.013 .000 -.099 .786
f
clarity_VVS1 .037 24.375 .000 .104 .935
f
clarity_VVS2 .041 27.309 .000 .117 .921
f
x -.264 -40.510 .000 -.172 .048
f
depth -.030 -20.696 .000 -.089 .997
g
6 table -.031 -21.198 .000 -.091 .961
g
y -.118 -25.372 .000 -.109 .093
g
z -.175 -37.137 .000 -.158 .090
g
cut_Good -.021 -14.897 .000 -.064 .993
g
cut_Ideal .038 26.164 .000 .112 .959
g
cut_Premium -.005 -3.126 .002 -.013 .984
g
cut_VeryGood .001 .973 .331 .004 .999
g
Page 22
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
g
color_E .004 2.597 .009 .011 .897
g
color_F -.003 -1.963 .050 -.008 .904
g
color_G -.021 -13.547 .000 -.058 .866
g
clarity_IF .041 28.434 .000 .122 .969
g
clarity_VS1 .005 3.530 .000 .015 .872
g
clarity_VS2 -.039 -24.376 .000 -.104 .786
g
clarity_VVS1 .038 25.965 .000 .111 .935
g
clarity_VVS2 .040 26.945 .000 .115 .921
g
x -.275 -42.776 .000 -.181 .048
g
depth -.028 -19.823 .000 -.085 .996
h
7 table -.026 -18.317 .000 -.079 .956
h
y .031 4.856 .000 .021 .050
h
z -.084 -14.145 .000 -.061 .057
h
cut_Good -.023 -16.085 .000 -.069 .992
h
cut_Ideal .038 26.547 .000 .114 .959
h
cut_Premium -.001 -.742 .458 -.003 .981
h
cut_VeryGood .000 -.084 .933 .000 .998
h
color_E .003 1.828 .068 .008 .897
h
color_F -.001 -.790 .429 -.003 .904
h
color_G -.021 -13.647 .000 -.059 .866
h
clarity_IF .038 26.726 .000 .114 .967
h
clarity_VS1 .009 5.841 .000 .025 .870
h
clarity_VS2 -.035 -21.881 .000 -.094 .782
h
clarity_VVS1 .034 23.008 .000 .099 .929
h
clarity_VVS2 .038 25.724 .000 .110 .920
h
depth -.046 -31.649 .000 -.135 .938
i
8 table -.044 -29.549 .000 -.126 .869
i
y .025 4.025 .000 .017 .050
i
z .008 1.254 .210 .005 .043
i
cut_Good -.017 -12.140 .000 -.052 .975
i
cut_Ideal .037 26.304 .000 .113 .959
i
Page 23
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
i
cut_Premium -.010 -7.136 .000 -.031 .943
i
cut_VeryGood .001 .509 .611 .002 .998
i
color_E .002 1.186 .235 .005 .896
i
color_F -.001 -.696 .487 -.003 .904
i
color_G -.019 -13.001 .000 -.056 .866
i
clarity_IF .036 25.789 .000 .110 .965
i
clarity_VS1 .009 5.906 .000 .025 .870
i
clarity_VS2 -.033 -21.237 .000 -.091 .782
i
clarity_VVS1 .032 22.159 .000 .095 .928
i
clarity_VVS2 .037 25.469 .000 .109 .919
j
9 y .018 2.903 .004 .013 .050
j
z .005 .678 .498 .003 .043
j
cut_Good -.008 -5.830 .000 -.025 .927
j
cut_Ideal .020 11.727 .000 .050 .653
j
cut_Premium .002 1.075 .282 .005 .870
j
cut_VeryGood .006 4.471 .000 .019 .980
j
color_E .003 1.924 .054 .008 .896
j
color_F -.001 -.622 .534 -.003 .904
j
color_G -.021 -13.889 .000 -.060 .865
j
clarity_IF .034 24.226 .000 .104 .962
j
clarity_VS1 .009 6.188 .000 .027 .870
j
clarity_VS2 -.032 -20.212 .000 -.087 .780
j
clarity_VVS1 .031 21.408 .000 .092 .927
j
clarity_VVS2 .036 24.964 .000 .107 .919
k
10 y .017 2.803 .005 .012 .050
k
z .004 .655 .513 .003 .043
k
cut_Good -.008 -5.605 .000 -.024 .927
k
cut_Ideal .019 11.413 .000 .049 .653
k
cut_Premium .003 1.928 .054 .008 .869
k
cut_VeryGood .005 3.798 .000 .016 .979
k
color_E .003 2.083 .037 .009 .896
k
Page 24
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
k
color_F -.001 -.499 .618 -.002 .903
k
color_G -.022 -14.536 .000 -.062 .865
k
clarity_IF .039 27.548 .000 .118 .949
k
clarity_VS1 .020 12.983 .000 .056 .814
k
clarity_VS2 -.021 -12.511 .000 -.054 .690
k
clarity_VVS1 .038 26.313 .000 .113 .899
l
11 y .017 2.698 .007 .012 .050
l
z .004 .578 .564 .002 .043
l
cut_Good -.008 -5.541 .000 -.024 .927
l
cut_Ideal .017 10.131 .000 .044 .652
l
cut_Premium .004 2.778 .005 .012 .868
l
cut_VeryGood .006 4.314 .000 .019 .979
l
color_E .005 3.626 .000 .016 .893
l
color_F -.001 -1.009 .313 -.004 .903
l
color_G -.025 -16.798 .000 -.072 .860
l
clarity_VS1 .028 18.267 .000 .078 .789
l
clarity_VS2 -.011 -6.196 .000 -.027 .651
l
clarity_VVS1 .044 30.444 .000 .130 .884
m
12 y .016 2.639 .008 .011 .050
m
z .003 .525 .600 .002 .043
m
cut_Good -.007 -5.247 .000 -.023 .927
m
cut_Ideal .015 9.080 .000 .039 .651
m
cut_Premium .006 3.820 .000 .016 .867
m
cut_VeryGood .006 4.094 .000 .018 .979
m
color_E .006 4.258 .000 .018 .893
m
color_F -.002 -1.604 .109 -.007 .903
m
color_G -.027 -18.354 .000 -.079 .858
m
clarity_VS1 .046 28.819 .000 .123 .720
m
clarity_VS2 .012 6.630 .000 .029 .544
n
13 y .014 2.327 .020 .010 .050
n
z .001 .150 .881 .001 .043
n
Page 25
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
n
cut_Good -.008 -5.441 .000 -.023 .927
n
cut_Ideal .015 8.955 .000 .039 .651
n
cut_Premium .006 4.357 .000 .019 .867
n
cut_VeryGood .005 3.768 .000 .016 .979
n
color_E .007 5.206 .000 .022 .892
n
color_F -.002 -1.532 .125 -.007 .903
n
color_G -.030 -20.625 .000 -.088 .854
n
clarity_VS2 .465 100.690 .000 .398 .072
o
14 y .004 .673 .501 .003 .050
o
z -.008 -1.336 .181 -.006 .043
o
cut_Good -.008 -6.252 .000 -.027 .927
o
cut_Ideal .014 9.076 .000 .039 .651
o
cut_Premium .005 3.768 .000 .016 .866
o
cut_VeryGood .000 .322 .748 .001 .977
o
color_E .007 5.666 .000 .024 .892
o
color_F -.001 -.595 .552 -.003 .903
o
color_G -.030 -22.706 .000 -.097 .854
p
15 y .003 .555 .579 .002 .050
p
z -.009 -1.555 .120 -.007 .043
p
cut_Good -.008 -6.651 .000 -.029 .927
p
cut_Ideal .014 9.130 .000 .039 .651
p
cut_Premium .006 4.546 .000 .020 .866
p
cut_VeryGood .000 -.176 .860 -.001 .977
p
color_E -.005 -3.239 .001 -.014 .761
p
color_F -.015 -10.491 .000 -.045 .760
q
16 y .003 .549 .583 .002 .050
q
z -.009 -1.603 .109 -.007 .043
q
Page 26
a
Excluded Variables
Collinearity
Statistics
Partial
Model Beta In t Sig. Correlation Tolerance
q
cut_Good -.008 -6.631 .000 -.029 .927
q
cut_Ideal .014 9.016 .000 .039 .651
q
cut_Premium .006 4.643 .000 .020 .865
q
cut_VeryGood .000 -.223 .823 -.001 .977
q
color_E -.020 -11.661 .000 -.050 .498
r
17 y .003 .588 .556 .003 .050
r
z -.009 -1.538 .124 -.007 .043
r
cut_Good -.008 -6.647 .000 -.029 .927
r
cut_Ideal .013 8.876 .000 .038 .651
r
cut_Premium .006 4.652 .000 .020 .865
r
cut_VeryGood .000 -.063 .950 .000 .977
s
18 y .003 .571 .568 .002 .050
s
z -.009 -1.535 .125 -.007 .043
s
cut_Good -.007 -5.339 .000 -.023 .905
s
cut_Premium .013 9.044 .000 .039 .723
s
cut_VeryGood .006 4.419 .000 .019 .778
t
19 y .007 1.241 .214 .005 .050
t
z -.007 -1.104 .270 -.005 .043
t
cut_Good -.003 -2.345 .019 -.010 .795
t
cut_VeryGood .028 14.655 .000 .063 .411
u
20 y .005 .892 .372 .004 .049
u
z -.008 -1.410 .159 -.006 .043
u
cut_Good .042 17.283 .000 .074 .254
v
21 y .002 .302 .762 .001 .049
v
z -.008 -1.444 .149 -.006 .043
Page 27
g. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H
h. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x
i. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth
j. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table
k. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2
l. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF
m. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1
n. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1
o. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2
p. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G
q. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F
r. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E
s. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E, ...
t. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E,
cut_Ideal, cut_Premium
u. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E,
cut_Ideal, cut_Premium, cut_VeryGood
v. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth,
table, clarity_VVS2, clarity_IF, clarity_VVS1, clarity_VS1, clarity_VS2, color_G, color_F, color_E,
cut_Ideal, cut_Premium, cut_VeryGood, cut_Good
Page 28
a
Residuals Statistics
Minimum Maximum Mean Std. Deviation N
Predicted Value -4304.597 39403.027 3932.800 3826.0953 53940
Residual -21385.0273 10694.5693 .0000 1129.8779 53940
Std. Predicted Value -2.153 9.271 .000 1.000 53940
Std. Residual -18.923 9.463 .000 1.000 53940
Charts
Histogram
Dependent Variable: price
Mean = -1.64E-14
15,000 Std. Dev. = 1.000
N = 53,940
10,000
Frequency
5,000
0
-20 -10 0 10
Page 29
Normal P-P Plot of Regression Standardized Residual
Dependent Variable: price
1.0
0.8
0.4
0.2
0.0
0.0 0.2 0.4 0.6 0.8 1.0
Page 30