examshti

examshti - (C) Crea CM for t will be o trendlin the futu 1)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Water Prices - East/West Coasts Date 1975 1.45 3.29 51.2960 20.0000 1976 1.67 3.41 51.4340 25.0100 1977 2.55 4.34 51.6090 31.0690 1978 2.61 4.47 53.3950 31.8000 1979 2.93 4.74 47.9640 31.2850 1980 3.59 5.84 48.2840 32.0420 1981 4.24 6.85 47.1140 26.0400 1982 5.20 8.51 43.0020 26.0600 1983 6.00 9.70 39.9670 30.9160 1984 6.12 8.80 39.7070 31.0000 1985 6.39 9.15 36.7500 32.7780 1986 6.34 8.83 36.2220 33.1100 1987 5.98 8.21 35.6340 32.0200 1988 5.50 7.87 37.6900 30.0100 1989 5.75 8.25 37.1283 20.0100 1990 6.46 8.58 32.5998 22.4500 1991 6.50 8.74 32.5872 30.1800 1992 6.31 8.96 35.2910 29.3800 1993 6.45 9.43 35.2076 27.2100 1994 6.66 10.14 35.2010 41.6004 1995 7.05 10.00 35.3794 40.8235 1996 7.02 10.08 37.3897 43.7638 1997 6.81 10.33 35.9959 40.5619 1998 7.29 10.60 29.6642 35.3292 1999 7.42 10.54 31.4031 38.3642 2000 7.46 11.43 31.6016 41.5342 2001 8.01 12.20 31.9392 41.0224 2002 8.44 11.15 30.7927 40.2764 2003 8.92 12.77 32.8434 45.6267 2004 10.87 14.04 30.1738 44.1434 >>>> Use formulas to answer questions 1 thru 3 <<<< East Coast Price per CM West Coast Price per CM Henry on East Coast CM Used Frank on West Coast CM Used Person with Higher Water Cost (A) In C You (B) Set of wate
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

examshti - (C) Crea CM for t will be o trendlin the futu 1)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online