Statistics
teddyoliver
Datasethomework.xlsxSheet1
| Project Dataset | ||||||||
| Morning | ||||||||
| Samples of size 4 were taken to find X-bar | Afternoon | |||||||
| Night | ||||||||
| Sample # | Time | Average (X-bar) | Smallest | Largest | Range | |||
| 1 | 6:00 AM | 25.2 | 24.9 | 25.7 | ||||
| 2 | 7 | 25.4 | 25.3 | 26.2 | ||||
| 3 | 8 | 25.2 | 25.1 | 26.4 | ||||
| 4 | 9 | 25.5 | 25.2 | 26.1 | ||||
| 5 | 10 | 25.1 | 25.2 | 26.3 | ||||
| 6 | 11 | 25.5 | 24.9 | 25.7 | ||||
| 7 | 12 Noon | 25.1 | 24.8 | 25.3 | ||||
| 8 | 1:00 PM | 25 | 24.5 | 25.4 | ||||
| 9 | 2 | 24.7 | 23.9 | 25.1 | ||||
| 10 | 3 | 25.1 | 23.9 | 25.2 | ||||
| 11 | 4 | 24.5 | 24.2 | 25.3 | ||||
| 12 | 5 | 24.7 | 24.3 | 25.3 | ||||
| 13 | 6 | 24.8 | 24.2 | 25 | ||||
| 14 | 7 | 24.4 | 24 | 25 | ||||
| 15 | 8 | 25 | 23.6 | 25.2 | ||||
| 16 | 9 | 24.8 | 24.4 | 25.4 | ||||
| 17 | 10 | 25.1 | 24.9 | 25.3 | ||||
| 18 | 11 | 24.1 | 23.9 | 25.1 | ||||
| 19 | 12 Mid Night | 23.9 | 23.1 | 25.2 | ||||
| 20 | 1:00 AM | 23.7 | 22.6 | 24.7 | ||||
| 21 | 2 | 23.8 | 22.7 | 24.6 | ||||
| 22 | 3 | 23.9 | 22.8 | 24 | ||||
| 23 | 4 | 23.5 | 22.5 | 24.1 | ||||
| 24 | 5 | 24.1 | 22.1 | 24.6 | ||||
| 25 | 6 | 25 | 24.6 | 25.1 | ||||
| 26 | 7 | 25.2 | 24.2 | 26.1 | ||||
| 27 | 8 | 25 | 24 | 25.5 | ||||
| 28 | 9 | 25 | 24.4 | 26.7 | ||||
| 29 | 10 | 25.1 | 24.6 | 26.8 | ||||
| 30 | 11 | 25.2 | 24 | 26.3 | ||||
| 31 | 12 Noon | 25.2 | 23.8 | 26.4 | ||||
| 32 | 1:00 PM | 25.3 | 24.4 | 26.1 | ||||
| 33 | 2 | 24.9 | 23.6 | 26 | ||||
| 34 | 3 | 24.6 | 23.8 | 26.7 | ||||
| 35 | 4 | 24.4 | 23.7 | 25.9 | ||||
| 36 | 5 | 24.7 | 23.9 | 25.1 | ||||
| 37 | 6 | 24.5 | 23.2 | 26.2 | ||||
| 38 | 7 | 24.6 | 24.1 | 26.7 | ||||
| 39 | 8 | 24.2 | 23.2 | 24.9 | ||||
| 40 | 9 | 24.4 | 24.2 | 25.1 | ||||
| 41 | 10 | 24.1 | 23.6 | 25.2 | ||||
| 42 | 11 | 23.8 | 23.1 | 25 | ||||
| 43 | 12 Midnight | 24.1 | 23.2 | 25.4 | ||||
| 44 | 1:00 AM | 23.8 | 23.4 | 26.7 | ||||
| 45 | 2 | 23.6 | 23 | 25.2 | ||||
| 46 | 3 | 24.5 | 23.4 | 25 | ||||
| 47 | 4 | 23.4 | 22.7 | 23.8 | ||||
| 48 | 5 | 23.7 | 22.9 | 24.5 | ||||
| 49 | 6 | 25.1 | 23.8 | 25.4 | ||||
| 50 | 7 | 24.8 | 23.4 | 25.6 | ||||
| 51 | 8 | 24.8 | 23 | 26.8 | ||||
| 52 | 9 | 25.2 | 24.1 | 25.7 | ||||
| 53 | 10 | 25.2 | 24.8 | 25.4 | ||||
| 54 | 11 | 25.4 | 24.5 | 25.7 | ||||
| 55 | 12 Noon | 25.2 | 23.7 | 25.9 | ||||
| 56 | 1PM | 24.9 | 23.7 | 26.2 | ||||
| 57 | 2 | 24.6 | 23.4 | 26 | ||||
| 58 | 3 | 24.7 | 23.8 | 25.8 | ||||
| 59 | 4 | 24.8 | 24.1 | 25.6 | ||||
| 60 | 5 | 24.3 | 23.9 | 26.2 | ||||
| 61 | 6 | 24.6 | 22.8 | 24.7 | ||||
| 62 | 7 | 24.6 | 23.7 | 25 | ||||
| 63 | 8 | 24.4 | 22.9 | 24.8 | ||||
| 64 | 9 | 24.6 | 22.2 | 24.9 | ||||
| 65 | 10 | 24.4 | 23.1 | 25.1 | ||||
| 66 | 11 | 23.9 | 22 | 25.2 | ||||
| 67 | 12 Midnight | 23.5 | 22.1 | 24.2 | ||||
| 68 | 1:00 AM | 23.4 | 22.3 | 24 | ||||
| 69 | 2 | 24 | 23.8 | 25 | ||||
| 70 | 3 | 23.8 | 23.1 | 24.6 | ||||
| 71 | 4 | 23.9 | 23.2 | 24.5 | ||||
| 72 | 5 | 23.5 | 22.3 | 25.1 |
