Details: The data provided in the file lead_concentrations.xsix (available on Blackboard) was taken from "Lead Results from Tap Water Sampling in Flint, MI during the Flint Water Crisis" (FlintWaterStudy.org, 2015). A total of 271 tests from different locations around Flint, Michigan are included in this file. Each column represents the lead concentration in parts per billion (ppb) for water sampled at three different running times: after immediately turning on the water (first draw), after running for 45 seconds (45 secs flushing), and after running for 2 minutes (2 mins flushing). Assume that lead concentrations are normally distributed.Part II: Some researchers claim that lead levels in water greater than 5.0 ppb can be a cause for concern. The questions below will help you follow the Five Step Approach to hypothesis testing to determine whether the average lead testing result from the first draw samples is greater than 5.0 ppb. Assume a level of significance of a = 0.05. 6) Since we want to determine whether the average lead testing result from the first draw samples is greater than 5.0 ppb, should the alternative hypothesis be upper-tailed, lower-tailed, or two- tailed? What is the assumed value for Ho? 7) Write down the equation for the appropriate test statistic for this hypothesis test. 8) Set up the decision rule for this hypothesis test. Make sure to include the appropriate z or t critical value. 9) Using the sample mean and standard deviation for the First draw results in Question (1) and the null value from Question (6), compute the test statistic (by hand). Show your work. 10) Make a decision for this hypothesis test using the decision rule in Question (8). 1 1) Based on this hypothesis test, write your conclusion as to whether the average lead testing result from the first draw samples should be concerning to the residents of Flint.Excel Instructions: The following instructions are provided to help you calculate the mean (with the AVERAGE function), the standard deviation (with the STDEV.S function). Note: Repeat this procedure for each COLUMN of data provided in the .csy file. Create a data table of cells like the one shown below and use the appropriate functions in the corresponding empty cells. For example, type the first column in cells FI-F3, type the third column in cells HI-H3, and type the fifth column in cells JI-J3. First draw 45 secs flushing 2 mins flushing Mean Mean Mean Standard Deviation Standard Deviation Standard Deviation O = AVERAGE(DATA_CELLS) The only argument that needs to be input here is the range of cells that the data are located (A2:A272, B2:B272, or C3:C272) For example, to calculate the mean for the first draw use: =AVERAGE(A2:A272) O =STDEV.S(DATA_CELLS) The only argument that needs to be input here is the range of cells that the data are located (A2:A272, B2:B272, or C3:C272) For example, to calculate the standard deviation for the first draw use: =AVERAGE(A2:A272)