Question

A food processing plant typically contain fungus spores. If the ventilation system is not adequate, this can have a serious effect of the health of employees. To determine the amount of spores present, random air samples are pumped to a certain plate, and the number of "colony-forming units (CFUs)" are determined after time allowed for incubation. The data from the room of a plant that slaughters 35,000 turkeys per day, which are obtained during the four seasons of the year, is given below. The units are in CFUs per cubic meter.

  Fall                         Winter                 Spring                   Summer

                1231                      384                         2105                       3175

                1254                      104                         701                         2526

                1088                      97                          842                         1090

                1124                       401                         1243                       1987

a) Examine the data using exploratory data analysis tools. Create at least one graph comparing means. b) Perform an one-way ANOVA to determine is the effect of the season is statistically significant. Use the four-step method discussed in the textbook. Be sure to give a practical conclusion. Assume the populations are normally distributed and the variances are roughly equal. Copy and paste the results of the test into your Word document. All results must be done in Excel.

Answer 1

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Fall	4	4697	1174.25	6514.917
Winter	4	986	246.5	28477.67
Spring	4	4891	1222.75	398656.3
summer	4	8778	2194.5	778083
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	7596049	3	2532016	8.358338	0.002865	3.490295
Within Groups	3635196	12	302933
Total	11231244	15