Q test - UMdrive

Document Sample
Q test - UMdrive Powered By Docstoc
					                                             Measured                measured data + outlier
                                             data
slope           1    0.745098    0.659143         10.9        13.2        10.9       15.3      13.8
        0.2     2    0.804446     0.85761         11.3        13.2        11.3       15.3      13.8
                3    0.849277    1.033337         11.6        13.2        11.6       15.3      13.8
                4    0.737053    0.634287         11.4        13.2        11.4       15.3      13.8
                5    0.269984    -0.61286         10.4        13.2        10.4       15.3      13.8
                6     0.02434    -1.97139          9.2        13.2         9.2       15.3      13.8
                7    0.488955    -0.02769         11.4        13.2        11.4       15.3      13.8
                8    0.651047    0.388149         12.0        13.2        12.0       15.3      13.8
                9    0.347512    -0.39205         11.4        13.2         46.4      15.3      13.8
               10    0.823743    0.929724         12.9        13.2        12.9       15.3      13.8
               11    0.423151    -0.19384         12.0        13.2        12.0       15.3      13.8
               12    0.420383    -0.20091         12.2        13.2        12.2       15.3      13.8
               13    0.962837    1.784606         14.4        13.2        14.4       15.3      13.8
               14    0.940264    1.556997         14.4        13.2        14.4       15.3      13.8
               15    0.531481    0.078993         13.1        13.2        13.1       15.3      13.8
               16      0.3291      -0.4424        12.8        13.2        12.8       15.3      13.8
               17    0.949924     1.64412         15.0        13.2        15.0       15.3      13.8
               18    0.942681    1.577687         15.2        13.2         43.2      15.3      13.8
               19    0.433344    -0.16787         13.6        13.2        13.6       15.3      13.8
               20    0.072235    -1.45935         12.5        13.2        12.5       15.3      13.8
               21    0.501151    0.002886         14.2        13.2        14.2       15.3      13.8
               22    0.729371    0.610912         15.0        13.2        15.0       15.3      13.8
               23    0.334816    -0.42665         14.2        13.2        14.2       15.3      13.8
               24     0.15965      -0.9959        13.8        13.2        13.8       15.3      13.8
               25     0.11528    -1.19892         13.8        13.2        13.8       15.3      13.8
               26    0.657702    0.406199         15.6        13.2        15.6       15.3      13.8
               27    0.821613     0.92153         16.3        13.2        16.3       15.3      13.8
               28    0.641601    0.362741         16.0        13.2        16.0       15.3      13.8
               29    0.204534    -0.82554         15.0        13.2        15.0       15.3      13.8
                                                         median
                                mean             13.2                     15.3                  0.7
                                mean without the outliers                 13.1
                                median           13.1                     13.6
                                SD                1.8                      8.4
                                RMSD              1.0
               1.0
               2.0
               3.0        0.3         -0.4         9.8        10.7         9.8       11.3      12.2
               4.0        0.2         -0.9         9.5        10.7         9.5       11.3      12.2
               5.0        0.5          0.1        10.7        10.7        10.7       11.3      12.2
               6.0        0.9          1.1        11.9        10.7        11.9       11.3      12.2
               7.0        0.3         -0.5        10.5        10.7        10.5       11.3      12.2
               8.0        0.1         -1.2        10.0        10.7        10.0       11.3      12.2
               9.0        0.3         -0.4        11.0        10.7        11.0       11.3      12.2
              10.0        0.5         -0.1        11.5        10.7        11.5       11.3      12.2
0.1         -1.2       10.6       10.7   16.6   11.3   12.2
0.2         -0.8       11.2       10.7   11.2   11.3   12.2

      mean             10.7              11.3
      mean without the outliers          10.7
      sd                0.8               2.0
12.5   23.7   6.9   12.5    8.7   16.8   9.5
12.5   23.7   6.9   12.7    8.9   16.8   9.5   50.0
12.5   23.7   6.9   12.9    9.1   16.8   9.5   45.0
12.5   23.7   6.9   13.1    9.2   16.8   9.5   40.0
12.5   23.7   6.9   13.2    9.4   16.8   9.5   35.0
12.5   23.7   6.9   13.4    9.6   16.8   9.5   30.0
                                               25.0
12.5   23.7   6.9   13.6    9.8   16.8   9.5
                                               20.0
12.5   23.7   6.9   13.8   10.0   16.8   9.5   15.0
12.5   23.7   6.9   14.0   10.1   16.8   9.5   10.0
12.5   23.7   6.9   14.2   10.3   16.8   9.5    5.0
12.5   23.7   6.9   14.3   10.5   16.8   9.5    0.0
12.5   23.7   6.9   14.5   10.7   16.8   9.5          0     5
12.5   23.7   6.9   14.7   10.9   16.8   9.5
12.5   23.7   6.9   14.9   11.1   16.8   9.5
12.5   23.7   6.9   15.1   11.2   16.8   9.5
12.5   23.7   6.9   15.2   11.4   16.8   9.5   50.0
12.5   23.7   6.9   15.4   11.6   16.8   9.5   45.0
12.5   23.7   6.9   15.6   11.8   16.8   9.5   40.0
12.5   23.7   6.9   15.8   12.0   16.8   9.5   35.0
12.5   23.7   6.9   16.0   12.1   16.8   9.5   30.0
12.5   23.7   6.9   16.2   12.3   16.8   9.5
                                               25.0
12.5   23.7   6.9   16.3   12.5   16.8   9.5
12.5   23.7   6.9   16.5   12.7   16.8   9.5   20.0
12.5   23.7   6.9   16.7   12.9   16.8   9.5   15.0
12.5   23.7   6.9   16.9   13.1   16.8   9.5   10.0
12.5   23.7   6.9   17.1   13.2   16.8   9.5    5.0
12.5   23.7   6.9   17.2   13.4   16.8   9.5          0     5
12.5   23.7   6.9   17.4   13.6   16.8   9.5
12.5   23.7   6.9   17.6   13.8   16.8   9.5
                                               13.0
                                               12.0
                                               11.0
                                               10.0
                                                9.0
                                                8.0
                                                7.0
 9.1                                            6.0
 9.1                                            5.0
 9.1                                                  0.0
 9.1
 9.1
 9.1
 9.1
 9.1
9.1
9.1
                                                       19.0
                                                       17.0
                                                       15.0
                                                       13.0
                                                       11.0
                                                        9.0
                                                        7.0
                                                        5.0
5         10   15     20      25     30           35          0   5



                                                       25.0
                                                       23.0
                                                       21.0
                                                       19.0
                                                       17.0
                                                       15.0
                                                       13.0
                                                       11.0
                                             25         9.0
                                                        7.0
                                                        5.0
5         10   15     20      25     30           35          0   5




                                   Series3
                                   Series4
                                   Series1
                                   Series2
                                   Linear (Series3)


    5.0        10.0        15.0
0.0




      Linest   0.130324 9.957668
               0.077415 0.480345
               0.261584 0.703153
               2.834006        8
                 1.4012 3.95539
           μ=13.2±1.8


10   15   20    25      30   35




           μ=15.3±8.4

10   15   20     25     30   35
Linest
 0.182168   10.42381
 0.021258   0.365113
 0.731172   0.957778
 73.43607         27
 67.36576   24.76815

RMSD        0.957778
Carbohydrate content of glycoproteins                                             15.0


             Individual
             measurements       average     X+ts      x-ts      X+2s     X-2s     14.0
         1          12.6            12.5     13.04     12.04     13.35    11.73
         2          11.9            12.5     13.04     12.04     13.35    11.73
         3          13.0            12.5     13.04     12.04     13.35    11.73
         4          12.7            12.5     13.04     12.04     13.35    11.73   13.0
         5          12.5            12.5     13.04     12.04     13.35    11.73

mean                  12.54
sd                     0.40                                                       12.0
n                       5.0
df                      4.0
min                    11.9
                                                                                  11.0
max                    13.0
Range                   1.1

t95                   2.776                                                       10.0
                                                                                         0
        ts
                       0.50
         n


                               95% chance that average is between

         ts
 x        12.54  0.50        13.04
          n                        12.04
15.0




14.0




13.0




12.0




11.0




10.0
       0   1   2   3   4   5   6
Sample
              Absorbaces    in   three
mg            independent samples
                                           Range             Av. all                  Av.-red
          0     0.099    0.099       0.1            0.001     0.099333           0     0.099333
          5     0.185    0.187     0.188            0.003     0.186667           5     0.186667
         10     0.282    0.272     0.272             0.01     0.275333          10     0.275333
         15     0.392    0.345     0.347            0.047     0.361333          15         0.346
         20     0.425    0.425      0.43            0.005     0.426667          20     0.426667
         25     0.483    0.488     0.496            0.013         0.489                    0.489


         15     0.392


          0   0.09933                               A              c           c        % Err
          5   0.18667                             0.35          14.82       15.09       1.82
         10   0.27533                              0.2           5.78        5.89       1.82
         15   0.36133                             0.392         17.35       17.67       1.82
         20   0.42667

         25     0.489




                                           yhat
                          x         y     yequation (blue)   sy(hat)      Min         Max          snew
          1                    0   0.099      0.104           0.005871     0.091553    0.116447      0.01406
          2                    0   0.099      0.104           0.005871     0.091553    0.116447      0.01406
          3                    0      0.1     0.104           0.005871     0.091553    0.116447      0.01406
          4                    5   0.185      0.187           0.004401     0.177603    0.196264     0.013512
          5                    5   0.187      0.187           0.004401     0.177603    0.196264     0.013512
          6                    5   0.188      0.187           0.004401     0.177603    0.196264     0.013512
          7                   10   0.282      0.270           0.003439     0.262577    0.277156      0.01323
          8                   10   0.272      0.270           0.003439     0.262577    0.277156      0.01323
          9                   10   0.272      0.270           0.003439     0.262577    0.277156      0.01323
         10     0.346         15   0.392      0.353           0.003439     0.345511    0.360089      0.01323
         11                   15   0.345      0.353           0.003439     0.345511    0.360089      0.01323
12                    15   0.347      0.353      0.003439   0.345511   0.360089 0.01323
13                    20   0.425      0.436      0.004401   0.426403   0.445064 0.013512
14                    20   0.425      0.436      0.004401   0.426403   0.445064 0.013512
15                    20    0.43      0.436      0.004401   0.426403   0.445064 0.013512
16                    25   0.483      0.519      0.005871    0.50622   0.531113 0.01406
17                    25   0.488      0.519      0.005871    0.50622   0.531113 0.01406
18                    25   0.496      0.519      0.005871    0.50622   0.531113 0.01406
     Xmean          12.5           Linest
     sX           8.7867                 0.017      0.104
       2
     sX           77.206                 0.000      0.006
     sy.x         0.0128                0.990       0.013
     n                15             1264.327      13.000
     n-1              14                0.206       0.002
     t(0.05,13)   2.1199
                                               0.55
                                                                                  Questionable point
                                                0.5
                                               0.45
                                                0.4       Avarage with
                                                          questionable point

                                absorbance
                                               0.35
                                                                                            y = 0.0166x + 0.104
                                                0.3
                                               0.25
                                                0.2
                                               0.15
                                                0.1
                                               0.05
                                                      0                 10                    20                    30
                                                                               μg protein


                                               0.55
                                                                                   Questionable point
                                                0.5
                                               0.45
                                                0.4       Avarage with
                                                          questionable point
                                absorbance




                                               0.35
                                                0.3                                            Avarage without
                                                                                               questionable point
                                               0.25
                                                0.2
                                               0.15
                                                                                            y = 0.0163x + 0.104
                                                0.1

Min         Max                                0.05
                                                      0        5         10         15        20        25          30
 0.074195    0.133805
 0.074195    0.133805                                                          μg protein
 0.074195    0.133805
 0.158289    0.215577
 0.158289    0.215577
                                             0.55
 0.158289    0.215577
 0.241821    0.297912                         0.5
 0.241821    0.297912                        0.45
 0.241821    0.297912
 0.324754    0.380846                         0.4
                        Absorbance




 0.324754    0.380846                        0.35
                        Absorbance
                                     0.35
0.324754   0.380846                   0.3
0.407089   0.464377
0.407089   0.464377                  0.25
0.407089   0.464377                   0.2
0.488862   0.548472
0.488862   0.548472
                                     0.15
0.488862   0.548472                   0.1
                                     0.05
                                            0       5        10        15          20           25          30
                                                                   mg protein



                                     0.44
                                     0.42
                                      0.4
                                     0.38
                      Absorbance




                                     0.36
                                     0.34
                                     0.32
                                      0.3
                                     0.28
                                     0.26
                                     0.24
                                            7   8       9   10    11   12     13    14         15    16     17
                                                                   mg protein


                            A                  c       c
                           0.35             14.82   15.09                   14.4        14.8         15.3
                           0.2               5.78    5.89                   14.9        15.1         15.3
                          0.392             17.35   17.67



                                     0.39

                                     0.37

                                     0.35
                      Absorbance
Absorbance
             0.33

             0.31

             0.29

             0.27
                    12   13   14        15   16   17
                               mg protein
30




30
30




17
17
Q test

Spectrophotometric determination of proteins
                              Measured data
                              without "assumed"
             Measured data outlier
                   12.53                     12.53
                                                                                                 Q test
                   12.56                     12.56
                   12.47                     12.47
                                                                     12.70
                   12.67
                   12.48                     12.48                   12.65


mean                   12.54                 12.51                   12.60

SD                      0.08                  0.04                   12.55

                                                                     12.50
is 12.67 an outlier?
                                                                     12.45
                                                                             0      1        2        3
Sort                                  gap
                                                                                                 # repetition
                           12.47
                           12.48                        0.01
                           12.53                        0.05
                           12.56                        0.03

                           12.67                        0.11

Range                          0.20                                                   Q     # of oserv.
                                                                                 90%
                                                                                 confidence
Q=gap/range                    0.55         0.55<0.64                               0.76             4
                                                                                    0.64             5
If Q(obs)>Q(tab) the point can be discarded                                         0.56             6
                                                                                    0.51             7
                                      0.55 should NOT be discarded                  0.47             8
                                                                                    0.44             9
                                                                                    0.41            10

                                                                                 Dean, R.B.,Dixon, W.J. Anal. Chem. 1
                                                                                 Rorabacher, D.R., Anal. Chem. 1991,
                   4    5       6

    # repetition




Dixon, W.J. Anal. Chem. 1951, 23, 636
, D.R., Anal. Chem. 1991, 63, 139
SUMMARY OUTPUT

       Regression Statistics
Multiple R                0.883215
R Square                  0.780069
Adjusted R Square         0.771924
Standard Error            0.917922
Observations                    29

ANOVA
                           df        SS       MS        F   Significance F
Regression                       1 80.69061 80.69061 95.76598 2.25E-10
Residual                        27 22.74969 0.842581
Total                           28 103.4403

                                 Standard Error t Stat
                       Coefficients                    P-value Lower 95%Upper 95%
Intercept               10.14252 0.34992 28.98525 7.04E-22 9.424543 10.8605
X Variable 1            0.199372 0.020373 9.78601 2.25E-10 0.157569 0.241174




RESIDUAL OUTPUT                                                PROBABILITY OUTPUT

     Observation                        Standard Residuals
                      Predicted Y Residuals                    Percentile       Y
                     1 10.34189 1.600637 1.644711               1.724138     10.24247
                     2 10.54126 -1.55881 -1.60173               5.172414     10.31535
                     3 10.74063 -0.56316 -0.57867                8.62069     10.99862
                     4 10.94001 -0.23749 -0.24402               12.06897     11.29955
                     5 11.13938 -1.14798 -1.17959               15.51724     11.34524
                     6 11.33875 1.935954 1.989261               18.96552     11.62557
                     7 11.53812 0.066052 0.06787                22.41379     11.74551
                     8 11.73749 -0.02408 -0.02474               25.86207     11.95207
                     9 11.93686 -0.35849 -0.36836               29.31034     12.29519
                    10 12.13624 -1.54356 -1.58606               32.75862     12.55863
                    11 12.33561 -1.23237 -1.26631                36.2069     12.64401
                    12 12.53498 -1.43975 -1.47939               39.65517     12.65156
                    13 12.73435 0.017001 0.017469               43.10345     12.86737
                    14 12.93372 -0.85475 -0.87829               46.55172     12.93875
                    15 13.13309 -1.26871 -1.30364                     50      13.3173
                    16 13.33247 0.172553 0.177304               53.44828     13.33192
                    17 13.53184 -1.06365 -1.09294               56.89655     13.60128
                    18 13.73121 -1.64029 -1.68546               60.34483     13.80113
                    19 13.93058 0.653201 0.671187                63.7931     13.80376
                    20 14.12995 0.112193 0.115283               67.24138     13.85019
                    21 14.32932 -1.39183 -1.43015               70.68966     14.44998
                    22 14.5287 0.128407 0.131943                74.13793     14.77259
23   14.72807 -0.24999 -0.25688    77.58621   14.83321
24   14.92744 -0.16838 -0.17302    81.03448   15.17085
25   15.12681 0.166414 0.170996    84.48276   15.39643
26   15.32618 -0.90746 -0.93245    87.93103   15.52514
27   15.52555 -0.10978   -0.1128   91.37931   15.76179
28   15.72493 0.376468 0.386834    94.82759    16.1525
29    15.9243 -0.54737 -0.56244    98.27586   17.18755
          0.917922
         R




                  U
        Lower 95.0%pper 95.0%
          9.424543 10.8605
                                                                  X Variable 1 Residual Plot
          0.157569 0.241174                                   Normal Probability Plot
                                                   3             X Variable 1 Line Fit Plot
                                                   2
                                         Residuals



                                    20             1
                                    15           20.0
                                                   0
LITY OUTPUT                         10           15.0                                                Y
                                                  -1 0                10            20          30
                                Y




                                                 10.0
                                         Y




                                     5            -2                                                 Predicted Y
                                     0            5.0
                                                     0.0 20                    X Variable 1
                                         0                          40      60       80       100    120
                                                         0         10       20        30       40
                                                                     Sample Percentile
                                                                       X Variable 1
Y        40
Predicted Y

120

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:2/27/2012
language:
pages:27