Spreadsheet: 0106eeea-0b67-4a72-84ac-22520e8fd084
Sheet: TEST 3 (T3)

 |  |  | TEST 3
 |  |  | TABLE 3a: Increased volume of test 3 (50ul/2ml H2O) in quartz cell
 |  |  | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  | TABLE 3b: Lower volume of test 3 (i.e. 20ul/2ml H2O) added to quartz cell
 | Not enough volume |  | 1 | 50 |  |  |  |  |  |  |  | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  | t-Test: Two-Sample Assuming Equal Variances
 |  |  | 2 | 50 | 0.04 | 0.029 | 0.026 | 0.021 |  |  |  | 1 | 20 | 0.014 | 0.009 | 0.008 | 0.007 |  |  |  | (Comparison between 20 and 50 ul i.e. table 3b and table 3c)
 |  |  | 3 | 50 | 0.029 | 0.015 | 0.014 | 0.013 |  |  |  | 2 | 20 | 0.014 | 0.01 | 0.009 | 0.007 |  |  |  |  | Variable 1 | Variable 2
 |  |  | 4 | 50 | 0.039 | 0.017 | 0.016 | 0.011 |  |  |  | 3 | 20 | 0.007 | 0.002 | 0.002 | 0.002 |  |  |  | Mean | 0.023 | 0.006624999999999999
 |  |  | 5 | 50 | 0.026 | 0.018 | 0.017 | 0.015 |  |  |  | 4 | 20 | 0.008 | 0.005 | 0.004 | 0.003 |  |  |  | [NAME] | 0.0005676666666666664 | 9.98214285714288e-06
 |  |  | 6 | 50 | 0.019 | 0.01 | 0.009 | 0.007 |  |  |  | 14 | 20 | 0.011 | 0.007 | 0.006 | 0.005 |  |  |  | Observations | 7 | 8
 |  |  | 7 | 50 | 0.023 | 0.012 | 0.011 | 0.008 |  |  |  | 16 | 20 | 0.018 | 0.011 | 0.01 | 0.008 |  |  |  | [NAME] | 0.0002673749999999999
 |  |  | 8 | 50 | 0.03 | 0.018 | 0.016 | 0.013 |  |  |  | 23 | 20 | 0.012 | 0.005 | 0.005 | 0.004 |  |  |  | Hypothesized Mean Difference | 0
 |  |  | 9 | 50 | 0.022 | 0.012 | 0.011 | 0.008 |  |  |  | 24 | 20 | 0.01 | 0.004 | 0.004 | 0.003 |  |  |  | df | 13
 |  |  | 10 | 50 | 0.025 | 0.014 | 0.013 | 0.01 |  |  |  | Median |  |  |  |  |  |  |  |  | t Stat | 1.934947980458698
 |  |  | 11 | 50 | 0.02 | 0.013 | 0.012 | 0.009 |  |  |  | STDEV |  |  |  |  |  |  |  |  | P(T<=t) one-tail | 0.03752810756226971
 |  |  | 12 | 50 | 0.025 | 0.018 | 0.016 | 0.012 |  |  |  | AV |  |  |  |  |  |  |  |  | t Critical one-tail | 1.770933395986873
 |  |  | 13 | 50 | 0.016 | 0.007 | 0.007 | 0.005 |  |  |  |  |  |  |  |  |  |  |  |  | P(T<=t) two-tail | 0.07505621512453942
 |  |  | 14 | 50 | 0.028 | 0.015 | 0.015 | 0.011 |  |  |  | Table 3c: These are samples (below) which are from table 3a for t-test comparison with table 3b. |  |  |  |  |  |  |  |  | t Critical two-tail | 2.160368656462793
 |  |  | 15 | 50 | 0.02 | 0.014 | 0.012 | 0.009 |  |  |  | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280
 | No repeat capable |  | 16 | 50 | 0.108 | 0.073 | 0.052 | 0.049 |  |  |  | 1 | 50
 |  |  | 17 | 50 | 0.029 | 0.025 | 0.026 | 0.017 |  |  |  | 2 | 50 | 0.04 | 0.029 | 0.026 | 0.021
 |  |  | 18 | 50 | 0.019 | 0.012 | 0.012 | 0.008 |  |  |  | 3 | 50 | 0.029 | 0.015 | 0.014 | 0.013
 |  |  | 19 | 50 | 0.021 | 0.013 | 0.011 | 0.009 |  |  |  | 4 | 50 | 0.039 | 0.017 | 0.016 | 0.011
 |  |  | 20 | 50 | 0.031 | 0.019 | 0.017 | 0.013 |  |  |  | 14 | 50 | 0.028 | 0.015 | 0.015 | 0.011
 |  |  | 21 | 50 | 0.026 | 0.014 | 0.013 | 0.01 |  |  |  | 16 | 50 | 0.108 | 0.073 | 0.052 | 0.049
 |  |  | 22 | 50 | 0.019 | 0.02 | 0.014 | 0.01 |  |  |  | 23 | 50 | 0.034 | 0.014 | 0.013 | 0.012
 |  |  | 23 | 50 | 0.034 | 0.014 | 0.013 | 0.012 |  |  |  | 24 | 50 | -0.002 | -0.002 | -0.002 | -0.002
 | No repeat capable |  | 24 | 50 | -0.002 | -0.002 | -0.002 | -0.002 |  |  |  | Median
 |  |  | Median |  |  |  |  |  |  |  |  | STDEV
 |  |  | STDEV |  |  |  |  |  |  |  |  | AV
 |  |  | AV
 |  |  | * Highlight red to visually indicate odd readings.