4

.xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

300

Subject

Civil Engineering

Date

Apr 3, 2024

Type

xlsx

Pages

16

Uploaded by CorporalButterfly4024 on coursehero.com

Raw Diamond Data Data for Analysis ID Color TotalPrice ColorOrdinal Color 1-3 Color 4-5 Color 6-7 1 H 544.1 3 544.1 860 1923.8 2 F 860 5 1134 1334.7 1621.6 3 D 1923.8 7 2169.5 964.2 1368.9 4 D 1621.6 7 2554.4 1511.1 1368.9 5 F 1334.7 5 2093 2404.1 1651.9 6 D 1368.9 7 3395.9 2673 1533.9 7 D 1368.9 7 3715.2 2216.2 1533.9 8 F 964.2 5 3321 3036.3 1905.1 9 G 1511.1 4 2988.9 3690.2 2189.4 10 E 1651.9 6 2822.9 3902.6 2528.2 11 E 1533.9 6 2581.9 3237.4 2712.5 12 E 1533.9 6 4762.8 3991.7 2302 13 E 1905.1 6 4024.1 5591.4 2688.2 14 E 2189.4 6 4776.4 7227.8 2341.7 15 F 2404.1 5 7239.4 12965.8 4617 16 E 2528.2 6 7792.2 9266.4 2421.1 17 F 2673 5 8212.1 7805.2 2421.1 18 D 2712.5 7 6385.8 9350.6 2971.3 19 E 2302 6 8135.6 9687.6 3317 20 E 2688.2 6 6666.3 10447.9 3664.4 21 E 2341.7 6 7160.1 11344.5 4378.4 22 D 4617 7 9320 12403.9 3965.8 23 F 2216.2 5 9648.9 11056.5 3597.6 24 J 1134 1 10734.6 11863.1 3746.1 25 E 2421.1 6 10385.5 14345.1 6228.5 26 E 2421.1 6 11214.5 14918.9 5620.4 27 H 2169.5 3 11382.5 9221.9 12816.1 28 F 3036.3 5 8704.4 36472.3 10972.8 29 E 2971.3 6 10673.6 3622.3 18831.2 30 E 3317 6 15431.6 3015.6 13267.8 31 F 3690.2 5 17933.4 2961.6 2222.3 32 D 3664.4 7 16794.2 3510 3848.7 33 F 3902.6 5 23413.1 5942.7 13095.8 34 G 3237.4 4 28090.9 6089.1 1793.3 35 I 2554.4 2 21872.2 7642.1 1624.9 36 J 2093 1 2679 7964.9 3348.5 37 D 4378.4 7 2905.4 8972.6 3073.5 38 H 3395.9 3 5068.1 10003.5 3682 39 E 3965.8 6 6808.7 9868.7 8240 40 G 3991.7 4 6707.8 14405 8981.3 41 H 3715.2 3 6750 20481.5 6833.2 42 H 3321 3 7765.9 23020.2 3993.3 43 E 3597.6 6 9205 53191.2 8791.5 44 E 3746.1 6 2916 7335.9 12418.7
45 I 2988.9 2 46 I 2822.9 2 47 J 2581.9 1 48 G 5591.4 4 49 I 4762.8 2 50 I 4024.1 2 51 D 6228.5 7 52 D 5620.4 7 53 H 4776.4 3 54 G 7227.8 4 55 F 12965.8 5 56 G 9266.4 4 57 G 7805.2 4 58 H 7239.4 3 59 G 9350.6 4 60 H 7792.2 3 61 G 9687.6 4 62 H 8212.1 3 63 I 6385.8 2 64 H 8135.6 3 65 G 10447.9 4 66 I 6666.3 2 67 F 11344.5 5 68 G 12403.9 4 69 I 7160.1 2 70 E 12816.1 6 71 G 11056.5 4 72 E 10972.8 6 73 G 11863.1 4 74 H 9320 3 75 H 9648.9 3 76 E 18831.2 6 77 H 10734.6 3 78 I 10385.5 2 79 H 11214.5 3 80 G 14345.1 4 81 I 11382.5 2 82 H 8704.4 3 83 I 10673.6 2 84 E 13267.8 6 85 G 14918.9 4 86 F 9221.9 5 87 H 15431.6 3 88 H 17933.4 3 89 H 16794.2 3 90 F 36472.3 5 91 H 23413.1 3
92 H 28090.9 3 93 I 21872.2 2 94 E 2222.3 6 95 E 3848.7 6 96 F 3622.3 5 97 D 13095.8 7 98 E 1793.3 6 99 E 1624.9 6 100 H 2679 3 101 E 3348.5 6 102 E 3073.5 6 103 F 3015.6 5 104 G 2961.6 4 105 H 2905.4 3 106 G 3510 4 107 E 3682 6 108 F 5942.7 5 109 H 5068.1 3 110 D 8240 7 111 G 6089.1 4 112 D 8981.3 7 113 E 6833.2 6 114 E 3993.3 6 115 E 8791.5 6 116 F 7642.1 5 117 G 7964.9 4 118 H 6808.7 3 119 G 8972.6 4 120 H 6707.8 3 121 H 6750 3 122 G 10003.5 4 123 H 7765.9 3 124 F 9868.7 5 125 H 9205 3 126 D 12418.7 7 127 G 14405 4 128 G 20481.5 4 129 F 23020.2 5 130 F 53191.2 5 131 F 7335.9 5 132 H 2916 3
Comparison Abs Mean Diff Standard Error Calculated Q Critical Q Significant Color 1-3 to Color 4-5 1430.3727 1043.4539 1.3708 3.3540 No Color 4-5 to Color 6-7 4530.9932 1043.4539 4.3423 3.3540 Yes Color 1-3 to Color 6-7 3100.6205 1043.4539 2.9715 3.3540 No ANOVA Output Anova: Single Factor SUMMARY Groups Count Sum Average Variance Color 1-3 44 348880.9 7929.1113637047196 Color 4-5 44 411817.3 9359.48409 9E+07 Color 6-7 44 212453.6 4828.4909116738648 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 472115784.15 2 236057892 4.927417 0.0086667 3.066391 Within Groups 6180006588 129 47907027.8 Total 6652122372 131
Diamonds <1 Carat Diamonds >=1 Carat ID TotalPrice < 1 ID TotalPrice >= 1 2 $979.30 288 $6,230.30 3 $544.10 289 $5,942.70 4 $1,010.90 290 $6,038.60 5 $1,570.40 169 $9,239.10 6 $955.60 170 $7,559.20 7 $860.00 291 $6,292.60 8 $860.00 292 $5,068.10 9 $1,258.70 171 $6,543.50 10 $1,923.80 172 $9,253.40 11 $1,328.70 173 $8,055.50 12 $1,616.00 174 $7,840.60 13 $1,621.60 293 $8,240.00 14 $1,163.60 294 $6,089.10 15 $1,547.90 175 $9,577.80 16 $1,334.70 176 $7,135.10 17 $1,368.90 177 $7,227.80 18 $1,368.90 295 $6,379.80 19 $1,175.00 296 $8,981.30 20 $1,193.40 297 $6,293.70 21 $1,248.50 178 $12,965.80 22 $1,285.20 179 $12,965.80 23 $1,656.10 180 $7,592.30 24 $1,475.10 1 $7,228.80 25 $1,112.50 181 $6,889.10 26 $964.20 182 $8,837.80 27 $1,511.10 183 $8,263.90 28 $1,437.40 184 $9,266.40 29 $1,627.30 185 $7,805.20 30 $1,422.20 186 $7,239.40 31 $853.30 187 $6,608.40 32 $1,026.40 188 $9,116.90 33 $1,856.80 189 $9,350.60 34 $1,651.90 190 $7,792.20 35 $1,533.90 191 $10,336.80 36 $1,533.90 192 $9,519.10 37 $1,533.90 193 $10,507.60 38 $1,043.30 298 $6,833.20 39 $2,842.60 194 $9,687.60 40 $1,776.60 195 $8,212.10 41 $1,288.00 299 $3,993.30 42 $1,905.10 196 $6,385.80 265 $1,255.50 197 $11,022.50 43 $2,650.70 198 $10,487.90 44 $2,200.50 199 $9,331.20
45 $2,106.80 200 $8,135.60 46 $2,434.50 300 $8,626.50 266 $1,305.70 301 $8,626.50 47 $2,189.40 302 $5,832.00 48 $2,404.10 201 $11,388.80 49 $2,806.70 202 $11,388.80 50 $2,528.20 203 $10,447.90 51 $2,296.40 204 $10,447.90 267 $1,793.30 205 $6,666.30 52 $2,505.90 303 $8,791.50 53 $2,089.40 304 $8,536.70 54 $2,673.00 206 $11,344.50 55 $2,220.10 305 $7,642.10 56 $2,712.50 306 $8,992.60 57 $2,302.00 307 $7,964.90 58 $1,993.50 308 $6,808.70 59 $1,863.50 207 $11,716.50 60 $2,688.20 208 $12,403.90 61 $2,341.70 209 $7,160.10 62 $2,408.60 309 $8,030.20 63 $2,226.20 210 $12,816.10 268 $1,624.90 211 $10,698.50 64 $4,617.00 310 $9,508.30 65 $2,438.10 311 $8,748.30 66 $2,369.30 312 $8,972.60 67 $1,984.50 313 $8,095.50 68 $1,069.20 212 $11,056.50 69 $2,216.20 213 $11,056.50 70 $1,134.00 314 $7,846.90 71 $2,478.70 315 $9,615.40 72 $2,408.70 316 $6,707.80 73 $2,421.10 317 $6,750.00 74 $2,421.10 349 $7,009.90 75 $2,448.20 214 $13,111.30 76 $2,169.50 215 $12,145.10 77 $2,755.60 318 $9,057.80 78 $3,036.30 216 $10,972.80 79 $2,237.80 217 $8,283.60 80 $5,335.20 319 $8,143.20 81 $2,886.80 320 $10,003.50 82 $2,619.50 321 $8,704.80 83 $2,971.30 322 $7,765.90 84 $2,849.20 218 $16,234.80 85 $3,827.30 219 $11,863.10 86 $3,317.00 220 $11,725.20 87 $3,229.10 221 $8,347.30 88 $2,891.70 222 $9,320.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help