Scenario The health department has hired you to analyze 100

Scenario: The health department has hired you to analyze 100 water samples taken near a beach on Lake Michigan. Your job is to analyze this data, reporting the numerical measures with a graphical representation of the data. You will also need to make a recommendation to close the beach or keep it open based on your data analysis. Below is a table containing the water samples from Lake Michigan near the beach suspected of having high levels of the coliform bacteria. You are to use this data to compute the statistics and construct the graphical representation.

Research Question is asking us to test and see if the population mean for the beach bacteria counts are lower than 200 fecal coliform counts.

Count of Coliform Bacteria from Water Samples (FC)

78

7

180

82

5

76

161

52

187

9

157

82

90

47

45

0

95

31

54

32

128

122

757

10

323

174

2

57

132

50

150

140

36

178

69

169

120

156

118

191

194

187

64

65

171

25

182

184

181

36

99

65

151

112

92

113

74

184

111

148

42

194

255

173

179

82

46

85

17

4

108

115

184

12

141

312

498

38

16

135

212

192

95

13

48

113

174

69

127

151

133

94

151

134

79

126

125

163

78

160

In a study like this, what potential issues may we encounter with the assumptions?

Count of Coliform Bacteria from Water Samples (FC)
78	7	180	82	5	76	161	52	187	9
157	82	90	47	45	0	95	31	54	32
128	122	757	10	323	174	2	57	132	50
150	140	36	178	69	169	120	156	118	191
194	187	64	65	171	25	182	184	181	36
99	65	151	112	92	113	74	184	111	148
42	194	255	173	179	82	46	85	17	4
108	115	184	12	141	312	498	38	16	135
212	192	95	13	48	113	174	69	127	151
133	94	151	134	79	126	125	163	78	160

Solution