Fix paper -Deliverable 5
jeffro401
Spreadsheet5_JRover_12917.xlsxSheet1
| Q1 | Q2 | |||||||
| n1 | 80 | Subject | Before | After | d (Before-After) | |||
| x1 (bar) | 186.7 | 1 | 200 | 191 | 9 | |||
| n2 | 70 | 2 | 174 | 170 | 4 | |||
| x2 (bar) | 201.9 | 3 | 198 | 177 | 21 | |||
| S1 | 38.5 | 4 | 170 | 167 | 3 | |||
| S2 | 39.8 | 5 | 179 | 159 | 20 | |||
| df | 148 | 6 | 182 | 151 | 31 | |||
| alpha | 0.01 | 7 | 193 | 176 | 17 | |||
| T-critical | 2.6094563313 | =TINV(B8,B7) | 8 | 209 | 183 | 26 | ||
| 9 | 185 | 159 | 26 | |||||
| 18.528125 | =B5*B5/B1 | 10 | 155 | 145 | 10 | |||
| 22.6291428571 | =B6*B6/B3 | 11 | 169 | 146 | 23 | |||
| 12 | 210 | 177 | 33 | |||||
| 6.41539304 | =SQRT(B11+B12) | |||||||
| T-Test | -2.369301445 | =(B2-B4)/B14 | Mean (d) | 18.5833333333 | =AVERAGE(H2:H13) | |||
| absolute | 2.369301445 | =ABS(B15) | Standard Devation (d) | 10.1036297108 | =STDEV(H2:H13) | |||
| P-Value | 0.0191121851 | =TDIST(B16,B7,2) | ||||||
| T-test | 6.3714285714 | =(H15/((H16/SQRT(12)))) | ||||||
| 6.3714285714 | =ABS(H18) | |||||||
| P value | 0.0000528547 | =TDIST(H19,11,2) | ||||||
| T-Critical | ||||||||
| 2.2009851601 | =TINV(0.05,11) | |||||||
| CI95% | =TDIST(H19,11,2) | |||||||
| UP | 25.0028733836 | =H15+G22*(H16/SQRT(12)) | ||||||
| LL | 12.1637932831 | =(H15-G22*(H16/SQRT(12))) | ||||||
