0% found this document useful (0 votes)
2 views30 pages

Stepwise Regression Analysis of Price

The document outlines a stepwise regression analysis aimed at predicting the price of diamonds based on various attributes such as carat, color, and clarity. It details the variables entered and removed in each step of the model building process, along with the corresponding statistical measures including R-squared values and ANOVA results. The analysis indicates a strong relationship between the predictors and the dependent variable, price.

Uploaded by

khanhhun16072005
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2 views30 pages

Stepwise Regression Analysis of Price

The document outlines a stepwise regression analysis aimed at predicting the price of diamonds based on various attributes such as carat, color, and clarity. It details the variables entered and removed in each step of the model building process, along with the corresponding statistical measures including R-squared values and ANOVA results. The analysis indicates a strong relationship between the predictors and the dependent variable, price.

Uploaded by

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

REGRESSION

/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).

a. Dependent Variable: price

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

a. Predictors: (Constant), carat


b. Predictors: (Constant), carat, clarity_SI2
c. Predictors: (Constant), carat, clarity_SI2, color_J
d. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1
e. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I
f. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H
g. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x
h. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth
i. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table
j. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,
clarity_VVS2
k. Predictors: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I, color_H, x, depth, table,

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

Residual 1.293E+11 53938 2398043.965


Total 8.585E+11 53939
c
2 Regression 7.420E+11 2 3.710E+11 171841.496 .000

Residual 1.165E+11 53937 2159029.109


Total 8.585E+11 53939
d
3 Regression 7.493E+11 3 2.498E+11 123370.980 .000

Residual 1.092E+11 53936 2024467.116


Total 8.585E+11 53939
e
4 Regression 7.560E+11 4 1.890E+11 99473.443 .000

Residual 1.025E+11 53935 1899996.616


Total 8.585E+11 53939
f
5 Regression 7.602E+11 5 1.520E+11 83443.991 .000

Residual 9.827E+10 53934 1822065.001


Total 8.585E+11 53939
g
6 Regression 7.632E+11 6 1.272E+11 72024.881 .000

Residual 9.525E+10 53933 1766106.613


Total 8.585E+11 53939
h
7 Regression 7.663E+11 7 1.095E+11 64090.332 .000

Residual 9.213E+10 53932 1708185.594


Total 8.585E+11 53939
i
8 Regression 7.680E+11 8 9.600E+10 57244.776 .000

Residual 9.045E+10 53931 1677068.245


Total 8.585E+11 53939
j
9 Regression 7.695E+11 9 8.550E+10 51804.148 .000

Residual 8.900E+10 53930 1650378.793


Total 8.585E+11 53939
k
10 Regression 7.705E+11 10 7.705E+10 47223.976 .000

Residual 8.799E+10 53929 1631554.753


Total 8.585E+11 53939
l
11 Regression 7.717E+11 11 7.016E+10 43603.201 .000

Residual 8.677E+10 53928 1608943.636


Total 8.585E+11 53939
m

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

Residual 8.530E+10 53927 1581786.606


Total 8.585E+11 53939
n
13 Regression 7.745E+11 13 5.957E+10 38242.014 .000

Residual 8.401E+10 53926 1557823.382


Total 8.585E+11 53939
o
14 Regression 7.878E+11 14 5.627E+10 42910.149 .000

Residual 7.071E+10 53925 1311312.502


Total 8.585E+11 53939
p
15 Regression 7.884E+11 15 5.256E+10 40466.017 .000

Residual 7.004E+10 53924 1298917.556


Total 8.585E+11 53939
q
16 Regression 7.886E+11 16 4.929E+10 38020.502 .000

Residual 6.990E+10 53923 1296295.646


Total 8.585E+11 53939
r
17 Regression 7.887E+11 17 4.640E+10 35881.580 .000

Residual 6.972E+10 53922 1293058.713


Total 8.585E+11 53939
s
18 Regression 7.889E+11 18 4.383E+10 33941.424 .000

Residual 6.962E+10 53921 1291196.008


Total 8.585E+11 53939
t
19 Regression 7.890E+11 19 4.152E+10 32207.514 .000

Residual 6.952E+10 53920 1289264.364


Total 8.585E+11 53939
u
20 Regression 7.892E+11 20 3.946E+10 30729.190 .000

Residual 6.924E+10 53919 1284172.845


Total 8.585E+11 53939
v
21 Regression 7.896E+11 21 3.760E+10 29441.710 .000

Residual 6.886E+10 53918 1277121.265


Total 8.585E+11 53939

a. Dependent Variable: price


b. Predictors: (Constant), carat
c. Predictors: (Constant), carat, clarity_SI2

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

a. Dependent Variable: price

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

a. Dependent Variable: price


b. Predictors in the Model: (Constant), carat
c. Predictors in the Model: (Constant), carat, clarity_SI2
d. Predictors in the Model: (Constant), carat, clarity_SI2, color_J
e. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1
f. Predictors in the Model: (Constant), carat, clarity_SI2, color_J, clarity_SI1, color_I

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

a. Dependent Variable: price

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

Regression Standardized Residual

Page 29
Normal P-P Plot of Regression Standardized Residual
Dependent Variable: price
1.0

0.8

Expected Cum Prob


0.6

0.4

0.2

0.0
0.0 0.2 0.4 0.6 0.8 1.0

Observed Cum Prob

Page 30

You might also like