Question: In the previous chapter, the water elevation data for Lake Powell were evaluated using the find function. Repeat the calculations, using a nested loop structure.
In the previous chapter, the water elevation data for Lake Powell were evaluated using the find function. Repeat the calculations, using a nested loop structure.
(a) Determine the average elevation of the water level for each year and for the eight-year period over which the data were collected.
(b) Determine how many months each year exceed the overall average for the eight-year period.
(c) 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.
(d) Determine the average elevation of the water for each month for the eight-year period.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
