In: Statistics and Probability
Two factors, time and medium are investigated on bacterial count on specimens. The response values are given.
a. Perform a factorial analysis using the EXCEL spreadsheet.
b. Create a factorial design square
c. Draw the main effects plot
d. Give conclusions
Medium |
time 10 |
time 15 |
time 20 |
1 |
2.6 |
4.0 |
5.5 |
1 |
2.7 |
4.1 |
5.4 |
2 |
3.7 |
5.7 |
7.8 |
2 |
3.8 |
5.8 |
7.7 |
(a) The EXCEL spreadsheet is:
(b) The Analysis of Variance table is:
Source | DF | Adj SS | Adj MS | F-Value | P-Value |
Medium | 1 | 8.6700 | 8.6700 | 92.48 | 0.000 |
time | 2 | 23.1200 | 11.5600 | 123.31 | 0.000 |
Error | 8 | 0.7500 | 0.0938 | ||
Lack-of-Fit | 2 | 0.7200 | 0.3600 | 72.00 | 0.000 |
Pure Error | 6 | 0.0300 | 0.0050 | ||
Total | 11 | 32.5400 |
(c) The main effects plot is:
(d) There is a main effect of time and medium on bacterial count on specimens.