Question: add the formulas needed to use in excel please 3. Recycling Can For the past 10 years, five Colorado cities have held a recycling contest

add the formulas needed to use in excel please add the formulas needed to use in excel please 3.add the formulas needed to use in excel please 3.

3. Recycling Can For the past 10 years, five Colorado cities have held a recycling contest to see which city does the best job of recycling plastic, glass, and aluminum. The cities participating in this year's contest are Arvada, Centennial, Lakewood, Highlands Ranch, and Parker. To make the contest fair for both large and small cities, the winning city will be the one that recycles the largest number of cans per capitathe number of cans recycled divided by the num- ber of city residents. You have been asked to help the coordinator, Jill Slater, to compile the numbers in an Excel worksheet and create the formulas to compute the total recycling by city each month, total recycling for all cities each month, and the per-capita recycling value that determines the contest winner. In addition, Jill wants to know a few statistics about the monthly recycling efforts, including the minimum, average, and maximum number of cans recycled. Jill has provided you with sample data, T2_Recycling Cans_Data.xlsx. Figure T2.22 shows a sample of what Jill would like to see as a completed worksheet. 0.02 per can Recycling Can Contest Feb City Arvada Centenntial Lakewood Highlands Ranch Parker Total Population Jan Mar Total 15,855 10,505 24.556 12,567 47.628 28.951 24.567 21,777 26,719 73,063 142.547 102.376 105,876 121.987 330.239 2,801,561 2.714.664 2,503,344 1.999,877 7.217,885 1,689,908 1,523,665 1,487,660 1.002.545 4,013,870 4,375,777 4.143.213 3.163.695 11.682,685 Per Capita 3.00 2.52 2.32 2.58 2.38 Minimum Average Maximum 10,505 21.777 12.567 875,155 828,643 632.739 2,714,664 2,503,344 1,999,877 0.02 per can Recycling Can Contest City Jan Feb Mar Total Per Capita Arvada 12,567 10,505 24,567 Centenntial Population 15,855 28,951 142,547 2,801,561 1,689,908 Lakewood Highlands Ranch 102,376 2,714,664 1,523,665 24,556 21,777 105,876 2,503,344 1,487,660 26,719 121,987 1,999,877 1,002,545 Parker Total Minimum Average Maximum Potential Revenue $- $- $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!