W&L Water Bill Homework

Use the data stored in GEOL150WandLWaterBillHW.xls (available on Sakai) to address the following items. Please submit your responses as a .doc(x) including the requested graphs either printed or via email by Friday March 28.

1. What campus building used the most volume of water in 2013?

2. What campus building used the least volume of water in 2013?

3. What campus building used the most water in 2013 when water use is normalized for the size (area) of the building?

4. What campus building used the least water in 2013 when water use is normalized for the size (area) of the building?

5. What percent of university water use came from the following categories in 2013?
a. academic
b. non-academic
c. athletic
d. residential (include fraternities and sororities)
make a pie chart...

6. Calculate the average water use per person per day in US gallons for residents of campus fraternities, campus sororities, and other campus residence halls. Which groups of residents used the most water in 2013? Which groups of residents used the least water in 2013? Is there a large difference between the three groups?

7. Make a 2-D column graphs of per resident water use per day in US gallons for all of the residential buildings (include fraternities and sororities). Are there any outliers? What are the top (or bottom) residence, top dorm, top sorority and top fraternity in terms of least per resident water use in 2013? What are the top residence, top dorm, top sorority and top fraternity in terms of highest per resident water use in 2013?  Why are these particular buildings the highest and lowest per resident users of water? (there may not be an interesting answer to this but I am interested to hear your input).

8. Plot the percent of yearly water use during a 2-month billing period for the following categories: academic, non-academic, athletic, and residential (include fraternities and sororities) buildings for the six billing periods of 2013 (your graph should be an xy scatter graph with billing period (1-6 or months) on the x axis and % on the y axis and four lines...). Describe the variation (or lack thereof) in seasonal water use throughout our campus.