Ratios and differences - numeric values

blood — xenobiotics — alcohol concentration         spectrophotometry  
Bennett3
AFT1   acute functional tolerance to EtOH (AFT1 = BEC 2 minus BEC 1)   [mg/mL]   ethanol 72 strains   age 8-14wks
  ILSXISS
Bennett3
AFT2   acute functional tolerance to EtOH (AFT2 = BEC 2 minus BEC 0)   [mg/mL]   ethanol 72 strains   age 8-14wks
  ILSXISS

Listing order:    


Difference:     AFT1 minus AFT2


Females
StrainSex Computed
difference
AFT1 AFT2 p value
on difference
ILS/IbgTejJ f   0.785   0.637 -0.148 p < 0.001
ILSXISS10 f   -0.144   0.574 0.718 p = 0.732
ILSXISS100/TejJ f   0.445   0.543 0.0983 p = 0.062
ILSXISS101/TejJ f   0.582   0.297 -0.285 p = 0.122
ILSXISS102/TejJ f   0.292   1.05 0.758 p = 0.578
ILSXISS103/TejJ f   0.188   1.03 0.842 p = 0.149
ILSXISS107/TejJ f   0.320   0.240 -0.0800 p = 0.318
ILSXISS110/TejJ f   0.430   1.16 0.730  
ILSXISS112/TejJ f   0.482   0.457 -0.0250 p = 0.100
ILSXISS114/TejJ f   0.100   1.13 1.03 p = 0.807
ILSXISS117 f   0.466   -0.340 -0.806 p = 0.126
ILSXISS122/TejJ f   0.551   0.513 -0.0383 p = 0.264
ILSXISS123/TejJ f   0.780   1.22 0.440 p = 0.018
ILSXISS124 f   0.716   0.463 -0.253 p = 0.092
ILSXISS13/TejJ f   0.388   1.02 0.632 p = 0.109
ILSXISS14/TejJ f   0.180   0.418 0.238 p = 0.409
ILSXISS16/TejJ f   0.270   0.440 0.170 p = 0.610
ILSXISS19/TejJ f   0.190   0.768 0.578 p = 0.474
ILSXISS2 f   -0.0400   1.06 1.10 p = 0.919
ILSXISS22/TejJ f   0.715   0.165 -0.550 p = 0.123
ILSXISS23/TejJ f   0.294   0.816 0.522 p = 0.400
ILSXISS25/TejJ f   0.170   0.643 0.473 p = 0.818
ILSXISS26/TejJ f   0.265   0.443 0.178 p = 0.190
ILSXISS28/TejJ f   -0.455   -0.170 0.285 p = 0.237
ILSXISS3/TejJ f   0.622   0.0250 -0.597 p = 0.239
ILSXISS31 f   0.300   0.492 0.192 p = 0.253
ILSXISS32/TejJ f   -0.160   0.840 1.00 p = 0.608
ILSXISS34/TejJ f   0.156   0.293 0.137 p = 0.729
ILSXISS36/TejJ f   0.204   0.676 0.472 p = 0.464
ILSXISS38 f   0.205   0.907 0.702 p = 0.371
ILSXISS39/TejJ f   0.270   0.548 0.278 p = 0.241
ILSXISS42/TejJ f   0.450   0.507 0.0575 p = 0.031
ILSXISS43/TejJ f   0.297   1.01 0.713 p = 0.404
ILSXISS46/TejJ f   0.299   0.616 0.317 p = 0.063
ILSXISS48/TejJ f   0.193   -0.487 -0.680 p = 0.716
ILSXISS49/TejJ f   0.0300   0.150 0.120 p = 0.900
ILSXISS5/TejJ f   0.136   0.673 0.537 p = 0.509
ILSXISS51/TejJ f   0.427   0.687 0.260 p = 0.062
ILSXISS52/TejJ f   0.464   0.387 -0.0767 p = 0.068
ILSXISS55 f   0.0670   0.107 0.0400 p = 0.897
ILSXISS56/TejJ f   0.0583   0.0500 -0.00833 p = 0.829
ILSXISS59 f   0.450   0.372 -0.0783 p = 0.092
ILSXISS60/TejJ f   0.938   0.850 -0.0880 p = 0.036
ILSXISS62/TejJ f   0.274   0.886 0.612 p = 0.567
ILSXISS68/TejJ f   0.217   0.472 0.255 p = 0.592
ILSXISS7/TejJ f   -0.128   0.0450 0.173 p = 0.760
ILSXISS70/TejJ f   -0.140   0.533 0.673 p = 0.801
ILSXISS72/TejJ f   0.466   1.17 0.704 p = 0.195
ILSXISS73/TejJ f   0.335   0.794 0.459 p = 0.096
ILSXISS75/TejJ f   0.944   0.478 -0.466 p = 0.094
ILSXISS76/TejJ f   0.132   1.08 0.948 p = 0.807
ILSXISS78/TejJ f   0.0320   0.566 0.534 p = 0.856
ILSXISS79 f   -0.203   0.827 1.03 p = 0.848
ILSXISS8/TejJ f   0.196   0.596 0.400 p = 0.047
ILSXISS80/TejJ f   0.248   0.614 0.366 p = 0.313
ILSXISS84/TejJ f   -0.378   0.317 0.695 p = 0.633
ILSXISS86/TejJ f   0.100   0.410 0.310 p = 0.691
ILSXISS88 f   0.998   1.11 0.112 p = 0.034
ILSXISS89/TejJ f   0.540   0.158 -0.382 p = 0.074
ILSXISS9/TejJ f   0.124   0.947 0.823 p = 0.842
ILSXISS90/TejJ f   0.209   0.627 0.418 p = 0.264
ILSXISS92/TejJ f   0.118   0.720 0.602 p = 0.513
ILSXISS93/TejJ f   0.409   0.596 0.187 p = 0.239
ILSXISS94/TejJ f   0.320   0.387 0.0675 p = 0.218
ILSXISS96/TejJ f   0.642   0.225 -0.417 p = 0.110
ILSXISS97/TejJ f   0.528   1.13 0.602 p = 0.009
ILSXISS98/TejJ f   0.320   0.825 0.505 p = 0.300
ILSXISS99/TejJ f   -0.200   1.19 1.39 p = 0.740
ISS/IbgTejJ f   0.130   1.76 1.63 p = 0.769

Males
StrainSex Computed
difference
AFT1 AFT2 p value
on difference
ILS/IbgTejJ m   0.145   0.279 0.134 p = 0.422
ILSXISS10 m   0.480   3.46945e-18 -0.480 p = 0.004
ILSXISS100/TejJ m   0.288   0.444 0.156 p = 0.254
ILSXISS101/TejJ m   0.398   -0.288 -0.686 p = 0.119
ILSXISS102/TejJ m   0.407   -0.135 -0.542 p = 0.251
ILSXISS103/TejJ m   0.216   0.900 0.684 p = 0.538
ILSXISS107/TejJ m   0.236   0.300 0.0640 p = 0.492
ILSXISS110/TejJ m   0.346   0.578 0.232 p = 0.084
ILSXISS112/TejJ m   0.553   0.595 0.0417 p = 0.031
ILSXISS114/TejJ m   0.0820   1.04 0.958 p = 0.771
ILSXISS115/TejJ m   0.486   0.808 0.322 p = 0.010
ILSXISS117 m   -0.0180   0.492 0.510 p = 0.960
ILSXISS122/TejJ m   0.0980   0.818 0.720 p = 0.806
ILSXISS123/TejJ m   0.662   0.996 0.334 p = 0.005
ILSXISS124 m   0.164   0.332 0.168 p = 0.656
ILSXISS13/TejJ m   0.378   0.354 -0.0240 p = 0.106
ILSXISS14/TejJ m   0.146   0.356 0.210 p = 0.590
ILSXISS16/TejJ m   0.484   -0.0333 -0.517 p = 0.312
ILSXISS19/TejJ m   -0.0120   0.973 0.985 p = 0.979
ILSXISS2 m   0.426   0.326 -0.100 p = 0.215
ILSXISS22/TejJ m   0.247   0.0825 -0.165 p = 0.585
ILSXISS23/TejJ m   0.462   0.272 -0.190 p = 0.034
ILSXISS24/TejJ m   0.568   0.700 0.132 p = 0.070
ILSXISS25/TejJ m   -0.128   0.792 0.920 p = 0.670
ILSXISS26/TejJ m   0.105   0.617 0.512 p = 0.786
ILSXISS3/TejJ m   0.600   0.725 0.125 p = 0.115
ILSXISS31 m   0.237   -0.0825 -0.320 p = 0.268
ILSXISS34/TejJ m   -0.202   -0.292 -0.0900 p = 0.498
ILSXISS36/TejJ m   -0.323   0.747 1.07 p = 0.302
ILSXISS38 m   -0.0540   0.716 0.770 p = 0.922
ILSXISS39/TejJ m   -0.0330   0.312 0.345 p = 0.937
ILSXISS42/TejJ m   0.235   0.505 0.270 p = 0.182
ILSXISS43/TejJ m   -0.306   0.588 0.894 p = 0.155
ILSXISS46/TejJ m   0.115   0.437 0.322 p = 0.534
ILSXISS48/TejJ m   -0.0330   0.465 0.498 p = 0.932
ILSXISS49/TejJ m   -0.267   0.230 0.497 p = 0.499
ILSXISS5/TejJ m   -0.220   0.230 0.450 p = 0.601
ILSXISS50/TejJ m   -0.0220   0.280 0.302 p = 0.917
ILSXISS51/TejJ m   -0.172   0.0640 0.236 p = 0.372
ILSXISS52/TejJ m   0.352   0.700 0.348 p = 0.123
ILSXISS54 m   0.263   0.630 0.367 p = 0.274
ILSXISS55 m   0.522   0.294 -0.228 p = 0.249
ILSXISS56/TejJ m   -0.0180   0.290 0.308 p = 0.935
ILSXISS59 m   0.356   0.00333 -0.353 p = 0.252
ILSXISS60/TejJ m   -0.00200   0.0240 0.0260 p = 0.997
ILSXISS62/TejJ m   -0.136   0.522 0.658 p = 0.572
ILSXISS66/TejJ m   -0.0340   0.507 0.541 p = 0.824
ILSXISS68/TejJ m   0.0100   0.387 0.377 p = 0.970
ILSXISS7/TejJ m   0.630   -0.150 -0.780  
ILSXISS70/TejJ m   0.883   0.400 -0.483 p = 0.042
ILSXISS72/TejJ m   0.458   0.728 0.270 p = 0.005
ILSXISS73/TejJ m   0.480   0.584 0.104 p = 0.015
ILSXISS75/TejJ m   0.272   0.542 0.270 p = 0.371
ILSXISS76/TejJ m   0.525   1.00 0.475 p = 0.041
ILSXISS78/TejJ m   0.152   0.589 0.437 p = 0.494
ILSXISS79 m   -0.178   0.260 0.438 p = 0.541
ILSXISS8/TejJ m   0.352   0.664 0.312 p = 0.292
ILSXISS80/TejJ m   0.178   0.764 0.586 p = 0.549
ILSXISS84/TejJ m   0.0800   1.15 1.07 p = 0.851
ILSXISS86/TejJ m   0.123   0.195 0.0717 p = 0.695
ILSXISS88 m   0.497   1.03 0.533 p = 0.033
ILSXISS89/TejJ m   0.257   0.407 0.150 p = 0.400
ILSXISS9/TejJ m   0.534   0.387 -0.147 p = 0.193
ILSXISS90/TejJ m   0.550   0.676 0.126 p = 0.447
ILSXISS92/TejJ m   0.331   0.324 -0.00714 p = 0.117
ILSXISS93/TejJ m   0.799   0.247 -0.552 p = 0.006
ILSXISS94/TejJ m   -0.0192   0.0633 0.0825 p = 0.972
ILSXISS96/TejJ m   1.04   0.300 -0.745 p = 0.060
ILSXISS97/TejJ m   0.572   0.864 0.292 p = 0.064
ILSXISS98/TejJ m   0.0730   0.380 0.307 p = 0.905
ILSXISS99/TejJ m   0.303   0.173 -0.130 p = 0.212
ISS/IbgTejJ m   0.0600   1.70 1.64 p = 0.916
    = statistically significant difference (p value on the t test ≤ 0.05 )



Tables can be copy-pasted into Excel if desired.