Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey There,I have combined the data and please find the attached.
Outline
The problem has been solved in the attached excel workbook, with 5 excel work sheets covering
•
Part 1
•
Part 2
•
Part 3
•
Part 4
•
Part 5
Recycling Aluminum Cans Contest
City
Population
Jan
Feb
March
April
May
June
Alexandria, VA
148892
10230
9845
9785
12132
12256
17645
Annandale, VA
41008
45678
47123
23145
12456
17896
23461
Arlington, VA
224906
90586
89456
86701
85818
55149
60060
Ashburn, VA
43511
30550
35469
42765
55012
59072
59408
Burke, VA
59469
121364
57236
89256
13564
12236
12256
Centreville, VA
71135
112354
175126
85963
91354
85126
79456
Chantilly, VA
23039
26005
19931
29997
30195
35997
45091
Fairfax Station, VA
17894
72167
71256
73421
72563
80845
79945
Fairfax, VA
23973
22452
21321
33190
33081
36085
29839
Falls Church, VA
13508
23341
13564
18934
34135
14562
14235
Great Falls, VA
15427
10267
15678
18987
23687
35097
35198
Leesburg, VA
47673
55891
45011
85123
90631
87541
69520
1801
2751
2421
2941
6318
10297
8075
Manassas, VA
37821
12145
11432
12354
12789
13012
12542
McLean, VA
48115
17450
14870
20454
29810
27714
28975
Merrifield, VA
15212
17423
16245
18754
15123
15244
17154
1051
1231
1007
1025
750
525
760
34166
24765
26667
26917
19875
20870
23951
982
1101
1204
1150
1203
1402
1103
Reston, VA
58404
23546
76231
56723
21567
15342
18342
Springfield, VA
30484
29456
26456
28912
21456
36456
22912
Vienna, VA
16370
21452
22654
29456
19873
13058
19381
Washington, DC
658893
251013
375680
761490
79016
80531
85481
Washington, VA
952
1041
1254
1543
942
791
850
Lovettesville, VA
Middleburg, VA
Oakton, VA
Purcellville, VA
Total
71893
169759
467770
282276
305912
629379
187216
450197
175968
118771
138914
433717
32803
74274
139273
99943
5298
143045
7163
211751
165648
125874
1633211
6421
Per Capita
Recycling Aluminum Cans Contest
NOVA TOWNS
City
Population
Jan
Feb
March
April
May
Alexandria, VA
148,892.00
10,230.00
9,845.00
9,785.00
12,132.00
12,256.00
Annandale, VA
41,008.00
45,678.00
47,123.00
23,145.00
12,456.00
17,896.00
Arlington, VA
224,906.00
90,586.00
89,456.00
86,701.00
85,818.00
55,149.00
Ashburn, VA
43,511.00
30,550.00
35,469.00
42,765.00
55,012.00
59,072.00
Burke, VA
59,469.00
121,364.00
57,236.00
89,256.00
13,564.00
12,236.00
Centreville, VA
71,135.00
112,354.00
175,126.00
85,963.00
91,354.00
85,126.00
Chantilly, VA
23,039.00
26,005.00
19,931.00
29,997.00
30,195.00
35,997.00
Fairfax Station, VA
17,894.00
72,167.00
71,256.00
73,421.00
72,563.00
80,845.00
Fairfax, VA
23,973.00
22,452.00
21,321.00
33,190.00
33,081.00
36,085.00
Falls Church, VA
13,508.00
23,341.00
13,564.00
18,934.00
34,135.00
14,562.00
Great Falls, VA
15,427.00
10,267.00
15,678.00
18,987.00
23,687.00
35,097.00
Leesburg, VA
47,673.00
55,891.00
45,011.00
85,123.00
90,631.00
87,541.00
1,801.00
2,751.00
2,421.00
2,941.00
6,318.00
10,297.00
Manassas, VA
37,821.00
12,145.00
11,432.00
12,354.00
12,789.00
13,012.00
McLean, VA
48,115.00
17,450.00
14,870.00
20,454.00
29,810.00
27,714.00
Merrifield, VA
15,212.00
17,423.00
16,245.00
18,754.00
15,123.00
15,244.00
1,051.00
1,231.00
1,007.00
1,025.00
750.00
525.00
34,166.00
24,765.00
26,667.00
26,917.00
19,875.00
20,870.00
982.00
1,101.00
1,204.00
1,150.00
1,203.00
1,402.00
Reston, VA
58,404.00
23,546.00
76,231.00
56,723.00
21,567.00
15,342.00
Springfield, VA
30,484.00
29,456.00
26,456.00
28,912.00
21,456.00
36,456.00
Vienna, VA
16,370.00
21,452.00
22,654.00
29,456.00
19,873.00
13,058.00
952.00
1,041.00
1,254.00
1,543.00
942.00
791.00
Lovettesville, VA
Middleburg, VA
Oakton, VA
Purcellville, VA
Washington, VA
City
Washington, DC
Population
658,893.00
Jan
Feb
March
April
May
251,013.00
375,680.00
761,490.00
79,016.00
80,531.00
June
Total
17,645.00
71,893.00
23,461.00
169,759.00
60,060.00
467,770.00
59...