Question for Prof.MacQueen
triity4
samplesizecalc.xlsBasedOnMean
| Validation (McClave, Benson, & Sincich, 2015, p. 302) | Your Project | ||
| Target Mean | |||
| Margin of Error | 5.00% | <= We want 5% margin of error from the population mean. | |
| Z for Confidence Interval | 1.96 | 1.96 | <= Z score for (1.96 for a 95% c.i.) |
| Standard Deviation | 1,000.00 | <= You can estimate based on a projected range | |
| Sampling Error | 100.00 | - 0 | |
| Sample size (Raw) | 384.16 | - 0 | |
| Sample Size (Rounded Up) | 385.00 | - 0 |
Ross DePinto:
Z score for 95% C.I.
BasedOnProportion
| Validation (McClave, Benson, & Sincich, 2015, p. 303, Statistics in Action Revisited) | Your Project | ||
| Target Proportion | 50.00% | ||
| Margin of Error | 5.00% | <= We want 5% margin of error from the population proportion | |
| Z for Confidence Interval | 1.645 | 1.96 | <= Z score for (1.96 for a 95% c.i.) |
| p * q | 0.25 | 0 | |
| Sampling Error | 0.10 | - 0 | |
| Sample size (Raw) | 67.650625 | - 0 | |
| Sample Size (Rounded Up) | 68.00 | - 0 |
Ross DePinto:
Z score for 95% C.I.
Sheet3
| Sample | Monday | Tuesday | Wednesday | Thursday | Friday | |
| Representative 1 | 3.2 | 6.7 | 1.3 | 8.4 | 2.2 | 21.8 |
| Representative 2 | 5 | 4.1 | 7.9 | 8.1 | 0.4 | 25.5 |
| Representative 3 | 7.1 | 3.2 | 2.1 | 6.5 | 3.7 | 22.6 |
| Representative 4 | 4.2 | 1.6 | 2.7 | 7.2 | 1.4 | 17.1 |
| Representative 5 | 1.7 | 7.1 | 1.6 | 0.9 | 1.8 | 13.1 |
| Representative 6 | 4.7 | 5.5 | 1.6 | 3.9 | 4 | 19.7 |
| Representative 7 | 6.2 | 2 | 1.2 | 0.9 | 1.4 | 11.7 |
| Representative 8 | 1.4 | 2.7 | 3.8 | 4.6 | 3.8 | 16.3 |
| Representative 9 | 1.1 | 4.3 | 9.1 | 3.1 | 2.7 | 20.3 |
| Representative 10 | 5.3 | 4.1 | 9.8 | 2.9 | 2.7 | 24.8 |
| Representative 11 | 3.2 | 2.9 | 4.1 | 5.6 | 0.8 | 16.6 |
| Representative 12 | 2.4 | 4.3 | 6.7 | 1.9 | 4.8 | 20.1 |
| Representative 13 | 8.8 | 5.3 | 6.6 | 1 | 4.5 | 26.2 |
| Representative 14 | 3.7 | 3.6 | 2 | 2.7 | 5.9 | 17.9 |
| Representative 15 | 1 | 1.9 | 6.5 | 3.3 | 4.7 | 17.4 |
| Representative 16 | 7 | 4 | 4.9 | 4.4 | 4.7 | 25 |
| Representative 17 | 5.5 | 7.1 | 2.1 | 0.9 | 2.8 | 18.4 |
| Representative 18 | 1.8 | 5.6 | 2.2 | 1.7 | 2.1 | 13.4 |
| Representative 19 | 2.6 | 3.7 | 4.8 | 1.4 | 5.8 | 18.3 |
| Representative 20 | 3.6 | 0.8 | 5.1 | 4.7 | 6.3 | 20.5 |
| 79.5 | ||||||
| 0.3 |
