Please answer Step 1 to Step 4

Step 1 - Understanding the Model:

There are two datasets.

• diamonds?contains the data used to build the regression model.
• new diamonds contains the data for the diamonds the company would like to purchase.

Both datasets contain carat, cut, and clarity data for each diamond. Only the?diamonds?dataset has prices.

• Carat?represents the weight of the diamond and is a numerical variable.
• Cut?represents the quality of the cut of the diamond, and falls into 5 categories: fair, good, very good, ideal, and premium. Each of these categories are represented by a number, 1-5, in the?Cut_Ord?variable.
• Clarity?represents the internal purity of the diamond, and falls into 8 categories: I1, SI2, SI1, VS1, VS2, VVS2, VVS1, and IF. Each of these categories are represented by a number, 1-8, in the?Clarity_Ord?variable.

Using Excel (or other application with which you are familiar), build the linear regression model using the diamonds dataset.

1. Based on the Summary Output produced by the regression analysis write out the linear regression model and explain why you are confident (or not confident) in the model to predict the price. NOTE: Copy and paste the summary output into your report.
2. According to the linear model, if a diamond is 1 carat heavier than another with the same cut and clarity, how much more would the retail price of the heavier diamond be? Why?
3. If you were interested in a 1.5 carat diamond with a?Very Good?cut (represented by a 3 in the model) and a?VS2?clarity rating (represented by a 5 in the model), what retail price would the model predict for the diamond?
4. Does color effect the price of the diamond? If the color code of the diamond specified in part 3 is H, I, or J, how much cheaper or more expensive will this diamond be compared to any other color of the same diamond?
5. Does the regression model estimated in part 4, produce residuals that are normally distributed? Explain your answer; you may use a graphic to support your explanation.

Step 2 -Calculate the predicted price for each diamond:?Using the?new diamondsdataset, for each diamond, plug in the values for each of the variables into the linear model (equation), then solve the equation to get the estimated, or predicted diamond price.Note: For this step, simply use the model developed in part three, which does not include the color code information.

Step 3 -Visualize the Data:?Create two scatter diagrams (or scatter plot).

• Plot 1 - Plot the data for the diamonds in the database, with carat on the x-axis and price on the y-axis.
• Plot 2 - Plot the data for the diamonds for which you are predicting prices with carat on the x-axis and predicted price on the y-axis.
• Note: If you know how, you can also plot both sets of data on the same chart in different colors.

1. What strikes you about this comparison?
2. After seeing this plot, do you feel confident in the model's ability to predict prices? Why or why not?

Step 4 -The Recommendation:?Now that you have the predicted price for each diamond, it's time to calculate the bid price for the whole set. Note: The diamond price that the model predicts represents the final retail price the consumer will pay. The company generally purchases diamonds from distributors at 70% of that price, so your recommended bid price should represent that. What bid do you recommend for the jewelry company? Please explain how you arrived at that number.

(CLO 1,4,5,6,7)

A B C D carat cut color clarity 1.52 Premium D 0.52 Ideal D SI1 1.02 Good G VS2 0.32 Premium G SI1 0.42 Premium 1 SI1 0.31 Premium F IF 1.29 Premium H $12 1 Premium H IF 10 1.02 Ideal D SI1 11 0.31 Ideal D VS2 12 2.01 Good $12 13 0.41 Ideal D VS1 14 0.58 Very Good H 15 0.7 Premium F SI1 16 0.3 Premium 1 VV52 17 1.21 Ideal F SI1 18 0.51 Ideal E VS2 19 1.02 Very Good F 20 2.01 Good SI1 21 0.31 Premium F VS2 22 1.06 Very Good E $12 23 0.31 Premium E VS2 24 0.52 Very Good G VS1 25 0.32 Ideal F VS2 26 0.7 Good G $1 1 27 1.91 Premium G 28 0.33 Premium H IF 29 0.4 Very Good I SI1 30 1.2 Premium F VS2 31 1.01 Very Good D $12 32 0.3 Ideal D $12 33 0.31 Very Good G SI1 34 0.7 Ideal H VS1 35 0.32 Good E V52 36 0.8 Premium ] SI1 37 1.23 Good D 11 38 0.3 Ideal H VS1 39 0.51 Premium G VS2 40 0.77 Ideal H SI1 41 0.35 Ideal D 512 42 1.05 Premium H 43 0.41 Ideal H VS2 44 1.01 Premium H SI1 45 0.72 Good F SI1 46 0.32 Ideal F VS2 47 1. 12 Premium G 11 48 0.5 Very Good G VVS2 49 0.7 Good D 50 1.51 Ideal D SI1 51 0.51 Premium F VS2 52 1.52 Fair $12 53 0.71 Ideal F VS1 54 1.09 Ideal F SI1 55 1. 41 Fair H 11 56 1 Very Good D VS2 57 1.51 Premium I $12 58 0.41 Ideal H VS2 59 0.46 Good E 60 1.5 Very Good F $1 1 61 0.3 Ideal H SI1 62 0.3 Ideal D $12 63 2.05 Ideal G S12 64 1.02 Premium D $12 65 1.62 Premium F SI1 66 1.23 Very Good F VVS2 67 0.75 Ideal VS2 68 1. 12 Very Good E 69 0.5 Very Good E VS2 70 0.4 Very Good I SI1 71 1.65 Ideal D $12 72 0.74 Ideal H VS1 73 0.41 I deal VV51 74 0.73 Ideal SI1 75 0.51 Ideal G $12 76 1.16 Ideal G IFA B C D E F G carat cut color clarity price 0.7 Very Good D SI1 2827 0.72 Premium G VS2 2795 0.32 Premium 1 SI1 554 0.76 Premium E SI1 2789 2770 LD DO N G U A W N H 0.76 Very Good F SI1 0.7 Very Good F VS2 2762 0.7 Fair VS1 2797 0.73 Very Good D SI1 2768 10 0.78 Ideal D SI1 2799 11 10 0.91 Premium G $12 2813 12 11 0.7 Very Good E SI1 2777 13 12 0.32 Ideal VS1 553 14 13 0.7 Premium E V51 2822 15 14 0.91 Fair H 2763 16 15 0.76 Ideal D $12 2770 17 16 0.73 Very Good H VS2 2779 18 17 0.73 Premium E VS2 2821 19 18 0.73 Ideal E SI1 2791 20 19 0.71 Good E SI1 2817 21 20 0.55 Very Good D VS1 2815 22 21 0.7 Premium E VS2 2777 23 22 0.75 Very Good F $1 1 2811 24 23 0.7 Good G VS1 2803 25 24 0.71 Very Good E VS2 2759 26 25 0.72 Very Good G VS2 2776 27 26 0.24 Premium G VS1 554 28 27 0.78 Premium F $1 1 2777 29 28 0.87 Very Good G $12 2802 30 29 0.32 Good SI1 654 31 30 0.9 Premium 1 2826 32 31 0.58 Ideal F VV51 2772 33 32 0.73 Premium E VS2 2812 34 33 0.71 Premium D SI1 2797 35 34 0.7 Very Good F VS2 2812 36 35 0.3 Very Good H SI1 554 37 36 0.7 Ideal E VS1 2818 38 37 0.29 Ideal F VS1 555 39 38 0.74 Very Good G $1 1 2762 40 39 1.01 Fair m 11 2788 41 40 0.71 Good D VS1 2816 42 41 0.71 Premium E VS2 2776 43 42 0.75 Premium E $1 1 2760 44 43 0.7 Premium E SI1 2777 44 0.76 Premium H VVS2 2792 45 0.32 Premium 1 SI1 554 46 0.84 Very Good E SI1 2813 47 0.7 Premium E SI1 2777 48 0.71 Ideal G VS1 2820 49 0.77 Premium H VS1 2789 50 0.7 Very Good D V52 2767 51 0.72 Premium F VS1 2802 52 0.71 Premium E VS2 2823 53 0.26 Ideal E V51 556 54 0.74 Good E VS1 2824 55 0.74 Very Good E SI1 2803 56 0.7 Very Good F V51 2767 57 0.9 Good SI1 2823 58 0.72 Idea G VS2 2805 59 0.78 Premium G VS2 2803 60 0.79 Ideal F S12 2771 0.71 Ideal E VS2 2817 0.38 Ideal $12 554 0.72 Very Good F VS1 2804 0.75 Ideal E SI1 2821 65 0.3 Very Good I SI1 405 66 0.79 Very Good D $12 2823 19 0.7 Premium E VS1 2782 68 0.6 Very Good G IF 2800 69 0.73 Ideal F VS2 2762 70 0.28 Ideal G VVS2 553 71 0.83 Very Good H SI1 2800 72 0.83 Ideal F $12 2790 74 73 0.53 Ideal E VS1 2821 75 74 0.32 Very Good F V52 556 76 75 0.22 Premium D VS2 404 76 0.72 Premium D SI1 2782 78 77 0.7 Ideal H W51 2827 79 78 0.7 Good E VS 2 2759A B C D E F G 80 79 0.71 Ideal E SI1 2823 81 80 0.78 Premium F SI1 2826 82 81 0.8 Premium F $12 2797 83 82 0.71 Very Good E VS2 2830 84 83 0.78 Very Good G 512 2759 85 84 0.91 Ideal $12 280 86 85 0.7 Very Good E VS2 2793 87 86 0.24 Premium H VS1 554 88 87 0.9 Ideal J VS2 2817 89 88 0.95 Fair F $12 2815 90 89 0.26 Very Good E VS1 554 91 90 0.3 Ideal D SI1 552 92 91 0.73 Premium F VS2 2805 93 92 0.7 Good E SI1 2812 94 93 0.7 Premium E VS1 2818 95 94 0.71 Premium D SI1 2797 96 95 0.71 Premium F VS1 2765 97 96 0.7 Very Good F VS2 2812 98 97 0.7 Good E VS1 2782 99 98 0.7 Premium E VS2 2818 100 99 0.7 Ideal E SI1 2757 101 100 0.7 Premium E VS1 2800 102 101 0.86 Fair m 2757 103 102 0.81 Good $12 2789 104 103 0.7 Good E VS1 2826 105 104 0.3 Premium J S12 405 106 105 0.83 Very Good D SI1 2811 107 106 0.6 Ideal F VV52 2822 108 107 0.72 Premium E VS2 2822 09 108 0.29 Very Good E VS1 555 L10 109 1.01 Premium F 11 2781 111 110 0.74 Premium G VS 1 2815 12 111 0.72 Good D VS2 2827 L13 112 1.02 Premium G 11 2815 L14 113 0.7 Ideal VV51 2827 n I L15 114 0.72 Good VS1 2795 L16 115 0.76 Ideal G VS2 2782 .17 116 0.74 Ideal m $12 2761 L18 117 0.71 Premium D SI1 2797 19 118 0.7 Ideal D SI1 2804 120 119 0.7 Ideal D SI1 2822 121 120 0.3 Premium D $1 1 552 122 121 0.77 Good VS1 2788 123 122 0.96 Ideal F 11 2801 124 123 0.75 Ideal G SI1 2760 125 124 0.7 Very Good F VS2 2780 126 125 0.74 Ideal D 512 2810 127 126 0.63 Ideal VVS2 2817 128 127 0.76 Good E SI1 2789 29 128 0.71 Ideal D SI1 2822 130 129 0.63 Premium E VVS2 2789 131 130 0.9 Fair H $12 2823 132 131 0.87 Very Good SI1 2791 133 132 0.99 Fair $12 2811 134 133 0.26 Very Good D VS2 554 135 134 0.74 Very Good F VS2 2775 136 135 0.98 Fair H $12 2777 137 136 0.7 Fair F VS2 2762 38 137 1 Premium I $12 2795 139 138 0.91 Good VS2 2813 140 139 0.3 Good H SI1 554 141 140 0.61 Ideal E VS2 282 142 141 0.71 Very Good F VS2 2777 43 142 0.3 Very Good H SI1 554 144 143 0.7 Premium D VS2 2773 145 144 0.72 Very Good F VS2 2784 146 145 0.7 Ideal H SI1 2815 147 146 1.04 Premium G 11 2801 48 147 0.76 Ideal VV52 2788 149 148 0.74 Premium G VS1 2800 150 149 0.72 Ideal H VS1 2819 151 150 0.7 Good F VS1 2819 152 151 0.73 Very Good E SI1 2760 153 152 0.7 Good H VVS2 2767 154 153 0.72 Premium I IF 2795 155 154 0.73 Ideal E S12 2805 156 155 0.81 Ideal G $12 2789 157 156 0.73 Ideal F VS2 2801 58 157 0.7 Very Good D SI1 2768A B C D E G 0. / VERY GOOD L TIC 2700 159 158 0.52 Ideal F VVS1 2778 160 159 0.7 Very Good H VVS 2788 161 160 0.81 Premium D $12 2809 162 161 0.71 Very Good E VS2 2795 163 162 0.8 Premium E S12 2829 164 163 0.63 Premium E VS1 2765 165 164 0.7 Premium F VS2 2818 166 165 0.54 Ideal E VV52 2776 167 166 0.71 Premium E SI1 2792 168 167 0.72 Ideal SI1 2782 169 168 0.6 Ideal m VS1 2774 170 169 0.7 Premium E SI1 2777 171 170 0.75 Ideal I SI1 2801 172 171 1.05 Fair L $12 2789 173 172 0.71 Ideal SI1 2764 174 173 0.7 Ideal VS2 2777 175 174 0.96 Fair $12 2759 176 175 0.73 Ideal V52 2762 177 176 0.82 Good G VS2 2805 178 177 0.3 Very Good SI1 405 179 178 0.73 Premium E VS1 2826 180 179 0.71 Ideal D SI1 2812 181 180 0.35 Ideal VS1 552 182 181 0.71 Very Good F VS1 2807 183 182 0.8 Good E 2829 184 183 0.24 Premium H VS1 554 185 184 0.7 Very Good D SI1 2804 186 185 0.72 Premium F SI1 2777 187 186 0.7 Ideal G VS2 2757 188 187 0.34 Ideal H VS2 555 189 188 0.59 Ideal E VV52 2761 190 189 0.9 Good $12 2800 191 190 0.3 Premium H 554 192 191 0.82 Ideal F $12 2799 193 192 0.74 Ideal W51 2822 194 193 0.7 Very Good D VS1 2777 195 194 0.7 Premium E SI1 2777 196 195 0.51 Ideal D VS1 2797 197 196 0.7 Ideal H SI1 2815 198 197 0.7 Ideal D 512 2828 199 198 0.74 Ideal SI1 2769 200 199 0.26 Ideal m VV52 554 201 200 0.71 Premium F VS1 2790 202 201 0.81 Ideal 512 2795 203 202 0.71 Ideal SI1 2776 204 203 0.96 Ideal 11 2826 205 204 0.3 Good H SI1 554 206 205 0.81 Very Good G SI1 2806 207 206 0.73 Ideal m SI1 2803 208 207 0.73 Good m SI1 2796 209 208 0.7 Ideal E SI1 2774 210 209 1.01 Premium H $12 2788 211 210 0.71 Premium F SI1 2809 212 211 0.7 Very Good F VS2 2803 213 212 0.79 Ideal VS1 2800 214 213 0.83 Ideal G SI1 2800 215 214 0.7 Premium F VS1 2792 216 215 0.72 Premium E VS2 2822 217 216 1.01 Premium H $12 2828 218 217 0.71 Premium D SI1 2822 219 218 0.8 Very Good E 512 2804 220 219 0.71 Ideal VVS2 2817 221 220 0.7 Ideal H SI1 2815 222 221 0.91 Fair H $12 2763 223 222 0.73 Premium D 2821 224 223 0.64 Ideal G VVS1 2766 225 224 0.71 Very Good G VS1 2768 226 225 0.76 Ideal VS2 2793 227 226 0.89 Premium H $12 2815 228 227 0.79 Very Good H VS1 2784 229 228 0.79 Very Good E SI1 2794 230 229 0.71 Premium F VS2 2803 231 230 0.71 Ideal F VS2 2780 232 231 0.72 Very Good F VS2 2787 233 232 0.61 Ideal G VS2 2816 234 233 0.52 Ideal F IF 2783 235 234 0.8 Very Good F 512 2772 236 235 0.57 Ideal F VVS2 2797A B C D E F G 137 236 0.26 Very Good E VV52 554 138 237 0.26 Good VV51 554 39 238 0.7 Premium E SI1 2777 40 239 0.71 Premium F VS1 2790 41 240 0.29 Very Good H $12 404 42 241 0.3 Premium H SI1 554 43 242 0.71 Very Good E VS2 2804 244 243 0.9 Fair 51 1 2804 245 244 0.3 Ideal G VS2 556 46 245 0.7 Ideal D SI1 2822 47 246 0.71 Good VS2 2777 48 247 0.7 Very Good F VS1 2810 49 248 0.7 Very Good G VS1 2812 250 249 0.53 Very Good D VVS2 2782 251 250 0.83 Ideal H SI1 2816 252 251 0.7 Ideal G VS1 2780 253 252 0.7 Good m VS2 2777 254 253 0.72 Premium E VS2 2815 255 254 0.3 Good 405 256 255 0.82 Ideal F $12 2824 257 256 0.71 Premium F VS2 2803 58 257 1 Premium H 11 2818 258 0.73 Premium F V52 2801 260 259 0.7 Very Good F VS1 2810 261 260 0.34 Ideal VS1 555 262 261 0.71 Ideal SI1 2788 163 262 0.63 Premium E VS1 2789 64 263 0.81 Very Good H $12 2797 165 264 0.72 Good G VS2 2776 266 265 0.7 Very Good F VS2 2812 267 266 0.22 Premium E VS2 404 168 267 0.3 Ideal G VS1 555 169 268 0.81 Premium VV52 2795 170 269 0.83 Very Good I VS1 2788 171 270 0.73 Very Good D SI1 2808 272 271 0.8 Premium G SI1 2760 173 272 0.32 Very Good I SI1 554 74 273 0.71 Ideal G VS2 2771 75 274 1 Premium J $12 2801 76 275 0.73 Very Good F SI1 2771 277 276 0.71 Premium D S/1 2822 178 277 0.24 Very Good F SI1 404 79 278 0.82 Premium E 2824 80 279 0.7 Good E SI1 2822 81 280 0.83 Very Good E $12 2799 282 281 0.93 Premium ! 2807 183 282 0.77 Ideal VS2 2763 84 283 0.81 Ideal $12 2761 285 284 0.71 Premium G VS2 2766 186 285 1 Fair H 512 2818 I 287 286 0.74 Ideal VS1 2797 88 287 0.7 Premium E VS2 2822 89 288 0.71 Premium E VS2 2817 290 289 0.36 Ideal VS2 556 291 290 0.77 Good SI1 2789 291 0.71 Good V52 2801 293 292 0.72 Ideal VS1 2829 194 293 0.77 Premium G VS2 2803 295 294 0.7 Premium E SI1 2777 296 295 0.74 Premium F VS2 2805 297 296 0.72 Very Good H VV52 2771 298 297 0.7 Premium E VS2 2818 199 298 0.71 Good VS2 2777 299 0.53 Ideal IF 2802 301 300 0.8 Ideal $12 2761 302 301 0.72 Ideal D 2804 303 302 0.74 Fair VS2 2805 304 303 0.75 Premium G VS2 2760 105 304 0.24 Very Good D VS1 553 306 305 0.31 Very Good G SI1 553 107 306 0.75 Very Good G VS2 2808 308 307 0.74 Ideal 2762 309 308 0.61 Ideal IF 2800 $10 309 0.7 Premium D SI1 2822 311 310 0.7 Very Good F VS2 2812 $12 311 0.34 Ideal VS1 555 13 312 0.83 Ideal G SI1 2800 314 313 0.76 Fair VS1 2800 15 314 0.51 Ideal VS1 2787316 315 0.71 Very Good E VS2 2804 317 316 0.81 Premium H VS2 2795 318 317 0.3 Premium H SI1 554 319 318 0.64 Ideal G IF 2790 320 319 0.75 Premium E 2814 321 320 0.77 Ideal VS2 2824 322 321 0.73 Premium G VS 1 2770 323 322 0.71 Premium G VS2 2766 324 323 0.73 Good m SI1 2821 325 324 0.7 Ideal 2822 326 325 0.7 Premium E VS1 2826 327 326 0.8 Ideal VS1 2760 328 327 0.3 Very Good H SI1 554 329 328 0.7 Premium E VS1 2818 330 329 0.91 Premium H SI1 2763 331 330 1 Fair G 11 2808 332 331 0.79 Very Good G SI1 279 333 332 0.99 Fair SI1 2812 334 333 0.91 Fair H S12 2825 335 334 0.7 Good VS1 2810 336 335 0.71 Good VS2 2801 337 336 0.32 Ideal SI1 554 338 337 0.72 Very Good H VS1 2782 339 338 0.77 Ideal H SI1 2781 340 339 0.76 Very Good F $12 2815 341 340 0.7 Premium F VS1 2792 342 341 0.75 Ideal D 2773 343 342 0.7 Premium F VS2 2822 344 343 0.71 Very Good F VS1 2765 345 344 0.75 Very Good D SI1 2760 346 345 0.96 Fair E 512 2815 347 346 0.3 Premium H SI1 554 348 347 0.71 Ideal E SI1 2792 349 348 0.72 Premium F VS1 2829 350 349 0.72 Ideal G SI1 2776 351 350 0.75 Very Good D 512 2782 352 351 0.86 Premium F $12 2818 353 352 0.75 Premium E 2829 354 353 0.71 Premium F VS2 2801 355 354 0.71 Premium G VS1 2825 356 355 0.8 Ideal $12 2762 357 356 0.72 Premium E VS2 2822 358 357 0.26 Very Good F 554 359 358 0.74 Ideal VS2 2761 360 359 0.71 Ideal G VS2 2762 361 360 0.8 Good G 2810 362 361 0.29 Very Good E VS1 555 363 362 0.73 Premium E SI1 2821 364 363 0.24 Premium E VS1 553 365 364 0.74 Ideal H VS1 2797 366 365 0.7 Premium D SI1 2782 367 366 0.75 Premium F SI1 2782 368 367 1 Fair VS2 2811 369 368 0.75 Very Good H VS1 2806 370 369 1.01 Fair E $12 2797 371 370 0.71 Premium G VS2 2803 372 371 0.72 Premium D S12 2795 373 372 0.72 Ideal VS2 2797 374 373 0.71 Ideal $12 2767 375 374 0.58 Ideal E VV52 2808 376 375 0.7 Very Good E VS2 2765 377 376 1.05 Very Good ! S12 2789 378 377 0.71 Premium E SI1 2817 379 378 0.23 Ideal G VS1 404 380 379 0.8 Very Good H VS2 2797 381 380 0.74 Ideal E SI1 2779 382 381 0.3 Premium H 51 1 554 383 382 0.55 Ideal IF 2789 384 383 0.9 Fair VS2 2815 385 384 0.7 Ideal VS1 2792 386 385 0.8 Ideal H SI1 2818 387 386 0.32 Ideal SI1 404 388 387 0.7 Premium E SI1 2777 389 388 0.7 Premium E VS2 2818 390 389 0.7 Very Good E 2777 391 390 0.71 Very Good D SI1 2764 392 391 0.71 Good D VS2 2788 393 392 0.71 Ideal D 512 2762 194 393 0.8 Very Good H VS2 2808A B C D E F 395 394 0.71 Premium E SI1 2817 396 395 0.72 Very Good G VS1 2819 397 396 0.42 Premium I $12 552 398 397 0.26 Very Good D VS2 554 399 398 0.31 Very Good F SI1 555 400 399 0.7 Ideal E SI1 2768 401 400 0.7 Ideal F SI1 2806 402 401 0.9 Premium I VS2 2761 403 402 0.3 Ideal D $1 1 552 404 403 0.73 Premium G VS2 2770 405 404 0.24 Premium H VV52 554 406 405 0.7 Ideal E VS2 2762 407 406 0.34 Ideal H VS2 555 408 407 0.76 Premium E 2789 409 408 0.7 Very Good D VS2 2826 410 409 0.64 Ideal D VS1 2787 411 410 0.73 Premium G VS2 2770 412 411 0.7 Premium E VS1 2826 413 412 0.76 Premium E SI1 2814 414 413 0.74 Idea G VS1 2780 415 414 0.71 Ideal m SI1 2817 416 415 0.7 Very Good F VS1 2808 417 416 0.71 Very Good F VS1 2807 418 417 0.84 Fair G 2782 419 418 0.78 Very Good I VV52 2816 420 419 0.77 Very Good H VS1 2765 421 420 0.7 Ideal D 2822 422 421 0.82 Ideal H VS2 2804 423 422 0.72 Ideal G SI1 2776 424 423 0.8 Premium H 2760 425 424 0.73 Ideal F SI1 2822 426 425 0.7 Ideal H SI1 2815 427 426 0.81 Very Good E SI1 2797 428 427 0.79 Premium H VV52 2827 429 428 0.71 Premium G VS1 2803 430 429 0.71 Premium E SI1 2792 431 430 0.77 Premium G VS2 2780 432 431 0.31 Premium G 553 433 432 0.57 Fair E VS1 2805 434 433 0.76 Premium I VV51 2790 435 434 0.71 Premium F VS2 2777 436 435 0.71 Ideal E VS2 2776 437 136 0.74 Ideal G 2760 438 437 0.71 Very Good G VS1 2803 439 438 1.2 Fair 11 2809 440 439 0.71 Premium E $1 1 2817 441 440 0.26 Very Good D VS1 554 442 441 0.83 Premium H SI1 2825 443 442 0.74 Premium F VS2 2805 444 443 0.71 Ideal G VS2 2803 445 444 0.87 Ideal H 2816 446 445 1.17 Premium 1 1 2825 447 446 0.83 Good VS2 2774 448 447 0.73 Premium G VS2 2770 449 448 0.73 Ideal D $12 2770 450 449 0.72 Ideal VS1 2804 451 450 0.71 Premium D VS2 2770 452 451 0.51 Ideal VS1 2812 453 452 0.71 Premium D VS2 2824 454 453 0.78 Premium F 2816 455 454 0.77 Ideal VS1 2798 456 455 0.72 Premium E VS2 2802 457 456 0.73 Premium E SI1 2821 458 457 0.54 Ideal E VV52 2776 459 458 0.7 Ideal E SI1 2789 460 459 0.9 Good VS2 2822 461 460 0.32 Premium SI1 554 462 461 0.58 Ideal G VS1 2772 463 462 0.72 Ideal 511 2804 464 463 0.32 Premium SI1 654 465 464 0.7 Fair F VS2 2762 466 465 0.7 Good E VS 2 2793 467 466 0.9 Very Good I $12 2800 468 467 0.7 Premium F VS2 2762 469 468 0.9 Very Good[ S12 2826 470 469 0.7 Ideal D SI1 2822 471 470 0.26 Very Good E VV51 554 472 471 0.59 Ideal E VS1 2829 473 472 0.86 Good $12 2819A B C D E F 473 472 0.86 Good F 512 2819 474 473 0.7 Good F V51 2759 175 474 0.78 Ideal H 51 1 2781 476 475 0.61 Very Good D VV52 2763 477 476 0.76 Ideal H 511 2765 478 477 0.73 Very Good E 51 1 2821 179 478 0.71 Premium E 51 1 2817 180 479 1.17 Very Good J 11 2774 481 480 0.3 Ideal H 511 554 482 481 0.32 Ideal 51 1 554 183 482 0.83 Premium H 51 1 2825 184 483 0.43 Very Good E 11 555 185 484 0.3 Ideal 512 405 86 485 0.35 Ideal G 555 187 486 0.8 Premium F 512 2762 188 487 0.81 Very Good F 511 2809 189 488 0.73 Very Good H W51 2772 490 489 0.73 Premium E 51 1 2821 191 490 0.76 Ideal E 511 2814 192 491 0.71 Good E V52 2772 193 492 0.7 Ideal E 51 1 2777 494 493 0.7 Premium E VS2 2822 195 494 0.7 Premium E V52 2822 196 495 0.71 Premium D 512 2768 197 496 0.73 Ideal H VS2 2793 198 497 0.33 Ideal H 512 554 661 498 0.71 Premium F V52 2801 500 499 0.7 Premium E V52 2822 501 500 0.71 Ideal F SI1 2770 502 501 0.73 Very Good G V51 2825