Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Why could the Robert Bosch approach make sense to the company?

Answered: 1 week ago