| A | B | C | D | E | F | G | H | |
| 1 | First dice | Second dice | Total (Leila's score) \(\boldsymbol { L }\) | Coin 1 | Coin 2 | Coin 3 | Coin 4 | Caleb's score \(\boldsymbol { C }\) |
| 2 | 1 | 2 | 3 | H | T | T | T | 3 |
| 3 | 6 | 1 | 7 | T | H | T | T | 3 |
| 4 | 2 | 6 | 8 | H | H | T | T | 6 |
| 5 | 2 | 5 | 7 | T | H | H | H | 9 |
| 6 | 1 | 5 | 6 | T | H | T | T | 3 |
| 7 | 5 | 2 | 7 | H | H | H | H | 12 |
| 8 | 1 | 1 | 2 | H | T | H | T | 6 |
| 9 | 2 | 6 | 8 | T | H | T | H | 6 |
| 10 | 6 | 2 | 8 | H | T | H | T | 6 |
| 11 | 1 | 3 | 4 | T | H | H | H | 9 |
| 12 | 6 | 1 | 7 | T | H | T | T | 3 |
| 13 | 3 | 1 | 4 | T | T | T | T | 0 |
| 14 | 3 | 6 | 9 | H | T | H | H | 9 |
| 15 | 2 | 3 | 5 | T | H | H | H | 9 |
| 16 | 2 | 5 | 7 | H | H | H | H | 12 |
| 17 | 1 | 5 | 6 | H | H | T | H | 9 |
| 18 | 5 | 6 | 11 | T | H | H | H | 9 |
| 19 | 4 | 2 | 6 | T | H | H | T | 6 |
| 20 | 6 | 5 | 11 | T | T | H | H | 6 |
| 21 | 1 | 1 | 2 | T | T | T | T | 0 |
| \multirow{2}{*}{} | Journey time (minutes) | |
| \cline { 2 - 3 } | Mean | Standard deviation |
| A to B | 21 | 3 |
| B to C | 29 | 4 |
| Sample Mean | 248.92 |
| Standard Error | 0.61506 |
| Sample Size | 40 |
| Confidence Level | 0.95 |
| Interval | \(248.92 \pm 1.2055\) |
| Mean | 3.565 |
| s | 1.05 |
| N | 40 |
| Z Test of a Mean | |
| Mean | 3.565 |
| S | 1.05 |
| SE | 0.1660 |
| N | 40 |
| Z | 0.994 |
| p | 0.160 |
| A | B | C | D | |
| 1 | \(\mathrm { X } _ { 1 }\) | \(\mathrm { X } _ { 2 }\) | \(\mathrm { X } _ { 3 }\) | T |
| 2 | 10.9 | 21.5 | 5.3 | 37.7 |
| 3 | 23.9 | 52.4 | 85.3 | 161.6 |
| 4 | 5.2 | 10.4 | 24.0 | 39.6 |
| 5 | 2.9 | 14.4 | 0.8 | 18.1 |
| 6 | 9.0 | 43.3 | 49.7 | 102.0 |
| 7 | 0.4 | 16.2 | 12.4 | 29.0 |
| 8 | 44.1 | 39.5 | 22.1 | 105.7 |
| 9 | 9.2 | 43.6 | 13.9 | 66.7 |
| 10 | 40.4 | 10.9 | 6.1 | 57.4 |
| 11 | 3.2 | 54.8 | 15.7 | 73.7 |
| 12 | 5.3 | 6.1 | 1.6 | 13.0 |
| 13 | 20.5 | 28.9 | 22.9 | 72.3 |
| 14 | 37.3 | 2.1 | 28.6 | 68.0 |
| 15 | 7.1 | 13.6 | 50.1 | 70.8 |
| 16 | 18.6 | 2.0 | 9.3 | 29.9 |
| 17 | 9.0 | 1.2 | 49.9 | 60.1 |
| 18 | 1.9 | 9.5 | 69.8 | 81.2 |
| 19 | 9.0 | 2.1 | 10.4 | 21.5 |
| 20 | 28.7 | 1.4 | 93.8 | 123.9 |
| 21 | 1.8 | 2.9 | 34.8 | 39.5 |
| A | B | C | D | E | F | G | H | 1 | J | K | |
| 1 | Original brightness | 1075 | 1121 | 1106 | 1095 | 1101 | 1109 | 1114 | 1123 | 1108 | 1115 |
| 2 | After 10000 hours | 1042 | 1084 | 1076 | 1065 | 1070 | 1079 | 1081 | 1091 | 1080 | 1082 |
| 3 | Percentage reduction | 3.07 | 3.30 | 2.71 | 2.74 | 2.82 | 2.71 | 2.96 | 2.85 | 2.53 | 2.96 |
| 4 | |||||||||||
| 5 | |||||||||||
| 6 | Sample mean (\%) | 2.8650 | |||||||||
| 7 | Sample sd (\%) | 0.2179 | |||||||||
| 8 | SE | 0.0689 | |||||||||
| 9 | DF | 9 | |||||||||
| 10 | tvalue | 2.262 | |||||||||
| 11 | Lower limit | 2.709 | |||||||||
| 12 | Upper limit | 3.021 | |||||||||
| 1.3 | |||||||||||
| 1 | A | B | C | D | E |
| 1 | X | Y | \(\mathbf { Z } = \mathbf { 5 } \mathbf { X } - \mathbf { Y }\) | \(\mathbf { Z } > \mathbf { 6 }\) | |
| 2 | 4 | 13 | 7 | Y | |
| 3 | 4 | 17 | 3 | N | |
| 4 | 3 | 21 | -6 | N | |
| 5 | |||||
| 6 | |||||
| 98 | 1 | 14 | -9 | N | |
| 99 | 5 | 12 | 13 | Y | |
| 100 | 3 | 18 | -3 | N | |
| 101 | 3 | 15 | 0 | N | |
| 102 | |||||
| 103 | Number of Y | 19 | |||
| 104 | Number of N | 81 | |||
| 105 |
| C5 | \(\times \vee f _ { x }\) | =RANDBETWEEN(1,6) | ||||||||
| A | B | C | D | E | F | G | H | J | ||
| 1 | dice 1 | dice 2 | dice 3 | dice 4 | dice 5 | dice 6 | High score | Low score | Difference | |
| 2 | game 1 | 2 | 2 | 4 | 2 | 3 | 3 | 4 | 2 | 2 |
| 3 | game 2 | 2 | 6 | 3 | 2 | 1 | 2 | 6 | 1 | 5 |
| 4 | game 3 | 3 | 1 | 5 | 3 | 4 | 6 | 6 | 1 | 5 |
| 5 | game 4 | 6 | 5 | 2 | 5 | 6 | 3 | 6 | 2 | 4 |
| 6 | game 5 | 6 | 3 | 3 | 5 | 3 | 2 | 6 | 2 | 4 |
| 7 | game 6 | 5 | 6 | 3 | 5 | 1 | 4 | 6 | 1 | 5 |
| 8 | game 7 | 2 | 3 | 1 | 2 | 6 | 4 | 6 | 1 | 5 |
| 9 | game 8 | 6 | 6 | 6 | 6 | 1 | 5 | 6 | 1 | 5 |
| 10 | game 9 | 3 | 6 | 2 | 5 | 4 | 1 | 6 | 1 | 5 |
| 11 | game 10 | 5 | 1 | 1 | 4 | 6 | 1 | 6 | 1 | 5 |
| 12 | game 11 | 2 | 5 | 6 | 1 | 6 | 5 | 6 | 1 | 5 |
| 13 | game 12 | 2 | 5 | 6 | 6 | 6 | 6 | 6 | 2 | 4 |
| 14 | game 13 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 2 | 2 |
| 15 | game 14 | 1 | 6 | 6 | 6 | 3 | 5 | 6 | 1 | 5 |
| 16 | game 15 | 2 | 2 | 3 | 3 | 5 | 1 | 5 | 1 | 4 |
| 17 | game 16 | 1 | 2 | 3 | 4 | 3 | 3 | 4 | 1 | 3 |
| 18 | game 17 | 5 | 2 | 4 | 2 | 1 | 6 | 6 | 1 | 5 |
| 19 | game 18 | 6 | 1 | 5 | 2 | 1 | 5 | 6 | 1 | 5 |
| 20 | game 19 | 1 | 3 | 5 | 1 | 3 | 5 | 5 | 1 | 4 |
| 21 | game 20 | 5 | 4 | 3 | 2 | 5 | 1 | |||
| 705 | 730 | 720 | 691 | 718 | 680 |
| 731 | 723 | 745 | 708 | 724 | 736 |
| 11.12 | 11.29 | 11.42 | 11.43 | 11.20 | 11.25 | 11.65 |
| 11.33 | 11.56 | 11.34 | 11.44 | 11.24 | 11.60 | 11.52 |
| Sample mean | Sample variance |
| 118.86 | 86.57 |