Spreadsheet: 22616d1211625612-excel-2007-what-kind-of-statistic-should-i-use-to-compare-power-between-men-and-women-kin_360_lab_data-analyse-it
Sheet: Dataset

 |  |  | MARGARIA-KALAMEN POWER TEST (STAIR CLIMBING TEST) |  |  |  |  |  |  |  |  |  | 100 M SPRINT & VELOCITY JUMP TEST
INITIALS | M/F | AGE |  | [NAME] (W/KG) | AB(W) |  | [NAME] (W/KG) 2 | AB(W) 2 |  | INITIALS | M/F | AGE |  | AB (W) | [NAME] (W/KG) | 100 METER |  | AB(W) 2 | REL(W/KG) 2 | 100 METER 2
SY | M | 21 |  | 18.15 | 1152.1 |  | 20.66 | 1311.92 |  | SY | M | 21 |  | 4012.1 | 64 | 4646.3 |  | 1887.15 | 31.45 | 4153.82
SR | M | 22 |  | 15.8 | 693.2 |  | 17.39 | 1541.36 |  | LS | M | 24 |  | 4375.44 | 60.3 | 6160.78 |  | N/A | N/A
EV | M | 22 |  | 13.91 | 879.01 |  | 14.47 | 2013 |  | RM | M | 21 |  | 4507.12 | 50.9 | 6345.3 |  | 4612.49 | 44.45 | 6015.86
JK | M | 21 |  | 11.59 | 925.39 |  | 12.13 | 968.48 |  | JI | M | 28 |  | 5157.82 | 63.04 | 6046.38 |  | 4828.26 | 59.01 | 5614.84
JT | M | 23 |  | 15.12 | 994.7 |  | 16.56 | 1089.55 |  | DH | M | 26 |  | 7037.63 | 94.98 | 6986.26 |  | 5788.57 | 78.12 | 6662.92
DJ | M | 22 |  | 14.9 | 1047.4 |  | 15.57 | 1090.2 |  | LC | M | 22 |  | 1298.42 | 20.5 | 4497.85 |  | 4525.14 | 71.28 | 8586.39
LC | M | 22 |  | 16.56 | 1051.6 |  | 17.99 | 1144.97 |  | JK | M | 21 |  | 1716.16 | 69.03 | 4387 |  | 3091.7 | 40.32 | 2048.92
RB | M | 23 |  | 15.56 | 1097.4 |  | 16.81 | 1185.6 |  | IM | M | 24 |  | 4651.1 | 58.47 | 5852.06 |  | 4805.17 | 60.06 | N/A
KH | M | 24 |  | 17.54 | 1177.2 |  | 18.73 | 1259.68 |  | JT | M | 23 |  | 3908.44 | 59.4 | 4573.6 |  | 3908.44 | 59.41 | N/A
MM | M | 24 |  | 16.3 | 1193.1 |  | 16.05 | 1174.78 |  | SG | M | 21 |  | 4376.53 | 59.2 | 5818.23 |  | 4903.82 | 66.33
IM | M | 24 |  | 19.09 | 1257.29 |  | N/A | N/A |  | SN | M | 25 |  | 4371.2 | 58.7 | 5110.9 |  | 3877.1 | 52.04
RM | M | 21 |  | 14.59 | 1290.5 |  | 15.12 | 1337.28 |  | HK | M | 21 |  | 4461.16 | 57.53 | 6555.94
SN | M | 25 |  | 18.8 | 1389.75 |  | 17.4 | 1296.5 |  | MM | M | 24 |  | 4208.02 | 57.5 | 5400.21 |  | N/A | N/A | 5359.59
HD | M | 26 |  | 22.6 | 1433.1 |  | 18.97 | 1198.6 |  | HD | M | 26 |  | 4674.8 | 73.9 | 5453.54 |  | 2618.46 | 41.5
RE | M | 24 |  | 15.01 | 1443.1 |  | 13.37 | 1294.9 |  | DJ | M | 22 |  | 3624.35 | 51.77 | 4568.8 |  | 3829.35 | 54.71
JS | M | 24 |  | 17.1 | 1484.9 |  | 15.46 | 1341.97 |  | SR | M | 22 |  | 4756.5 | 53.78 | 6236.2 |  | 4897 | 55.25 | 6948.56
OZ | M | 27 |  | 18.4 | 1510.3 |  | 19.1 | 1572.1 |  | EV | M | 22 |  | 4444.06 | 70.34 | 4727.39 |  | 5117.07 | 36.81 | 4260
GG | M | 33 |  | 15.45 | 1517.7 |  | 17.1 | 1679.46 |  | RE | M | 24 |  | 2901.23 | 30.18 | 6499.71 |  | 5191.2 | 53.6 | N/A
DH | M | 26 |  | 22.68 | 1676.8 |  | N/A | N/A |  | OZ | M | 27 |  | 5370.8 | 65.4 | 6038.3 |  | 4976.4 | 60.6 | 6034.8
JI | M | 28 |  | 20.1 | 1683 |  | 18 | 1468.6 |  | JS | M | 24 |  | 3327.9 | 38.3 | 7006 |  | 4851.1 | 54.73 | 5641.8
LS | M | 24 |  | 24.84 | 1805.62 |  | 26.76 | 1941.39 |  | RB | M | 23 |  | 2841.7 | 40.3 | 8020.2 |  | 5131.6 | 72.8 | 4949.8
HK | M | 21 |  | 23.72 | 1839.12 |  | 16.97 | 1315.8 |  | GG | M | 33 |  | 5957.8 | 60.68 | 6896.7 |  | 6168.7 | 62.8 | 6437.25
SG | M | 21 |  | 27.83 | 2107.52 |  | 25.45 | 1881.57 |  | KH | M | 24 |  | 4769.05 | 71.04 | 5042.73 |  | 4485 | 66.67 | 5030.61
EG | M | 27 |  | N/A | N/A |  | N/A | N/A |  | WW | M | 27 |  | 4843.7 | 56.2 | 7018.35 |  | N/A | N/A | 6980.02
WW | M | 27 |  | N/A | N/A |  | N/A | N/A |  | EG | M | 27 |  | N/A | N/A | N/A |  | N/A | N/A | N/A
 | N=25 |  |  |  |  |  |  |  |  |  | Average | 24.08 |  | 4233.042916666666 | 57.72666666666667 | 5828.697083333333 |  | 4474.686 | 56.097 | 5648.345333333334
 | Average | 24.08 |  | 18.07130434782609 | 1332.6 |  | 17.62190476190476 | 1386.081428571428 |  |  | Standard Deviation | 2.856571371417141 |  | 1225.221223273857 | 15.01822795853399 | 995.1934428104186 |  | 1028.875618708417 | 12.38783108325941 | 1514.294925755721
 | Standard Deviation | 2.856571371417141 |  | 3.960423880376058 | 345.7864447366842 |  | 3.44890072203828 | 289.2726948103771
 | T-Test
JE | F | 21 |  | 7.2 | 424.25 |  | 9.07 | 534.97 |  | JE | F | 21 |  | 2333.08 | 39.5 | 3645.05 |  | 4186.6 | 41.02 | N/A
TC | F | 24 |  | 8.35 | 556.54 |  | 9.35 | 626.76 |  | [NAME] | F | 24 |  | 2857.21 | 42.64 | 3377.75 |  | N/A | N/A | N/A
DW | F | 25 |  | 11.27 | 639.54 |  | 10.98 | 626.07 |  | TC | F | 25 |  | 2511.09 | 44.3 | 2851.46 |  | 4806.97 | 44.98 | 3369.08
TS | F | 35 |  | 9.82 | 580.57 |  | 11.16 | 658.44 |  | DW | F | 35 |  | 1640.99 | 27.77 | 2761.19 |  | 2262.27 | 38.34 | 2748.41
RT | F | 21 |  | 11.72 | 637.5 |  | 11.72 | 637.8 |  | TS | F | 21 |  | 2136.46 | 39.3 | 3291.7 |  | 2083.52 | 38.3 | 3083.8
MD | F | 25 |  | 13.19 | 825.84 |  | 10.44 | 653.05 |  | RT | F | 25 |  | 2773.74 | 44.22 | 3368.12 |  | 2858.76 | 45.68 | 3199.33
TW | F | 37 |  | 11.45 | 710.05 |  | N/A | N/A |  | MD | F | 37 |  | 2520.9 | 38.78 | 3626.98 |  | 2557.23 | 39.34 | 3461.38
AY | F | 22 |  | 8.55 | 892.24 |  | 7.05 | 730.43 |  | TW | F | 22 |  | 4850 | 46.41 | 5021.47 |  | 4705.17 | 45.55 | 4214.2
BV | F | 25 |  | 10.6 | 658.2 |  | 10.18 | 632.49 |  | AY | F | 25 |  | 2501.99 | 40.27 | 3205.91 |  | 1740.62 | 28.02
MT | F | 24 |  | 11.04 | 881.4 |  | 11.9 | 951.88 |  | BV | F | 24 |  | N/A | N/A | N/A |  | N/A | N/A | N/A
OJ | F | 22 |  | 15.6 | 745.3 |  | 15.69 | 750.82 |  | MT | F | 22 |  | 2178.42 | 45.52 | 2914.97 |  | N/A | N/A | N/A
EM | F | 23 |  | 19.3 | 1196.5 |  | 17.99 | 113.62 |  | OJ | F | 23 |  | 2677.73 | 43.09 | 4183.81 |  | 1798.41 | 29.05
BC | F | 21 |  | 14.6 | 951.3 |  | 14.8 | 962.1 |  | EM | F | 21 |  | 2818.29 | 43.55 | 4076.8 |  | 2936.1 | 45.17
CS | F | 24 |  | 8.4 | 525.7 |  | 9.2 | 576.7 |  | BC | F | 24 |  | 2352.51 | 37.34 | 3716.7 |  | 2479.67 | 34.36
GM | F | 23 |  | 10.6 | 805.2 |  | 9.53 | 724.25 |  | CS | F | 23 |  | 3049.46 | 40.12 | 4327.3 |  | 3225.39 | 42.44
EP | F | 22 |  | 14.44 | 686.1 |  | 13.85 | 658.07 |  | GM | F | 22 |  | 2030.5 | 42.74 | 3462.31 |  | N/A | N/A | N/A
MC | F | 22 |  | 14.19 | 733.95 |  | 14.19 | 733.95 |  | EP | F | 22 |  | 4439.6 | 85.87 | 3508.6 |  | 4539.6 | 86.87 | 3608.6
FG | F | 28 |  | N/A | N/A |  | N/A | N/A |  | MC | F | 28 |  | 3552.3 | 57.6 | 4104 |  | N/A | N/A | 3925
TT | F | 22 |  | N/A | N/A |  | 11.68 | 604.09 |  | FG | F | 22 |  | 2498.9 | 48.3 | 2949.28 |  | 43.62 | 2256.1 | 2839
KA | F | 28 |  | N/A | N/A |  | 6.52 | 326.08 |  | TT | F | 28 |  | N/A | N/A | N/A |  | 1146 | 22.92
 | F | 22 |  | N/A | N/A |  | N/A | N/A |  | KA | F | 22 |  | N/A | N/A | N/A |  | N/A | N/A | N/A
 | [NAME] |  |  |  |  |  |  |  |  |  | Average | 24.57142857142857 |  | 2762.398333333333 | 44.85111111111111 | 3577.411111111111 |  | 2757.995333333333 | 189.2093333333333 | 3383.2
 | Average | 24.57142857142857 |  | 11.78352941176471 | 732.3635294117648 |  | 11.40555555555556 | 638.9761111111112 |  |  | Standard Deviation | 4.307800234126792 |  | 805.6400768059417 | 11.78872037604489 | 589.9337428288923 |  | 1368.152996122179 | 571.9677349724578 | 482.6729492886448
 | Standard Deviation | 4.307800234126792 |  | 3.123619577462324 | 184.169377236729 |  | 2.979915557868402 | 192.5981537123308
MARGARIA-KALAMEN POWER TEST (STAIR CLIMBING TEST)
INITIALS | Gender | AGE | [NAME] (W/KG) | AB(W) | [NAME] (W/KG) 2 | AB(W) 2
SY | M | 21 | 18.15 | 1152.1 | 20.66 | 1311.92
LS | M | 24 | 24.84 | 1805.62 | 26.76 | 1941.39
RM | M | 21 | 14.59 | 1290.5 | 15.12 | 1337.28
JI | M | 28 | 20.1 | 1683 | 18 | 1468.6
DH | M | 26 | 22.68 | 1676.8 | N/A | N/A
JE | F | 21 | 7.2 | 424.25 | 9.07 | 534.97
LC | M | 22 | 16.56 | 1051.6 | 17.99 | 1144.97
[NAME] | F | 24 | 8.35 | 556.54 | 9.35 | 626.76
TC | F | 25 | 11.27 | 639.54 | 10.98 | 626.07
DW | F | 35 | 9.82 | 580.57 | 11.16 | 658.44
JK | M | 21 | 11.59 | 925.39 | 12.13 | 968.48
TS | F | 21 | 11.72 | 637.5 | 11.72 | 637.8
IM | M | 24 | 19.09 | 1257.29 | N/A | N/A
JT | M | 23 | 15.12 | 994.7 | 16.56 | 1089.55
RT | F | 25 | 13.19 | 825.84 | 10.44 | 653.05
MD | F | 37 | 11.45 | 710.05 | N/A | N/A
TW | F | 22 | 8.55 | 892.24 | 7.05 | 730.43
AY | F | 25 | 10.6 | 658.2 | 10.18 | 632.49
BV | F | 24 | 11.04 | 881.4 | 11.9 | 951.88
SG | M | 21 | 27.83 | 2107.52 | 25.45 | 1881.57
SN | M | 25 | 18.8 | 1389.75 | 17.4 | 1296.5
HK | M | 21 | 23.72 | 1839.12 | 16.97 | 1315.8
MT | F | 22 | 15.6 | 745.3 | 15.69 | 750.82
OJ | F | 23 | 19.3 | 1196.5 | 17.99 | 113.62
MM | M | 24 | 16.3 | 1193.1 | 16.05 | 1174.78
HD | M | 26 | 22.6 | 1433.1 | 18.97 | 1198.6
EM | F | 21 | 14.6 | 951.3 | 14.8 | 962.1
DJ | M | 22 | 14.9 | 1047.4 | 15.57 | 1090.2
BC | F | 24 | 8.4 | 525.7 | 9.2 | 576.7
CS | F | 23 | 10.6 | 805.2 | 9.53 | 724.25
SR | M | 22 | 15.8 | 693.2 | 17.39 | 1541.36
GM | F | 22 | 14.44 | 686.1 | 13.85 | 658.07
EV | M | 22 | 13.91 | 879.01 | 14.47 | 2013
RE | M | 24 | 15.01 | 1443.1 | 13.37 | 1294.9
OZ | M | 27 | 18.4 | 1510.3 | 19.1 | 1572.1
JS | M | 24 | 17.1 | 1484.9 | 15.46 | 1341.97
RB | M | 23 | 15.56 | 1097.4 | 16.81 | 1185.6
GG | M | 33 | 15.45 | 1517.7 | 17.1 | 1679.46
KH | M | 24 | 17.54 | 1177.2 | 18.73 | 1259.68
EP | F | 22 | 14.19 | 733.95 | 14.19 | 733.95
MC | F | 28 | N/A | N/A | N/A | N/A
FG | F | 22 | N/A | N/A | 11.68 | 604.09
WW | M | 27 | N/A | N/A | N/A | N/A
TT | F | 28 | N/A | N/A | 6.52 | 326.08
KA | F | 22 | N/A | N/A | N/A | N/A
EG | M | 27 | N/A | N/A | N/A | N/A
 | [NAME]
 | Average | 24.30434782608696 | 15.399 | 1077.4995 | 14.75282051282051 | 1041.26358974359
 | Standard Deviation | 3.558211568360912 | 4.770761805532539 | 414.3258329082655 | 4.482117655468539 | 450.5579210646987