Question
JAVA Question: The Colorado River Drainage Basin covers parts of seven western states. A series of dams has been con- structed on the Colorado River
JAVA Question:
The Colorado River Drainage Basin covers parts of seven western states. A series of dams has been con- structed on the Colorado River and its tributaries to store runo water and to generate low-cost hydroelectric power. The ability to regulate the ow of water has made the growth of agriculture and population in these arid desert states possible. Even during periods of extended drought, a steady, reliable source of water and electricity has been available to the basin states. Lake Powell is one of these reservoirs. The le lake powell.csv contains data on the water level in the reservoir for the 8 years from 2008 to 2015. Write a Java program that reads the contents of this CSV le and uses the data to answer the following questions: 1. Determine the average elevation of the water level for each year, and for the 8-year period over which the data were collected. 2. Determine how many months each year exceed the overall average for the 8-year period. 3. Create a report that lists the month (number) and the year for each of the months that exceed the overall average. For example, June is month 6. 4. Determine the average elevation of the water for each month for the 8-year period.
Below is the CSV File:
"Month",2008,2009,2010,2011,2012,2013,2014,2015 "January",3.5906600e+03,3.6141700e+03,3.6221400e+03,3.6205500e+03,3.6369100e+03,3.6044200e+03,3.5786900e+03,3.5935700e+03 "February",3.5906600e+03,3.6120500e+03,3.6201600e+03,3.6149500e+03,3.6352800e+03,3.6014700e+03,3.5755500e+03,3.5922300e+03 "March",3.5897700e+03,3.6104300e+03,3.6194100e+03,3.6107300e+03,3.6353300e+03,3.5989600e+03,3.5747600e+03,3.5910200e+03 "April",3.5940900e+03,3.6112600e+03,3.6205000e+03,3.6119300e+03,3.6357600e+03,3.5965300e+03,3.5775600e+03,3.5901800e+03 "May",3.6108100e+03,3.6290900e+03,3.6259600e+03,3.6231300e+03,3.6368300e+03,3.5994400e+03,3.5893800e+03,3.5972700e+03 "June",3.6310500e+03,3.6404900e+03,3.6388200e+03,3.6489800e+03,3.6339000e+03,3.6000700e+03,3.6091900e+03,3.6135400e+03 "July",3.6330000e+03,3.6411400e+03,3.6365200e+03,3.6608600e+03,3.6284500e+03,3.5941700e+03,3.6080500e+03,3.6126200e+03 "August",3.6295500e+03,3.6375000e+03,3.6345500e+03,3.6553400e+03,3.6236200e+03,3.5896400e+03,3.6058200e+03,3.6090700e+03 "September",3.6269000e+03,3.6353700e+03,3.6336600e+03,3.6530100e+03,3.6215600e+03,3.5912500e+03,3.6055300e+03,3.6060100e+03 "October",3.6238200e+03,3.6335200e+03,3.6340800e+03,3.6502700e+03,3.6194600e+03,3.5908800e+03,3.6055700e+03,3.6064400e+03 "November",3.6219000e+03,3.6311000e+03,3.6303100e+03,3.6456700e+03,3.6151000e+03,3.5879000e+03,3.6018700e+03,3.6054700e+03 "December",3.6178900e+03,3.6262200e+03,3.6265400e+03,3.6397500e+03,3.6098200e+03,3.5844300e+03,3.5977500e+03,3.6008000e+03
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started