WK7excel.xlsx
Sheet1
| Y | training | script | s.t | | | | sd |
| 11 | -1 | -1 | 1 | | Group A | 10.8 | 1.9235384062 |
| 13 | -1 | -1 | 1 |
| 12 | -1 | -1 | 1 |
| 10 | -1 | -1 | 1 |
| 8 | -1 | -1 | 1 |
| 23 | 1 | -1 | -1 |
| 21 | 1 | -1 | -1 | | Group C | 20.6 | 2.0736441353 |
| 22 | 1 | -1 | -1 |
| 19 | 1 | -1 | -1 |
| 18 | 1 | -1 | -1 |
| 15 | -1 | 1 | -1 |
| 18 | -1 | 1 | -1 | | Group B | 15.2 | 1.9235384062 |
| 16 | -1 | 1 | -1 |
| 14 | -1 | 1 | -1 |
| 13 | -1 | 1 | -1 |
| 42 | 1 | 1 | 1 |
| 38 | 1 | 1 | 1 | | Group D | 41.8 | 3.3466401061 |
| 39 | 1 | 1 | 1 |
| 44 | 1 | 1 | 1 |
| 46 | 1 | 1 | 1 |
| Script/training | | No | Yes | | | Script -x1 | training -x2 | x | AVG | Sd |
| No(-1) | | 11 | 23 |
| | | 13 | 21 |
| | | 12 | 22 |
| | | 10 | 19 |
| | | 8 | 18 |
| Group | | A | C |
| Mean | | 10.8 |
| SD | | 1.9235384062 |
| Yes(1) |
| | | 15 | 42 |
| | | 18 | 38 |
| | | 16 | 39 |
| | | 14 | 44 |
| | | 13 | 46 |
| Group | | B | D |
| Mean | | 15.2 |
| St | | 1.9235384062 |
Sheet2
| | x1 | x2 | x3 | x1x2 | x1x3 | x2x3 | x1x2x3 | Average sales |
| 1 | -1 | -1 | -1 | 1 | 1 | 1 | -1 | 51.5 |
| 2 | 1 | -1 | -1 | -1 | -1 | 1 | 1 | 44.5 |
| 3 | -1 | 1 | -1 | -1 | 1 | -1 | 1 | 56 |
| 4 | 1 | 1 | -1 | 1 | -1 | -1 | -1 | 78 |
| 5 | -1 | -1 | 1 | 1 | -1 | -1 | 1 | 54 |
| 6 | 1 | -1 | 1 | -1 | 1 | -1 | -1 | 53 |
| 7 | -1 | 1 | 1 | -1 | -1 | 1 | -1 | 67.5 |
| 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 96.5 |
| Sum +1 | 272 | 298 | 271 | 280 | 257 | 260 | 251 |
| Sum -1 | 229 | 203 | 230 | 221 | 244 | 241 | 250 |
| Avg + | 68 | 74.5 | 67.75 | 70 | 64.25 | 65 | 62.75 |
| Avg - | 57.25 | 50.75 | 57.5 | 55.25 | 61 | 60.25 | 62.5 |
| effect | 10.75 | 23.75 | 10.25 | 14.75 | 3.25 | 4.75 | 0.25 |
| effect |
JSY0814
