Special Education Law

MAT-144 Mission Project: Part C Statistical Study Worksheet

Answer the following based on the data presented in the included Part C Data spreadsheet. You will use the analysis you complete here to prepare a written report of your findings. Be sure to submit your written report and completed worksheet to your instructor.

1) Record the mean and median of each group of samples.

a. Original sample collected by mission team

i. Mean 72.93

ii. Median 78.00

b. Villager supplied sample

iii. Mean 35.26

iv. Median 9.00

c. Student biologist collected sample

v. Mean 40.76

vi. Median 65.00

2) Look at the box plots and histograms for each of the datasets. Record any differences you notice in the charts. Does it appear from the charts that the villagers have access to cleaner water after the mission? The major differences that was noticed was that there was more E. coli in the drinking water for the villagers before the wells were set in place. After the wells were set in place the charts show that E. coli went down in the water that is provided to the villagers. Yes, the villagers do have access to clean drinking water after the well has been set in place.

3) The mission team wants to do a statistical test to support whether or not the villagers have access to cleaner water. State the null and alternative hypotheses that can be used to test the data.

The null hypothesis is that amount of E. coli in the water is the same amount present after the wells were dug. The alternative hypotheses are that the amount of E. coli in the water is less than the original amount after the well were dug. Therefore, the villagers have cleaner water. Which the data shows.

4) The results of a statistical test to compare the means of the samples are shown on the spreadsheet. Determine if there is statistically significant evidence that the means are different at the α = 0.05 level.

The...