3. Use the Water TAP dataset and complete the blank cells in Table 2 and edit the caption. The count is the total number of samples for the parameter (this includes zero values but not 'no results' data). Mean, standard deviation, median, mode, minimum, and maximum are standard calculations used to evaluate a dataset. To calculate the range, subtract the minimum value from the maximum value. Use two significant figures (the hundredths place) for all values. Table 2 Edit this caption Contaminant Chlorine Copper Iron Nitrate (as Nitrogen) Nitrite (as Nitrogen) pH Count Mean Standard Deviation Median Mode Minimum Maximum Range WATER_TAP_Shared_Data File Edit View Insert Format 100% Trying to connect... Tools Extensions Help Data View only J4 A 1 2 3 fx Bacteria B Water Testing and Awareness Project (WaterTAP) Updated: December 31, 2023 Share D E F G H | J K L M N 4 Total Hardness Total Chlorine Alkalinity Nitrite Nitrate Copper Test Date (ppm) (ppm) pH (ppm) (ppm) (ppm) Iron (ppm) Bacteria Pesticide Innml 5 2/13/2023 200 0 180 8 0 0 1.3 3 = Purple Color Negative Result Negative Lead Negative Zip Code of Water Sample Water source 55045 Private Well Water 6 2/20/2023 100 1 180 8 5 1.3 0 = Purple Color Negative Result Positive Negative 96929 7 3/14/2023 50 0 40 6 0 5 1.3 0 = Purple Color Negative Result Negative Negative 22602 Municipal Tap Water Private Well Water 8 3/27/2023 100 0 80 7 0 0 0 0.5 = Purple Color Negative Result Negative Negative 95553 private spring water 9 3/27/2023 0 0 40 LO 0 10 0 0 Yellow Color = Positive Result Negative Negative 24557 10 3/29/2023 100 3 80 7 0 0 1.3 0 = Purple Color Negative Result Positive Negative 99577 11 4/16/2023 200 5 120 8 10 0 0 = Purple Color Negative Result Negative Negative 76549 12 4/16/2023 100 3 80 7 0 0 1.3 0 Purple Color = Negative Result Negative Negative 71006 Private Well Water Municipal Tap Water Municipal Tap Water Municipal Tap Water 13 4/18/2023 50 3 80 8 0 0 1.3 0 = Purple Color Negative Result Negative Negative 62301 Municipal Tap Water 14 5/17/2023 200 1 80 7 0 0 1.3 0 Purple Color = Negative Result Negative Negative 92802 Municipal Tap Water 15 5/17/2023 100 3 80 7 0 10 1.3 0 = Purple Color Negative Result Negative Negative 42206 Municipal Tap Water 16 6/9/2023 100 3 80 8 0 0 0 0 Yellow Color = Positive Result Negative Negative 76549 17 6/10/2023 100 3 180 7 0 0 1.3 0 = Purple Color Negative Result Negative Negative 43065 Municipal Tap Water Municipal Tap Water 18 6/13/2023 50 3 40 8 0 0 1.3 0 Purple Color = Negative Result Negative Negative 21742 19 6/15/2023 100 1 No results 6 0 3 0 = Purple Color Negative Result Negative Negative 19020 20 7/16/2023 50 0 40 21 7/17/2023 50 0 22 7/19/2023 100 5 80 23 7/19/2023 100 3 80 24 7/20/2023 50 0 200 6 0 0 1.3 0 Yellow Color = Positive Result Positive Negative 98597 LO 5 0 0 0 0 Yellow Color = Positive Result Negative Negative 23842 8 0 0 0 0 = Purple Color Negative Result Negative Negative 35763 7 0 0 0 0.5 = 7 0 5 0 0 = Purple Color Negative Result Purple Color Negative Negative 93437 Negative Result Negative Negative 22152 25 8/11/2023 50 0 180 8 0.5 10 0 0 = Purple Color Negative Result Negative Negative 25438 Municipal Tap Water Municipal Tap Water Municipal Tap Water Private Well Water Municipal Tap Water Municipal Tap Water Municipal Tap Water Private Well Water 26 8/12/2023 50 3 27 8/15/2023 100 0.5 480 40 6 0 0 0 0.3 = Purple Color Negative Result Negative Negative 32566 80 8 0 1.3 0 Purple Color = Negative Result Negative Negative 28547 Municipal Tap Water Municipal Tap Water A J4 WATER_TAP_Shared_Data 8 Trying to connect... File Edit View Insert Format Data Tools Extensions Help View only 100% fx Bacteria A B 1 2 3 C Water Testing and Awareness Project (WaterTAP) Updated: December 31, 2023 Share D E F G H | J K L M N 4 Total Hardness Test Date Total Chlorine Alkalinity (ppm) Nitrite (ppm) H pH (ppm) Nitrate (ppm) Copper (ppm) Iron (ppm) Bacteria Pesticide Lead Zip Code of Water Sample Water source Innml MINIC mumvipui rup m 24 7/20/2023 50 0 0 7 0 5 0 0 = Purple Color Negative Result Negative Negative 22152 Municipal Tap Water 25 8/11/2023 50 0 180 8 0.5 10 0 0 Purple Color Negative Result Negative Negative 25438 26 8/12/2023 50 3 40 40 6 CO 0 0 0 0.3 Purple Color = Negative Result Negative Negative 32566 Private Well Water Municipal Tap Water 27 8/15/2023 100 0.5 80 8 0 0 1.3 0 = Purple Color Negative Result Negative Negative 28547 Municipal Tap Water 28 8/16/2023 50 0 40 6 0 0 1.3 0 Yellow Color = Positive Result Negative Negative 95747 Municipal Tap Water 29 8/16/2023 100 0 180 8 0 0 1.3 0 = Purple Color Negative Result Negative Negative 85650 Small Community Well 30 8/19/2023 200 0.5 180 8 0 0 1.3 0 = 31 9/22/2023 100 3 40 7 0 0 0 0 = 32 10/22/2023 50 0.5 80 7 0 0 1.3 No results = 33 10/23/2023 100 3 120 34 10/24/2023 100 1 1280 8 0 0 1.3 0.3 8 0 0 1.3 0 Purple Color Purple Color Negative Result Purple Color Negative Result Purple Color = Negative Result Purple Color = Negative Result Negative Result Negative Negative 31548 Municipal Tap Water Negative Positive 29456 Municipal Tap Water 35 11/1/2023 50 3 80 7 0 0 1.3 36 11/15/2023 50 LC 5 80 8 0 0 1.3 37 11/15/2023 100 1 40 8 0.5 5 1.3 0 0.3 No results = Purple Color Negative Result Negative Negative Negative Negative Negative Negative Negative Negative 71112 Municipal Tap Water 85613 Municipal Tap Water 48111 Municipal Tap Water 26757 Municipal Tap Water = Purple Color Negative Result Negative Negative 08641 Municipal Tap Water = 38 11/19/2023 39 11/19/2023 40 11/27/2023 555 50 1 40 7 0 0 0 0.3 Purple Color Negative Result Yellow Color = Positive Result Negative Negative 43558 Negative Negative 82005 50 LO 5 40 7 0 50 1 40 6 0 05 1.3 = Purple Color Negative Result Negative Negative 1.3 0.3 = Purple Color Negative Result No results Negative 33024 32570 Municipal Tap Water Municipal Tap Water Municipal Tap Water Municipal Tap Water