cenario – With several recent environmental disasters (e.g., BP oil spill, Fukushima Daiichi Nuclear Power Plant, Hurricanes Katrina, Irene and Sandy, etc.), many metropolitan areas have been looking for ways to be more environmentally conscious … AND perhaps to make some money. For several years, towns/cities in Northern Virginia have been running trial programs for recycling paper, bottles, and cans. Last year, twenty one towns plus the District of Columbia decided to hold a competition to determine the municipality that did the best job of recycling, with the focus on aluminum cans. It is an important program given the outdoor opportunities around the region, including the Appalachian Trail, the C&O Canal, the Potomac River, and the Chesapeake Bay, among others. To make the contest fair, the winning town/city will be the one that recycles the largest number per capita, i.e., the number of cans recycled divided by the number of residents for that town/city.
Ali Tambor (everyone calls her “Al”) is the competition coordinator for the recycling project. Al has provided you with some data (and a rough starting point for the spreadsheet) in the file “HW1 – Spring 2016 – Recycling Cans.xls .”
- First, Al would like for you to alphabetize the list of participating towns/cities in an Excel worksheet according to the state. Display the numbers and create the formulas to compute the total recycling for each city by the year (for the data given). This should be a whole number in the standard display as discussed in the Excel data validation handout. Make sure you break out Washington DC from the Northern Virginia (NOVA) towns. Include the additional data provided in Additional Data, Word document (1 pt).
- Determine the per capita recycling value to 1 decimal place. This will determine the contest winner for the first six months of 2015 (including Washington, DC). Use conditional formatting to determine the largest per capita value for the Jan-June timeframe (e.g. after the six month period, which city would win? (1 pt).
- In addition, she wants to know a few statistics about the monthly recycling efforts, including the minimum, average, and maximum values for the number of cans recycled for each month, i.e., what was the smallest number of cans recycled, the average, and the largest for each month). Break this out by Northern Virginia towns/cities (as the Washington DC numbers would constitute the smallest
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]