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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t-Test: Two-Sample Assuming Equal Variances
 |  | NOTE: | TEST 4 UV spectrometer will be conducted on 24th Sept., as DNA was still present following 48 hrs heat treatment @ 55 d C, |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compare 260 (Column F v's P)
 |  |  | which requires further time to push beyond an expected threshold for dissolving the DNA pellets. The samples were |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Variable 1 | Variable 2
 |  |  | placed into the refrigerator over the weekend. It is important to note that FG3 buffer was not increased, as the protocol advices further incubation if low buffer. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean | 0.01427272727272727 | 0.01208333333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4.561818181818178e-05 | 9.390151515151504e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Observations | 11 | 12
 |  |  |  | Denotes samples used in tests 1 - 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 7.090945165945159e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hypothesized Mean Difference | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | df | 21
 |  |  | Table 4a: Normal protease mix |  |  |  |  |  |  |  |  |  |  |  | Table 4b: Double protease mix |  |  |  |  |  |  |  | t Stat | 0.6228663882187676
 |  |  | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  |  | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  | P(T<=t) one-tail | 0.2700390884104094
 |  | Sample id. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t Critical one-tail | 1.720742902811878
 |  | 1 | 50 | 0.045 | 0.015 | 0.015 | 0.012 |  |  |  |  | 1 | 50 | 0.052 | 0.011 | 0.013 | 0.011 |  |  | P(T<=t) two-tail | 0.5400781768208187
 |  | 2 | 50 | 0.063 | 0.022 | 0.022 | 0.018 |  |  |  |  | 2 | 50 | 0.061 | 0.019 | 0.02 | 0.018 |  |  | t Critical two-tail | 2.07961384472768
 |  | 3 | 50 | 0.047 | 0.023 | 0.022 | 0.016 |  |  |  |  | 3 | 50 | 0.07 | 0.027 | 0.028 | 0.024
 |  | 4 | 50 | 0.035 | 0.013 | 0.012 | 0.009 |  |  |  |  | 4 | 50 | 0.031 | 0.007 | 0.009 | 0.008 |  |  | t-Test: Two-Sample Assuming Equal Variances
 |  | 5 | 50 |  |  |  |  |  |  |  |  | 5 | 50 | 0.035 | 0.006 | 0.008 | 0.008 |  |  | Compare 280 (Column H v's R)
 |  | 6 | 50 | 0.039 | 0.012 | 0.012 | 0.009 |  |  |  |  | 6 | 50 | 0.037 | 0.009 | 0.011 | 0.01 |  |  |  | Variable 1 | Variable 2
 |  | 7 | 50 | 0.035 | 0.008 | 0.009 | 0.008 |  |  |  |  | 7 | 50 | 0.034 | 0.014 | 0.014 | 0.012 |  |  | Mean | 0.01109090909090909 | 0.01233333333333334
 |  | 8 | 50 | 0.039 | 0.017 | 0.016 | 0.012 |  |  |  |  | 8 | 50 | 0.037 | 0.003 | 0.005 | 0.006 |  |  | [NAME] | 2.029090909090906e-05 | 5.060606060606055e-05
 |  | 9 | 50 | 0.034 | 0.003 | 0.005 | 0.004 |  |  |  |  | 9 | 50 | 0.032 | -0.001 | 0.003 | 0.004 |  |  | Observations | 11 | 12
 |  | 10 | 50 | 0.031 | 0.008 | 0.008 | 0.006 |  |  |  |  | 10 | 50 | 0.03 | 0.004 | 0.006 | 0.006 |  |  | [NAME] | 3.617027417027412e-05
 |  | 11 | 50 | 0.046 | 0.012 | 0.013 | 0.011 |  |  |  |  | 11 | 50 | 0.051 | 0.015 | 0.016 | 0.015 |  |  | Hypothesized Mean Difference | 0
 |  | 12 | 50 | 0.042 | 0.024 | 0.023 | 0.017 |  |  |  |  | 12 | 50 | 0.064 | 0.031 | 0.03 | 0.026 |  |  | df | 21
 |  | 13 | 50 | 0.028 | 0.007 | 0.007 | 0.005 |  |  |  |  | Median |  |  |  |  |  |  |  | t Stat | -0.4948995558769163
 |  | 14 | 50 | 0.049 | 0.013 | 0.014 | 0.011 |  |  |  |  | STDEV |  |  |  |  |  |  |  | P(T<=t) one-tail | 0.3129046433083514
 |  | 15 | 50 | 0.03 | 0.009 | 0.009 | 0.006 |  |  |  |  | AV |  |  |  |  |  |  |  | t Critical one-tail | 1.720742902811878
 |  | 16 | 50 | 0.042 | 0.016 | 0.015 | 0.012 |  |  |  |  |  |  |  |  |  |  |  |  | P(T<=t) two-tail | 0.6258092866167029
 |  | 17 | 50 | 0.036 | 0.014 | 0.014 | 0.011 |  |  |  |  |  |  |  |  |  |  |  |  | t Critical two-tail | 2.07961384472768
 |  | 18 | 50 | 0.058 | 0.027 | 0.027 | 0.023
 |  | 19 | 50 | 0.038 | 0.011 | 0.013 | 0.009 |  |  |  |  |  |  |  |  |  |  |  |  | t-Test: Two-Sample Assuming Equal Variances
 |  | 20 | 50 | 0.05 | 0.013 | 0.015 | 0.015 |  |  |  |  |  |  |  |  |  |  |  |  | (260/280 comparison i.e. J v's S. Only samples 5 - 62)
 |  | 21 | 50 | 0.082 | 0.004 | 0.008 | 0.011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Variable 1 | Variable 2
 |  | 22 | 50 | 0.034 | 0.01 | 0.011 | 0.012 |  |  |  |  |  |  |  |  |  |  |  |  | Mean | 1.200914372483 | 0.8317663817663817
 |  | 23 | 50 | 0.037 | 0.017 | 0.016 | 0.014 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.0480914274463593 | 0.159597904864999
 |  | 24 | 50 | 0.013 | 0.003 | 0.004 | 0.003 |  |  |  |  |  |  |  |  |  |  |  |  | Observations | 9 | 12
 |  | 25 | 50 | 0.042 | 0.018 | 0.018 | 0.015 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.1126478091097823
 |  | 26 | 50 | 0.019 | 0.007 | 0.008 | 0.007 |  |  |  |  |  |  |  |  |  |  |  |  | Hypothesized Mean Difference | 0
 |  | 27 | 50 | 0.036 | 0.018 | 0.018 | 0.015 |  |  |  |  |  |  |  |  |  |  |  |  | df | 19
 |  | 28 | 50 | 0.025 | 0.01 | 0.011 | 0.008 |  |  |  |  |  |  |  |  |  |  |  |  | t Stat | 2.49425794636373
 |  | 29 | 50 | 0.037 | 0.003 | 0.006 | 0.007 |  |  |  |  |  |  |  |  |  |  |  |  | P(T<=t) one-tail | 0.0110025355368311
 |  | 30 | 50 | 0.029 | 0.004 | 0.006 | 0.004 |  |  |  |  |  |  |  |  |  |  |  |  | t Critical one-tail | 1.72913281152137
 |  | 31 | 50 | 0.035 | 0.014 | 0.015 | 0.012 |  |  |  |  |  |  |  |  |  |  |  |  | P(T<=t) two-tail | 0.02200507107366219
 |  | 32 | 50 | 0.03 | 0.012 | 0.012 | 0.009 |  |  |  |  |  |  |  |  |  |  |  |  | t Critical two-tail | 2.09302405440831
 |  | 33 | 50 | 0.051 | 0.009 | 0.011 | 0.01
 |  | 34 | 50 | 0.035 | 0.011 | 0.013 | 0.01
 |  | 35 | 50 | 0.061 | 0.012 | 0.015 | 0.014
 |  | 36 | 50 | 0.052 | 0.009 | 0.012 | 0.011
 |  | 37 | 50 | 0.042 | 0.005 | 0.008 | 0.006
 |  | 38 | 50 | 0.038 | 0.011 | 0.012 | 0.01
 |  | 39 | 50 | 0.033 | 0.002 | 0.005 | 0.005
 |  | 40 | 50 | 0.031 | -0.001 | 0.003 | 0.004
 |  | 41 | 50 | 0.047 | 0.005 | 0.008 | 0.008
 |  | 42 | 50 | 0.039 | 0.014 | 0.017 | 0.011
 |  | 43 | 50 | 0.051 | 0.016 | 0.017 | 0.014
 |  | 44 | 50 | 0.041 | 0.008 | 0.011 | 0.009
 |  | 45 | 50 | 0.017 | -0.006 | -0.003 | -0.002
 |  | 46 | 50 | 0.05 | 0.012 | 0.014 | 0.012
 |  | 47 | 50 | 0.061 | 0.016 | 0.018 | 0.016
 |  | 48 | 50 | 0.052 | 0.006 | 0.009 | 0.008
 |  | 49 | 50 | 0.048 | 0.019 | 0.019 | 0.016
 |  | 50 | 50 | 0.038 | 0.011 | 0.012 | 0.011
 |  | 51 | 50 | 0.065 | 0.03 | 0.029 | 0.024
 |  | 52 | 50 | 0.042 | 0.018 | 0.019 | 0.014
 |  | 53 | 50 | 0.049 | 0.019 | 0.02 | 0.017
 |  | 54 | 50 | 0.034 | 0.016 | 0.016 | 0.013
 |  | 55 | 50 | 0.045 | 0.026 | 0.025 | 0.02
 |  | 56 | 50 | 0.031 | 0.008 | 0.009 | 0.008
 |  | 57 | 50 | 0.037 | 0.015 | 0.015 | 0.012
 |  | 58 | 50 | 0.038 | 0.007 | 0.009 | 0.008
 |  | 59 | 50 | 0.045 | 0.012 | 0.014 | 0.012
 |  | 60 | 50 | 0.062 | 0.023 | 0.024 | 0.02
 |  | 61 | 50 | 0.046 | 0.018 | 0.018 | 0.014
 |  | 62 | 50 | 0.04 | 0.021 | 0.02 | 0.015
 |  | 63 | 50 | 0.049 | 0.004 | 0.007 | 0.007
 |  |  | Median
 |  |  | STDEV
 |  |  | AV