This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: (C) Crea CM for t will be o trendlin the futu 1) Display the least amount paid per CM for water between 1988-2004. 2) Assuming the figures in column B represent the water price for the entire year, how much money did Henry spend in total on water between 2000 and 2004, inclusive? 3) Display the name of the person who spent the most money overall for the entire period for water. You may use the average cost of water over 1975-2004 in calculating your answer. COLUMN 'F': Determine who paid the most for water for a given year. u must use a formula to determine this. the background color to RED for the price er if the cost per CM exceeds 7.20 or BLUE if the cost drops below 5.25 ate a graph plotting the cost of water per the East Coast and West Coast (the plots on the same graph). Then create a linear ne for each region extending 7 years into ure....
View Full Document
This note was uploaded on 06/01/2010 for the course COMM 308 taught by Professor Durbin during the Spring '10 term at WVU.
- Spring '10