Question

1. The peak flow (cfs) data measured at USGS 04208000 Cuyahoga River at Independence, OH is available athttps://nwis.waterdata.usgs.gov/usa/nwis/peak. As of Mar 3, 2021, the logged data period (calendar year) is

from 1922 to 2020 (if longer than 2020, only use up to 2020). Copy the required data from the downloaded file and paste them into a spreadsheet or your preferred program for analysis. Then students must convert' mm/dd/yyyy' into 'water years' to obtain one peak flow value per one water year.[20] (1) Build a box plot using the peak flow data for the water years from 1922 to 2020. Ignore (i.e., do not include)the missing values (Excel ignores empty cells in the selected range automatically).[6] (2) Compute the 1st, 2nd, and 3rd quartiles using Excel or other software. Specify the function name used. (3) Compute the arithmetic mean, (4) Find the min and max.(min=max= (5) What is the interquartile range of the data? (6) Are the values you have found from Steps 3 to 5 same as the values reported in Step 1 Boxplot? (

Question image 1Question image 2Question image 3Question image 4Question image 5Question image 6Question image 7