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.