Info. systems homework

Background: This is REAL data. Ellis, KS is currently listed in a Stage 3 Water Emergency. Some argue that this is not reflective of the actual situation. The population of Ellis has remained approximately constant from 2004-2014. The water level in the wells is based upon the level of ground water located in the ground. The graphic provides data on the wells currently in operation (1,2,4,5,7,11,12,13). The wells are measured from the top of the well to the current water level. The measurement recorded is the ‘empty’ space in the well. The corresponding % is the percent ‘full’ of each well. The total height is a measurement from the bottom of the well to the top. The 3 stages are based upon the average level of all the wells.

Questions:

1. What is the current average percentage of water the wells hold? Assuming the wells actually could not ever be completely full (without the town being flooded), what numbers should be used as the maximum? Using these numbers, what is the current average percentage of water the wells hold?

2. How long will it be until each well is dry, based on the trends from 2007 to 2014? 2004 to 2014? Which should be used? Will Ellis ever run out of water?

3. How much total water was available in the wells in 2004? In 2014? Should this make a difference in deciding the stage?

4. What stage of water watch would you put Ellis in?

HELP! - Shane’s Tips and Tricks.

Before answering the questions:

Convert the wells to general ‘units’. Use 1 inch of well as 1 unit of water. For example, a 2’7” well would potentially hold 31 units of water. To convert quickly, use two columns, one for feet, one for inches. Multiply the feet column by 12, and add the inches to get your total units.

Ignore the days/months and assume the wells were measured at the same time each year listed.

Remember, years 2004,2005,2006,2007 will not have the same impact as years 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 due to the time differences unless you ‘create’ data for each year (in other words you can’t just compare the difference from 04-07 and 07-14. Find the increase or decrease in each well, and divide that by the number of years. For example, For well 1, years 2004, 2007, there was a 4% increase. Using 100 units as the start (just for an example), 2004 would equal 100. 2005 would be 101.3. 2006 would be 103.6. 2007 would be 104.

Question 1 Help:

Average the current water levels. Use the ‘highest’ recorded water level as the 100% maximum. Adjust the % water level to this new maximum.

Question 2 Help:

First, find the current increase/decline per year for each time period. Use the current water levels to calculate how many years it will take for the well to run empty (if declining).

Question 3 Help:

Report as units. Sum the total number of units during each specified year.

Question 4 Help:

Choose!