Posted: March 12th, 2023
See attached for Questions
Question 1.
Let’s say you were to roll two dice 1000 times.
What is the number of times you would expect the number 7 to appear?
Flag question: Spacer
You will need to download the
data_analysis.xlsx
Download data_analysis.xlsx
worksheet to complete parts of this homework. Make sure you create backup copies of the data, as you will be asked to answer several questions about the data, and will want the ability to filter, rearrange, and organize the data however you like, to best answer the questions.
Flag question: Question 2
Question 2.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete. For this question, we want you to focus specifically on the
ash
additive.
You should use all of the data in the dataset, but assume that the data is a sample.
What is the standard deviation (round to the nearest 4 decimal places)?
example 12.33414 –> 12.3341
example 48.39208 –> 48.3921
Flag question: Question 3
Question 3.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete. For this question, we want you to focus specifically on the
air ent admix additive.
What is the mean (round to the nearest 4 decimal places)? example 48.39208 –> 48.3921
Flag question: Question 4
Question 4.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete.
Which additive shows the highest relative standard deviation?
Group of answer choices
cement
slag
ash
water
superplastic
air_ent_admix
Flag question: Question 5
Question 5.
What can you tell us about how the Coefficient of Variation might be related to skewness? Use the data from the Analysis1_DescriptiveStats worksheet for your answer.
View keyboard shortcuts
pView keyboard shortcutsAccessibility Checker
0 words
Switch to the html editorFullscreen
Flag question: Question 6
Question 6.
Use the Analysis2_Correlation worksheet for this question.
Compare the most expensive additive (cement) with the overall Strength.
What patterns to you see? Does one have to invest heavily in Cement to achieve a strong concrete mixture?
In a sentence or two, what is happening with any outlier groups?
View keyboard shortcuts
pView keyboard shortcutsAccessibility Checker
0 words
Switch to the html editorFullscreen
Flag question: Question 7
Question 7.
Use the Analysis3_ShapeAndSkewness worksheet for this question.
Please investigate both Water and Coarseagg as the two additives that seem closest to a normal distribution. Create histograms for both additives for comparison.
Using any methods you think appropriate, answer the question: “From a statistical standpoint, which variable closest represents a Normal Distribution.
View keyboard shortcuts
pView keyboard shortcutsAccessibility Checker
0 words
Switch to the html editorFullscreen
Flag question: Spacer
There is a spreadsheet in the data_analysis.xlsx workbook named NormalDistributions, to assist you with these questions.
Flag question: Question 8
Question 8.
500 students are getting ready to take the bar exam. Assume that the scores can be approximated by a normal distribution. How many students do we expect to be within 2 standard deviations from the mean? Enter your answer, rounded to the nearest whole number.
Flag question: Question 9
Question 9.
During the height of flu season, demand per day for flu vaccinations in the IU Health network is normally distributed with a mean of 1200 vaccinations and std deviation of 55. What is the probability that demand for a particular day will be less than 1100 vaccinations (round to the nearest 4 decimal places)?
Flag question: Question 10
Question 10.
A hospital is trying to improve quality in every area. One of the metrics they look closely at is the quality of physicians. Several individual measurements contribute to a physician’s quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8. A physician score of 94 or better is considered to be exceptional.
What is the probability that a doctor (selected at random) would have a quality score of 94 or higher (round to the nearest 4 decimal places)?
Flag question: Question 11
Question 11.
A hospital is trying to improve quality in every area. One of the metrics they look closely at is the quality of physicians. Several individual measurements contribute to a physician’s quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8. A physician score of 94 or better is considered to be exceptional.
What portion of physicians would have a quality score between 73 and 93 (inclusive) (round to the nearest 4 decimal places)?
Flag question: Spacer
Flag question: Question 12
Question 12.
A company’s sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call. What is the probability exactly 70 sales will be made (round to the nearest 4 decimal places)?
Flag question: Question 13
Question 13.
A company’s sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call. What is the combined probability that 60 or fewer or 75 or more will be made (round to the nearest 4 decimal places)?
Flag question: Question 14
Question 14.
A company’s sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call. What is the probability that fewer than 70 will be made (round to the nearest 4 decimal places)?
Flag question: Question 15
Question 15.
A company’s sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call. What is the probability that more than 70 will be made (round to the nearest 4 decimal places)?
Flag question: Spacer
You will need to navigate to the IdeaxShell worksheet, and complete the problem listed. Once you’ve finished, answer the next question, then upload your spreadsheet.
HINT: This is very similar to the lecture problem and we strongly suggest you set it up like that.
Flag question: Question 16
Question 16.
Based on your data table for the IDEAX problem, what is the optimal number of videos to create to maximize expected profit?
Enter your answer as a whole number.
Flag question: Question 17
Question 17.
If the company makes a decision to produce 510 promo videos (ignore your answer on the previous problem), what would be the expected total cost (add both Promo Cost and Expected Post-Production Cost)?
Round to nearest two decimals.
Flag question: Question 18
Question 181.
Please upload your data_analysis.xslx worksheet here, so we can grade your work.
Concrete Data
region
cement
slag
ash
water
superplastic
coarseagg
fineagg
air ent admix
strength
midwest
331
0
0
192
0
879
825
3
13.52
midwest
154
174
185
228
7
845
612
28
24.34
midwest
236.9
91.7
71.5
246.9
6
852.9
695.4
28
28.63
midwest
108.3
162.4
0
203.5
0
938.2
849
3
2.33
midwest
380
95
0
228
0
932
594
7
32.82
midwest
184
86
190
213
6
923
623
28
22.93
midwest
108.3
162.4
0
203.5
0
938.2
849
7
7.72
midwest
170.3
155.5
0
185.7
0
1026.6
724.3
7
10.73
midwest
155
0
143
193
9
877
868
28
9.74
midwest
212
141.3
0
203.5
0
973.4
750
3
6.81
midwest
102
153
0
192
0
887
942
7
7.68
midwest
255
0
0
192
0
889.8
945
3
8.2
midwest
380
95
0
228
0
932
594
28
36.45
midwest
166.8
250.2
0
203.5
0
975.6
692.6
3
6.9
midwest
284
15
141
179
5.5
842
801
7
24.13
midwest
299.8
0
119.8
211.5
9.9
878.2
727.6
28
23.84
midwest
144.8
0
133.6
180.8
11.1
979.5
811.5
28
13.2
midwest
151.6
0
111.9
184.4
7.9
992
815.9
28
12.18
midwest
152
0
112
184
8
992
816
28
12.18
midwest
250.2
166.8
0
203.5
0
977.6
694.1
3
9.73
midwest
149
153
194
192
8
935
623
28
24.58
midwest
236
0
0
194
0
968
885
14
12.84
midwest
200
133
0
192
0
965.4
806.2
3
11.41
midwest
133
200
0
192
0
927.4
839.2
7
13.66
midwest
157
236
0
192
0
935.4
781.2
3
9.69
midwest
170.3
155.5
0
185.7
0
1026.6
724.3
28
25.73
midwest
140
133
103
200
7
916
753
28
36.44
midwest
164
163
128
197
8
961
641
28
27.23
midwest
139.9
132.6
103.3
200.3
7.4
916
753.4
28
36.44
midwest
203.5
305.3
0
203.5
0
963.4
630
3
9.56
midwest
149
139
109
193
6
892
780
28
23.69
midwest
150.9
0
183.9
166.6
11.6
991.2
772.2
28
15.57
midwest
183.9
122.6
0
203.5
0
959.2
800
28
24.05
midwest
102
153
0
192
0
887
942
28
17.28
midwest
143.7
170.2
132.6
191.6
8.5
814.1
805.3
28
29.87
midwest
272.6
0
89.6
198.7
10.6
931.3
762.2
28
32.25
midwest
157
236
0
192
0
935.4
781.2
7
16.89
midwest
305.3
203.5
0
203.5
0
965.4
631
3
14.14
midwest
273
0
90
199
11
931
762
28
32.24
midwest
167
187
195
185
7
898
636
28
23.89
midwest
277
0
0
191
0
968
856
14
21.26
midwest
272.8
105.1
81.8
209.7
9
904
679.7
28
37.17
midwest
273
105
82
210
9
904
680
28
37.17
midwest
333
0
0
192
0
931.2
842.6
7
23.4
midwest
155
183
0
193
9
1047
697
28
18.28
midwest
326.5
0
137.9
199
10.8
801.1
792.5
28
38.63
midwest
141.3
212
0
203.5
0
971.8
748.5
28
29.89
midwest
307
0
0
193
0
968
812
28
27.53
midwest
326
0
138
199
11
801
792
28
40.68
midwest
148.1
0
136.6
158.1
16.1
1001.8
830.1
28
17.96
midwest
148
0
137
158
16
1002
830
28
17.95
midwest
154.8
183.4
0
193.3
9.1
877.2
867.7
28
23.79
midwest
145
116
119
184
5.7
833
880
28
29.16
midwest
305.3
203.5
0
203.5
0
965.4
631
7
25.89
midwest
153.1
145
113
178.5
8
1001.9
688.7
28
25.56
midwest
145.9
230.5
0
202.5
3.4
827
871.8
28
32.72
midwest
304
140
0
214
6
895
722
28
33.42
midwest
233.8
0
94.6
197.9
4.6
947
852.2
3
10.38
midwest
252.1
97.1
75.6
193.8
8.3
835.5
821.4
28
33.4
midwest
266
114
0
228
0
932
670
90
47.03
midwest
132
207
161
179
5
867
736
28
33.3
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
3
10.03
midwest
342
38
0
228
0
932
670
90
50.46
midwest
393
0
0
192
0
940
758
28
39.58
midwest
252
0
0
186
0
1111
784
7
11.47
midwest
237.5
237.5
0
228
0
932
594
90
33.12
midwest
152.7
144.7
0
178.1
8
999.7
822.2
28
19.01
midwest
153
145
0
178
8
1000
822
28
19.01
midwest
265
111
86
195
6
833
790
28
41.54
midwest
255.3
98.8
77
188.6
6.5
919
749.3
28
33.8
midwest
250.2
166.8
0
203.5
0
977.6
694.1
28
36.96
midwest
151.8
178.1
138.7
167.5
18.3
944
694.6
28
36.35
midwest
145.7
172.6
0
181.9
3.4
985.8
816.8
28
23.74
midwest
152
178
139
168
18
944
695
28
36.35
midwest
516
0
0
162
8.3
801
802
28
41.37
midwest
385
0
0
186
0
966
763
28
31.35
midwest
380
95
0
228
0
932
594
90
40.56
midwest
475
0
0
228
0
932
594
90
42.23
midwest
298
0
107
186
6
879
815
28
42.64
midwest
480
0
0
192
0
936.2
712.2
7
34.57
midwest
141.9
166.6
129.7
173.5
10.9
882.6
785.3
28
44.61
midwest
157
236
0
192
0
935.4
781.2
28
33.66
midwest
298
137
107
201
6
878
655
28
53.52
midwest
200
0
0
180
0
1125
845
7
7.84
midwest
222.4
0
96.7
189.3
4.5
967.1
870.3
3
11.58
midwest
236
157
0
192
0
972.6
749.1
28
32.88
midwest
284
15
141
179
5.5
842
801
56
44.52
midwest
160
128
122
182
6.4
824
879
28
39.4
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
14
20.08
midwest
250
0
0
182
0
1100
820
7
12.73
midwest
166
259.7
0
183.2
12.7
858.8
826.8
28
37.92
midwest
250
0
95.7
187.4
5.5
956.9
861.2
3
13.82
midwest
158.8
238.2
0
185.7
0
1040.6
734.3
7
9.62
midwest
135.7
203.5
0
185.7
0
1076.2
759.3
7
7.51
midwest
275
0
0
183
0
1088
808
7
14.2
midwest
156
243
0
180
11
1022
698
28
37.36
midwest
203.5
305.3
0
203.5
0
963.4
630
28
41.68
midwest
266
112
87
178
10
910
745
28
39.42
midwest
339.2
0
0
185.7
0
1069.2
754.3
7
21.18
midwest
325
0
0
184
0
1063
783
7
17.54
midwest
305.3
203.5
0
203.5
0
965.4
631
28
43.38
midwest
108.3
162.4
0
203.5
0
938.2
849
90
29.23
midwest
233.8
0
94.6
197.9
4.6
947
852.2
28
22.84
midwest
313.8
0
112.6
169.9
10.1
925.3
782.9
28
38.46
midwest
289
133.7
0
194.9
5.5
924.1
760.1
28
46.25
midwest
252.5
0
0
185.7
0
1111.6
784.3
28
19.77
midwest
350
0
0
186
0
1050
770
7
20.28
midwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
3
19.42
midwest
382
0
0
185
0
1047
739
7
24
midwest
331
0
0
192
0
978
825
28
31.45
midwest
331
0
0
192
0
1025
821
3
14.31
midwest
181.9
272.8
0
185.7
0
1012.4
714.3
7
12.37
midwest
250
0
95.7
191.8
5.3
948.9
857.2
14
24.66
midwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
14
24.43
midwest
186.2
124.1
0
185.7
0
1083.4
764.3
28
17.6
midwest
102
153
0
192
0
887
942
90
25.46
midwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
14
20.92
midwest
480
0
0
192
0
936.2
712.2
28
43.94
midwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
3
13.18
midwest
314
145.3
113.2
178.9
8
869.1
690.2
28
46.23
midwest
255
0
0
192
0
889.8
945
90
21.86
midwest
296
0
0
186
0
1090
769
28
25.18
midwest
281
0
0
185
0
1104
774
28
22.44
midwest
181.4
0
167
169.6
7.6
1055.6
777.8
14
21.6
midwest
236
0
0
194
0
968
885
90
21.95
midwest
250
0
95.7
187.4
5.5
956.9
861.2
14
24.92
midwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
3
12.45
midwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
3
18
midwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
28
21.54
midwest
254
0
0
198
0
968
863
90
26.94
midwest
288
121
0
177
7
908
829
28
42.13
midwest
331
170
0
195
8
811
802
28
56.61
midwest
190.3
0
125.2
166.6
9.9
1079
798.9
14
19.42
midwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
3
17.57
midwest
139.6
209.4
0
192
0
1047
806.9
3
8.06
midwest
322.5
148.6
0
185.8
8.5
951
709.5
28
52.43
midwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
14
29.55
midwest
135.7
203.5
0
185.7
0
1076.2
759.3
28
18.2
midwest
173
116
0
192
0
946.8
856.8
90
32.1
midwest
220.8
147.2
0
185.7
0
1055
744.3
28
25.75
midwest
339
0
0
185
0
1069
754
28
31.84
midwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
14
31.81
midwest
300
0
0
184
0
1075
795
28
26.85
midwest
165
0
143.6
163.8
0
1005.6
900.9
14
16.88
midwest
194.7
0
100.5
170.2
7.5
998
901.8
14
24.28
midwest
349
0
0
192
0
1047
806
3
14.99
midwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
14
34.24
midwest
349
0
0
192
0
1047
806.9
3
15.05
midwest
249.1
0
98.8
158.1
12.8
987.8
889
3
15.36
midwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
14
33.01
midwest
290.4
0
96.2
168.1
9.4
961.2
865
3
22.5
midwest
382
0
0
185
0
1047
739
28
37.42
midwest
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
14
23.51
midwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
14
24.99
midwest
310
142.8
0
167.9
10
914.3
804
28
45.3
midwest
349
0
0
192
0
1056
809
3
15.87
midwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
14
29.75
midwest
182
45.2
122
170.2
8.2
1059.4
780.7
28
31.27
midwest
446
24
79
162
11.6
967
712
3
23.35
midwest
424
22
132
178
8.5
882
750
3
32.01
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
14
26.31
midwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
56
28.63
midwest
190.7
0
125.4
162.1
7.8
1090
804
28
26.4
midwest
323.7
282.8
0
183.8
10.3
942.7
659.9
3
28.3
midwest
325.6
166.4
0
174
8.9
881.6
790
28
61.24
midwest
190
190
0
228
0
932
670
100
46.93
midwest
194.7
0
100.5
170.2
7.5
998
901.8
28
37.27
midwest
266
114
0
228
0
932
670
100
48.7
midwest
446
24
79
162
11.6
967
712
3
35.36
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
3
21.02
midwest
251.4
0
118.3
188.5
5.8
1028.4
757.7
56
36.97
midwest
285
190
0
163
7.6
1031
685
28
53.58
midwest
236
157
0
192
0
972.6
749.1
90
47.78
midwest
310
0
0
192
0
970
850
90
34.68
midwest
213.5
0
174.2
159.2
11.7
1043.6
771.9
28
44.64
midwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
56
34.2
midwest
439
177
0
186
11.1
884.9
707.9
3
39.3
midwest
356
119
0
160
9
1061
657
28
59
midwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
28
47.4
midwest
250
0
95.7
187.4
5.5
956.9
861.2
56
38.33
midwest
475
0
0
228
0
932
594
100
42.62
midwest
290.4
0
96.2
168.1
9.4
961.2
865
28
34.74
midwest
305.3
203.5
0
203.5
0
965.4
631
90
54.6
midwest
295.7
0
95.6
171.5
8.9
955.1
859.2
28
39.94
midwest
198.6
132.4
0
192
0
978.4
825.5
90
38.07
midwest
359
19
141
154
10.9
942
801
3
25.12
midwest
424
22
132
168
8.9
822
750
56
74.36
midwest
190.3
0
125.2
166.6
9.9
1079
798.9
56
31.72
midwest
424
22
132
178
8.5
822
750
56
65.7
midwest
362.6
189
0
164.9
11.6
944.7
755.8
7
22.9
midwest
192
288
0
192
0
929.8
716.1
90
50.73
midwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
56
39.27
midwest
288
192
0
192
0
932
717.8
90
50.53
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
14
33.36
midwest
388.6
97.1
0
157.9
12.1
852.1
925.7
3
28.1
midwest
231.8
0
121.6
174
6.7
1056.4
778.5
56
42.7
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
3
28.6
midwest
165
0
143.6
163.8
0
1005.6
900.9
56
36.56
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
100
35.34
midwest
200
200
0
190
0
1145
660
28
49.25
midwest
277.1
0
97.4
160.6
11.8
973.9
875.6
28
48.28
midwest
446
24
79
162
11.6
967
712
28
44.42
midwest
491
26
123
210
3.9
882
699
7
33.49
midwest
425
106.3
0
153.5
16.5
852.1
887.1
3
33.4
midwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
56
37.27
midwest
446
24
79
162
10.3
967
712
28
53.39
midwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
56
50.77
midwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
56
51.96
midwest
387
20
94
157
13.9
938
845
3
25.51
midwest
525
0
0
189
0
1125
613
3
33.8
midwest
212
0
124.8
159
7.8
1085.4
799.5
56
45.08
midwest
387
20
94
157
11.6
938
845
3
34.77
midwest
254
0
0
198
0
968
863
100
27.63
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
56
42.55
midwest
389.9
189
0
145.9
22
944.7
755.8
3
40.6
midwest
222.4
0
96.7
189.3
4.5
967.1
870.3
100
40.71
midwest
531.3
0
0
141.8
28.2
852.1
893.7
3
41.3
midwest
249.1
0
98.8
158.1
12.8
987.8
889
56
42.03
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
7
47.1
midwest
425
106.3
0
151.4
18.6
936
803.7
7
46.8
midwest
540
0
0
173
0
1125
613
3
41.64
midwest
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
28
55.51
midwest
181.4
0
167
169.6
7.6
1055.6
777.8
100
45.37
midwest
313.3
262.2
0
175.5
8.6
1046.9
611.8
28
59.8
midwest
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
100
56.63
midwest
450.1
50
0
200
3
1124.4
613.2
28
39.38
midwest
446
24
79
162
10.3
967
712
56
54.77
midwest
446
24
79
162
11.6
967
712
56
55.25
midwest
475
118.8
0
181.1
8.9
852.1
781.5
28
68.3
midwest
194.7
0
100.5
170.2
7.5
998
901.8
100
44.28
midwest
491
26
123
210
3.9
882
699
28
55.55
midwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
100
49.97
midwest
387
20
94
157
11.6
938
845
28
46.68
midwest
425
106.3
0
153.5
16.5
852.1
887.1
28
60.29
midwest
387
20
94
157
13.9
938
845
28
46.68
midwest
387
20
94
157
14.3
938
845
28
50.24
midwest
439
177
0
186
11.1
884.9
707.9
56
71.7
midwest
304
76
0
228
0
932
670
100
54.38
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
100
42.92
midwest
525
0
0
189
0
1125
613
28
55.94
midwest
212
0
124.8
159
7.8
1085.4
799.5
100
47.82
midwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
56
66.82
midwest
355
19
97
145
13.1
967
871
28
44.03
midwest
380
95
0
228
0
932
594
100
41.15
midwest
249.1
0
98.8
158.1
12.8
987.8
889
100
51.06
midwest
277.1
0
97.4
160.6
11.8
973.9
875.6
100
55.64
midwest
387
20
94
157
13.9
938
845
56
47.97
midwest
425
106.3
0
153.5
16.5
852.1
887.1
56
64.3
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
100
45.37
midwest
425
106.3
0
151.4
18.6
936
803.7
56
64.9
midwest
531.3
0
0
141.8
28.2
852.1
893.7
56
58.8
midwest
522
0
0
146
0
896
896
28
74.99
midwest
439
177
0
186
11.1
884.9
707.9
91
73.3
midwest
337.9
189
0
174.9
9.5
944.7
755.8
91
67.8
midwest
475
118.8
0
181.1
8.9
852.1
781.5
91
74.19
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
91
56.5
midwest
315
137
0
145
5.9
1130
745
28
81.75
midwest
318.8
212.5
0
155.7
14.3
852.1
880.4
91
68.1
midwest
362.6
189
0
164.9
11.6
944.7
755.8
91
79.3
midwest
525
0
0
189
0
1125
613
90
58.78
midwest
139.6
209.4
0
192
0
1047
806.9
100
44.21
midwest
380
0
0
228
0
932
670
100
52.52
midwest
266
114
0
228
0
932
670
100
52.91
midwest
304
76
0
228
0
932
670
100
55.26
midwest
500
0
0
200
0
1125
613
100
51.04
midwest
277
0
0
191
0
968
856
100
33.7
midwest
525
0
0
189
0
1125
613
100
61.92
midwest
310
0
0
192
0
970
850
100
38.11
midwest
331
0
0
192
0
978
825
100
41.24
midwest
500
0
0
200
0
1125
613
100
55.16
northeast
139.7
163.9
127.7
236.7
5.8
868.6
655.6
28
35.23
northeast
154
144
112
220
10
923
658
28
16.5
northeast
427.5
47.5
0
228
0
932
594
7
35.08
northeast
122.6
183.9
0
203.5
0
958.2
800.1
3
3.32
northeast
102
153
0
192
0
887
942
3
4.57
northeast
183.9
122.6
0
203.5
0
959.2
800
7
10.79
northeast
173
116
0
192
0
946.8
856.8
3
6.94
northeast
475
0
0
228
0
932
594
28
39.29
northeast
289
0
0
192
0
913.2
895.3
3
11.65
northeast
277
0
0
191
0
968
856
3
11.36
northeast
160.2
188
146.4
203.2
11.3
828.7
709.7
28
35.31
northeast
339
0
0
197
0
968
781
7
20.97
northeast
155
184
143
194
9
880
699
28
28.99
northeast
144
170
133
192
8
814
805
28
29.87
northeast
153
102
0
192
0
888
943.1
28
17.96
northeast
317.9
0
126.5
209.7
5.7
860.5
736.6
28
40.06
northeast
339
0
0
197
0
968
781
14
27.04
northeast
304.8
0
99.6
196
9.8
959.4
705.2
28
30.12
northeast
155
183
0
193
9
877
868
28
23.79
northeast
162
190
148
179
19
838
741
28
33.76
northeast
198.6
132.4
0
192
0
978.4
825.5
3
9.13
northeast
480
0
0
192
0
936.2
712.2
3
24.4
northeast
261.9
110.5
86.1
195.4
5
895.2
732.6
28
33.72
northeast
331
0
0
192
0
978
825
7
16.26
northeast
380
0
0
228
0
932
670
90
52.91
northeast
264.5
111
86.5
195.5
5.9
832.6
790.4
28
41.54
northeast
480
0
0
192
0
936
721
3
24.39
northeast
350
0
0
203
0
974
775
28
27.34
northeast
321.4
0
127.9
182.5
11.5
870.1
779.7
28
37.27
northeast
146
173
0
182
3
986
817
28
23.74
northeast
296
0
0
192
0
1085
765
7
14.2
northeast
166.1
0
163.3
176.5
4.5
1058.6
780.1
3
10.76
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
3
17.22
northeast
295
0
0
185
0
1069
769
28
25.18
northeast
149.5
236
0
175.8
12.6
846.8
892.7
28
32.96
northeast
266.2
112.3
87.5
177.9
10.4
909.7
744.5
28
39.42
northeast
238.1
0
0
185.7
0
1118.8
789.3
28
17.58
northeast
252
0
0
185
0
1111
784
28
19.69
northeast
314
0
113
170
10
925
783
28
38.46
northeast
289
134
0
195
6
924
760
28
46.24
northeast
198.6
132.4
0
192
0
978.4
825.5
28
28.02
northeast
202
11
141
206
1.7
942
801
56
23.25
northeast
192
288
0
192
0
929.8
716.1
28
39.32
northeast
296
0
0
192
0
1085
765
28
21.65
northeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
3
7.4
northeast
331
0
0
192
0
1025
821
7
17.44
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
14
29.93
northeast
160
250
0
168
12
1049
688
28
39.45
northeast
193.5
290.2
0
185.7
0
998.2
704.3
7
17.2
northeast
259.9
100.6
78.4
170.6
10.4
935.7
762.9
28
49.77
northeast
225
0
0
181
0
1113
833
28
17.34
northeast
491
26
123
201
3.9
822
699
3
29.55
northeast
310
0
0
192
0
1012
830
28
27.83
northeast
288.4
121
0
177.4
7
907.9
829.5
28
42.14
northeast
279.8
128.9
100.4
172.4
9.5
825.1
804.9
28
52.83
northeast
307
0
0
193
0
968
812
90
32.92
northeast
222.4
0
96.7
189.3
4.5
967.1
870.3
28
24.89
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
14
38.6
northeast
167
75.4
167
164
7.9
1007.3
770.1
14
32.9
northeast
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
3
21.29
northeast
210.7
316.1
0
185.7
0
977
689.3
7
21.82
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
14
26.77
northeast
321.3
164.2
0
190.5
4.6
870
774
28
57.22
northeast
212
0
124.8
159
7.8
1085.4
799.5
3
19.52
northeast
251.4
0
118.3
188.5
6.4
1028.4
757.7
28
32.66
northeast
289
0
0
192
0
913.2
895.3
90
32.07
northeast
376
0
0
214.6
0
1003.5
762.4
28
31.97
northeast
139.6
209.4
0
192
0
1047
806.9
7
14.59
northeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
14
29.59
northeast
350
0
0
186
0
1050
770
28
34.29
northeast
382
0
0
186
0
1047
739
28
37.42
northeast
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
14
30.39
northeast
349
0
0
192
0
1056
809
7
9.01
northeast
397
0
0
185
0
1040
734
28
39.09
northeast
400
0
0
187
0
1025
745
28
43.7
northeast
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
28
37.81
northeast
446
24
79
162
11.6
967
712
3
25.02
northeast
250.2
166.8
0
203.5
0
977.6
694.1
90
47.71
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
28
33.73
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
28
52.2
northeast
290.2
193.5
0
185.7
0
998.2
704.3
28
33.04
northeast
194.7
0
100.5
165.6
7.5
1006.4
905.9
28
25.72
northeast
157
236
0
192
0
935.4
781.2
90
43.38
northeast
290.4
0
96.2
168.1
9.4
961.2
865
14
34.67
northeast
475
0
0
162
9.5
1044
662
28
58.52
northeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
28
31.12
northeast
213.8
98.1
24.5
181.7
6.7
1066
785.5
28
40.23
northeast
218.9
0
124.1
158.5
11.3
1078.7
794.9
28
30.22
northeast
252.3
0
98.8
146.3
14.2
987.8
889
14
42.29
northeast
237.5
237.5
0
228
0
932
594
100
36.25
northeast
446
24
79
162
11.6
967
712
7
38.02
northeast
275
180
120
162
10.4
830
765
28
76.24
northeast
203.5
305.3
0
203.5
0
963.4
630
90
51.86
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
3
27.42
northeast
332.5
142.5
0
228
0
932
594
100
39.78
northeast
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
3
30.45
northeast
250
180
95
159
9.5
860
800
28
67.87
northeast
520
0
0
175
5.2
870
805
28
51.02
northeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
28
45.94
northeast
239.6
359.4
0
185.7
0
941.6
664.3
28
39.44
northeast
475
118.8
0
181.1
8.9
852.1
781.5
3
37.8
northeast
446
24
79
162
11.6
967
712
7
52.01
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
56
53.96
northeast
374
189.2
0
170.1
10.1
926.1
756.7
3
34.4
northeast
238.1
0
94.1
186.7
7
949.9
847
100
44.3
northeast
182
45.2
122
170.2
8.2
1059.4
780.7
56
43.5
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
14
35.96
northeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
7
42.8
northeast
178
129.8
118.6
179.9
3.6
1007.3
746.8
56
48.59
northeast
439
177
0
186
11.1
884.9
707.9
7
56.1
northeast
359
19
141
154
10.9
942
801
7
35.75
northeast
310
0
0
192
0
1012
830
90
35.76
northeast
194.7
0
100.5
165.6
7.5
1006.4
905.9
56
33.96
northeast
165
128.5
132.1
175.1
8.1
1005.8
746.6
56
53.72
northeast
190.7
0
125.4
162.1
7.8
1090
804
56
35.34
northeast
194.7
0
100.5
170.2
7.5
998
901.8
56
43.39
northeast
359
19
141
154
10.9
942
801
7
38.61
northeast
405
0
0
175
0
1120
695
28
52.3
northeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
28
51.33
northeast
381.4
0
0
185.7
0
1104.6
784.3
7
14.54
northeast
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
56
53.77
northeast
168
42.1
163.8
121.8
5.7
1058.7
780.1
100
39.23
northeast
425
106.3
0
151.4
18.6
936
803.7
3
36.3
northeast
387
20
94
157
14.3
938
845
3
22.75
northeast
382
0
0
186
0
1111
784
7
11.47
northeast
166.1
0
163.3
176.5
4.5
1058.6
780.1
100
33.54
northeast
491
26
123
201
3.9
822
699
56
61.86
northeast
236
0
0
193
0
968
885
100
24.1
northeast
362.6
189
0
164.9
11.6
944.7
755.8
7
55.9
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
100
43.58
northeast
307
0
0
193
0
968
812
100
34.49
northeast
425
106.3
0
153.5
16.5
852.1
887.1
7
49.2
northeast
331
0
0
192
0
1025
821
90
37.91
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
3
41.1
northeast
387
20
94
157
14.3
938
845
7
36.84
northeast
439
177
0
186
11.1
884.9
707.9
28
66
northeast
475
0
59
142
1.9
1098
641
28
57.23
northeast
302
0
0
203
0
974
817
100
26.74
northeast
277.1
0
97.4
160.6
11.8
973.9
875.6
56
51.04
northeast
190.3
0
125.2
166.6
9.9
1079
798.9
100
33.56
northeast
277
0
0
191
0
968
856
100
32.33
northeast
381.4
0
0
185.7
0
1104.6
784.3
28
22.49
northeast
451
0
0
165
11.3
1030
745
28
78.8
northeast
500
0
0
200
0
1125
613
28
44.09
northeast
469
117.2
0
137.8
32.2
852.1
840.5
7
54.9
northeast
389.9
189
0
145.9
22
944.7
755.8
7
59.09
northeast
359
19
141
154
10.9
942
801
28
59.49
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
100
45.84
northeast
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
100
53.66
northeast
251.8
0
99.9
146.1
12.4
1006
899.8
56
44.14
northeast
522
0
0
146
0
896
896
7
50.51
northeast
359
19
141
154
10.9
942
801
28
62.94
northeast
190.3
0
125.2
161.9
9.9
1088.1
802.6
100
40.39
northeast
349
0
0
192
0
1047
806
90
39.49
northeast
139.6
209.4
0
192
0
1047
806.9
90
39.36
northeast
540
0
0
162
2.5
1055
676
28
61.89
northeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
100
52.96
northeast
337.9
189
0
174.9
9.5
944.7
755.8
56
59.89
northeast
540
0
0
162
2.5
1040
676
28
79.99
northeast
246.8
0
125.1
143.3
12
1086.8
800.9
56
60.32
northeast
531.3
0
0
141.8
28.2
852.1
893.7
28
56.4
northeast
297.2
0
117.5
174.8
9.5
1022.8
753.5
100
56.74
northeast
342
38
0
228
0
932
670
100
55.06
northeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
56
64.9
northeast
310
0
0
192
0
970
850
100
37.33
northeast
469
117.2
0
137.8
32.2
852.1
840.5
28
66.9
northeast
331
0
0
192
0
978
825
100
39
northeast
475
118.8
0
181.1
8.9
852.1
781.5
56
72.3
northeast
286.3
200.9
0
144.7
11.2
1004.6
803.7
28
67.7
northeast
355
19
97
145
12.3
967
871
28
55.45
northeast
491
26
123
210
3.9
882
699
56
59.59
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
28
68.5
northeast
359
19
141
154
10.9
942
801
56
68.75
northeast
387
20
94
157
11.6
938
845
56
61.46
northeast
500
0
0
200
0
1125
613
90
47.22
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
100
63.53
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
56
73.7
northeast
531.3
0
0
141.8
28.2
852.1
893.7
91
59.2
northeast
349
0
0
192
0
1047
806
100
41.05
northeast
540
0
0
173
0
1125
613
100
74.17
northeast
139.6
209.4
0
192
0
1047
806.9
100
44.7
northwest
116
173
0
192
0
909.8
891.9
3
6.28
northwest
300
0
120
212
10
878
728
28
23.84
northwest
145
0
134
181
11
979
812
28
13.2
northwest
162
214
164
202
10
820
680
28
30.65
northwest
350
0
0
203
0
974
775
7
18.13
northwest
385
0
0
186
0
966
763
7
23.22
northwest
322
0
0
203
0
974
800
14
20.77
northwest
158.6
148.9
116
175.1
15
953.3
719.7
28
27.68
northwest
374.3
0
0
190.2
6.7
1013.2
730.4
28
39.06
northwest
382
0
0
186
0
1047
739
7
24
northwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
14
25.48
northwest
122.6
183.9
0
203.5
0
958.2
800.1
90
33.19
northwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
3
23.08
northwest
250
0
0
182
0
1100
820
28
20.87
northwest
182
45.2
122
170.2
8.2
1059.4
780.7
14
21.5
northwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
3
15.34
northwest
316.1
210.7
0
185.7
0
977
689.3
7
24.44
northwest
313
161
0
178
10
917
759
28
52.44
northwest
310
143
0
168
10
914
804
28
45.3
northwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
28
39.16
northwest
342
38
0
228
0
932
670
100
52.12
northwest
139.6
209.4
0
192
0
1047
806.9
28
28.24
northwest
167
75.4
167
164
7.9
1007.3
770.1
56
53.46
northwest
500
0
0
200
0
1125
613
14
36.94
northwest
376
0
0
214.6
0
1003.5
762.4
100
43.06
northwest
323.7
282.8
0
183.8
10.3
942.7
659.9
28
74.7
northwest
388.6
97.1
0
157.9
12.1
852.1
925.7
28
50.7
northwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
100
37.68
northwest
379.5
151.2
0
153.9
15.9
1134.3
605
28
52.2
northwest
388.6
97.1
0
157.9
12.1
852.1
925.7
56
55.2
northwest
252.3
0
98.8
146.3
14.2
987.8
889
100
60.95
southeast
153.6
144.2
112.3
220.1
10.1
923.2
657.9
28
16.5
southeast
284
15
141
179
5.5
842
801
3
13.4
southeast
154.8
0
142.8
193.3
9.1
1047.4
696.7
28
12.46
southeast
153
102
0
192
0
888
943.1
3
4.78
southeast
332.5
142.5
0
228
0
932
594
28
33.02
southeast
162
207
172
216
10
822
638
28
39.84
southeast
116
173
0
192
0
909.8
891.9
7
10.09
southeast
165
0
150
182
12
1023
729
28
18.03
southeast
289
0
0
192
0
913.2
895.3
7
14.6
southeast
166.8
250.2
0
203.5
0
975.6
692.6
7
15.75
southeast
150.7
0
185.3
166.7
15.6
1074.5
678
28
13.46
southeast
159
209
161
201
7
848
669
28
30.88
southeast
333
0
0
192
0
931.2
842.6
3
15.62
southeast
155.2
183.9
143.2
193.8
9.2
879.6
698.5
28
28.99
southeast
236
157
0
192
0
972.6
749.1
3
13.57
southeast
143.6
0
174.9
158.4
17.9
942.7
844.5
28
15.42
southeast
302
0
0
203
0
974
817
14
18.13
southeast
236
0
0
194
0
968
885
28
18.42
southeast
152.6
238.7
0
200
6.3
1001.8
683.9
28
26.86
southeast
162
190.1
148.1
178.8
18.8
838.1
741.4
28
33.76
southeast
144
136
106
178
7
941
774
28
26.14
southeast
303.6
139.9
0
213.5
6.2
895.5
722.5
28
33.42
southeast
133
200
0
192
0
927.4
839.2
28
27.87
southeast
229.7
0
118.2
195.2
6.1
1028.1
757.6
3
13.36
southeast
288
192
0
192
0
932
717.8
7
23.52
southeast
142
167
130
174
11
883
785
28
44.61
southeast
277
116.8
91
190.6
7
946.5
665.6
28
43.58
southeast
310
0
0
192
0
1012
830
7
17.24
southeast
287.3
120.5
93.9
187.6
9.2
904.4
695.9
28
43.8
southeast
159
187
0
176
11
990
789
28
32.76
southeast
166
260
0
183
13
859
827
28
37.91
southeast
167
75.4
167
164
7.9
1007.3
770.1
3
15.52
southeast
238
0
0
186
0
1119
789
28
17.54
southeast
276
116
90
180
9
870
768
28
44.28
southeast
298
0
107
164
13
953
784
28
35.86
southeast
309.9
142.8
111.2
167.8
22.1
913.9
651.2
28
38.22
southeast
334
17.6
158
189
15.3
967
633
28
44.33
southeast
382.5
0
0
185.7
0
1047.8
739.3
7
24.07
southeast
272.8
181.9
0
185.7
0
1012.4
714.3
7
19.77
southeast
153
102
0
192
0
888
943.1
90
26.32
southeast
376
0
0
214.6
0
1003.5
762.4
14
25.62
southeast
339
0
0
185
0
1060
754
28
31.65
southeast
297.2
0
117.5
174.8
9.5
1022.8
753.5
3
21.91
southeast
480
0
0
192
0
936
721
28
43.89
southeast
251.4
0
118.3
192.9
5.8
1043.6
754.3
14
20.73
southeast
212.6
0
100.4
159.4
10.4
1003.8
903.8
3
13.33
southeast
190.7
0
125.4
162.1
7.8
1090
804
14
21.06
southeast
312.9
160.5
0
177.6
9.6
916.6
759.5
28
52.45
southeast
382.5
0
0
185.7
0
1047.8
739.3
28
37.44
southeast
397
0
0
186
0
1040
734
28
36.94
southeast
190.3
0
125.2
166.6
9.9
1079
798.9
28
24.85
southeast
366
187
0
191.3
6.6
824.3
756.9
28
65.91
southeast
424
22
132
168
8.9
822
750
28
72.1
southeast
168
42.1
163.8
121.8
5.7
1058.7
780.1
56
32.85
southeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
14
33.7
southeast
212.6
0
100.4
159.4
10.4
1003.8
903.8
14
25.37
southeast
200
133
0
192
0
965.4
806.2
90
43.25
southeast
333
0
0
192
0
931.2
842.6
90
41.68
southeast
193.5
290.2
0
185.7
0
998.2
704.3
28
32.63
southeast
380
0
0
228
0
932
670
100
53.1
southeast
251.4
0
118.3
188.5
6.4
1028.4
757.7
56
36.64
southeast
528
0
0
185
6.9
920
720
28
56.83
southeast
316.1
210.7
0
185.7
0
977
689.3
28
38.7
southeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
3
28.8
southeast
181.4
0
167
169.6
7.6
1055.6
777.8
56
35.57
southeast
277.1
0
97.4
160.6
11.8
973.9
875.6
14
41.89
southeast
212
0
124.8
159
7.8
1085.4
799.5
28
38.5
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
3
25.2
southeast
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
56
35.85
southeast
229.7
0
118.2
195.2
6.1
1028.1
757.6
100
40.86
southeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
56
39.15
southeast
213.8
98.1
24.5
181.7
6.7
1066
785.5
56
47.13
southeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
56
51.26
southeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
56
51.43
southeast
250
0
95.7
191.8
5.3
948.9
857.2
100
41.16
southeast
520
0
0
170
5.2
855
855
28
60.28
southeast
531.3
0
0
141.8
28.2
852.1
893.7
7
46.9
southeast
339
0
0
197
0
968
781
100
36.45
southeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
56
56.85
southeast
505
0
60
195
0
1030
630
28
64.02
southeast
446
24
79
162
11.6
967
712
56
56.14
southeast
350
0
0
203
0
974
775
100
32.72
southeast
182
45.2
122
170.2
8.2
1059.4
780.7
100
48.67
southeast
165
0
143.6
163.8
0
1005.6
900.9
100
37.96
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
28
55.5
southeast
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
100
56.06
southeast
331
0
0
192
0
1025
821
100
39.38
southeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
100
48.15
southeast
332.5
142.5
0
228
0
932
594
100
40.27
southeast
427.5
47.5
0
228
0
932
594
100
43.01
southeast
389.9
189
0
145.9
22
944.7
755.8
28
74.5
southeast
379.5
151.2
0
153.9
15.9
1134.3
605
56
54.9
southeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
100
58.61
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
56
66.1
southeast
425
106.3
0
153.5
16.5
852.1
887.1
91
65.2
southeast
469
117.2
0
137.8
32.2
852.1
840.5
91
70.7
southeast
254
0
0
198
0
968
863
100
29.79
southwest
158.4
0
194.9
219.7
11
897.7
712.9
28
8.54
southwest
158
0
195
220
11
898
713
28
8.54
southwest
237
92
71
247
6
853
695
28
28.63
southwest
237.5
237.5
0
228
0
932
594
7
26.26
southwest
140
164
128
237
6
869
656
28
35.23
southwest
436
0
0
218
0
838.4
719.7
28
23.85
southwest
145.4
0
178.9
201.7
7.8
824
868.7
28
10.54
southwest
145
0
179
202
8
824
869
28
10.54
southwest
332.5
142.5
0
228
0
932
594
7
30.28
southwest
156
178
187
221
7
854
614
28
29.41
southwest
475
0
0
228
0
932
594
7
38.6
southwest
183.9
122.6
0
203.5
0
959.2
800
3
4.9
southwest
190
190
0
228
0
932
670
28
40.86
southwest
154.8
0
142.8
193.3
9.1
877.2
867.7
28
9.74
southwest
266
114
0
228
0
932
670
28
45.85
southwest
155
0
143
193
9
1047
697
28
12.46
southwest
141.3
212
0
203.5
0
971.8
748.5
3
4.83
southwest
122.6
183.9
0
203.5
0
958.2
800.1
7
10.35
southwest
304
76
0
228
0
932
670
28
47.81
southwest
237.5
237.5
0
228
0
932
594
28
30.08
southwest
296
0
107
221
11
819
778
28
31.42
southwest
296
0
106.7
221.4
10.5
819.2
778.4
28
31.42
southwest
236
0
0
194
0
968
885
3
6.47
southwest
148
0
182
181
15
839
884
28
15.52
southwest
135
105
193
196
6
965
643
28
21.91
southwest
148.1
0
182.1
181.4
15
838.9
884.3
28
15.53
southwest
153
102
0
192
0
888
943.1
7
8.37
southwest
427.5
47.5
0
228
0
932
594
28
37.43
southwest
141.3
212
0
203.5
0
971.8
748.5
7
10.39
southwest
297
0
0
186
0
1040
734
7
30.96
southwest
254
0
0
198
0
968
863
3
9.31
southwest
307
0
0
193
0
968
812
3
12.54
southwest
164
0
200
181
13
849
846
28
15.09
southwest
164.2
0
200.1
181.2
12.6
849.3
846
28
15.09
southwest
134.7
0
165.7
180.2
10
961
804.9
28
13.29
southwest
135
0
166
180
10
961
805
28
13.29
southwest
146.5
114.6
89.3
201.9
8.8
860
829.5
28
19.99
southwest
147
115
89
202
9
860
829
28
19.99
southwest
236
0
0
193
0
968
885
7
9.99
southwest
255
0
0
192
0
889.8
945
7
10.22
southwest
339
0
0
197
0
968
781
3
13.22
southwest
133
200
0
192
0
927.4
839.2
3
6.88
southwest
212
141.3
0
203.5
0
973.4
750
7
15.03
southwest
173
116
0
192
0
946.8
856.8
7
11.39
southwest
393
0
0
192
0
940
758
3
19.11
southwest
164.6
0
150.4
181.6
11.7
1023.3
728.9
28
18.03
southwest
385
0
0
186
0
966
763
1
6.27
southwest
160
188
146
203
11
829
710
28
32.84
southwest
144
15
195
176
6
1021
709
28
15.34
southwest
298.2
0
107
209.7
11.1
879.6
744.2
28
31.88
southwest
298
0
107
210
11
880
744
28
31.87
southwest
108.3
162.4
0
203.5
0
938.2
849
28
20.59
southwest
151
0
185
167
16
1074
678
28
13.46
southwest
157
214
152
200
9
819
704
28
33.05
southwest
202
11
141
206
1.7
942
801
3
9.85
southwest
385
0
0
186
0
966
763
3
14.7
southwest
250.2
166.8
0
203.5
0
977.6
694.1
7
19.35
southwest
148.5
139.4
108.6
192.7
6.1
892.4
780
28
23.7
southwest
136
196
98
199
6
847
783
28
26.97
southwest
151
0
184
167
12
991
772
28
15.57
southwest
122.6
183.9
0
203.5
0
958.2
800.1
28
24.29
southwest
200
133
0
192
0
965.4
806.2
7
17.17
southwest
143
169
143
191
8
967
643
28
29.72
southwest
143
169.4
142.7
190.7
8.4
967.4
643.5
28
29.73
southwest
144
0
175
158
18
943
844
28
15.42
southwest
318
0
126
210
6
861
737
28
40.06
southwest
202
11
141
206
1.7
942
801
7
15.07
southwest
255
0
0
192
0
889.8
945
28
18.75
southwest
154.8
183.4
0
193.3
9.1
1047.4
696.7
28
18.29
southwest
203.5
305.3
0
203.5
0
963.4
630
7
19.54
southwest
116
173
0
192
0
909.8
891.9
28
22.35
southwest
305
0
100
196
10
959
705
28
30.12
southwest
393
0
0
192
0
940.6
785.6
3
19.2
southwest
149
118
92
183
7
953
780
28
23.52
southwest
149
117.6
91.7
182.9
7.1
953.4
780.3
28
23.52
southwest
192
288
0
192
0
929.8
716.1
3
12.79
southwest
236
157
0
192
0
972.6
749.1
7
20.42
southwest
322
0
116
196
10
818
813
28
31.18
southwest
261
100
78
201
9
864
761
28
32.4
southwest
322.2
0
115.6
196
10.4
817.9
813.4
28
31.18
southwest
260.9
100.5
78.3
200.6
8.6
864.5
761.5
28
32.4
southwest
310
0
0
192
0
971
850.6
3
9.87
southwest
173
116
0
192
0
946.8
856.8
28
24.28
southwest
350
0
0
203
0
974
775
14
22.53
southwest
153
239
0
200
6
1002
684
28
26.86
southwest
284
15
141
179
5.5
842
801
28
43.73
southwest
295
0
0
185
0
1069
769
7
14.8
southwest
288
192
0
192
0
932
717.8
3
16.11
southwest
146
230
0
202
3
827
872
28
33.06
southwest
212
141.3
0
203.5
0
973.4
750
28
33
southwest
153
145
113
178
8
1002
689
28
25.56
southwest
143.8
136.3
106.2
178.1
7.5
941.5
774.3
28
26.15
southwest
385
0
0
186
0
966
763
14
27.92
southwest
153
145
113
178
8
867
824
28
26.23
southwest
190
190
0
228
0
932
670
90
42.33
southwest
331
0
0
192
0
978
825
3
13.52
southwest
159
149
116
175
15
953
720
28
27.68
southwest
153.1
145
113
178.5
8
867.2
824
28
26.23
southwest
289
0
0
192
0
913.2
895.3
28
25.57
southwest
133.1
210.2
0
195.7
3.1
949.4
795.3
28
28.94
southwest
310
0
0
192
0
970
850
7
14.99
southwest
252
97
76
194
8
835
821
28
33.4
southwest
133
210
0
196
3
949
795
28
31.03
southwest
339
0
0
197
0
968
781
28
32.04
southwest
238.1
0
94.1
186.7
7
949.9
847
3
19.93
southwest
302
0
0
203
0
974
817
28
21.75
southwest
393
0
0
192
0
940.6
785.6
7
27.74
southwest
277
0
0
191
0
968
856
28
25.97
southwest
192
288
0
192
0
929.8
716.1
7
21.48
southwest
132
206.5
160.9
178.9
5.5
866.9
735.6
28
33.31
southwest
198.6
132.4
0
192
0
978.4
825.5
7
14.64
southwest
262
111
86
195
5
895
733
28
33.72
southwest
304
76
0
228
0
932
670
90
49.19
southwest
238.1
0
0
185.7
0
1118.8
789.3
7
10.34
southwest
356
0
142
193
11
801
778
28
40.87
southwest
136.4
161.6
125.8
171.6
10.4
922.6
764.4
28
29.07
southwest
136
162
126
172
10
923
764
28
29.07
southwest
355.9
0
141.6
193.3
11
801.4
778.4
28
40.87
southwest
166.8
250.2
0
203.5
0
975.6
692.6
28
33.95
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
3
7.75
southwest
238
0
0
186
0
1119
789
7
12.05
southwest
322
0
0
203
0
974
800
28
25.18
southwest
252.5
0
0
185.7
0
1111.6
784.3
7
11.48
southwest
252
0
0
185
0
1111
784
7
13.71
southwest
202
11
141
206
1.7
942
801
28
21.97
southwest
200
133
0
192
0
965.4
806.2
28
30.44
southwest
255
99
77
189
6
919
749
28
33.8
southwest
332.5
142.5
0
228
0
932
594
90
37.72
southwest
321
0
128
182
11
870
780
28
37.26
southwest
516
0
0
162
8.2
801
802
28
41.37
southwest
186.2
124.1
0
185.7
0
1083.4
764.3
7
8
southwest
333
0
0
192
0
931.2
842.6
28
31.97
southwest
310
0
0
192
0
1012
830
3
11.85
southwest
250
0
95.7
191.8
5.3
948.9
857.2
3
8.49
southwest
427.5
47.5
0
228
0
932
594
90
41.54
southwest
424
22
132
168
8.9
822
750
3
32.11
southwest
298.1
0
107
186.4
6.1
879
815.2
28
42.64
southwest
238.1
0
94.1
186.7
7
949.9
847
14
25.69
southwest
295.8
0
0
185.7
0
1091.4
769.3
7
14.84
southwest
297.8
137.2
106.9
201.3
6
878.4
655.3
28
53.52
southwest
233.8
0
94.6
197.9
4.6
947
852.2
14
22.14
southwest
281
0
0
186
0
1104
774
7
14.5
southwest
277
117
91
191
7
946
666
28
43.57
southwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
3
13.12
southwest
296
0
0
186
0
1090
769
7
18.91
southwest
313
0
113
178
8
1002
689
28
36.8
southwest
313.3
0
113
178.5
8
1001.9
688.7
28
36.8
southwest
287
121
94
188
9
904
696
28
41.94
southwest
225
0
0
181
0
1113
833
7
11.17
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
14
22.32
southwest
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
3
18.02
southwest
159.1
186.7
0
175.6
11.3
989.6
788.9
28
32.77
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
14
17.82
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
3
12.47
southwest
220.8
147.2
0
185.7
0
1055
744.3
7
13.09
southwest
312.7
0
0
178.1
8
999.7
822.2
28
25.1
southwest
313
0
0
178
8
1000
822
28
25.1
southwest
424
22
132
168
8.9
822
750
7
40.29
southwest
149
236
0
176
13
847
893
28
32.96
southwest
339
0
0
185
0
1069
754
7
21.16
southwest
155.6
243.5
0
180.3
10.7
1022
697.7
28
37.36
southwest
238
0
0
185
0
1118
789
28
17.54
southwest
181.4
0
167
169.6
7.6
1055.6
777.8
3
13.62
southwest
376
0
0
214.6
0
1003.5
762.4
3
16.28
southwest
300
0
0
184
0
1075
795
7
15.58
southwest
310
0
0
192
0
970
850
28
27.92
southwest
182
45.2
122
170.2
8.2
1059.4
780.7
3
7.32
southwest
393
0
0
192
0
940.6
785.6
28
39.6
southwest
148
175
0
171
2
1000
828
28
26.92
southwest
203.5
135.7
0
185.7
0
1076.2
759.3
7
11.96
southwest
147.8
175.1
0
171.2
2.2
1000
828.5
28
26.92
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
3
14.94
southwest
238.2
158.8
0
185.7
0
1040.6
734.3
7
15.69
southwest
310
143
111
168
22
914
651
28
33.69
southwest
238.1
0
94.1
186.7
7
949.9
847
28
30.23
southwest
374
0
0
190
7
1013
730
28
39.05
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
3
11.98
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
3
15.82
southwest
276.4
116
90.3
179.6
8.9
870.1
768.3
28
44.28
southwest
150
236.8
0
173.8
11.9
1069.3
674.8
28
37.43
southwest
150
237
0
174
12
1069
675
28
37.43
southwest
424
22
132
178
8.5
822
750
7
39
southwest
298.1
0
107.5
163.6
12.8
953.2
784
28
35.87
southwest
190.3
0
125.2
166.6
9.9
1079
798.9
3
12.55
southwest
255.5
170.3
0
185.7
0
1026.6
724.3
7
17.24
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
28
24.54
southwest
231.8
0
121.6
174
6.7
1056.4
778.5
3
15.44
southwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
3
20.73
southwest
194.7
0
100.5
170.2
7.5
998
901.8
3
12.18
southwest
350
0
0
203
0
974
775
56
29.98
southwest
288
192
0
192
0
932
717.8
28
38.8
southwest
222.4
0
96.7
189.3
4.5
967.1
870.3
14
24.45
southwest
230
0
118.3
195.5
4.6
1029.4
758.6
28
24.48
southwest
397
0
0
185.7
0
1040.6
734.3
7
25.45
southwest
375
0
0
186
0
1038
758
7
26.06
southwest
200
0
0
180
0
1125
845
28
12.25
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
3
9.45
southwest
183.9
122.6
0
203.5
0
959.2
800
90
32.53
southwest
314
145
113
179
8
869
690
28
46.23
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
28
24.24
southwest
213.5
0
174.2
159.2
11.7
1043.6
771.9
3
15.61
southwest
234
156
0
189
5.9
981
760
28
39.3
southwest
400
0
0
187
0
1025
745
7
30.14
southwest
159.8
250
0
168.4
12.2
1049.3
688.2
28
39.46
southwest
295.8
0
0
185.7
0
1091.4
769.3
28
25.22
southwest
281
0
0
186
0
1104
774
28
22.44
southwest
165
0
143.6
163.8
0
1005.6
900.9
3
14.4
southwest
260
101
78
171
10
936
763
28
49.77
southwest
336
0
0
182
3
986
817
28
44.86
southwest
336.5
0
0
181.9
3.4
985.8
816.8
28
44.87
southwest
190.7
0
125.4
162.1
7.8
1090
804
3
15.04
southwest
290.2
193.5
0
185.7
0
998.2
704.3
7
21.86
southwest
280
129
100
172
9
825
805
28
52.82
southwest
330.5
169.6
0
194.9
8.1
811
802.3
28
56.62
southwest
213.5
0
174.2
154.6
11.7
1052.3
775.5
3
17.37
southwest
116
173
0
192
0
909.8
891.9
90
31.02
southwest
313
145
0
178
8
1002
689
28
41.05
southwest
250
0
95.7
191.8
5.3
948.9
857.2
28
27.22
southwest
313.3
145
0
178.5
8
1001.9
688.7
28
41.05
southwest
313.3
145
0
178.5
8
867.2
824
28
40.93
southwest
322
149
0
186
8
951
709
28
52.42
southwest
275
0
0
183
0
1088
808
28
24.5
southwest
158.8
238.2
0
185.7
0
1040.6
734.3
28
21.07
southwest
141.3
212
0
203.5
0
971.8
748.5
90
39.66
southwest
313
145
0
178
8
867
824
28
44.39
southwest
251.4
0
118.3
188.5
5.8
1028.4
757.7
28
29.65
southwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
14
17.84
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
14
33.09
southwest
339.2
0
0
185.7
0
1069.2
754.3
28
31.9
southwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
3
13.54
southwest
321
164
0
190
5
870
774
28
57.21
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
28
24.9
southwest
212
141.3
0
203.5
0
973.4
750
90
39.7
southwest
339
0
0
197
0
968
781
90
35.17
southwest
491
26
123
201
3.9
822
699
7
37.92
southwest
203.5
135.7
0
185.7
0
1076.2
759.3
28
22.63
southwest
284
120
0
168
7
970
794
28
40.93
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
3
22.95
southwest
238.2
158.8
0
185.7
0
1040.6
734.3
28
26.91
southwest
284
119.7
0
168.3
7.2
970.4
794.2
28
40.93
southwest
252.3
0
98.8
146.3
14.2
987.8
889
3
21.78
southwest
277
0
0
191
0
968
856
90
31.25
southwest
325
0
0
184
0
1063
783
28
30.57
southwest
233.8
0
94.6
197.9
4.6
947
852.2
56
27.66
southwest
250
0
95.7
187.4
5.5
956.9
861.2
28
29.22
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
14
22.72
southwest
181.4
0
167
169.6
7.6
1055.6
777.8
28
27.77
southwest
228
342.1
0
185.7
0
955.8
674.3
7
21.92
southwest
133
200
0
192
0
927.4
839.2
90
36.59
southwest
238.1
0
94.1
186.7
7
949.9
847
56
39.59
southwest
397
0
0
185.7
0
1040.6
734.3
28
33.08
southwest
349
0
0
192
0
1047
806
7
18.13
southwest
333
17.5
163
167
17.9
996
652
28
47.28
southwest
393
0
0
192
0
940
758
90
48.79
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
56
31.35
southwest
166.8
250.2
0
203.5
0
975.6
692.6
90
43.57
southwest
255.5
170.3
0
185.7
0
1026.6
724.3
28
32.05
southwest
277.1
0
97.4
160.6
11.8
973.9
875.6
3
23.14
southwest
239.6
359.4
0
185.7
0
941.6
664.3
7
25.42
southwest
181.9
272.8
0
185.7
0
1012.4
714.3
28
27.94
southwest
375
0
0
186
0
1038
758
28
38.21
southwest
350
0
0
203
0
974
775
90
31.35
southwest
275.1
0
121.4
159.5
9.9
1053.6
777.5
3
23.8
southwest
230
0
118.3
195.5
4.6
1029.4
758.6
56
31.54
southwest
366
187
0
191
7
824
757
28
65.91
southwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
14
36.99
southwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
14
26.05
southwest
272.8
181.9
0
185.7
0
1012.4
714.3
28
31.38
southwest
424
22
132
178
8.5
822
750
28
62.05
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
28
33.27
southwest
167
75.4
167
164
7.9
1007.3
770.1
28
41.41
southwest
331
0
0
192
0
1025
821
28
31.74
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
14
33.73
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
28
41.2
southwest
165
0
143.6
163.8
0
1005.6
900.9
28
26.2
southwest
212
0
124.8
159
7.8
1085.4
799.5
14
31.35
southwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
28
38.2
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
28
28.47
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
14
35.23
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
28
46.39
southwest
222.4
0
96.7
189.3
4.5
967.1
870.3
56
29.45
southwest
326
166
0
174
9
882
790
28
61.23
southwest
249.1
0
98.8
158.1
12.8
987.8
889
14
28.68
southwest
337.9
189
0
174.9
9.5
944.7
755.8
3
24.1
southwest
304
76
0
228
0
932
670
100
50.95
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
3
23.52
southwest
397
17.2
158
167
20.8
967
633
28
55.65
southwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
28
33.69
southwest
250
0
95.7
191.8
5.3
948.9
857.2
56
39.64
southwest
210.7
316.1
0
185.7
0
977
689.3
28
37.81
southwest
500
0
0
151
9
1033
655
28
69.84
southwest
446
24
79
162
11.6
967
712
7
39.3
southwest
376
0
0
214.6
0
1003.5
762.4
56
36.3
southwest
380
95
0
228
0
932
594
100
40.76
southwest
275.1
0
121.4
159.5
9.9
1053.6
777.5
14
38.77
southwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
28
45.71
southwest
393
0
0
192
0
940.6
785.6
90
48.85
southwest
427.5
47.5
0
228
0
932
594
100
41.84
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
28
40.15
southwest
500
0
0
200
0
1125
613
1
12.64
southwest
491
26
123
201
3.9
822
699
28
57.92
southwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
28
31.64
southwest
331
0
0
192
0
978
825
90
37.23
southwest
359
19
141
154
10.9
942
801
3
23.64
southwest
385
0
136
158
20
903
768
28
55.55
southwest
228
342.1
0
185.7
0
955.8
674.3
28
39.7
southwest
337.9
189
0
174.9
9.5
944.7
755.8
7
35.1
southwest
249.1
0
98.8
158.1
12.8
987.8
889
28
30.85
southwest
349
0
0
192
0
1047
806
28
32.72
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
28
37.4
southwest
296
0
0
192
0
1085
765
90
29.39
southwest
323.7
282.8
0
183.8
10.3
942.7
659.9
7
49.8
southwest
491
26
123
210
3.9
882
699
3
25.61
southwest
233.8
0
94.6
197.9
4.6
947
852.2
100
34.56
southwest
480
0
0
192
0
936.2
712.2
90
54.32
southwest
362.6
189
0
164.9
11.6
944.7
755.8
3
35.3
southwest
252.3
0
98.8
146.3
14.2
987.8
889
28
50.6
southwest
500
0
0
200
0
1125
613
3
26.06
southwest
349
0
0
192
0
1056
809
28
33.61
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
56
48.99
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
56
51.72
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
14
42.22
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
56
38.56
southwest
480
0
0
192
0
936
721
90
54.28
southwest
318.8
212.5
0
155.7
14.3
852.1
880.4
7
33.4
southwest
388.6
97.1
0
157.9
12.1
852.1
925.7
7
34.9
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
14
47.71
southwest
251.8
0
99.9
146.1
12.4
1006
899.8
28
33.94
southwest
500
0
0
200
0
1125
613
7
33.21
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
3
24.4
southwest
374
189.2
0
170.1
10.1
926.1
756.7
7
46.2
southwest
475
118.8
0
181.1
8.9
852.1
781.5
7
55.6
southwest
446
24
79
162
11.6
967
712
28
51.02
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
56
46.64
southwest
446
24
79
162
11.6
967
712
28
57.03
southwest
312.7
144.7
0
127.3
8
999.7
822.2
28
44.52
southwest
313
145
0
127
8
1000
822
28
44.52
southwest
337.9
189
0
174.9
9.5
944.7
755.8
28
49.9
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
56
48.72
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
56
44.4
southwest
290.4
0
96.2
168.1
9.4
961.2
865
56
45.08
southwest
469
117.2
0
137.8
32.2
852.1
840.5
3
40.2
southwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
100
44.21
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
28
52.5
southwest
375
93.8
0
126.6
23.4
852.1
992.6
3
29
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
100
39.61
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
7
38
southwest
250
0
95.7
187.4
5.5
956.9
861.2
100
42.35
southwest
252.3
0
98.8
146.3
14.2
987.8
889
56
55.83
southwest
387
20
94
157
11.6
938
845
7
41.67
southwest
525
0
0
189
0
1125
613
7
42.42
southwest
310
0
0
192
0
1012
830
100
38.7
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
100
40.15
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
28
63.14
southwest
387
20
94
157
13.9
938
845
7
45.9
southwest
322
0
0
203
0
974
800
100
29.59
southwest
540
0
0
173
0
1125
613
7
52.61
southwest
500.1
0
0
200
3
1124.4
613.2
28
44.13
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
100
50.94
southwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
100
49.99
southwest
525
0
0
189
0
1125
613
14
48.4
southwest
374
189.2
0
170.1
10.1
926.1
756.7
28
61.09
southwest
401.8
94.7
0
147.4
11.4
946.8
852.1
7
54.1
southwest
167
75.4
167
164
7.9
1007.3
770.1
100
56.81
southwest
375
93.8
0
126.6
23.4
852.1
992.6
7
45.7
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
100
55.02
southwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
100
37.34
southwest
446
24
79
162
11.6
967
712
56
61.07
southwest
190.7
0
125.4
162.1
7.8
1090
804
100
40.57
southwest
540
0
0
173
0
1125
613
14
59.76
southwest
362.6
189
0
164.9
11.6
944.7
755.8
28
71.3
southwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
100
53.9
southwest
190
190
0
228
0
932
670
100
50.66
southwest
425
106.3
0
151.4
18.6
936
803.7
28
61.8
southwest
266
114
0
228
0
932
670
100
51.73
southwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
100
46.23
southwest
380
0
0
228
0
932
670
100
53.3
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
100
50.08
southwest
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
56
61.99
southwest
349
0
0
192
0
1056
809
90
40.66
southwest
237.5
237.5
0
228
0
932
594
100
38.41
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
100
52.04
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
100
47.74
southwest
290.4
0
96.2
168.1
9.4
961.2
865
100
48.97
southwest
323.7
282.8
0
183.8
10.3
942.7
659.9
56
80.2
southwest
213.5
0
174.2
154.6
11.7
1052.3
775.5
100
59.3
southwest
475
0
0
228
0
932
594
100
42.13
southwest
374
189.2
0
170.1
10.1
926.1
756.7
56
63.4
southwest
540
0
0
173
0
1125
613
28
67.31
southwest
375
93.8
0
126.6
23.4
852.1
992.6
28
56.7
southwest
198.6
132.4
0
192
0
978.4
825.5
100
41.72
southwest
359
19
141
154
10.9
942
801
56
66.78
southwest
500
0
0
140
4
966
853
28
67.57
southwest
362.6
189
0
164.9
11.6
944.7
755.8
56
77.3
southwest
349
0
0
192
0
1056
809
100
40.86
southwest
387
20
94
157
14.3
938
845
56
56.34
southwest
469
117.2
0
137.8
32.2
852.1
840.5
56
69.3
southwest
313.3
262.2
0
175.5
8.6
1046.9
611.8
91
66.6
southwest
375
93.8
0
126.6
23.4
852.1
992.6
56
60.2
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
56
72.99
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
100
66.42
southwest
374
189.2
0
170.1
10.1
926.1
756.7
91
64.9
southwest
388.6
97.1
0
157.9
12.1
852.1
925.7
91
57.6
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
100
66.95
southwest
389.9
189
0
145.9
22
944.7
755.8
56
79.4
southwest
425
106.3
0
151.4
18.6
936
803.7
91
66.7
southwest
540
0
0
173
0
1125
613
90
69.66
southwest
375
93.8
0
126.6
23.4
852.1
992.6
91
62.5
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
91
76.8
southwest
401.8
94.7
0
147.4
11.4
946.8
852.1
91
75.5
southwest
389.9
189
0
145.9
22
944.7
755.8
91
82.6
southwest
190
190
0
228
0
932
670
100
53.69
southwest
342
38
0
228
0
932
670
100
56.14
southwest
237.5
237.5
0
228
0
932
594
100
39
southwest
332.5
142.5
0
228
0
932
594
100
41.05
southwest
475
0
0
228
0
932
594
100
41.93
southwest
380
95
0
228
0
932
594
100
43.7
southwest
427.5
47.5
0
228
0
932
594
100
43.7
southwest
485
0
0
146
0
1120
800
28
71.99
southwest
236
0
0
193
0
968
885
100
25.08
southwest
307
0
0
193
0
968
812
100
36.15
southwest
339
0
0
197
0
968
781
100
38.89
southwest
540
0
0
173
0
1125
613
100
71.62
southwest
198.6
132.4
0
192
0
978.4
825.5
100
44.3
southwest
525
0
0
189
0
1125
613
100
67.11
southwest
349
0
0
192
0
1047
806
100
42.13
This is a sample of 1005 possible mixtures of concrete, and the strength of the mixture when tested after it was used in different regions.
The next worksheet will describe in detail each additive from concrete through air entrapment admixtures.
We recommend you make a back up copy of the original data before doing any analysis. Easiest way to do that, is to right click on the Worksheet name “Concrete Data”, choose Move or Copy, and click the checkbox labeled “Create a copy”.
About the Data
region
cement
slag
ash
water
superplastic
coarseagg
fineagg
air ent admix
strength
Concrete is a crucial material in civil engineering.
The concrete strength is a function of the ingredients. These ingredients include cement, blast furnace slag, fly ash, water, superplasticizer, coarse aggregate, and fine aggregate. All measurements are given in kilograms per cubic meter (kg / m3)
The most expensive ingredient in concrete is the cement, so minimizing concrete costs, means minimizing the amount of cement.
The use of slag in concrete has several benefits, including reduced energy, reduced greenhouse gas emissions, and reduced use of raw materials. It works synergistically with portland cement to increase strength, reduce permeability, improve resistance to chemical attack and inhibit rebar corrosion.
Ash use in concrete improves the workability of concrete, and the strength and durability of hardened concrete. Fly ash use is also cost effective. When fly ash is added to concrete, the amount of portland cement may be reduced. Fly ash when used appropriately can; reduce costs, cement contents and associated embodied CO2 emissions, placing less demand on the use of natural resources when used in concrete.
Superplasticizers are powerful water reducers that enable an increase in the ultimate stress of concrete by decreasing the w/c ratio, a decrease in the cement content while maintaining the same range of strength or workability, an increase in concrete compacity, and other effects.
Aggregate materials help to make concrete mixes more compact. They also decrease the consumption of cement and water. Aggregates make up 60-80% of the volume of concrete and 70-85% of the mass of concrete. Aggregate is also very important for strength, thermal and elastic properties of concrete, dimensional stability and volume stability. … Including aggregate in the mix can control the shrinkage level and prevent cracking.
Air entrapment admixtures are typically made of Natural wood resins, alkali salts, animal and vegetable fats and oils, althought there are many synthetic options as well. These entrain a large number of uniform, stable and closed tiny bubbles in the process of mixing concrete to reduce the segregation of concrete mixture, improve the workability, and also enhance anti-freeze ability and durability
Analysis1_DescriptiveStats
region
cement
slag
ash
water
superplastic
coarseagg
fineagg
air ent admix
strength
midwest
315
137
0
145
5.9
1130
745
28
81.75
midwest
362.6
189
0
164.9
11.6
944.7
755.8
91
79.3
midwest
522
0
0
146
0
896
896
28
74.99
midwest
424
22
132
168
8.9
822
750
56
74.36
midwest
475
118.8
0
181.1
8.9
852.1
781.5
91
74.19
midwest
439
177
0
186
11.1
884.9
707.9
91
73.3
midwest
439
177
0
186
11.1
884.9
707.9
56
71.7
midwest
475
118.8
0
181.1
8.9
852.1
781.5
28
68.3
cement
slag
ash
water
superplastic
coarseagg
fineagg
air_ent_admix
midwest
318.8
212.5
0
155.7
14.3
852.1
880.4
91
68.1
Mean
midwest
337.9
189
0
174.9
9.5
944.7
755.8
91
67.8
Std Dev
midwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
56
66.82
Skewness
midwest
424
22
132
178
8.5
822
750
56
65.7
Median
midwest
425
106.3
0
151.4
18.6
936
803.7
56
64.9
Min
midwest
425
106.3
0
153.5
16.5
852.1
887.1
56
64.3
Max
midwest
525
0
0
189
0
1125
613
100
61.92
CV
midwest
325.6
166.4
0
174
8.9
881.6
790
28
61.24
midwest
425
106.3
0
153.5
16.5
852.1
887.1
28
60.29
midwest
313.3
262.2
0
175.5
8.6
1046.9
611.8
28
59.8
midwest
356
119
0
160
9
1061
657
28
59
midwest
531.3
0
0
141.8
28.2
852.1
893.7
56
58.8
midwest
525
0
0
189
0
1125
613
90
58.78
midwest
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
100
56.63
midwest
331
170
0
195
8
811
802
28
56.61
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
91
56.5
midwest
525
0
0
189
0
1125
613
28
55.94
midwest
277.1
0
97.4
160.6
11.8
973.9
875.6
100
55.64
midwest
491
26
123
210
3.9
882
699
28
55.55
midwest
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
28
55.51
midwest
304
76
0
228
0
932
670
100
55.26
midwest
446
24
79
162
11.6
967
712
56
55.25
midwest
500
0
0
200
0
1125
613
100
55.16
midwest
446
24
79
162
10.3
967
712
56
54.77
midwest
305.3
203.5
0
203.5
0
965.4
631
90
54.6
midwest
304
76
0
228
0
932
670
100
54.38
midwest
285
190
0
163
7.6
1031
685
28
53.58
midwest
298
137
107
201
6
878
655
28
53.52
midwest
446
24
79
162
10.3
967
712
28
53.39
midwest
266
114
0
228
0
932
670
100
52.91
midwest
380
0
0
228
0
932
670
100
52.52
midwest
322.5
148.6
0
185.8
8.5
951
709.5
28
52.43
midwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
56
51.96
midwest
249.1
0
98.8
158.1
12.8
987.8
889
100
51.06
midwest
500
0
0
200
0
1125
613
100
51.04
midwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
56
50.77
midwest
192
288
0
192
0
929.8
716.1
90
50.73
midwest
288
192
0
192
0
932
717.8
90
50.53
midwest
342
38
0
228
0
932
670
90
50.46
midwest
387
20
94
157
14.3
938
845
28
50.24
midwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
100
49.97
midwest
200
200
0
190
0
1145
660
28
49.25
midwest
266
114
0
228
0
932
670
100
48.7
midwest
277.1
0
97.4
160.6
11.8
973.9
875.6
28
48.28
midwest
387
20
94
157
13.9
938
845
56
47.97
midwest
212
0
124.8
159
7.8
1085.4
799.5
100
47.82
midwest
236
157
0
192
0
972.6
749.1
90
47.78
midwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
28
47.4
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
7
47.1
midwest
266
114
0
228
0
932
670
90
47.03
midwest
190
190
0
228
0
932
670
100
46.93
midwest
425
106.3
0
151.4
18.6
936
803.7
7
46.8
midwest
387
20
94
157
11.6
938
845
28
46.68
midwest
387
20
94
157
13.9
938
845
28
46.68
midwest
289
133.7
0
194.9
5.5
924.1
760.1
28
46.25
midwest
314
145.3
113.2
178.9
8
869.1
690.2
28
46.23
midwest
181.4
0
167
169.6
7.6
1055.6
777.8
100
45.37
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
100
45.37
midwest
310
142.8
0
167.9
10
914.3
804
28
45.3
midwest
212
0
124.8
159
7.8
1085.4
799.5
56
45.08
midwest
213.5
0
174.2
159.2
11.7
1043.6
771.9
28
44.64
midwest
141.9
166.6
129.7
173.5
10.9
882.6
785.3
28
44.61
midwest
284
15
141
179
5.5
842
801
56
44.52
midwest
446
24
79
162
11.6
967
712
28
44.42
midwest
194.7
0
100.5
170.2
7.5
998
901.8
100
44.28
midwest
139.6
209.4
0
192
0
1047
806.9
100
44.21
midwest
355
19
97
145
13.1
967
871
28
44.03
midwest
480
0
0
192
0
936.2
712.2
28
43.94
midwest
305.3
203.5
0
203.5
0
965.4
631
28
43.38
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
100
42.92
midwest
231.8
0
121.6
174
6.7
1056.4
778.5
56
42.7
midwest
298
0
107
186
6
879
815
28
42.64
midwest
475
0
0
228
0
932
594
100
42.62
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
56
42.55
midwest
475
0
0
228
0
932
594
90
42.23
midwest
288
121
0
177
7
908
829
28
42.13
midwest
249.1
0
98.8
158.1
12.8
987.8
889
56
42.03
midwest
203.5
305.3
0
203.5
0
963.4
630
28
41.68
midwest
540
0
0
173
0
1125
613
3
41.64
midwest
265
111
86
195
6
833
790
28
41.54
midwest
516
0
0
162
8.3
801
802
28
41.37
midwest
531.3
0
0
141.8
28.2
852.1
893.7
3
41.3
midwest
331
0
0
192
0
978
825
100
41.24
midwest
380
95
0
228
0
932
594
100
41.15
midwest
222.4
0
96.7
189.3
4.5
967.1
870.3
100
40.71
midwest
326
0
138
199
11
801
792
28
40.68
midwest
389.9
189
0
145.9
22
944.7
755.8
3
40.6
midwest
380
95
0
228
0
932
594
90
40.56
midwest
295.7
0
95.6
171.5
8.9
955.1
859.2
28
39.94
midwest
393
0
0
192
0
940
758
28
39.58
midwest
266
112
87
178
10
910
745
28
39.42
midwest
160
128
122
182
6.4
824
879
28
39.4
midwest
450.1
50
0
200
3
1124.4
613.2
28
39.38
midwest
439
177
0
186
11.1
884.9
707.9
3
39.3
midwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
56
39.27
midwest
326.5
0
137.9
199
10.8
801.1
792.5
28
38.63
midwest
313.8
0
112.6
169.9
10.1
925.3
782.9
28
38.46
midwest
250
0
95.7
187.4
5.5
956.9
861.2
56
38.33
midwest
310
0
0
192
0
970
850
100
38.11
midwest
198.6
132.4
0
192
0
978.4
825.5
90
38.07
midwest
166
259.7
0
183.2
12.7
858.8
826.8
28
37.92
midwest
382
0
0
185
0
1047
739
28
37.42
midwest
156
243
0
180
11
1022
698
28
37.36
midwest
194.7
0
100.5
170.2
7.5
998
901.8
28
37.27
midwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
56
37.27
midwest
272.8
105.1
81.8
209.7
9
904
679.7
28
37.17
midwest
273
105
82
210
9
904
680
28
37.17
midwest
251.4
0
118.3
188.5
5.8
1028.4
757.7
56
36.97
midwest
250.2
166.8
0
203.5
0
977.6
694.1
28
36.96
midwest
165
0
143.6
163.8
0
1005.6
900.9
56
36.56
midwest
380
95
0
228
0
932
594
28
36.45
midwest
140
133
103
200
7
916
753
28
36.44
midwest
139.9
132.6
103.3
200.3
7.4
916
753.4
28
36.44
midwest
151.8
178.1
138.7
167.5
18.3
944
694.6
28
36.35
midwest
152
178
139
168
18
944
695
28
36.35
midwest
446
24
79
162
11.6
967
712
3
35.36
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
100
35.34
midwest
387
20
94
157
11.6
938
845
3
34.77
midwest
290.4
0
96.2
168.1
9.4
961.2
865
28
34.74
midwest
310
0
0
192
0
970
850
90
34.68
midwest
480
0
0
192
0
936.2
712.2
7
34.57
midwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
14
34.24
midwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
56
34.2
midwest
255.3
98.8
77
188.6
6.5
919
749.3
28
33.8
midwest
525
0
0
189
0
1125
613
3
33.8
midwest
277
0
0
191
0
968
856
100
33.7
midwest
157
236
0
192
0
935.4
781.2
28
33.66
midwest
491
26
123
210
3.9
882
699
7
33.49
midwest
304
140
0
214
6
895
722
28
33.42
midwest
252.1
97.1
75.6
193.8
8.3
835.5
821.4
28
33.4
midwest
425
106.3
0
153.5
16.5
852.1
887.1
3
33.4
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
14
33.36
midwest
132
207
161
179
5
867
736
28
33.3
midwest
237.5
237.5
0
228
0
932
594
90
33.12
midwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
14
33.01
midwest
236
157
0
192
0
972.6
749.1
28
32.88
midwest
380
95
0
228
0
932
594
7
32.82
midwest
145.9
230.5
0
202.5
3.4
827
871.8
28
32.72
midwest
272.6
0
89.6
198.7
10.6
931.3
762.2
28
32.25
midwest
273
0
90
199
11
931
762
28
32.24
midwest
173
116
0
192
0
946.8
856.8
90
32.1
midwest
424
22
132
178
8.5
882
750
3
32.01
midwest
339
0
0
185
0
1069
754
28
31.84
midwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
14
31.81
midwest
190.3
0
125.2
166.6
9.9
1079
798.9
56
31.72
midwest
331
0
0
192
0
978
825
28
31.45
midwest
385
0
0
186
0
966
763
28
31.35
midwest
182
45.2
122
170.2
8.2
1059.4
780.7
28
31.27
midwest
141.3
212
0
203.5
0
971.8
748.5
28
29.89
midwest
143.7
170.2
132.6
191.6
8.5
814.1
805.3
28
29.87
midwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
14
29.75
midwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
14
29.55
midwest
108.3
162.4
0
203.5
0
938.2
849
90
29.23
midwest
145
116
119
184
5.7
833
880
28
29.16
midwest
236.9
91.7
71.5
246.9
6
852.9
695.4
28
28.63
midwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
56
28.63
midwest
379.5
151.2
0
153.9
15.9
1134.3
605
3
28.6
midwest
323.7
282.8
0
183.8
10.3
942.7
659.9
3
28.3
midwest
388.6
97.1
0
157.9
12.1
852.1
925.7
3
28.1
midwest
254
0
0
198
0
968
863
100
27.63
midwest
307
0
0
193
0
968
812
28
27.53
midwest
164
163
128
197
8
961
641
28
27.23
midwest
254
0
0
198
0
968
863
90
26.94
midwest
300
0
0
184
0
1075
795
28
26.85
midwest
190.7
0
125.4
162.1
7.8
1090
804
28
26.4
midwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
14
26.31
midwest
305.3
203.5
0
203.5
0
965.4
631
7
25.89
midwest
220.8
147.2
0
185.7
0
1055
744.3
28
25.75
midwest
170.3
155.5
0
185.7
0
1026.6
724.3
28
25.73
midwest
153.1
145
113
178.5
8
1001.9
688.7
28
25.56
midwest
387
20
94
157
13.9
938
845
3
25.51
midwest
102
153
0
192
0
887
942
90
25.46
midwest
296
0
0
186
0
1090
769
28
25.18
midwest
359
19
141
154
10.9
942
801
3
25.12
midwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
14
24.99
midwest
250
0
95.7
187.4
5.5
956.9
861.2
14
24.92
midwest
250
0
95.7
191.8
5.3
948.9
857.2
14
24.66
midwest
149
153
194
192
8
935
623
28
24.58
midwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
14
24.43
midwest
154
174
185
228
7
845
612
28
24.34
midwest
194.7
0
100.5
170.2
7.5
998
901.8
14
24.28
midwest
284
15
141
179
5.5
842
801
7
24.13
midwest
183.9
122.6
0
203.5
0
959.2
800
28
24.05
midwest
382
0
0
185
0
1047
739
7
24
midwest
167
187
195
185
7
898
636
28
23.89
midwest
299.8
0
119.8
211.5
9.9
878.2
727.6
28
23.84
midwest
154.8
183.4
0
193.3
9.1
877.2
867.7
28
23.79
midwest
145.7
172.6
0
181.9
3.4
985.8
816.8
28
23.74
midwest
149
139
109
193
6
892
780
28
23.69
midwest
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
14
23.51
midwest
333
0
0
192
0
931.2
842.6
7
23.4
midwest
446
24
79
162
11.6
967
712
3
23.35
midwest
184
86
190
213
6
923
623
28
22.93
midwest
362.6
189
0
164.9
11.6
944.7
755.8
7
22.9
midwest
233.8
0
94.6
197.9
4.6
947
852.2
28
22.84
midwest
290.4
0
96.2
168.1
9.4
961.2
865
3
22.5
midwest
281
0
0
185
0
1104
774
28
22.44
midwest
236
0
0
194
0
968
885
90
21.95
midwest
255
0
0
192
0
889.8
945
90
21.86
midwest
181.4
0
167
169.6
7.6
1055.6
777.8
14
21.6
midwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
28
21.54
midwest
277
0
0
191
0
968
856
14
21.26
midwest
339.2
0
0
185.7
0
1069.2
754.3
7
21.18
midwest
251.8
0
99.9
146.1
12.4
1006
899.8
3
21.02
midwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
14
20.92
midwest
350
0
0
186
0
1050
770
7
20.28
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
14
20.08
midwest
252.5
0
0
185.7
0
1111.6
784.3
28
19.77
midwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
3
19.42
midwest
190.3
0
125.2
166.6
9.9
1079
798.9
14
19.42
midwest
152.7
144.7
0
178.1
8
999.7
822.2
28
19.01
midwest
153
145
0
178
8
1000
822
28
19.01
midwest
155
183
0
193
9
1047
697
28
18.28
midwest
135.7
203.5
0
185.7
0
1076.2
759.3
28
18.2
midwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
3
18
midwest
148.1
0
136.6
158.1
16.1
1001.8
830.1
28
17.96
midwest
148
0
137
158
16
1002
830
28
17.95
midwest
186.2
124.1
0
185.7
0
1083.4
764.3
28
17.6
midwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
3
17.57
midwest
325
0
0
184
0
1063
783
7
17.54
midwest
102
153
0
192
0
887
942
28
17.28
midwest
157
236
0
192
0
935.4
781.2
7
16.89
midwest
165
0
143.6
163.8
0
1005.6
900.9
14
16.88
midwest
349
0
0
192
0
1056
809
3
15.87
midwest
150.9
0
183.9
166.6
11.6
991.2
772.2
28
15.57
midwest
249.1
0
98.8
158.1
12.8
987.8
889
3
15.36
midwest
349
0
0
192
0
1047
806.9
3
15.05
midwest
349
0
0
192
0
1047
806
3
14.99
midwest
331
0
0
192
0
1025
821
3
14.31
midwest
275
0
0
183
0
1088
808
7
14.2
midwest
305.3
203.5
0
203.5
0
965.4
631
3
14.14
midwest
250
0
95.7
187.4
5.5
956.9
861.2
3
13.82
midwest
133
200
0
192
0
927.4
839.2
7
13.66
midwest
331
0
0
192
0
879
825
3
13.52
midwest
144.8
0
133.6
180.8
11.1
979.5
811.5
28
13.2
midwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
3
13.18
midwest
236
0
0
194
0
968
885
14
12.84
midwest
250
0
0
182
0
1100
820
7
12.73
midwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
3
12.45
midwest
181.9
272.8
0
185.7
0
1012.4
714.3
7
12.37
midwest
151.6
0
111.9
184.4
7.9
992
815.9
28
12.18
midwest
152
0
112
184
8
992
816
28
12.18
midwest
222.4
0
96.7
189.3
4.5
967.1
870.3
3
11.58
midwest
252
0
0
186
0
1111
784
7
11.47
midwest
200
133
0
192
0
965.4
806.2
3
11.41
midwest
170.3
155.5
0
185.7
0
1026.6
724.3
7
10.73
midwest
233.8
0
94.6
197.9
4.6
947
852.2
3
10.38
midwest
230
0
118.3
195.5
4.6
1029.4
758.6
3
10.03
midwest
155
0
143
193
9
877
868
28
9.74
midwest
250.2
166.8
0
203.5
0
977.6
694.1
3
9.73
midwest
157
236
0
192
0
935.4
781.2
3
9.69
midwest
158.8
238.2
0
185.7
0
1040.6
734.3
7
9.62
midwest
203.5
305.3
0
203.5
0
963.4
630
3
9.56
midwest
255
0
0
192
0
889.8
945
3
8.2
midwest
139.6
209.4
0
192
0
1047
806.9
3
8.06
midwest
200
0
0
180
0
1125
845
7
7.84
midwest
108.3
162.4
0
203.5
0
938.2
849
7
7.72
midwest
102
153
0
192
0
887
942
7
7.68
midwest
135.7
203.5
0
185.7
0
1076.2
759.3
7
7.51
midwest
166.8
250.2
0
203.5
0
975.6
692.6
3
6.9
midwest
212
141.3
0
203.5
0
973.4
750
3
6.81
midwest
108.3
162.4
0
203.5
0
938.2
849
3
2.33
northeast
540
0
0
162
2.5
1040
676
28
79.99
northeast
451
0
0
165
11.3
1030
745
28
78.8
northeast
275
180
120
162
10.4
830
765
28
76.24
northeast
540
0
0
173
0
1125
613
100
74.17
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
56
73.7
northeast
475
118.8
0
181.1
8.9
852.1
781.5
56
72.3
northeast
359
19
141
154
10.9
942
801
56
68.75
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
28
68.5
northeast
250
180
95
159
9.5
860
800
28
67.87
northeast
286.3
200.9
0
144.7
11.2
1004.6
803.7
28
67.7
northeast
469
117.2
0
137.8
32.2
852.1
840.5
28
66.9
northeast
439
177
0
186
11.1
884.9
707.9
28
66
northeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
56
64.9
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
100
63.53
northeast
359
19
141
154
10.9
942
801
28
62.94
northeast
540
0
0
162
2.5
1055
676
28
61.89
northeast
491
26
123
201
3.9
822
699
56
61.86
northeast
387
20
94
157
11.6
938
845
56
61.46
northeast
246.8
0
125.1
143.3
12
1086.8
800.9
56
60.32
northeast
337.9
189
0
174.9
9.5
944.7
755.8
56
59.89
northeast
491
26
123
210
3.9
882
699
56
59.59
northeast
359
19
141
154
10.9
942
801
28
59.49
northeast
531.3
0
0
141.8
28.2
852.1
893.7
91
59.2
northeast
389.9
189
0
145.9
22
944.7
755.8
7
59.09
northeast
475
0
0
162
9.5
1044
662
28
58.52
northeast
475
0
59
142
1.9
1098
641
28
57.23
northeast
321.3
164.2
0
190.5
4.6
870
774
28
57.22
northeast
297.2
0
117.5
174.8
9.5
1022.8
753.5
100
56.74
northeast
531.3
0
0
141.8
28.2
852.1
893.7
28
56.4
northeast
439
177
0
186
11.1
884.9
707.9
7
56.1
northeast
362.6
189
0
164.9
11.6
944.7
755.8
7
55.9
northeast
355
19
97
145
12.3
967
871
28
55.45
northeast
342
38
0
228
0
932
670
100
55.06
northeast
469
117.2
0
137.8
32.2
852.1
840.5
7
54.9
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
56
53.96
northeast
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
56
53.77
northeast
165
128.5
132.1
175.1
8.1
1005.8
746.6
56
53.72
northeast
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
100
53.66
northeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
100
52.96
northeast
380
0
0
228
0
932
670
90
52.91
northeast
279.8
128.9
100.4
172.4
9.5
825.1
804.9
28
52.83
northeast
405
0
0
175
0
1120
695
28
52.3
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
28
52.2
northeast
446
24
79
162
11.6
967
712
7
52.01
northeast
203.5
305.3
0
203.5
0
963.4
630
90
51.86
northeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
28
51.33
northeast
277.1
0
97.4
160.6
11.8
973.9
875.6
56
51.04
northeast
520
0
0
175
5.2
870
805
28
51.02
northeast
522
0
0
146
0
896
896
7
50.51
northeast
259.9
100.6
78.4
170.6
10.4
935.7
762.9
28
49.77
northeast
425
106.3
0
153.5
16.5
852.1
887.1
7
49.2
northeast
178
129.8
118.6
179.9
3.6
1007.3
746.8
56
48.59
northeast
250.2
166.8
0
203.5
0
977.6
694.1
90
47.71
northeast
500
0
0
200
0
1125
613
90
47.22
northeast
289
134
0
195
6
924
760
28
46.24
northeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
28
45.94
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
100
45.84
northeast
139.6
209.4
0
192
0
1047
806.9
100
44.7
northeast
238.1
0
94.1
186.7
7
949.9
847
100
44.3
northeast
251.8
0
99.9
146.1
12.4
1006
899.8
56
44.14
northeast
500
0
0
200
0
1125
613
28
44.09
northeast
400
0
0
187
0
1025
745
28
43.7
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
100
43.58
northeast
182
45.2
122
170.2
8.2
1059.4
780.7
56
43.5
northeast
194.7
0
100.5
170.2
7.5
998
901.8
56
43.39
northeast
157
236
0
192
0
935.4
781.2
90
43.38
northeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
7
42.8
northeast
252.3
0
98.8
146.3
14.2
987.8
889
14
42.29
northeast
288.4
121
0
177.4
7
907.9
829.5
28
42.14
northeast
264.5
111
86.5
195.5
5.9
832.6
790.4
28
41.54
northeast
401.8
94.7
0
147.4
11.4
946.8
852.1
3
41.1
northeast
349
0
0
192
0
1047
806
100
41.05
northeast
190.3
0
125.2
161.9
9.9
1088.1
802.6
100
40.39
northeast
213.8
98.1
24.5
181.7
6.7
1066
785.5
28
40.23
northeast
317.9
0
126.5
209.7
5.7
860.5
736.6
28
40.06
northeast
332.5
142.5
0
228
0
932
594
100
39.78
northeast
349
0
0
192
0
1047
806
90
39.49
northeast
160
250
0
168
12
1049
688
28
39.45
northeast
239.6
359.4
0
185.7
0
941.6
664.3
28
39.44
northeast
266.2
112.3
87.5
177.9
10.4
909.7
744.5
28
39.42
northeast
139.6
209.4
0
192
0
1047
806.9
90
39.36
northeast
192
288
0
192
0
929.8
716.1
28
39.32
northeast
475
0
0
228
0
932
594
28
39.29
northeast
168
42.1
163.8
121.8
5.7
1058.7
780.1
100
39.23
northeast
397
0
0
185
0
1040
734
28
39.09
northeast
331
0
0
192
0
978
825
100
39
northeast
359
19
141
154
10.9
942
801
7
38.61
northeast
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
14
38.6
northeast
314
0
113
170
10
925
783
28
38.46
northeast
446
24
79
162
11.6
967
712
7
38.02
northeast
331
0
0
192
0
1025
821
90
37.91
northeast
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
28
37.81
northeast
475
118.8
0
181.1
8.9
852.1
781.5
3
37.8
northeast
382
0
0
186
0
1047
739
28
37.42
northeast
310
0
0
192
0
970
850
100
37.33
northeast
321.4
0
127.9
182.5
11.5
870.1
779.7
28
37.27
northeast
387
20
94
157
14.3
938
845
7
36.84
northeast
425
106.3
0
151.4
18.6
936
803.7
3
36.3
northeast
237.5
237.5
0
228
0
932
594
100
36.25
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
14
35.96
northeast
310
0
0
192
0
1012
830
90
35.76
northeast
359
19
141
154
10.9
942
801
7
35.75
northeast
190.7
0
125.4
162.1
7.8
1090
804
56
35.34
northeast
160.2
188
146.4
203.2
11.3
828.7
709.7
28
35.31
northeast
139.7
163.9
127.7
236.7
5.8
868.6
655.6
28
35.23
northeast
427.5
47.5
0
228
0
932
594
7
35.08
northeast
290.4
0
96.2
168.1
9.4
961.2
865
14
34.67
northeast
307
0
0
193
0
968
812
100
34.49
northeast
374
189.2
0
170.1
10.1
926.1
756.7
3
34.4
northeast
350
0
0
186
0
1050
770
28
34.29
northeast
194.7
0
100.5
165.6
7.5
1006.4
905.9
56
33.96
northeast
162
190
148
179
19
838
741
28
33.76
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
28
33.73
northeast
261.9
110.5
86.1
195.4
5
895.2
732.6
28
33.72
northeast
190.3
0
125.2
166.6
9.9
1079
798.9
100
33.56
northeast
166.1
0
163.3
176.5
4.5
1058.6
780.1
100
33.54
northeast
290.2
193.5
0
185.7
0
998.2
704.3
28
33.04
northeast
149.5
236
0
175.8
12.6
846.8
892.7
28
32.96
northeast
307
0
0
193
0
968
812
90
32.92
northeast
167
75.4
167
164
7.9
1007.3
770.1
14
32.9
northeast
251.4
0
118.3
188.5
6.4
1028.4
757.7
28
32.66
northeast
277
0
0
191
0
968
856
100
32.33
northeast
289
0
0
192
0
913.2
895.3
90
32.07
northeast
376
0
0
214.6
0
1003.5
762.4
28
31.97
northeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
28
31.12
northeast
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
3
30.45
northeast
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
14
30.39
northeast
218.9
0
124.1
158.5
11.3
1078.7
794.9
28
30.22
northeast
304.8
0
99.6
196
9.8
959.4
705.2
28
30.12
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
14
29.93
northeast
144
170
133
192
8
814
805
28
29.87
northeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
14
29.59
northeast
491
26
123
201
3.9
822
699
3
29.55
northeast
155
184
143
194
9
880
699
28
28.99
northeast
198.6
132.4
0
192
0
978.4
825.5
28
28.02
northeast
310
0
0
192
0
1012
830
28
27.83
northeast
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
3
27.42
northeast
350
0
0
203
0
974
775
28
27.34
northeast
339
0
0
197
0
968
781
14
27.04
northeast
231.8
0
121.6
174
6.7
1056.4
778.5
14
26.77
northeast
302
0
0
203
0
974
817
100
26.74
northeast
194.7
0
100.5
165.6
7.5
1006.4
905.9
28
25.72
northeast
295
0
0
185
0
1069
769
28
25.18
northeast
446
24
79
162
11.6
967
712
3
25.02
northeast
222.4
0
96.7
189.3
4.5
967.1
870.3
28
24.89
northeast
480
0
0
192
0
936.2
712.2
3
24.4
northeast
480
0
0
192
0
936
721
3
24.39
northeast
236
0
0
193
0
968
885
100
24.1
northeast
155
183
0
193
9
877
868
28
23.79
northeast
146
173
0
182
3
986
817
28
23.74
northeast
202
11
141
206
1.7
942
801
56
23.25
northeast
387
20
94
157
14.3
938
845
3
22.75
northeast
381.4
0
0
185.7
0
1104.6
784.3
28
22.49
northeast
210.7
316.1
0
185.7
0
977
689.3
7
21.82
northeast
296
0
0
192
0
1085
765
28
21.65
northeast
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
3
21.29
northeast
339
0
0
197
0
968
781
7
20.97
northeast
252
0
0
185
0
1111
784
28
19.69
northeast
212
0
124.8
159
7.8
1085.4
799.5
3
19.52
northeast
153
102
0
192
0
888
943.1
28
17.96
northeast
238.1
0
0
185.7
0
1118.8
789.3
28
17.58
northeast
331
0
0
192
0
1025
821
7
17.44
northeast
225
0
0
181
0
1113
833
28
17.34
northeast
251.4
0
118.3
188.5
5.8
1028.4
757.7
3
17.22
northeast
193.5
290.2
0
185.7
0
998.2
704.3
7
17.2
northeast
154
144
112
220
10
923
658
28
16.5
northeast
331
0
0
192
0
978
825
7
16.26
northeast
139.6
209.4
0
192
0
1047
806.9
7
14.59
northeast
381.4
0
0
185.7
0
1104.6
784.3
7
14.54
northeast
296
0
0
192
0
1085
765
7
14.2
northeast
289
0
0
192
0
913.2
895.3
3
11.65
northeast
382
0
0
186
0
1111
784
7
11.47
northeast
277
0
0
191
0
968
856
3
11.36
northeast
183.9
122.6
0
203.5
0
959.2
800
7
10.79
northeast
166.1
0
163.3
176.5
4.5
1058.6
780.1
3
10.76
northeast
198.6
132.4
0
192
0
978.4
825.5
3
9.13
northeast
349
0
0
192
0
1056
809
7
9.01
northeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
3
7.4
northeast
173
116
0
192
0
946.8
856.8
3
6.94
northeast
102
153
0
192
0
887
942
3
4.57
northeast
122.6
183.9
0
203.5
0
958.2
800.1
3
3.32
northwest
323.7
282.8
0
183.8
10.3
942.7
659.9
28
74.7
northwest
252.3
0
98.8
146.3
14.2
987.8
889
100
60.95
northwest
388.6
97.1
0
157.9
12.1
852.1
925.7
56
55.2
northwest
167
75.4
167
164
7.9
1007.3
770.1
56
53.46
northwest
313
161
0
178
10
917
759
28
52.44
northwest
379.5
151.2
0
153.9
15.9
1134.3
605
28
52.2
northwest
342
38
0
228
0
932
670
100
52.12
northwest
388.6
97.1
0
157.9
12.1
852.1
925.7
28
50.7
northwest
310
143
0
168
10
914
804
28
45.3
northwest
376
0
0
214.6
0
1003.5
762.4
100
43.06
northwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
28
39.16
northwest
374.3
0
0
190.2
6.7
1013.2
730.4
28
39.06
northwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
100
37.68
northwest
500
0
0
200
0
1125
613
14
36.94
northwest
122.6
183.9
0
203.5
0
958.2
800.1
90
33.19
northwest
162
214
164
202
10
820
680
28
30.65
northwest
139.6
209.4
0
192
0
1047
806.9
28
28.24
northwest
158.6
148.9
116
175.1
15
953.3
719.7
28
27.68
northwest
166.1
0
163.3
176.5
4.5
1058.6
780.1
14
25.48
northwest
316.1
210.7
0
185.7
0
977
689.3
7
24.44
northwest
382
0
0
186
0
1047
739
7
24
northwest
300
0
120
212
10
878
728
28
23.84
northwest
385
0
0
186
0
966
763
7
23.22
northwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
3
23.08
northwest
182
45.2
122
170.2
8.2
1059.4
780.7
14
21.5
northwest
250
0
0
182
0
1100
820
28
20.87
northwest
322
0
0
203
0
974
800
14
20.77
northwest
350
0
0
203
0
974
775
7
18.13
northwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
3
15.34
northwest
145
0
134
181
11
979
812
28
13.2
northwest
116
173
0
192
0
909.8
891.9
3
6.28
southeast
389.9
189
0
145.9
22
944.7
755.8
28
74.5
southeast
424
22
132
168
8.9
822
750
28
72.1
southeast
469
117.2
0
137.8
32.2
852.1
840.5
91
70.7
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
56
66.1
southeast
366
187
0
191.3
6.6
824.3
756.9
28
65.91
southeast
425
106.3
0
153.5
16.5
852.1
887.1
91
65.2
southeast
505
0
60
195
0
1030
630
28
64.02
southeast
520
0
0
170
5.2
855
855
28
60.28
southeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
100
58.61
southeast
275.1
0
121.4
159.5
9.9
1053.6
777.5
56
56.85
southeast
528
0
0
185
6.9
920
720
28
56.83
southeast
446
24
79
162
11.6
967
712
56
56.14
southeast
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
100
56.06
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
28
55.5
southeast
379.5
151.2
0
153.9
15.9
1134.3
605
56
54.9
southeast
380
0
0
228
0
932
670
100
53.1
southeast
312.9
160.5
0
177.6
9.6
916.6
759.5
28
52.45
southeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
56
51.43
southeast
213.5
0
174.2
159.2
11.7
1043.6
771.9
56
51.26
southeast
182
45.2
122
170.2
8.2
1059.4
780.7
100
48.67
southeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
100
48.15
southeast
213.8
98.1
24.5
181.7
6.7
1066
785.5
56
47.13
southeast
531.3
0
0
141.8
28.2
852.1
893.7
7
46.9
southeast
142
167
130
174
11
883
785
28
44.61
southeast
334
17.6
158
189
15.3
967
633
28
44.33
southeast
276
116
90
180
9
870
768
28
44.28
southeast
480
0
0
192
0
936
721
28
43.89
southeast
287.3
120.5
93.9
187.6
9.2
904.4
695.9
28
43.8
southeast
277
116.8
91
190.6
7
946.5
665.6
28
43.58
southeast
200
133
0
192
0
965.4
806.2
90
43.25
southeast
427.5
47.5
0
228
0
932
594
100
43.01
southeast
277.1
0
97.4
160.6
11.8
973.9
875.6
14
41.89
southeast
333
0
0
192
0
931.2
842.6
90
41.68
southeast
250
0
95.7
191.8
5.3
948.9
857.2
100
41.16
southeast
229.7
0
118.2
195.2
6.1
1028.1
757.6
100
40.86
southeast
332.5
142.5
0
228
0
932
594
100
40.27
southeast
162
207
172
216
10
822
638
28
39.84
southeast
331
0
0
192
0
1025
821
100
39.38
southeast
168.9
42.2
124.3
158.3
10.8
1080.8
796.2
56
39.15
southeast
316.1
210.7
0
185.7
0
977
689.3
28
38.7
southeast
212
0
124.8
159
7.8
1085.4
799.5
28
38.5
southeast
309.9
142.8
111.2
167.8
22.1
913.9
651.2
28
38.22
southeast
165
0
143.6
163.8
0
1005.6
900.9
100
37.96
southeast
166
260
0
183
13
859
827
28
37.91
southeast
382.5
0
0
185.7
0
1047.8
739.3
28
37.44
southeast
397
0
0
186
0
1040
734
28
36.94
southeast
251.4
0
118.3
188.5
6.4
1028.4
757.7
56
36.64
southeast
339
0
0
197
0
968
781
100
36.45
southeast
298
0
107
164
13
953
784
28
35.86
southeast
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
56
35.85
southeast
181.4
0
167
169.6
7.6
1055.6
777.8
56
35.57
southeast
162
190.1
148.1
178.8
18.8
838.1
741.4
28
33.76
southeast
213.5
0
174.2
154.6
11.7
1052.3
775.5
14
33.7
southeast
303.6
139.9
0
213.5
6.2
895.5
722.5
28
33.42
southeast
332.5
142.5
0
228
0
932
594
28
33.02
southeast
168
42.1
163.8
121.8
5.7
1058.7
780.1
56
32.85
southeast
159
187
0
176
11
990
789
28
32.76
southeast
350
0
0
203
0
974
775
100
32.72
southeast
193.5
290.2
0
185.7
0
998.2
704.3
28
32.63
southeast
339
0
0
185
0
1060
754
28
31.65
southeast
159
209
161
201
7
848
669
28
30.88
southeast
254
0
0
198
0
968
863
100
29.79
southeast
155.2
183.9
143.2
193.8
9.2
879.6
698.5
28
28.99
southeast
313.3
262.2
0
175.5
8.6
1046.9
611.8
3
28.8
southeast
133
200
0
192
0
927.4
839.2
28
27.87
southeast
152.6
238.7
0
200
6.3
1001.8
683.9
28
26.86
southeast
153
102
0
192
0
888
943.1
90
26.32
southeast
144
136
106
178
7
941
774
28
26.14
southeast
376
0
0
214.6
0
1003.5
762.4
14
25.62
southeast
212.6
0
100.4
159.4
10.4
1003.8
903.8
14
25.37
southeast
318.8
212.5
0
155.7
14.3
852.1
880.4
3
25.2
southeast
190.3
0
125.2
166.6
9.9
1079
798.9
28
24.85
southeast
382.5
0
0
185.7
0
1047.8
739.3
7
24.07
southeast
288
192
0
192
0
932
717.8
7
23.52
southeast
297.2
0
117.5
174.8
9.5
1022.8
753.5
3
21.91
southeast
190.7
0
125.4
162.1
7.8
1090
804
14
21.06
southeast
251.4
0
118.3
192.9
5.8
1043.6
754.3
14
20.73
southeast
272.8
181.9
0
185.7
0
1012.4
714.3
7
19.77
southeast
236
0
0
194
0
968
885
28
18.42
southeast
302
0
0
203
0
974
817
14
18.13
southeast
165
0
150
182
12
1023
729
28
18.03
southeast
238
0
0
186
0
1119
789
28
17.54
southeast
310
0
0
192
0
1012
830
7
17.24
southeast
153.6
144.2
112.3
220.1
10.1
923.2
657.9
28
16.5
southeast
166.8
250.2
0
203.5
0
975.6
692.6
7
15.75
southeast
333
0
0
192
0
931.2
842.6
3
15.62
southeast
167
75.4
167
164
7.9
1007.3
770.1
3
15.52
southeast
143.6
0
174.9
158.4
17.9
942.7
844.5
28
15.42
southeast
289
0
0
192
0
913.2
895.3
7
14.6
southeast
236
157
0
192
0
972.6
749.1
3
13.57
southeast
150.7
0
185.3
166.7
15.6
1074.5
678
28
13.46
southeast
284
15
141
179
5.5
842
801
3
13.4
southeast
229.7
0
118.2
195.2
6.1
1028.1
757.6
3
13.36
southeast
212.6
0
100.4
159.4
10.4
1003.8
903.8
3
13.33
southeast
154.8
0
142.8
193.3
9.1
1047.4
696.7
28
12.46
southeast
116
173
0
192
0
909.8
891.9
7
10.09
southeast
153
102
0
192
0
888
943.1
3
4.78
southwest
389.9
189
0
145.9
22
944.7
755.8
91
82.6
southwest
323.7
282.8
0
183.8
10.3
942.7
659.9
56
80.2
southwest
389.9
189
0
145.9
22
944.7
755.8
56
79.4
southwest
362.6
189
0
164.9
11.6
944.7
755.8
56
77.3
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
91
76.8
southwest
401.8
94.7
0
147.4
11.4
946.8
852.1
91
75.5
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
56
72.99
southwest
485
0
0
146
0
1120
800
28
71.99
southwest
540
0
0
173
0
1125
613
100
71.62
southwest
362.6
189
0
164.9
11.6
944.7
755.8
28
71.3
southwest
500
0
0
151
9
1033
655
28
69.84
southwest
540
0
0
173
0
1125
613
90
69.66
southwest
469
117.2
0
137.8
32.2
852.1
840.5
56
69.3
southwest
500
0
0
140
4
966
853
28
67.57
southwest
540
0
0
173
0
1125
613
28
67.31
southwest
525
0
0
189
0
1125
613
100
67.11
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
100
66.95
southwest
359
19
141
154
10.9
942
801
56
66.78
southwest
425
106.3
0
151.4
18.6
936
803.7
91
66.7
southwest
313.3
262.2
0
175.5
8.6
1046.9
611.8
91
66.6
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
100
66.42
southwest
366
187
0
191
7
824
757
28
65.91
southwest
374
189.2
0
170.1
10.1
926.1
756.7
91
64.9
southwest
374
189.2
0
170.1
10.1
926.1
756.7
56
63.4
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
28
63.14
southwest
375
93.8
0
126.6
23.4
852.1
992.6
91
62.5
southwest
424
22
132
178
8.5
822
750
28
62.05
southwest
218.2
54.6
123.8
140.8
11.9
1075.7
792.7
56
61.99
southwest
425
106.3
0
151.4
18.6
936
803.7
28
61.8
southwest
326
166
0
174
9
882
790
28
61.23
southwest
374
189.2
0
170.1
10.1
926.1
756.7
28
61.09
southwest
446
24
79
162
11.6
967
712
56
61.07
southwest
375
93.8
0
126.6
23.4
852.1
992.6
56
60.2
southwest
540
0
0
173
0
1125
613
14
59.76
southwest
213.5
0
174.2
154.6
11.7
1052.3
775.5
100
59.3
southwest
491
26
123
201
3.9
822
699
28
57.92
southwest
388.6
97.1
0
157.9
12.1
852.1
925.7
91
57.6
southwest
321
164
0
190
5
870
774
28
57.21
southwest
446
24
79
162
11.6
967
712
28
57.03
southwest
167
75.4
167
164
7.9
1007.3
770.1
100
56.81
southwest
375
93.8
0
126.6
23.4
852.1
992.6
28
56.7
southwest
330.5
169.6
0
194.9
8.1
811
802.3
28
56.62
southwest
387
20
94
157
14.3
938
845
56
56.34
southwest
342
38
0
228
0
932
670
100
56.14
southwest
252.3
0
98.8
146.3
14.2
987.8
889
56
55.83
southwest
397
17.2
158
167
20.8
967
633
28
55.65
southwest
475
118.8
0
181.1
8.9
852.1
781.5
7
55.6
southwest
385
0
136
158
20
903
768
28
55.55
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
100
55.02
southwest
480
0
0
192
0
936.2
712.2
90
54.32
southwest
480
0
0
192
0
936
721
90
54.28
southwest
401.8
94.7
0
147.4
11.4
946.8
852.1
7
54.1
southwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
100
53.9
southwest
190
190
0
228
0
932
670
100
53.69
southwest
297.8
137.2
106.9
201.3
6
878.4
655.3
28
53.52
southwest
380
0
0
228
0
932
670
100
53.3
southwest
280
129
100
172
9
825
805
28
52.82
southwest
540
0
0
173
0
1125
613
7
52.61
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
28
52.5
southwest
322
149
0
186
8
951
709
28
52.42
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
100
52.04
southwest
266
114
0
228
0
932
670
100
51.73
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
56
51.72
southwest
446
24
79
162
11.6
967
712
28
51.02
southwest
304
76
0
228
0
932
670
100
50.95
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
100
50.94
southwest
190
190
0
228
0
932
670
100
50.66
southwest
252.3
0
98.8
146.3
14.2
987.8
889
28
50.6
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
100
50.08
southwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
100
49.99
southwest
337.9
189
0
174.9
9.5
944.7
755.8
28
49.9
southwest
323.7
282.8
0
183.8
10.3
942.7
659.9
7
49.8
southwest
260
101
78
171
10
936
763
28
49.77
southwest
304
76
0
228
0
932
670
90
49.19
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
56
48.99
southwest
290.4
0
96.2
168.1
9.4
961.2
865
100
48.97
southwest
393
0
0
192
0
940.6
785.6
90
48.85
southwest
393
0
0
192
0
940
758
90
48.79
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
56
48.72
southwest
525
0
0
189
0
1125
613
14
48.4
southwest
304
76
0
228
0
932
670
28
47.81
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
100
47.74
southwest
277.2
97.8
24.5
160.7
11.2
1061.7
782.5
14
47.71
southwest
333
17.5
163
167
17.9
996
652
28
47.28
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
56
46.64
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
28
46.39
southwest
314
145
113
179
8
869
690
28
46.23
southwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
100
46.23
southwest
374
189.2
0
170.1
10.1
926.1
756.7
7
46.2
southwest
387
20
94
157
13.9
938
845
7
45.9
southwest
266
114
0
228
0
932
670
28
45.85
southwest
213.7
98.1
24.5
181.7
6.9
1065.8
785.4
28
45.71
southwest
375
93.8
0
126.6
23.4
852.1
992.6
7
45.7
southwest
290.4
0
96.2
168.1
9.4
961.2
865
56
45.08
southwest
336.5
0
0
181.9
3.4
985.8
816.8
28
44.87
southwest
336
0
0
182
3
986
817
28
44.86
southwest
312.7
144.7
0
127.3
8
999.7
822.2
28
44.52
southwest
313
145
0
127
8
1000
822
28
44.52
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
56
44.4
southwest
313
145
0
178
8
867
824
28
44.39
southwest
198.6
132.4
0
192
0
978.4
825.5
100
44.3
southwest
276.4
116
90.3
179.6
8.9
870.1
768.3
28
44.28
southwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
100
44.21
southwest
500.1
0
0
200
3
1124.4
613.2
28
44.13
southwest
284
15
141
179
5.5
842
801
28
43.73
southwest
380
95
0
228
0
932
594
100
43.7
southwest
427.5
47.5
0
228
0
932
594
100
43.7
southwest
277
117
91
191
7
946
666
28
43.57
southwest
166.8
250.2
0
203.5
0
975.6
692.6
90
43.57
southwest
298.1
0
107
186.4
6.1
879
815.2
28
42.64
southwest
525
0
0
189
0
1125
613
7
42.42
southwest
250
0
95.7
187.4
5.5
956.9
861.2
100
42.35
southwest
190
190
0
228
0
932
670
90
42.33
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
14
42.22
southwest
475
0
0
228
0
932
594
100
42.13
southwest
349
0
0
192
0
1047
806
100
42.13
southwest
287
121
94
188
9
904
696
28
41.94
southwest
475
0
0
228
0
932
594
100
41.93
southwest
427.5
47.5
0
228
0
932
594
100
41.84
southwest
198.6
132.4
0
192
0
978.4
825.5
100
41.72
southwest
387
20
94
157
11.6
938
845
7
41.67
southwest
427.5
47.5
0
228
0
932
594
90
41.54
southwest
167
75.4
167
164
7.9
1007.3
770.1
28
41.41
southwest
516
0
0
162
8.2
801
802
28
41.37
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
28
41.2
southwest
313
145
0
178
8
1002
689
28
41.05
southwest
313.3
145
0
178.5
8
1001.9
688.7
28
41.05
southwest
332.5
142.5
0
228
0
932
594
100
41.05
southwest
313.3
145
0
178.5
8
867.2
824
28
40.93
southwest
284
120
0
168
7
970
794
28
40.93
southwest
284
119.7
0
168.3
7.2
970.4
794.2
28
40.93
southwest
356
0
142
193
11
801
778
28
40.87
southwest
355.9
0
141.6
193.3
11
801.4
778.4
28
40.87
southwest
190
190
0
228
0
932
670
28
40.86
southwest
349
0
0
192
0
1056
809
100
40.86
southwest
380
95
0
228
0
932
594
100
40.76
southwest
349
0
0
192
0
1056
809
90
40.66
southwest
190.7
0
125.4
162.1
7.8
1090
804
100
40.57
southwest
424
22
132
168
8.9
822
750
7
40.29
southwest
469
117.2
0
137.8
32.2
852.1
840.5
3
40.2
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
28
40.15
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
100
40.15
southwest
318
0
126
210
6
861
737
28
40.06
southwest
212
141.3
0
203.5
0
973.4
750
90
39.7
southwest
228
342.1
0
185.7
0
955.8
674.3
28
39.7
southwest
141.3
212
0
203.5
0
971.8
748.5
90
39.66
southwest
250
0
95.7
191.8
5.3
948.9
857.2
56
39.64
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
100
39.61
southwest
393
0
0
192
0
940.6
785.6
28
39.6
southwest
238.1
0
94.1
186.7
7
949.9
847
56
39.59
southwest
159.8
250
0
168.4
12.2
1049.3
688.2
28
39.46
southwest
234
156
0
189
5.9
981
760
28
39.3
southwest
446
24
79
162
11.6
967
712
7
39.3
southwest
374
0
0
190
7
1013
730
28
39.05
southwest
424
22
132
178
8.5
822
750
7
39
southwest
237.5
237.5
0
228
0
932
594
100
39
southwest
339
0
0
197
0
968
781
100
38.89
southwest
288
192
0
192
0
932
717.8
28
38.8
southwest
275.1
0
121.4
159.5
9.9
1053.6
777.5
14
38.77
southwest
310
0
0
192
0
1012
830
100
38.7
southwest
475
0
0
228
0
932
594
7
38.6
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
56
38.56
southwest
237.5
237.5
0
228
0
932
594
100
38.41
southwest
375
0
0
186
0
1038
758
28
38.21
southwest
173.5
50.1
173.5
164.8
6.5
1006.2
793.5
28
38.2
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
7
38
southwest
491
26
123
201
3.9
822
699
7
37.92
southwest
210.7
316.1
0
185.7
0
977
689.3
28
37.81
southwest
332.5
142.5
0
228
0
932
594
90
37.72
southwest
427.5
47.5
0
228
0
932
594
28
37.43
southwest
150
236.8
0
173.8
11.9
1069.3
674.8
28
37.43
southwest
150
237
0
174
12
1069
675
28
37.43
southwest
212.6
0
100.4
159.4
10.4
1003.8
903.8
28
37.4
southwest
155.6
243.5
0
180.3
10.7
1022
697.7
28
37.36
southwest
194.7
0
100.5
165.6
7.5
1006.4
905.9
100
37.34
southwest
321
0
128
182
11
870
780
28
37.26
southwest
331
0
0
192
0
978
825
90
37.23
southwest
297.2
0
117.5
174.8
9.5
1022.8
753.5
14
36.99
southwest
313
0
113
178
8
1002
689
28
36.8
southwest
313.3
0
113
178.5
8
1001.9
688.7
28
36.8
southwest
133
200
0
192
0
927.4
839.2
90
36.59
southwest
376
0
0
214.6
0
1003.5
762.4
56
36.3
southwest
307
0
0
193
0
968
812
100
36.15
southwest
298.1
0
107.5
163.6
12.8
953.2
784
28
35.87
southwest
362.6
189
0
164.9
11.6
944.7
755.8
3
35.3
southwest
140
164
128
237
6
869
656
28
35.23
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
14
35.23
southwest
339
0
0
197
0
968
781
90
35.17
southwest
337.9
189
0
174.9
9.5
944.7
755.8
7
35.1
southwest
388.6
97.1
0
157.9
12.1
852.1
925.7
7
34.9
southwest
233.8
0
94.6
197.9
4.6
947
852.2
100
34.56
southwest
166.8
250.2
0
203.5
0
975.6
692.6
28
33.95
southwest
251.8
0
99.9
146.1
12.4
1006
899.8
28
33.94
southwest
255
99
77
189
6
919
749
28
33.8
southwest
213.7
0
174.7
154.8
10.2
1053.5
776.4
14
33.73
southwest
262
111
86
195
5
895
733
28
33.72
southwest
310
143
111
168
22
914
651
28
33.69
southwest
172.4
13.6
172.4
156.8
4.1
1006.3
856.4
28
33.69
southwest
349
0
0
192
0
1056
809
28
33.61
southwest
252
97
76
194
8
835
821
28
33.4
southwest
318.8
212.5
0
155.7
14.3
852.1
880.4
7
33.4
southwest
132
206.5
160.9
178.9
5.5
866.9
735.6
28
33.31
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
28
33.27
southwest
500
0
0
200
0
1125
613
7
33.21
southwest
165
128.5
132.1
175.1
8.1
1005.8
746.6
14
33.09
southwest
397
0
0
185.7
0
1040.6
734.3
28
33.08
southwest
146
230
0
202
3
827
872
28
33.06
southwest
157
214
152
200
9
819
704
28
33.05
southwest
212
141.3
0
203.5
0
973.4
750
28
33
southwest
149
236
0
176
13
847
893
28
32.96
southwest
160
188
146
203
11
829
710
28
32.84
southwest
159.1
186.7
0
175.6
11.3
989.6
788.9
28
32.77
southwest
349
0
0
192
0
1047
806
28
32.72
southwest
183.9
122.6
0
203.5
0
959.2
800
90
32.53
southwest
261
100
78
201
9
864
761
28
32.4
southwest
260.9
100.5
78.3
200.6
8.6
864.5
761.5
28
32.4
southwest
424
22
132
168
8.9
822
750
3
32.11
southwest
255.5
170.3
0
185.7
0
1026.6
724.3
28
32.05
southwest
339
0
0
197
0
968
781
28
32.04
southwest
333
0
0
192
0
931.2
842.6
28
31.97
southwest
339.2
0
0
185.7
0
1069.2
754.3
28
31.9
southwest
298.2
0
107
209.7
11.1
879.6
744.2
28
31.88
southwest
298
0
107
210
11
880
744
28
31.87
southwest
331
0
0
192
0
1025
821
28
31.74
southwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
28
31.64
southwest
230
0
118.3
195.5
4.6
1029.4
758.6
56
31.54
southwest
296
0
107
221
11
819
778
28
31.42
southwest
296
0
106.7
221.4
10.5
819.2
778.4
28
31.42
southwest
272.8
181.9
0
185.7
0
1012.4
714.3
28
31.38
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
56
31.35
southwest
350
0
0
203
0
974
775
90
31.35
southwest
212
0
124.8
159
7.8
1085.4
799.5
14
31.35
southwest
277
0
0
191
0
968
856
90
31.25
southwest
322
0
116
196
10
818
813
28
31.18
southwest
322.2
0
115.6
196
10.4
817.9
813.4
28
31.18
southwest
133
210
0
196
3
949
795
28
31.03
southwest
116
173
0
192
0
909.8
891.9
90
31.02
southwest
297
0
0
186
0
1040
734
7
30.96
southwest
249.1
0
98.8
158.1
12.8
987.8
889
28
30.85
southwest
325
0
0
184
0
1063
783
28
30.57
southwest
200
133
0
192
0
965.4
806.2
28
30.44
southwest
332.5
142.5
0
228
0
932
594
7
30.28
southwest
238.1
0
94.1
186.7
7
949.9
847
28
30.23
southwest
400
0
0
187
0
1025
745
7
30.14
southwest
305
0
100
196
10
959
705
28
30.12
southwest
237.5
237.5
0
228
0
932
594
28
30.08
southwest
350
0
0
203
0
974
775
56
29.98
southwest
143
169.4
142.7
190.7
8.4
967.4
643.5
28
29.73
southwest
143
169
143
191
8
967
643
28
29.72
southwest
251.4
0
118.3
188.5
5.8
1028.4
757.7
28
29.65
southwest
322
0
0
203
0
974
800
100
29.59
southwest
222.4
0
96.7
189.3
4.5
967.1
870.3
56
29.45
southwest
156
178
187
221
7
854
614
28
29.41
southwest
296
0
0
192
0
1085
765
90
29.39
southwest
250
0
95.7
187.4
5.5
956.9
861.2
28
29.22
southwest
136.4
161.6
125.8
171.6
10.4
922.6
764.4
28
29.07
southwest
136
162
126
172
10
923
764
28
29.07
southwest
375
93.8
0
126.6
23.4
852.1
992.6
3
29
southwest
133.1
210.2
0
195.7
3.1
949.4
795.3
28
28.94
southwest
249.1
0
98.8
158.1
12.8
987.8
889
14
28.68
southwest
237
92
71
247
6
853
695
28
28.63
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
28
28.47
southwest
181.9
272.8
0
185.7
0
1012.4
714.3
28
27.94
southwest
385
0
0
186
0
966
763
14
27.92
southwest
310
0
0
192
0
970
850
28
27.92
southwest
181.4
0
167
169.6
7.6
1055.6
777.8
28
27.77
southwest
393
0
0
192
0
940.6
785.6
7
27.74
southwest
159
149
116
175
15
953
720
28
27.68
southwest
233.8
0
94.6
197.9
4.6
947
852.2
56
27.66
southwest
250
0
95.7
191.8
5.3
948.9
857.2
28
27.22
southwest
136
196
98
199
6
847
783
28
26.97
southwest
148
175
0
171
2
1000
828
28
26.92
southwest
147.8
175.1
0
171.2
2.2
1000
828.5
28
26.92
southwest
238.2
158.8
0
185.7
0
1040.6
734.3
28
26.91
southwest
153
239
0
200
6
1002
684
28
26.86
southwest
237.5
237.5
0
228
0
932
594
7
26.26
southwest
153
145
113
178
8
867
824
28
26.23
southwest
153.1
145
113
178.5
8
867.2
824
28
26.23
southwest
165
0
143.6
163.8
0
1005.6
900.9
28
26.2
southwest
143.8
136.3
106.2
178.1
7.5
941.5
774.3
28
26.15
southwest
375
0
0
186
0
1038
758
7
26.06
southwest
500
0
0
200
0
1125
613
3
26.06
southwest
218.9
0
124.1
158.5
11.3
1078.7
794.9
14
26.05
southwest
277
0
0
191
0
968
856
28
25.97
southwest
238.1
0
94.1
186.7
7
949.9
847
14
25.69
southwest
491
26
123
210
3.9
882
699
3
25.61
southwest
289
0
0
192
0
913.2
895.3
28
25.57
southwest
153
145
113
178
8
1002
689
28
25.56
southwest
397
0
0
185.7
0
1040.6
734.3
7
25.45
southwest
239.6
359.4
0
185.7
0
941.6
664.3
7
25.42
southwest
295.8
0
0
185.7
0
1091.4
769.3
28
25.22
southwest
322
0
0
203
0
974
800
28
25.18
southwest
312.7
0
0
178.1
8
999.7
822.2
28
25.1
southwest
313
0
0
178
8
1000
822
28
25.1
southwest
236
0
0
193
0
968
885
100
25.08
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
28
24.9
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
28
24.54
southwest
275
0
0
183
0
1088
808
28
24.5
southwest
230
0
118.3
195.5
4.6
1029.4
758.6
28
24.48
southwest
222.4
0
96.7
189.3
4.5
967.1
870.3
14
24.45
southwest
286.3
200.9
0
144.7
11.2
1004.6
803.7
3
24.4
southwest
122.6
183.9
0
203.5
0
958.2
800.1
28
24.29
southwest
173
116
0
192
0
946.8
856.8
28
24.28
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
28
24.24
southwest
337.9
189
0
174.9
9.5
944.7
755.8
3
24.1
southwest
436
0
0
218
0
838.4
719.7
28
23.85
southwest
275.1
0
121.4
159.5
9.9
1053.6
777.5
3
23.8
southwest
148.5
139.4
108.6
192.7
6.1
892.4
780
28
23.7
southwest
359
19
141
154
10.9
942
801
3
23.64
southwest
149
118
92
183
7
953
780
28
23.52
southwest
149
117.6
91.7
182.9
7.1
953.4
780.3
28
23.52
southwest
246.8
0
125.1
143.3
12
1086.8
800.9
3
23.52
southwest
277.1
0
97.4
160.6
11.8
973.9
875.6
3
23.14
southwest
295.7
0
95.6
171.5
8.9
955.1
859.2
3
22.95
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
14
22.72
southwest
203.5
135.7
0
185.7
0
1076.2
759.3
28
22.63
southwest
350
0
0
203
0
974
775
14
22.53
southwest
281
0
0
186
0
1104
774
28
22.44
southwest
116
173
0
192
0
909.8
891.9
28
22.35
southwest
229.7
0
118.2
195.2
6.1
1028.1
757.6
14
22.32
southwest
233.8
0
94.6
197.9
4.6
947
852.2
14
22.14
southwest
202
11
141
206
1.7
942
801
28
21.97
southwest
228
342.1
0
185.7
0
955.8
674.3
7
21.92
southwest
135
105
193
196
6
965
643
28
21.91
southwest
290.2
193.5
0
185.7
0
998.2
704.3
7
21.86
southwest
252.3
0
98.8
146.3
14.2
987.8
889
3
21.78
southwest
302
0
0
203
0
974
817
28
21.75
southwest
192
288
0
192
0
929.8
716.1
7
21.48
southwest
339
0
0
185
0
1069
754
7
21.16
southwest
158.8
238.2
0
185.7
0
1040.6
734.3
28
21.07
southwest
178
129.8
118.6
179.9
3.6
1007.3
746.8
3
20.73
southwest
108.3
162.4
0
203.5
0
938.2
849
28
20.59
southwest
236
157
0
192
0
972.6
749.1
7
20.42
southwest
146.5
114.6
89.3
201.9
8.8
860
829.5
28
19.99
southwest
147
115
89
202
9
860
829
28
19.99
southwest
238.1
0
94.1
186.7
7
949.9
847
3
19.93
southwest
203.5
305.3
0
203.5
0
963.4
630
7
19.54
southwest
250.2
166.8
0
203.5
0
977.6
694.1
7
19.35
southwest
393
0
0
192
0
940.6
785.6
3
19.2
southwest
393
0
0
192
0
940
758
3
19.11
southwest
296
0
0
186
0
1090
769
7
18.91
southwest
255
0
0
192
0
889.8
945
28
18.75
southwest
154.8
183.4
0
193.3
9.1
1047.4
696.7
28
18.29
southwest
349
0
0
192
0
1047
806
7
18.13
southwest
164.6
0
150.4
181.6
11.7
1023.3
728.9
28
18.03
southwest
214.9
53.8
121.9
155.6
9.6
1014.3
780.6
3
18.02
southwest
213.8
98.1
24.5
181.7
6.7
1066
785.5
14
17.84
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
14
17.82
southwest
238
0
0
185
0
1118
789
28
17.54
southwest
213.5
0
174.2
154.6
11.7
1052.3
775.5
3
17.37
southwest
255.5
170.3
0
185.7
0
1026.6
724.3
7
17.24
southwest
200
133
0
192
0
965.4
806.2
7
17.17
southwest
376
0
0
214.6
0
1003.5
762.4
3
16.28
southwest
288
192
0
192
0
932
717.8
3
16.11
southwest
173.8
93.4
159.9
172.3
9.7
1007.2
746.6
3
15.82
southwest
238.2
158.8
0
185.7
0
1040.6
734.3
7
15.69
southwest
213.5
0
174.2
159.2
11.7
1043.6
771.9
3
15.61
southwest
300
0
0
184
0
1075
795
7
15.58
southwest
151
0
184
167
12
991
772
28
15.57
southwest
148.1
0
182.1
181.4
15
838.9
884.3
28
15.53
southwest
148
0
182
181
15
839
884
28
15.52
southwest
231.8
0
121.6
174
6.7
1056.4
778.5
3
15.44
southwest
144
0
175
158
18
943
844
28
15.42
southwest
144
15
195
176
6
1021
709
28
15.34
southwest
164
0
200
181
13
849
846
28
15.09
southwest
164.2
0
200.1
181.2
12.6
849.3
846
28
15.09
southwest
202
11
141
206
1.7
942
801
7
15.07
southwest
190.7
0
125.4
162.1
7.8
1090
804
3
15.04
southwest
212
141.3
0
203.5
0
973.4
750
7
15.03
southwest
310
0
0
192
0
970
850
7
14.99
southwest
167.4
129.9
128.6
175.5
7.8
1006.3
746.6
3
14.94
southwest
295.8
0
0
185.7
0
1091.4
769.3
7
14.84
southwest
295
0
0
185
0
1069
769
7
14.8
southwest
385
0
0
186
0
966
763
3
14.7
southwest
198.6
132.4
0
192
0
978.4
825.5
7
14.64
southwest
281
0
0
186
0
1104
774
7
14.5
southwest
165
0
143.6
163.8
0
1005.6
900.9
3
14.4
southwest
252
0
0
185
0
1111
784
7
13.71
southwest
181.4
0
167
169.6
7.6
1055.6
777.8
3
13.62
southwest
212.5
0
100.4
159.3
8.7
1007.8
903.6
3
13.54
southwest
331
0
0
192
0
978
825
3
13.52
southwest
151
0
185
167
16
1074
678
28
13.46
southwest
134.7
0
165.7
180.2
10
961
804.9
28
13.29
southwest
135
0
166
180
10
961
805
28
13.29
southwest
339
0
0
197
0
968
781
3
13.22
southwest
251.4
0
118.3
188.5
6.4
1028.4
757.7
3
13.12
southwest
220.8
147.2
0
185.7
0
1055
744.3
7
13.09
southwest
192
288
0
192
0
929.8
716.1
3
12.79
southwest
500
0
0
200
0
1125
613
1
12.64
southwest
190.3
0
125.2
166.6
9.9
1079
798.9
3
12.55
southwest
307
0
0
193
0
968
812
3
12.54
southwest
212.1
0
121.6
180.3
5.7
1057.6
779.3
3
12.47
southwest
155
0
143
193
9
1047
697
28
12.46
southwest
200
0
0
180
0
1125
845
28
12.25
southwest
194.7
0
100.5
170.2
7.5
998
901.8
3
12.18
southwest
238
0
0
186
0
1119
789
7
12.05
southwest
251.4
0
118.3
192.9
5.8
1043.6
754.3
3
11.98
southwest
203.5
135.7
0
185.7
0
1076.2
759.3
7
11.96
southwest
310
0
0
192
0
1012
830
3
11.85
southwest
252.5
0
0
185.7
0
1111.6
784.3
7
11.48
southwest
173
116
0
192
0
946.8
856.8
7
11.39
southwest
225
0
0
181
0
1113
833
7
11.17
southwest
145.4
0
178.9
201.7
7.8
824
868.7
28
10.54
southwest
145
0
179
202
8
824
869
28
10.54
southwest
141.3
212
0
203.5
0
971.8
748.5
7
10.39
southwest
122.6
183.9
0
203.5
0
958.2
800.1
7
10.35
southwest
238.1
0
0
185.7
0
1118.8
789.3
7
10.34
southwest
255
0
0
192
0
889.8
945
7
10.22
southwest
236
0
0
193
0
968
885
7
9.99
southwest
310
0
0
192
0
971
850.6
3
9.87
southwest
202
11
141
206
1.7
942
801
3
9.85
southwest
154.8
0
142.8
193.3
9.1
877.2
867.7
28
9.74
southwest
190.3
0
125.2
161.9
9.9
1088.1
802.6
3
9.45
southwest
254
0
0
198
0
968
863
3
9.31
southwest
158.4
0
194.9
219.7
11
897.7
712.9
28
8.54
southwest
158
0
195
220
11
898
713
28
8.54
southwest
250
0
95.7
191.8
5.3
948.9
857.2
3
8.49
southwest
153
102
0
192
0
888
943.1
7
8.37
southwest
186.2
124.1
0
185.7
0
1083.4
764.3
7
8
southwest
168
42.1
163.8
121.8
5.7
1058.7
780.1
3
7.75
southwest
182
45.2
122
170.2
8.2
1059.4
780.7
3
7.32
southwest
133
200
0
192
0
927.4
839.2
3
6.88
southwest
236
0
0
194
0
968
885
3
6.47
southwest
385
0
0
186
0
966
763
1
6.27
southwest
183.9
122.6
0
203.5
0
959.2
800
3
4.9
southwest
141.3
212
0
203.5
0
971.8
748.5
3
4.83
Use Descriptive Statistics to report back on the following summary measures , for the additives used in making concrete.
Once you’ve complered working, you can return to Canvas for a couple fo questions to answer.
Assume this is a sample set of data.
Once you’re ready, return to Canvas to answer questions based on these summary measures.
What is CV? As you know, standard deviation of a dataset is a way to measure how far the average value lies from the mean. The larger the standard deviation, the more spread the values are from the sample mean. However, the designation of high or low standard deviation depends on the data you have. A standard deviation of 5 for a vehicle which averages 17 miles per gallon, has a relatively higher than an annual Dow Jones standard deviation of 2000 on an average of 35870. One way to understand whether or not a certain value for the standard deviation is high or low is to find the coefficient of variation (CV).
To calculate CV, take the standard deviation, and divide it by the mean. This calculates a ratio between the standard deviation and the mean. The higher the CV, the higher the standard deviation of a sample relative to the mean.
Take the following data: 10,10,11,12,13,17,19,22,25,26,26,26,30,35,50. The avg is 22.1. and the std dev is 11.0. This tells us the typical value in this dataset are 11.0 units away from the mean. The CV of 0.49 tells us that the standard deviation is about half the size of the sample mean.
Look at the mean, standard deviation, and CV for the data above. What can you tell us about the CV and skewness? Answer in Canvas, but show your work on this worksheet.
Analysis2_Correlation
cement
strength
158.4
8.54
158
8.54
331
13.52
154
24.34
237
28.63
236.9
28.63
139.7
35.23
237.5
26.26
140
35.23
436
23.85
145.4
10.54
154
16.5
145
10.54
153.6
16.5
332.5
30.28
108.3
2.33
380
32.82
427.5
35.08
156
29.41
475
38.6
122.6
3.32
184
22.93
108.3
7.72
183.9
4.9
190
40.86
170.3
10.73
154.8
9.74
155
9.74
102
4.57
266
45.85
284
13.4
155
12.46
154.8
12.46
141.3
4.83
122.6
10.35
304
47.81
153
4.78
183.9
10.79
237.5
30.08
212
6.81
332.5
33.02
102
7.68
296
31.42
296
31.42
116
6.28
236
6.47
148
15.52
135
21.91
255
8.2
148.1
15.53
380
36.45
153
8.37
427.5
37.43
141.3
10.39
173
6.94
162
39.84
297
30.96
254
9.31
307
12.54
164
15.09
475
39.29
164.2
15.09
134.7
13.29
135
13.29
146.5
19.99
166.8
6.9
284
24.13
299.8
23.84
147
19.99
236
9.99
255
10.22
116
10.09
300
23.84
339
13.22
133
6.88
212
15.03
144.8
13.2
173
11.39
145
13.2
151.6
12.18
289
11.65
152
12.18
250.2
9.73
393
19.11
277
11.36
164.6
18.03
149
24.58
165
18.03
385
6.27
160
32.84
144
15.34
298.2
31.88
236
12.84
298
31.87
108.3
20.59
162
30.65
160.2
35.31
200
11.41
289
14.6
166.8
15.75
133
13.66
150.7
13.46
151
13.46
159
30.88
339
20.97
157
9.69
157
33.05
170.3
25.73
140
36.44
164
27.23
139.9
36.44
333
15.62
202
9.85
385
14.7
203.5
9.56
250.2
19.35
148.5
23.7
149
23.69
136
26.97
150.9
15.57
155.2
28.99
151
15.57
122.6
24.29
200
17.17
155
28.99
183.9
24.05
102
17.28
143
29.72
143
29.73
236
13.57
143.7
29.87
144
29.87
153
17.96
317.9
40.06
272.6
32.25
143.6
15.42
144
15.42
157
16.89
305.3
14.14
339
27.04
318
40.06
273
32.24
202
15.07
167
23.89
350
18.13
277
21.26
272.8
37.17
302
18.13
273
37.17
255
18.75
333
23.4
236
18.42
385
23.22
155
18.28
154.8
18.29
203.5
19.54
304.8
30.12
116
22.35
305
30.12
393
19.2
149
23.52
149
23.52
192
12.79
322
20.77
236
20.42
322
31.18
261
32.4
326.5
38.63
322.2
31.18
141.3
29.89
260.9
32.4
307
27.53
326
40.68
310
9.87
148.1
17.96
155
23.79
173
24.28
148
17.95
154.8
23.79
152.6
26.86
350
22.53
162
33.76
153
26.86
198.6
9.13
162
33.76
284
43.73
295
14.8
145
29.16
144
26.14
288
16.11
146
33.06
212
33
153
25.56
305.3
25.89
153.1
25.56
145.9
32.72
143.8
26.15
385
27.92
153
26.23
158.6
27.68
190
42.33
304
33.42
331
13.52
303.6
33.42
159
27.68
153.1
26.23
289
25.57
233.8
10.38
133.1
28.94
310
14.99
252
33.4
133
31.03
339
32.04
252.1
33.4
238.1
19.93
302
21.75
393
27.74
277
25.97
192
21.48
266
47.03
133
27.87
132
33.31
480
24.4
132
33.3
261.9
33.72
198.6
14.64
262
33.72
304
49.19
238.1
10.34
331
16.26
230
10.03
356
40.87
136.4
29.07
136
29.07
342
50.46
355.9
40.87
393
39.58
166.8
33.95
168
7.75
238
12.05
229.7
13.36
252
11.47
237.5
33.12
322
25.18
288
23.52
152.7
19.01
252.5
11.48
252
13.71
380
52.91
153
19.01
202
21.97
200
30.44
265
41.54
255
33.8
264.5
41.54
255.3
33.8
480
24.39
332.5
37.72
250.2
36.96
321
37.26
350
27.34
151.8
36.35
145.7
23.74
152
36.35
321.4
37.27
516
41.37
516
41.37
186.2
8
146
23.74
333
31.97
310
11.85
296
14.2
385
31.35
380
40.56
250
8.49
427.5
41.54
475
42.23
298
42.64
480
34.57
424
32.11
298.1
42.64
238.1
25.69
166.1
10.76
141.9
44.61
157
33.66
298
53.52
295.8
14.84
297.8
53.52
142
44.61
200
7.84
222.4
11.58
277
43.58
233.8
22.14
281
14.5
277
43.57
251.4
13.12
296
18.91
236
32.88
313
36.8
284
44.52
313.3
36.8
310
17.24
160
39.4
287
41.94
225
11.17
251.4
17.22
230
20.08
287.3
43.8
295
25.18
229.7
22.32
214.9
18.02
250
12.73
159.1
32.77
168
17.82
212.1
12.47
159
32.76
220.8
13.09
166
37.92
250
13.82
312.7
25.1
166
37.91
313
25.1
424
40.29
158.8
9.62
149.5
32.96
135.7
7.51
149
32.96
339
21.16
155.6
37.36
275
14.2
156
37.36
203.5
41.68
266
39.42
238
17.54
181.4
13.62
376
16.28
266.2
39.42
339.2
21.18
300
15.58
167
15.52
238.1
17.58
238
17.54
310
27.92
182
7.32
393
39.6
148
26.92
203.5
11.96
325
17.54
252
19.69
147.8
26.92
167.4
14.94
305.3
43.38
238.2
15.69
108.3
29.23
310
33.69
233.8
22.84
238.1
30.23
374
39.05
313.8
38.46
251.4
11.98
276
44.28
314
38.46
289
46.25
173.8
15.82
374.3
39.06
252.5
19.77
276.4
44.28
150
37.43
289
46.24
150
37.43
424
39
298
35.86
198.6
28.02
298.1
35.87
350
20.28
165
19.42
202
23.25
382
24
382
24
309.9
38.22
192
39.32
331
31.45
190.3
12.55
334
44.33
331
14.31
382.5
24.07
181.9
12.37
255.5
17.24
229.7
24.54
231.8
15.44
250
24.66
296
21.65
178
20.73
194.7
12.18
350
29.98
166.1
25.48
288
38.8
222.4
24.45
230
24.48
251.4
24.43
186.2
17.6
397
25.45
375
26.06
200
12.25
190.3
9.45
102
25.46
122.6
33.19
212.1
20.92
183.9
32.53
168.9
7.4
314
46.23
480
43.94
168
24.24
213.8
13.18
213.5
15.61
314
46.23
234
39.3
331
17.44
255
21.86
272.8
19.77
251.4
29.93
400
30.14
296
25.18
173.5
23.08
153
26.32
281
22.44
160
39.45
181.4
21.6
236
21.95
159.8
39.46
295.8
25.22
281
22.44
250
24.92
194.7
12.45
193.5
17.2
376
25.62
259.9
49.77
165
14.4
260
49.77
336
44.86
213.7
18
336.5
44.87
225
17.34
339
31.65
190.7
15.04
491
29.55
166.1
21.54
310
27.83
254
26.94
288
42.13
297.2
21.91
290.2
21.86
280
52.82
250
20.87
480
43.89
330.5
56.62
251.4
20.73
288.4
42.14
331
56.61
279.8
52.83
213.5
17.37
307
32.92
222.4
24.89
182
21.5
214.9
38.6
190.3
19.42
116
31.02
213.7
17.57
313
41.05
250
27.22
313.3
41.05
218.9
15.34
313.3
40.93
322
52.42
167
32.9
139.6
8.06
172.4
21.29
322.5
52.43
173.8
29.55
275
24.5
135.7
18.2
158.8
21.07
173
32.1
212.6
13.33
220.8
25.75
141.3
39.66
339
31.84
313
44.39
210.7
21.82
251.4
29.65
167.4
31.81
213.8
17.84
165
33.09
339.2
31.9
212.5
13.54
300
26.85
321
57.21
212.1
24.9
231.8
26.77
165
16.88
321.3
57.22
212
39.7
339
35.17
316.1
24.44
491
37.92
194.7
24.28
212
19.52
203.5
22.63
251.4
32.66
289
32.07
284
40.93
295.7
22.95
349
14.99
178
34.24
238.2
26.91
284
40.93
349
15.05
252.3
21.78
277
31.25
325
30.57
233.8
27.66
250
29.22
249.1
15.36
190.3
22.72
181.4
27.77
228
21.92
190.7
21.06
173.5
33.01
290.4
22.5
376
31.97
139.6
14.59
312.9
52.45
213.5
29.59
133
36.59
350
34.29
238.1
39.59
382
37.42
313
52.44
397
33.08
168.9
23.51
349
18.13
382
37.42
194.7
24.99
213.7
30.39
382.5
37.44
333
47.28
393
48.79
397
36.94
349
9.01
229.7
31.35
166.8
43.57
310
45.3
310
45.3
255.5
32.05
277.1
23.14
190.3
24.85
239.6
25.42
181.9
27.94
397
39.09
375
38.21
350
31.35
275.1
23.8
230
31.54
349
15.87
172.4
29.75
366
65.91
366
65.91
297.2
36.99
218.9
26.05
272.8
31.38
424
62.05
182
31.27
424
72.1
251.4
33.27
446
23.35
167
41.41
400
43.7
173.8
37.81
331
31.74
168
32.85
213.5
33.7
446
25.02
212.6
25.37
200
43.25
250.2
47.71
333
41.68
231.8
33.73
214.9
52.2
213.7
33.73
178
39.16
167.4
41.2
424
32.01
193.5
32.63
212.5
26.31
290.2
33.04
165
26.2
166.1
28.63
212
31.35
173.5
38.2
194.7
25.72
190.7
26.4
190.3
28.47
323.7
28.3
157
43.38
295.7
35.23
165
46.39
325.6
61.24
222.4
29.45
326
61.23
190
46.93
194.7
37.27
249.1
28.68
266
48.7
337.9
24.1
290.4
34.67
475
58.52
446
35.36
251.8
21.02
168.9
31.12
304
50.95
246.8
23.52
342
52.12
251.4
36.97
380
53.1
285
53.58
251.4
36.64
397
55.65
172.4
33.69
236
47.78
213.8
40.23
250
39.64
210.7
37.81
218.9
30.22
252.3
42.29
528
56.83
237.5
36.25
316.1
38.7
500
69.84
446
38.02
275
76.24
310
34.68
213.5
44.64
212.1
34.2
203.5
51.86
446
39.3
218.2
27.42
439
39.3
332.5
39.78
376
36.3
356
59
277.2
30.45
250
67.87
380
40.76
275.1
38.77
213.7
45.71
393
48.85
313.3
28.8
181.4
35.57
297.2
47.4
427.5
41.84
250
38.33
139.6
28.24
213.7
40.15
475
42.62
500
12.64
491
57.92
212.5
31.64
277.1
41.89
290.4
34.74
331
37.23
305.3
54.6
359
23.64
385
55.55
228
39.7
337.9
35.1
295.7
39.94
520
51.02
249.1
30.85
349
32.72
198.6
38.07
212
38.5
359
25.12
213.5
45.94
212.6
37.4
424
74.36
296
29.39
190.3
31.72
239.6
39.44
424
65.7
475
37.8
362.6
22.9
192
50.73
323.7
49.8
446
52.01
214.9
53.96
251.4
39.27
318.8
25.2
288
50.53
251.8
33.36
491
25.61
374
34.4
388.6
28.1
233.8
34.56
480
54.32
362.6
35.3
252.3
50.6
500
26.06
238.1
44.3
182
43.5
349
33.61
218.2
35.96
231.8
42.7
173.8
48.99
313.3
42.8
167
53.46
178
48.59
439
56.1
359
35.75
310
35.76
167.4
51.72
194.7
33.96
165
53.72
246.8
42.22
190.7
35.34
379.5
28.6
165
36.56
230
35.34
194.7
43.39
200
49.25
359
38.61
190.3
38.56
277.1
48.28
480
54.28
172.4
35.85
446
44.42
318.8
33.4
405
52.3
491
33.49
388.6
34.9
229.7
40.86
275.1
51.33
168.9
39.15
425
33.4
277.2
47.71
381.4
14.54
173.5
53.77
251.8
33.94
500
33.21
286.3
24.4
374
46.2
168
39.23
213.8
47.13
218.9
37.27
475
55.6
425
36.3
446
51.02
387
22.75
213.5
51.26
382
11.47
446
53.39
166.1
33.54
213.7
50.77
297.2
51.96
387
25.51
491
61.86
213.7
46.64
236
24.1
446
57.03
312.7
44.52
313
44.52
525
33.8
500
36.94
213.5
51.43
212
45.08
337.9
49.9
250
41.16
387
34.77
254
27.63
295.7
48.72
212.6
44.4
212.5
42.55
389.9
40.6
222.4
40.71
290.4
45.08
531.3
41.3
362.6
55.9
469
40.2
520
60.28
249.1
42.03
251.4
43.58
379.5
47.1
307
34.49
425
46.8
251.4
44.21
246.8
52.5
375
29
540
41.64
212.1
39.61
286.3
38
425
49.2
331
37.91
401.8
41.1
250
42.35
387
36.84
376
43.06
439
66
252.3
55.83
531.3
46.9
218.2
55.51
387
41.67
525
42.42
339
36.45
475
57.23
310
38.7
302
26.74
277.1
51.04
190.3
33.56
277
32.33
181.4
45.37
323.7
74.7
313.3
59.8
251.4
40.15
381.4
22.49
277.2
63.14
214.9
56.63
387
45.9
450.1
39.38
322
29.59
451
78.8
275.1
56.85
500
44.09
540
52.61
469
54.9
446
54.77
505
64.02
388.6
50.7
500.1
44.13
446
55.25
389.9
59.09
475
68.3
446
56.14
173.8
50.94
178
49.99
359
59.49
525
48.4
350
32.72
231.8
45.84
374
61.09
401.8
54.1
167
56.81
167.4
53.66
251.8
44.14
375
45.7
165
55.02
182
48.67
165
37.96
194.7
44.28
318.8
55.5
522
50.51
359
62.94
194.7
37.34
190.3
40.39
491
55.55
446
61.07
172.4
37.68
379.5
52.2
190.7
40.57
349
39.49
173.5
56.06
139.6
39.36
540
59.76
540
61.89
213.8
49.97
213.5
52.96
387
46.68
337.9
59.89
362.6
71.3
331
39.38
540
79.99
425
60.29
387
46.68
168.9
48.15
213.7
53.9
190
50.66
425
61.8
246.8
60.32
531.3
56.4
266
51.73
297.2
56.74
218.9
46.23
380
53.3
213.7
50.08
387
50.24
439
71.7
304
54.38
342
55.06
212.5
42.92
218.2
61.99
525
55.94
212
47.82
349
40.66
237.5
38.41
295.7
52.04
212.6
47.74
277.2
66.82
355
44.03
313.3
64.9
290.4
48.97
332.5
40.27
310
37.33
323.7
80.2
380
41.15
213.5
59.3
475
42.13
427.5
43.01
469
66.9
388.6
55.2
331
39
374
63.4
475
72.3
540
67.31
249.1
51.06
286.3
67.7
375
56.7
198.6
41.72
252.3
60.95
359
66.78
355
55.45
389.9
74.5
491
59.59
401.8
68.5
379.5
54.9
359
68.75
277.1
55.64
275.1
58.61
318.8
66.1
500
67.57
387
47.97
425
64.3
251.8
45.37
425
64.9
362.6
77.3
531.3
58.8
522
74.99
349
40.86
387
56.34
387
61.46
439
73.3
337.9
67.8
469
69.3
500
47.22
313.3
66.6
375
60.2
286.3
72.99
218.2
63.53
246.8
66.42
374
64.9
388.6
57.6
277.2
66.95
475
74.19
389.9
79.4
401.8
73.7
379.5
56.5
315
81.75
318.8
68.1
425
65.2
531.3
59.2
425
66.7
362.6
79.3
525
58.78
469
70.7
540
69.66
349
41.05
375
62.5
139.6
44.21
286.3
76.8
401.8
75.5
389.9
82.6
380
52.52
266
52.91
190
53.69
304
55.26
342
56.14
237.5
39
332.5
41.05
475
41.93
380
43.7
427.5
43.7
485
71.99
500
51.04
236
25.08
254
29.79
307
36.15
277
33.7
339
38.89
525
61.92
540
71.62
310
38.11
331
41.24
198.6
44.3
500
55.16
525
67.11
540
74.17
349
42.13
139.6
44.7
Compare the most expensive additive (cement) with the overall Strength. A correlation and scatterplot are the tools to use for this step. It may also help to output descriptive statistics statistics for Strength.
What patterns to you see? Does one have to invest heavily in Cement to achieve a strong concrete mixture?
In a sentence or two, what is happening with any outlier groups? Return to Canvas to answer these questions regarding concrete and strength.
Analysis3_ShapeAndSkewness
water
coarseagg
219.7
897.7
220
898
192
879
228
845
247
853
246.9
852.9
236.7
868.6
228
932
237
869
218
838.4
201.7
824
220
923
202
824
220.1
923.2
228
932
203.5
938.2
228
932
228
932
221
854
228
932
203.5
958.2
213
923
203.5
938.2
203.5
959.2
228
932
185.7
1026.6
193.3
877.2
193
877
192
887
228
932
179
842
193
1047
193.3
1047.4
203.5
971.8
203.5
958.2
228
932
192
888
203.5
959.2
228
932
203.5
973.4
228
932
192
887
221
819
221.4
819.2
192
909.8
194
968
181
839
196
965
192
889.8
181.4
838.9
228
932
192
888
228
932
203.5
971.8
192
946.8
216
822
186
1040
198
968
193
968
181
849
228
932
181.2
849.3
180.2
961
180
961
201.9
860
203.5
975.6
179
842
211.5
878.2
202
860
193
968
192
889.8
192
909.8
212
878
197
968
192
927.4
203.5
973.4
180.8
979.5
192
946.8
181
979
184.4
992
192
913.2
184
992
203.5
977.6
192
940
191
968
181.6
1023.3
192
935
182
1023
186
966
203
829
176
1021
209.7
879.6
194
968
210
880
203.5
938.2
202
820
203.2
828.7
192
965.4
192
913.2
203.5
975.6
192
927.4
166.7
1074.5
167
1074
201
848
197
968
192
935.4
200
819
185.7
1026.6
200
916
197
961
200.3
916
192
931.2
206
942
186
966
203.5
963.4
203.5
977.6
192.7
892.4
193
892
199
847
166.6
991.2
193.8
879.6
167
991
203.5
958.2
192
965.4
194
880
203.5
959.2
192
887
191
967
190.7
967.4
192
972.6
191.6
814.1
192
814
192
888
209.7
860.5
198.7
931.3
158.4
942.7
158
943
192
935.4
203.5
965.4
197
968
210
861
199
931
206
942
185
898
203
974
191
968
209.7
904
203
974
210
904
192
889.8
192
931.2
194
968
186
966
193
1047
193.3
1047.4
203.5
963.4
196
959.4
192
909.8
196
959
192
940.6
183
953
182.9
953.4
192
929.8
203
974
192
972.6
196
818
201
864
199
801.1
196
817.9
203.5
971.8
200.6
864.5
193
968
199
801
192
971
158.1
1001.8
193
877
192
946.8
158
1002
193.3
877.2
200
1001.8
203
974
179
838
200
1002
192
978.4
178.8
838.1
179
842
185
1069
184
833
178
941
192
932
202
827
203.5
973.4
178
1002
203.5
965.4
178.5
1001.9
202.5
827
178.1
941.5
186
966
178
867
175.1
953.3
228
932
214
895
192
978
213.5
895.5
175
953
178.5
867.2
192
913.2
197.9
947
195.7
949.4
192
970
194
835
196
949
197
968
193.8
835.5
186.7
949.9
203
974
192
940.6
191
968
192
929.8
228
932
192
927.4
178.9
866.9
192
936.2
179
867
195.4
895.2
192
978.4
195
895
228
932
185.7
1118.8
192
978
195.5
1029.4
193
801
171.6
922.6
172
923
228
932
193.3
801.4
192
940
203.5
975.6
121.8
1058.7
186
1119
195.2
1028.1
186
1111
228
932
203
974
192
932
178.1
999.7
185.7
1111.6
185
1111
228
932
178
1000
206
942
192
965.4
195
833
189
919
195.5
832.6
188.6
919
192
936
228
932
203.5
977.6
182
870
203
974
167.5
944
181.9
985.8
168
944
182.5
870.1
162
801
162
801
185.7
1083.4
182
986
192
931.2
192
1012
192
1085
186
966
228
932
191.8
948.9
228
932
228
932
186
879
192
936.2
168
822
186.4
879
186.7
949.9
176.5
1058.6
173.5
882.6
192
935.4
201
878
185.7
1091.4
201.3
878.4
174
883
180
1125
189.3
967.1
190.6
946.5
197.9
947
186
1104
191
946
188.5
1028.4
186
1090
192
972.6
178
1002
179
842
178.5
1001.9
192
1012
182
824
188
904
181
1113
188.5
1028.4
195.5
1029.4
187.6
904.4
185
1069
195.2
1028.1
155.6
1014.3
182
1100
175.6
989.6
121.8
1058.7
180.3
1057.6
176
990
185.7
1055
183.2
858.8
187.4
956.9
178.1
999.7
183
859
178
1000
168
822
185.7
1040.6
175.8
846.8
185.7
1076.2
176
847
185
1069
180.3
1022
183
1088
180
1022
203.5
963.4
178
910
185
1118
169.6
1055.6
214.6
1003.5
177.9
909.7
185.7
1069.2
184
1075
164
1007.3
185.7
1118.8
186
1119
192
970
170.2
1059.4
192
940.6
171
1000
185.7
1076.2
184
1063
185
1111
171.2
1000
175.5
1006.3
203.5
965.4
185.7
1040.6
203.5
938.2
168
914
197.9
947
186.7
949.9
190
1013
169.9
925.3
192.9
1043.6
180
870
170
925
194.9
924.1
172.3
1007.2
190.2
1013.2
185.7
1111.6
179.6
870.1
173.8
1069.3
195
924
174
1069
178
822
164
953
192
978.4
163.6
953.2
186
1050
175.1
1005.8
206
942
185
1047
186
1047
167.8
913.9
192
929.8
192
978
166.6
1079
189
967
192
1025
185.7
1047.8
185.7
1012.4
185.7
1026.6
195.2
1028.1
174
1056.4
191.8
948.9
192
1085
179.9
1007.3
170.2
998
203
974
176.5
1058.6
192
932
189.3
967.1
195.5
1029.4
188.5
1028.4
185.7
1083.4
185.7
1040.6
186
1038
180
1125
161.9
1088.1
192
887
203.5
958.2
180.3
1057.6
203.5
959.2
158.3
1080.8
179
869
192
936.2
121.8
1058.7
181.7
1066
159.2
1043.6
178.9
869.1
189
981
192
1025
192
889.8
185.7
1012.4
188.5
1028.4
187
1025
186
1090
164.8
1006.2
192
888
185
1104
168
1049
169.6
1055.6
194
968
168.4
1049.3
185.7
1091.4
186
1104
187.4
956.9
165.6
1006.4
185.7
998.2
214.6
1003.5
170.6
935.7
163.8
1005.6
171
936
182
986
181.7
1065.8
181.9
985.8
181
1113
185
1060
162.1
1090
201
822
176.5
1058.6
192
1012
198
968
177
908
174.8
1022.8
185.7
998.2
172
825
182
1100
192
936
194.9
811
192.9
1043.6
177.4
907.9
195
811
172.4
825.1
154.6
1052.3
193
968
189.3
967.1
170.2
1059.4
155.6
1014.3
166.6
1079
192
909.8
154.8
1053.5
178
1002
191.8
948.9
178.5
1001.9
158.5
1078.7
178.5
867.2
186
951
164
1007.3
192
1047
156.8
1006.3
185.8
951
172.3
1007.2
183
1088
185.7
1076.2
185.7
1040.6
192
946.8
159.4
1003.8
185.7
1055
203.5
971.8
185
1069
178
867
185.7
977
188.5
1028.4
175.5
1006.3
181.7
1066
175.1
1005.8
185.7
1069.2
159.3
1007.8
184
1075
190
870
180.3
1057.6
174
1056.4
163.8
1005.6
190.5
870
203.5
973.4
197
968
185.7
977
201
822
170.2
998
159
1085.4
185.7
1076.2
188.5
1028.4
192
913.2
168
970
171.5
955.1
192
1047
179.9
1007.3
185.7
1040.6
168.3
970.4
192
1047
146.3
987.8
191
968
184
1063
197.9
947
187.4
956.9
158.1
987.8
161.9
1088.1
169.6
1055.6
185.7
955.8
162.1
1090
164.8
1006.2
168.1
961.2
214.6
1003.5
192
1047
177.6
916.6
159.2
1043.6
192
927.4
186
1050
186.7
949.9
185
1047
178
917
185.7
1040.6
158.3
1080.8
192
1047
186
1047
165.6
1006.4
181.7
1065.8
185.7
1047.8
167
996
192
940
186
1040
192
1056
195.2
1028.1
203.5
975.6
168
914
167.9
914.3
185.7
1026.6
160.6
973.9
166.6
1079
185.7
941.6
185.7
1012.4
185
1040
186
1038
203
974
159.5
1053.6
195.5
1029.4
192
1056
156.8
1006.3
191
824
191.3
824.3
174.8
1022.8
158.5
1078.7
185.7
1012.4
178
822
170.2
1059.4
168
822
192.9
1043.6
162
967
164
1007.3
187
1025
172.3
1007.2
192
1025
121.8
1058.7
154.6
1052.3
162
967
159.4
1003.8
192
965.4
203.5
977.6
192
931.2
174
1056.4
155.6
1014.3
154.8
1053.5
179.9
1007.3
175.5
1006.3
178
882
185.7
998.2
159.3
1007.8
185.7
998.2
163.8
1005.6
176.5
1058.6
159
1085.4
164.8
1006.2
165.6
1006.4
162.1
1090
161.9
1088.1
183.8
942.7
192
935.4
171.5
955.1
175.1
1005.8
174
881.6
189.3
967.1
174
882
228
932
170.2
998
158.1
987.8
228
932
174.9
944.7
168.1
961.2
162
1044
162
967
146.1
1006
158.3
1080.8
228
932
143.3
1086.8
228
932
188.5
1028.4
228
932
163
1031
188.5
1028.4
167
967
156.8
1006.3
192
972.6
181.7
1066
191.8
948.9
185.7
977
158.5
1078.7
146.3
987.8
185
920
228
932
185.7
977
151
1033
162
967
162
830
192
970
159.2
1043.6
180.3
1057.6
203.5
963.4
162
967
140.8
1075.7
186
884.9
228
932
214.6
1003.5
160
1061
160.7
1061.7
159
860
228
932
159.5
1053.6
181.7
1065.8
192
940.6
175.5
1046.9
169.6
1055.6
174.8
1022.8
228
932
187.4
956.9
192
1047
154.8
1053.5
228
932
200
1125
201
822
159.3
1007.8
160.6
973.9
168.1
961.2
192
978
203.5
965.4
154
942
158
903
185.7
955.8
174.9
944.7
171.5
955.1
175
870
158.1
987.8
192
1047
192
978.4
159
1085.4
154
942
154.6
1052.3
159.4
1003.8
168
822
192
1085
166.6
1079
185.7
941.6
178
822
181.1
852.1
164.9
944.7
192
929.8
183.8
942.7
162
967
155.6
1014.3
192.9
1043.6
155.7
852.1
192
932
146.1
1006
210
882
170.1
926.1
157.9
852.1
197.9
947
192
936.2
164.9
944.7
146.3
987.8
200
1125
186.7
949.9
170.2
1059.4
192
1056
140.8
1075.7
174
1056.4
172.3
1007.2
175.5
1046.9
164
1007.3
179.9
1007.3
186
884.9
154
942
192
1012
175.5
1006.3
165.6
1006.4
175.1
1005.8
143.3
1086.8
162.1
1090
153.9
1134.3
163.8
1005.6
195.5
1029.4
170.2
998
190
1145
154
942
161.9
1088.1
160.6
973.9
192
936
156.8
1006.3
162
967
155.7
852.1
175
1120
210
882
157.9
852.1
195.2
1028.1
159.5
1053.6
158.3
1080.8
153.5
852.1
160.7
1061.7
185.7
1104.6
164.8
1006.2
146.1
1006
200
1125
144.7
1004.6
170.1
926.1
121.8
1058.7
181.7
1066
158.5
1078.7
181.1
852.1
151.4
936
162
967
157
938
159.2
1043.6
186
1111
162
967
176.5
1058.6
181.7
1065.8
174.8
1022.8
157
938
201
822
154.8
1053.5
193
968
162
967
127.3
999.7
127
1000
189
1125
200
1125
154.6
1052.3
159
1085.4
174.9
944.7
191.8
948.9
157
938
198
968
171.5
955.1
159.4
1003.8
159.3
1007.8
145.9
944.7
189.3
967.1
168.1
961.2
141.8
852.1
164.9
944.7
137.8
852.1
170
855
158.1
987.8
188.5
1028.4
153.9
1134.3
193
968
151.4
936
188.5
1028.4
143.3
1086.8
126.6
852.1
173
1125
180.3
1057.6
144.7
1004.6
153.5
852.1
192
1025
147.4
946.8
187.4
956.9
157
938
214.6
1003.5
186
884.9
146.3
987.8
141.8
852.1
140.8
1075.7
157
938
189
1125
197
968
142
1098
192
1012
203
974
160.6
973.9
166.6
1079
191
968
169.6
1055.6
183.8
942.7
175.5
1046.9
192.9
1043.6
185.7
1104.6
160.7
1061.7
155.6
1014.3
157
938
200
1124.4
203
974
165
1030
159.5
1053.6
200
1125
173
1125
137.8
852.1
162
967
195
1030
157.9
852.1
200
1124.4
162
967
145.9
944.7
181.1
852.1
162
967
172.3
1007.2
179.9
1007.3
154
942
189
1125
203
974
174
1056.4
170.1
926.1
147.4
946.8
164
1007.3
175.5
1006.3
146.1
1006
126.6
852.1
175.1
1005.8
170.2
1059.4
163.8
1005.6
170.2
998
155.7
852.1
146
896
154
942
165.6
1006.4
161.9
1088.1
210
882
162
967
156.8
1006.3
153.9
1134.3
162.1
1090
192
1047
164.8
1006.2
192
1047
173
1125
162
1055
181.7
1066
159.2
1043.6
157
938
174.9
944.7
164.9
944.7
192
1025
162
1040
153.5
852.1
157
938
158.3
1080.8
181.7
1065.8
228
932
151.4
936
143.3
1086.8
141.8
852.1
228
932
174.8
1022.8
158.5
1078.7
228
932
154.8
1053.5
157
938
186
884.9
228
932
228
932
159.3
1007.8
140.8
1075.7
189
1125
159
1085.4
192
1056
228
932
171.5
955.1
159.4
1003.8
160.7
1061.7
145
967
175.5
1046.9
168.1
961.2
228
932
192
970
183.8
942.7
228
932
154.6
1052.3
228
932
228
932
137.8
852.1
157.9
852.1
192
978
170.1
926.1
181.1
852.1
173
1125
158.1
987.8
144.7
1004.6
126.6
852.1
192
978.4
146.3
987.8
154
942
145
967
145.9
944.7
210
882
147.4
946.8
153.9
1134.3
154
942
160.6
973.9
159.5
1053.6
155.7
852.1
140
966
157
938
153.5
852.1
146.1
1006
151.4
936
164.9
944.7
141.8
852.1
146
896
192
1056
157
938
157
938
186
884.9
174.9
944.7
137.8
852.1
200
1125
175.5
1046.9
126.6
852.1
144.7
1004.6
140.8
1075.7
143.3
1086.8
170.1
926.1
157.9
852.1
160.7
1061.7
181.1
852.1
145.9
944.7
147.4
946.8
153.9
1134.3
145
1130
155.7
852.1
153.5
852.1
141.8
852.1
151.4
936
164.9
944.7
189
1125
137.8
852.1
173
1125
192
1047
126.6
852.1
192
1047
144.7
1004.6
147.4
946.8
145.9
944.7
228
932
228
932
228
932
228
932
228
932
228
932
228
932
228
932
228
932
228
932
146
1120
200
1125
193
968
198
968
193
968
191
968
197
968
189
1125
173
1125
192
970
192
978
192
978.4
200
1125
189
1125
173
1125
192
1047
192
1047
Please investigate both Water and Coarseagg as the two additives that seem closest to a normal distribution. Create histograms for both additives for comparison.
Using any methods you think appropriate, answer the question: “From a statistical standpoint, which variable closest represents a Normal Distribution.
Please return to Canvas explain your answer:
NormalDistributions
Question
Answer
* Remember to return to Canvas to input all of these answers.
500 students are getting ready to take the bar exam. Assume that the scores can be approximated by a normal distribution. How many students do we expect to be within 2 standard deviations from the mean? Enter your answer, rounded to the nearest whole number.
During the height of flu season, demand per day for flu vaccinations in the IU Health network is normally distributed with a mean of 1200 vaccinations and std deviation of 55. What is the probability that demand for a particular day will be less than 1100 vaccinations?
P(X≤1100)
A hospital is trying to improve quality in every area. One of the metrics they look closely at is the quality of physicians. Several individual measurements contribute to a physician’s quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8. A physician score of 94 or better is considered to be exceptional.
What is the probability that a doctor (selected at random) would have a quality score of 94 or higher (round to the nearest 4 decimal places)?
P(X≥94)
A hospital is trying to improve quality in every area. One of the metrics they look closely at is the quality of physicians. Several individual measurements contribute to a physician’s quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8. A physician score of 94 or better is considered to be exceptional.
What portion of physicians would have a quality score between 73 and 93 (inclusive)? (round to the nearest 4 decimal places)?
P(73≤X≤93)
IdeaxShell
Number of Promo Videos to create
Feb-21
Cost per (promo) video
$50
Post-Production Costs 20
$1,000
Breakpoint for cost
20
P{customer purchases}
0.045
Revenue per video bought
$1,900
Expected Profit
This shell file with key data is provided for your convenience, but you can make any changes you need to make, including the wording of cell titles.
We need to know the number in the Red cell – the number of Promo videos to create – as well as the expected profit from that decision in the yellow cell.
image1
image2
image3
image4
Place an order in 3 easy steps. Takes less than 5 mins.