Docstoc

Mann-Kendall_7_year

Document Sample
Mann-Kendall_7_year Powered By Docstoc
					Note to User:

IDEM is not responsible for any errors that might occur through the use
of this spreadsheet. The user is entirely responsible for the accuracy
of the calculations and results produced by this spreadsheet.
hrough the use
 he accuracy
Mann Kendall Trend Evaluation
               Contaminant:                Benzene

Monitoring Inputs                                                                                                                    Mann-Kendall Results
                                                                                                                                                                                                                                                                                                                                               Mess1 - Benzene
Quarter        Mess1          Mess2        POC1                             POC2                 POC3                                0-8 Quarter Evaluation                                                      12 Quarter Evaluation
               ug/l           ug/l         ug/l                             ug/l                 ug/l                                Mess1 Increasing                                                            Mess1 Increasing                                                                0.016




                                                                                                                                                                                                                                                                          Concentration (ug/l)
          1              0           4.7              0                             0.099                       0                    Mess2 Decreasing                                                            Mess2 Decreasing                                                                0.014
                                                                                                                                                                                                                                                                                                 0.012
          2              0           3.9              0                             0.027                       0                    POC1 Increasing                                                             POC1 Stable/No Trend                                                             0.01
                                                                                                                                                                                                                                                                                                 0.008
          3              0           1.1              0                             0.011                       0                    POC2 Stable/No Trend                                                        POC2 Increasing                                                                 0.006
                                                                                                                                                                                                                                                                                                 0.004
          4            0             4.2      0.0092                               0.0096                    0                       POC3 Increasing                                                             POC3 Increasing                                                                 0.002
          5       0.0075             3.1       0.021                                    4                0.048                                                                                                                                                                                       0
                                                                                                                                                                                                                                                                                                                   1       2       3       4       5        6       7       8       9 10 11 12 13 14 15 16
          6         0.01             3.1       0.032                                  2.1                0.045                       5-12 Quarter Evaluation                                                     16 Quarter Evaluation
          7           0.011          2.7          0.026                                 1.9              0.038                       Mess1 Stable/No Trend                                                       Mess1 Stable/No Trend                                                                                                                     Quarters (1/4 years)

          8           0.009          2.6          0.028                                 1.8              0.039                       Mess2 Decreasing                                                            Mess2 Decreasing
          9           0.012          2.5           0.13                                 2.5              0.082                       POC1 Stable/No Trend                                                        POC1 Increasing                                                                                                               Mess2 - Benzene
          10             0           2.2              0                                      3                  0                    POC2 Stable/No Trend                                                        POC2 Increasing                                                                  5

          11          0.014          2.2          0.059                                 2.5              0.074                       POC3 Stable/No Trend                                                        POC3 Increasing                                                                 4.5




                                                                                                                                                                                                                                                                          Concentration (ug/l)
                                                                                                                                                                                                                                                                                                  4
          12              0          2.3              0                                 3.1              0.069                                                                                                                                                                                   3.5

          13              0            0              0                                   0                  0                       9-16 Quarter Evaluation                                                     7 Year Evaluation                                                                3
                                                                                                                                                                                                                                                                                                 2.5
          14          0.002           2            355                                  210                   350                    Mess1 Stable/No Trend                                                       Mess1 Stable/No Trend                                                            2

          15          0.001           1            200                                  320                   420                    Mess2 Decreasing                                                            (See 7 year sheet for chart)                                                    1.5
                                                                                                                                                                                                                                                                                                  1

          16          0.002           2            360                                  240                   370                    POC1 Increasing                                                                                                                                             0.5
                                                                                                                                                                                                                                                                                                  0
                                                                                                                                     POC2 Increasing                                                                                                                                                       1       2       3       4       5       6            7       8       9    10   11   12   13   14   15   16


                              Data Entry Cell                                                                                        POC3 Increasing                                                                                                                                                                                               Quarters (1/4 years)



                                                                                                              POC1 - Benzene                                                                                      POC2 - Benzene                                                                                                               POC3 - Benzene
Mess1 - Benzene
Mess2 - Benzene                                                                                                                                                                                                                                                                                   500
                                                                            400
POC1 - Benzene




                                                                                                                                                                                                                                                                          Concentration (ug/l)
                                                                            350




                                                                                                                                                                   Concentration (ug/l)
                                                     Concentration (ug/l)




                                                                                                                                                                                          350                                                                                                     400
POC2 - Benzene                                                              300                                                                                                           300
                                                                                                                                                                                                                                                                                                  300
                                                                            250                                                                                                           250
POC3 - Benzene                                                                                                                                                                            200
                                                                            200                                                                                                                                                                                                                   200
                                                                                                                                                                                          150
                                                                            150
                                                                                                                                                                                          100                                                                                                     100
                                                                            100
                                                                                                                                                                                           50
                                                                             50                                                                                                                                                                                                                        0
                                                                                                                                                                                            0
                                                                                                                                                                                                                                                                                                               1       2       3       4       5       6        7       8       9    10   11   12   13   14   15   16
                                                                              0                                                                                                            -50   1   2   3   4    5    6   7   8   9   10   11   12   13   14   15   16
                                                                                                                                                                                                                                                                                                 -100
                                                                                    1    2       3   4    5     6   7   8   9   10   11   12   13   14   15   16                          -100
                                                                             -50
                                                                                                                                                                                                                                                                                                 -200
                                                                            -100                                                                                                                                      Quarters (1/4 Years)
                                                                                                              Quarters (1/4 years)                                                                                                                                                                                                                 Quarters (1/4 Years)




      USER NOTES:
      This spreadsheet is to be used with the RISC Technical Guide Appendix 3 Stability Monitoring guidelines. The Mann-Kendall
      trend test** is executed and results are shown for 1 chemical and 5 wells. As stated in the RISC policy, the test should be executed
      on quarters 0 thru 8, 5 thru 12, 9 thru 16, 0 thru 12, and 0 thru 16. The 7 year evaluation is also executed on the 7 Year tab.
      This sheet performed these tests and shows results on each tab below.

      * Except for the 7 Year sheet, data entry is only needed on the Data Entry sheet. The data entry cells are yellow. The calculation sheets
      are automatically linked and results are sent to this Data Entry sheet. Data entry for the 7 year test is on the 7 year sheet. Results from
      all evaluations are shown under Mann-Kendall Results above. A result of stable means there is no upward trend at that well.
      A result of expanding means that a trend exists at the well. Results are used with the RISC policy to assess closure or further action at the site.

      * The 8 quarter evaluations (0-8, 5-12, & 8-16) use an "s" value of 10, which corresponds to a false positive alpha of 10%**.
      * The 12, 16, and 28 (7 year) quarter evaluations use an alpha of 5%.
      * The 12, 16, and 28 quarter evaluations have a 6 duplicate value limit. So, if the same number is entered 7 or more times, the test is invalid.
        The user should use the most accurate values possible so that the duplicates are minimized.

      ** FROM: EPA Practical Methods for Data Analysis, EPA QA/G-9 QA00 UPDATE, July 2000, Section 4.3.4.

      Note that the user is responsible for all results on this sheet. IDEM is not responsible for any errors as a result of using this sheet.
Mann-Kendall Trend: Quarters 0-8
              Contaminant:        Benzene

Mess1
                                            Mann-Kendall Trend: Quarters 0-8
                                            Quarter          1          2        3         4         5
S Value                                     Data             0          0        0         0    0.0075
Neg           Pos                                    0                  0        0         0    0.0075
          2                  20                      0                           0         0    0.0075
S Value                      18                      0                                     0    0.0075
Evaluation Increasing                                0                                          0.0075
                                               0.0075
                                                  0.01
                                                 0.011
                                                 0.009



Mess2                                       Mann-Kendall Trend: Quarters 0-8
                                            Quarter           1         2         3         4        5
S Value                                     Data            4.7       3.9       1.1       4.2      3.1
Neg        Pos                                     4.7               -0.8      -3.6      -0.5     -1.6
        21                 6                       3.9                         -2.8       0.3     -0.8
S Value                  -15                       1.1                                    3.1        2
Evaluation Decreasing                              4.2                                            -1.1
                                                   3.1
                                                   3.1
                                                   2.7
                                                   2.6



POC1                                        Mann-Kendall Trend: Quarters 0-8
                                            Quarter          1          2        3         4         5
S Value                                     Data             0          0        0    0.0092     0.021
Neg           Pos                                    0                  0        0    0.0092     0.021
          2                  23                      0                           0    0.0092     0.021
S Value                      21                      0                                0.0092     0.021
Evaluation Increasing                          0.0092                                           0.0118
                                                 0.021
                                                 0.032
                                                 0.026
                                                 0.028



POC2                                        Mann-Kendall Trend: Quarters 0-8
                                            Quarter           1         2         3         4        5
S Value                                     Data          0.099     0.027     0.011    0.0096        4
Neg        Pos                                   0.099             -0.072    -0.088   -0.0894    3.901
        12                   16                  0.027                       -0.016   -0.0174    3.973
S Value                       4                  0.011                                -0.0014    3.989
Evaluation Stable/No Trend      0.0096                                  3.9904
                                      4
                                    2.1
                                    1.9
                                    1.8



POC3                         Mann-Kendall Trend: Quarters 0-8
                             Quarter          1          2      3   4        5
S Value                      Data             0          0      0   0    0.048
Neg           Pos                     0                  0      0   0    0.048
          5             17            0                         0   0    0.048
S Value                 12            0                             0    0.048
Evaluation Increasing                 0                                  0.048
                                  0.048
                                  0.045
                                  0.038
                                  0.039
      6        7         8
   0.01    0.011     0.009
   0.01    0.011     0.009
   0.01    0.011     0.009
   0.01    0.011     0.009
   0.01    0.011     0.009
0.0025    0.0035    0.0015
           0.001    -0.001
                    -0.002




      6        7         8
    3.1      2.7       2.6
   -1.6       -2      -2.1
   -0.8     -1.2      -1.3
      2      1.6       1.5
   -1.1     -1.5      -1.6
      0     -0.4      -0.5
            -0.4      -0.5
                      -0.1




     6         7         8
 0.032     0.026     0.028
 0.032     0.026     0.028
 0.032     0.026     0.028
 0.032     0.026     0.028
0.0228    0.0168    0.0188
 0.011     0.005     0.007
          -0.006    -0.004
                     0.002




      6         7         8
    2.1       1.9       1.8
 2.001     1.801     1.701
 2.073     1.873     1.773
 2.089     1.889     1.789
2.0904    1.8904    1.7904
   -1.9      -2.1      -2.2
             -0.2      -0.3
                       -0.1




     6         7         8
 0.045     0.038     0.039
 0.045     0.038     0.039
 0.045     0.038     0.039
 0.045     0.038     0.039
 0.045     0.038     0.039
-0.003     -0.01    -0.009
          -0.007    -0.006
                     0.001
Mann-Kendall Trend: Quarters 5-12
          Contaminant:         Benzene

Mess1
                                         Mann-Kendall Trend: Quarters 5-12
                                         Quarter          1          2          3        4        5          6        7          8
S Value                                  Data        0.0075       0.01      0.011    0.009    0.012          0    0.014          0
Neg        Pos                              0.0075             0.0025      0.0035   0.0015   0.0045   -0.0075    0.0065   -0.0075
        13               14                    0.01                         0.001   -0.001    0.002      -0.01    0.004      -0.01
S Value                   1                   0.011                                 -0.002    0.001    -0.011     0.003    -0.011
Evaluation Stable/No Trend                    0.009                                           0.003    -0.009     0.005    -0.009
                                              0.012                                                    -0.012     0.002    -0.012
                                                  0                                                               0.014          0
                                              0.014                                                                        -0.014
                                                  0



Mess2                                    Mann-Kendall Trend: Quarters 5-12
                                         Quarter           1         2          3        4        5         6         7         8
S Value                                  Data            3.1       3.1        2.7      2.6      2.5       2.2       2.2       2.3
Neg        Pos                                  3.1                  0       -0.4     -0.5     -0.6      -0.9      -0.9      -0.8
        24                 2                    3.1                          -0.4     -0.5     -0.6      -0.9      -0.9      -0.8
S Value                  -22                    2.7                                   -0.1     -0.2      -0.5      -0.5      -0.4
Evaluation Decreasing                           2.6                                            -0.1      -0.4      -0.4      -0.3
                                                2.5                                                      -0.3      -0.3      -0.2
                                                2.2                                                                   0       0.1
                                                2.2                                                                           0.1
                                                2.3



POC1                                     Mann-Kendall Trend: Quarters 5-12
                                         Quarter           1         2          3        4        5         6         7         8
S Value                                  Data          0.021    0.032       0.026    0.028     0.13         0     0.059         0
Neg        Pos                                0.021             0.011       0.005    0.007    0.109    -0.021     0.038    -0.021
        14               13                   0.032                        -0.006   -0.004    0.098    -0.032     0.027    -0.032
S Value                  -1                   0.026                                  0.002    0.104    -0.026     0.033    -0.026
Evaluation Stable/No Trend                    0.028                                           0.102    -0.028     0.031    -0.028
                                               0.13                                                     -0.13    -0.071     -0.13
                                                  0                                                               0.059         0
                                              0.059                                                                        -0.059
                                                  0



POC2                                     Mann-Kendall Trend: Quarters 5-12
                                         Quarter          1          2          3        4        5         6         7         8
S Value                                  Data             4        2.1        1.9      1.8      2.5         3       2.5       3.1
Neg        Pos                                    4               -1.9       -2.1     -2.2     -1.5        -1      -1.5      -0.9
        11               16                     2.1                          -0.2     -0.3      0.4       0.9       0.4         1
S Value                   5                     1.9                                   -0.1      0.6       1.1       0.6       1.2
Evaluation Stable/No Trend                      1.8                                             0.7       1.2       0.7       1.3
                                                2.5                                                       0.5         0       0.6
                                                  3                                                                -0.5       0.1
                                                2.5                                                                           0.6
                                                3.1



POC3                                     Mann-Kendall Trend: Quarters 5-12
                                         Quarter           1         2          3        4        5         6         7         8
S Value                                  Data          0.048    0.045       0.038    0.039    0.082         0     0.074     0.069
Neg        Pos                                0.048            -0.003       -0.01   -0.009    0.034    -0.048     0.026     0.021
        13               15                   0.045                        -0.007   -0.006    0.037    -0.045     0.029     0.024
S Value                   2                   0.038                                  0.001    0.044    -0.038     0.036     0.031
Evaluation Stable/No Trend                    0.039                                           0.043    -0.039     0.035      0.03
                                              0.082                                                    -0.082    -0.008    -0.013
                                                  0                                                               0.074     0.069
                                              0.074                                                                        -0.005
                                              0.069
Mann-Kendall Trend: Quarters 9-16
              Contaminant:         Benzene

Mess1
                                             Mann-Kendall Trend: Quarters 9-16
                                             Quarter           1         2         3         4        5
S Value                                      Data          0.012         0     0.014         0        0
Neg        Pos                                    0.012             -0.012     0.002    -0.012   -0.012
        12               12                           0                        0.014         0        0
S Value                   0                       0.014                                 -0.014   -0.014
Evaluation Stable/No Trend                            0                                               0
                                                      0
                                                  0.002
                                                  0.001
                                                  0.002



Mess2                                        Mann-Kendall Trend: Quarters 9-16
                                             Quarter           1         2          3        4        5
S Value                                      Data            2.5       2.2        2.2      2.3        0
Neg        Pos                                      2.5               -0.3       -0.3     -0.2     -2.5
        20                     6                    2.2                             0      0.1     -2.2
S Value                      -14                    2.2                                    0.1     -2.2
Evaluation Decreasing                               2.3                                            -2.3
                                                      0
                                                      2
                                                      1
                                                      2



POC1                                         Mann-Kendall Trend: Quarters 9-16
                                             Quarter           1         2          3        4        5
S Value                                      Data           0.13         0      0.059        0        0
Neg           Pos                                  0.13              -0.13     -0.071    -0.13    -0.13
          7                  18                       0                         0.059        0        0
S Value                      11                   0.059                                 -0.059   -0.059
Evaluation Increasing                                 0                                               0
                                                      0
                                                    355
                                                    200
                                                    360



POC2                                         Mann-Kendall Trend: Quarters 9-16
                                             Quarter           1         2          3        4        5
S Value                                      Data            2.5         3        2.5      3.1        0
Neg           Pos                                   2.5                0.5          0      0.6     -2.5
          6                  21                       3                          -0.5      0.1       -3
S Value                      15                     2.5                                    0.6     -2.5
Evaluation Increasing               3.1                                            -3.1
                                      0
                                   210
                                   320
                                   240



POC3                         Mann-Kendall Trend: Quarters 9-16
                             Quarter           1         2          3        4        5
S Value                      Data          0.082         0      0.074    0.069        0
Neg           Pos                 0.082             -0.082     -0.008   -0.013   -0.082
          8             19            0                         0.074    0.069        0
S Value                 11        0.074                                 -0.005   -0.074
Evaluation Increasing             0.069                                          -0.069
                                      0
                                    350
                                    420
                                    370
      6         7         8
  0.002     0.001     0.002
  -0.01    -0.011     -0.01
  0.002     0.001     0.002
 -0.012    -0.013    -0.012
  0.002     0.001     0.002
  0.002     0.001     0.002
           -0.001         0
                      0.001




      6         7         8
      2         1         2
   -0.5      -1.5      -0.5
   -0.2      -1.2      -0.2
   -0.2      -1.2      -0.2
   -0.3      -1.3      -0.3
      2         1         2
               -1         0
                          1




      6         7         8
    355       200       360
 354.87    199.87    359.87
    355       200       360
354.941   199.941   359.941
    355       200       360
    355       200       360
             -155         5
                        160




      6         7         8
    210       320       240
  207.5     317.5     237.5
    207       317       237
  207.5     317.5     237.5
  206.9     316.9     236.9
    210       320       240
              110        30
                        -80




      6         7         8
    350       420       370
349.918   419.918   369.918
    350       420       370
349.926   419.926   369.926
349.931   419.931   369.931
    350       420       370
               70        20
                        -50
Mann-Kendall Trend: 12 Quarters
                           Contamiant:            Benzene

Mess1
                                                                                     Mann-Kendall Trend: Samples > 1
Evaluation                                                                           Quarter          1
V(S)                               184.3333333                                       Data             0
Z Well                             1.767703018                                                0
Zalpha                                    1.645             Formula       Wp                  0
Stable/No Trend/Exp        Increasing                                 0          0            0
                                                                      0          0            0
S Value                                                               0          0      0.0075
Neg                        Pos                                        0          0         0.01
                      13                    38                        0          0        0.011
S Value                                     25                        0          0        0.009
                                                                      0          0        0.012
                                                                      0          0            0
Count matches                                                         0          0        0.014
2 limit = 3                                  1                        0          0            0
3 limit = 3                                  1                        0          0
4 limit = 3                                  1                        6        510
5 limit = 2                                  1                        0          0
6 limit = 2                                  1              SUM                510            # 0s



Mess2
                                                                                     Mann-Kendall Trend: Samples > 1
Evaluation                                                                           Quarter           1
V(S)                              210.6666667                                        Data            4.7
Z Well                           -2.824788555                                               4.7
Zalpha                                   1.645              Formula       Wp                3.9
Stable/No Trend/Exp        Decreasing                                 2        18           1.1
                                                                      2        18           4.2
S Value                                                               0         0           3.1
Neg                        Pos                                        0         0           3.1
                      52                    12                        0         0           2.7
S Value                                    -40                        0         0           2.6
                                                                      0         0           2.5
                                                                      0         0           2.2
Count matches                                                         0         0           2.2
2 limit = 3                                  2                        0         0           2.3
3 limit = 3                                  0                        0         0
4 limit = 3                                  0                        0         0
5 limit = 2                                  0                        0         0
6 limit = 2                                  0              SUM                36             # 0s



POC1
                                                                                     Mann-Kendall Trend: Samples > 1
Evaluation                                                                 Quarter             1
V(S)                                        196                            Data                0
Z Well                             1.642857143                                      0
Zalpha                                    1.645   Formula       Wp                  0
Stable/No Trend/Exp        Stable/No Trend                  0          0            0
                                                            0          0      0.0092
S Value                                                     0          0       0.021
Neg                        Pos                              0          0       0.032
                      16                    40              0          0       0.026
S Value                                     24              0          0       0.028
                                                            0          0         0.13
                                                            0          0            0
Count matches                                               0          0       0.059
2 limit = 3                                  1              0          0            0
3 limit = 3                                  1              5        300
4 limit = 3                                  1              0          0
5 limit = 2                                  1              0          0
6 limit = 2                                  0    SUM                300                # 0s



POC2
                                                                           Mann-Kendall Trend: Samples > 1
Evaluation                                                                 Quarter           1
V(S)                               211.6666667                             Data          0.099
Z Well                              2.06203019                                  0.099
Zalpha                                    1.645   Formula       Wp              0.027
Stable/No Trend/Exp        Increasing                       2        18         0.011
                                                            0         0       0.0096
S Value                                                     0         0              4
Neg                        Pos                              0         0            2.1
                      17                    48              0         0            1.9
S Value                                     31              0         0            1.8
                                                            0         0            2.5
                                                            0         0              3
Count matches                                               0         0            2.5
2 limit = 3                                  1              0         0            3.1
3 limit = 3                                  0              0         0
4 limit = 3                                  0              0         0
5 limit = 2                                  0              0         0
6 limit = 2                                  0    SUM                18                 # 0s



POC3
                                                                           Mann-Kendall Trend: Samples > 1
Evaluation                                                                 Quarter          1
V(S)                                        196                            Data             0
Z Well                             2.071428571                                     0
Zalpha                                    1.645   Formula       Wp                 0
Stable/No Trend/Exp        Increasing                       0         0            0
                                                            0         0            0
S Value                               0     0   0.048
Neg                  Pos              0     0   0.045
                13         43         0     0   0.038
S Value                    30         0     0   0.039
                                      0     0   0.082
                                      0     0       0
Count matches                         0     0   0.074
2 limit = 3                1          0     0   0.069
3 limit = 3                1          5   300
4 limit = 3                1          0     0
5 limit = 2                1          0     0
6 limit = 2                0    SUM       300           # 0s
ndall Trend: Samples > 10, Normal Approx:
                    2         3        4         5         6        7        8        9         10
                    0         0        0    0.0075      0.01    0.011    0.009    0.012          0
                    0         0        0    0.0075      0.01    0.011    0.009    0.012          0
                              0        0    0.0075      0.01    0.011    0.009    0.012          0
                                       0    0.0075      0.01    0.011    0.009    0.012          0
                                            0.0075      0.01    0.011    0.009    0.012          0
                                                     0.0025    0.0035   0.0015   0.0045   -0.0075
                                                                0.001   -0.001    0.002      -0.01
                                                                        -0.002    0.001    -0.011
                                                                                  0.003    -0.009
                                                                                           -0.012




                   1         2         3        0         0        0        0        0          4




ndall Trend: Samples > 10, Normal Approx:
                    2          3        4        5         6        7        8        9        10
                  3.9        1.1      4.2      3.1       3.1      2.7      2.6      2.5       2.2
                 -0.8       -3.6     -0.5     -1.6      -1.6       -2     -2.1     -2.2      -2.5
                            -2.8      0.3     -0.8      -0.8     -1.2     -1.3     -1.4      -1.7
                                      3.1        2         2      1.6      1.5      1.4       1.1
                                              -1.1      -1.1     -1.5     -1.6     -1.7        -2
                                                           0     -0.4     -0.5     -0.6      -0.9
                                                                 -0.4     -0.5     -0.6      -0.9
                                                                          -0.1     -0.2      -0.5
                                                                                   -0.1      -0.4
                                                                                             -0.3




                   0         0         0        0         1        0        0        0          0




ndall Trend: Samples > 10, Normal Approx:
                   2         3         4         5        6         7         8          9         10
                   0         0    0.0092     0.021    0.032     0.026     0.028       0.13          0
                   0         0    0.0092     0.021    0.032     0.026     0.028       0.13          0
                             0    0.0092     0.021    0.032     0.026     0.028       0.13          0
                                  0.0092     0.021    0.032     0.026     0.028       0.13          0
                                            0.0118   0.0228    0.0168    0.0188    0.1208    -0.0092
                                                      0.011     0.005     0.007     0.109     -0.021
                                                               -0.006    -0.004     0.098     -0.032
                                                                          0.002     0.104     -0.026
                                                                                    0.102     -0.028
                                                                                                -0.13




                   1         2         0        0         0         0         0         0          3




ndall Trend: Samples > 10, Normal Approx:
                     2         3        4        5         6         7         8         9        10
                 0.027     0.011   0.0096        4       2.1       1.9       1.8       2.5         3
                -0.072    -0.088  -0.0894    3.901    2.001     1.801     1.701     2.401     2.901
                          -0.016  -0.0174    3.973    2.073     1.873     1.773     2.473     2.973
                                  -0.0014    3.989    2.089     1.889     1.789     2.489     2.989
                                            3.9904   2.0904    1.8904    1.7904    2.4904    2.9904
                                                        -1.9      -2.1      -2.2      -1.5        -1
                                                                  -0.2      -0.3       0.4       0.9
                                                                            -0.1       0.6       1.1
                                                                                       0.7       1.2
                                                                                                 0.5




                   0         0         0        0         0         0         0         0          0




ndall Trend: Samples > 10, Normal Approx:
                    2         3        4         5        6         7         8         9         10
                    0         0        0     0.048    0.045     0.038     0.039     0.082          0
                    0         0        0     0.048    0.045     0.038     0.039     0.082          0
                              0        0     0.048    0.045     0.038     0.039     0.082          0
                                       0     0.048    0.045     0.038     0.039     0.082          0
                                             0.048    0.045     0.038     0.039     0.082          0
                -0.003    -0.01   -0.009   0.034   -0.048
                         -0.007   -0.006   0.037   -0.045
                                   0.001   0.044   -0.038
                                           0.043   -0.039
                                                   -0.082




1   2   3   0       0        0        0       0        4
    11         12
 0.014          0
 0.014          0
 0.014          0
 0.014          0
 0.014          0
0.0065   -0.0075
 0.004      -0.01
 0.003    -0.011
 0.005    -0.009
 0.002    -0.012
 0.014          0
          -0.014




    0          5




    11        12
   2.2       2.3
  -2.5      -2.4
  -1.7      -1.6
   1.1       1.2
    -2      -1.9
  -0.9      -0.8
  -0.9      -0.8
  -0.5      -0.4
  -0.4      -0.3
  -0.3      -0.2
     0       0.1
             0.1




    1          0
    11          12
 0.059           0
 0.059           0
 0.059           0
 0.059           0
0.0498    -0.0092
 0.038     -0.021
 0.027     -0.032
 0.033     -0.026
 0.031     -0.028
-0.071       -0.13
 0.059           0
           -0.059




     0          4




     11        12
    2.5       3.1
 2.401     3.001
 2.473     3.073
 2.489     3.089
2.4904    3.0904
   -1.5      -0.9
    0.4         1
    0.6       1.2
    0.7       1.3
      0       0.6
   -0.5       0.1
              0.6




     1          0




    11         12
 0.074      0.069
 0.074      0.069
 0.074      0.069
 0.074      0.069
 0.074      0.069
 0.026    0.021
 0.029    0.024
 0.036    0.031
 0.035     0.03
-0.008   -0.013
 0.074    0.069
         -0.005




    0        0
Mann-Kendall Trend: 16 Quarters
                           Contaminant:          Benzene

Mess1
                                                                      Mann-Kendall Trend: Samples > 10,   Normal Approx:
Evaluation                                                            Quarter    1      2      3          4      5       6     7      8      9             10     11         12       13       14       15       16
V(S)                                       464                        Data       0      0      0          0 0.0075   0.01 0.011 0.009 0.012                 0 0.014           0        0    0.002    0.001    0.002
Z Well                            0.974900525                              0            0      0          0 0.0075   0.01 0.011 0.009 0.012                 0 0.014           0        0    0.002    0.001    0.002
Zalpha                                   1.645        Formula Wp           0                   0          0 0.0075   0.01 0.011 0.009 0.012                 0 0.014           0        0    0.002    0.001    0.002
Stable/No Trend/Exp        Stable/No Trend                  2    18        0                              0 0.0075   0.01 0.011 0.009 0.012                 0 0.014           0        0    0.002    0.001    0.002
                                                            0     0        0                                0.0075   0.01 0.011 0.009 0.012                 0 0.014           0        0    0.002    0.001    0.002
S Value                                                     0     0   0.008                                        0.0025 0.0035 0.0015 0.0045         -0.008 0.0065     -0.008   -0.008   -0.006   -0.007   -0.006
Neg                        Pos                              0     0    0.01                                                0.001 -0.001 0.002           -0.01 0.004       -0.01    -0.01   -0.008   -0.009   -0.008
                      38                   60               0     0   0.011                                                      -0.002 0.001          -0.011 0.003      -0.011   -0.011   -0.009    -0.01   -0.009
S Value                                    22               0     0   0.009                                                              0.003         -0.009 0.005      -0.009   -0.009   -0.007   -0.008   -0.007
                                                            0     0   0.012                                                                            -0.012 0.002      -0.012   -0.012    -0.01   -0.011    -0.01
                                                            0     0        0                                                                                   0.014          0        0    0.002    0.001    0.002
Count matches                                               0     0   0.014                                                                                              -0.014   -0.014   -0.012   -0.013   -0.012
2 limit = 3                                 2               0     0        0                                                                                                           0    0.002    0.001    0.002
3 limit = 3                                 1               0     0        0                                                                                                                0.002    0.001    0.002
4 limit = 3                                 1               6  510    0.002                                                                                                                         -0.001        0
5 limit = 2                                 1               0     0   0.001                                                                                                                                   0.001
6 limit = 2                                 1         SUM      528    0.002 # 0s        1      2          3      0      0        0        0       0        4        0        5        6        0        0         1


Mess2
                                                                      Mann-Kendall Trend: Samples > 10, Normal Approx:
Evaluation                                                            Quarter     1      2      3       4      5       6          7        8       9      10        11       12       13       14       15       16
V(S)                             490.3333333                          Data      4.7    3.9    1.1     4.2    3.1     3.1        2.7      2.6     2.5      2.2      2.2      2.3        0        2        1        2
Z Well                            -3.70312305                            4.7          -0.8   -3.6    -0.5   -1.6    -1.6         -2     -2.1    -2.2     -2.5     -2.5     -2.4     -4.7     -2.7     -3.7     -2.7
Zalpha                                  1.645         Formula Wp         3.9                 -2.8     0.3   -0.8    -0.8       -1.2     -1.3    -1.4     -1.7     -1.7     -1.6     -3.9     -1.9     -2.9     -1.9
Stable/No Trend/Exp        Decreasing                       2    18      1.1                          3.1      2       2        1.6      1.5     1.4      1.1      1.1      1.2     -1.1      0.9     -0.1      0.9
                                                            2    18      4.2                                -1.1    -1.1       -1.5     -1.6    -1.7       -2       -2     -1.9     -4.2     -2.2     -3.2     -2.2
S Value                                                     2    18      3.1                                           0       -0.4     -0.5    -0.6     -0.9     -0.9     -0.8     -3.1     -1.1     -2.1     -1.1
Neg                        Pos                              0     0      3.1                                                   -0.4     -0.5    -0.6     -0.9     -0.9     -0.8     -3.1     -1.1     -2.1     -1.1
                      99                    18              0     0      2.7                                                            -0.1    -0.2     -0.5     -0.5     -0.4     -2.7     -0.7     -1.7     -0.7
S Value                                    -81              0     0      2.6                                                                    -0.1     -0.4     -0.4     -0.3     -2.6     -0.6     -1.6     -0.6
                                                            0     0      2.5                                                                             -0.3     -0.3     -0.2     -2.5     -0.5     -1.5     -0.5
                                                            0     0      2.2                                                                                         0      0.1     -2.2     -0.2     -1.2     -0.2
Count matches                                               0     0      2.2                                                                                                0.1     -2.2     -0.2     -1.2     -0.2
2 limit = 3                                 3               0     0      2.3                                                                                                        -2.3     -0.3     -1.3     -0.3
3 limit = 3                                 0               0     0        0                                                                                                                    2        1        2
4 limit = 3                                 0               0     0        2                                                                                                                            -1        0
5 limit = 2                                 0               0     0        1                                                                                                                                      1
6 limit = 2                                 0         SUM        54        2 # 0s        0      0       0      0       1         0        0       0        0        1        0        0        0        0         1


POC1
                                                                      Mann-Kendall Trend: Samples > 10, Normal Approx:
Evaluation                                                            Quarter    1      2      3        4      5       6      7      8     9               10     11         12       13       14       15    16
V(S)                                       465                        Data       0      0      0 0.0092 0.021 0.032 0.026 0.028         0.13                0 0.059           0        0      355      200   360
Z Well                             2.596937816                             0            0      0 0.0092 0.021 0.032 0.026 0.028         0.13                0 0.059           0        0      355      200   360
Zalpha                                   1.645        Formula Wp           0                   0 0.0092 0.021 0.032 0.026 0.028         0.13                0 0.059           0        0      355      200   360
Stable/No Trend/Exp        Increasing                       0    0         0                       0.0092 0.021 0.032 0.026 0.028       0.13                0 0.059           0        0      355      200   360
                                                            0    0    0.009                               0.0118 0.0228 0.0168 0.0188 0.1208           -0.009 0.0498     -0.009   -0.009   354.99   199.99359.99
S Value                                                     0    0    0.021                                       0.011 0.005 0.007 0.109              -0.021 0.038      -0.021   -0.021   354.98   199.98359.98
Neg                        Pos                              0    0    0.032                                              -0.006 -0.004 0.098           -0.032 0.027      -0.032   -0.032   354.97   199.97359.97
                      24                   81               0    0    0.026                                                      0.002 0.104           -0.026 0.033      -0.026   -0.026   354.97   199.97359.97
S Value                                    57               0    0    0.028                                                            0.102           -0.028 0.031      -0.028   -0.028   354.97   199.97359.97
                                                            0    0     0.13                                                                             -0.13 -0.071      -0.13    -0.13   354.87   199.87359.87
                                                            0    0         0                                                                                   0.059          0        0      355      200   360
Count matches                                               0    0    0.059                                                                                              -0.059   -0.059   354.94   199.94359.94
2 limit = 3                                 1               0    0         0                                                                                                           0      355      200   360
3 limit = 3                                 1               0    0         0                                                                                                                  355      200   360
4 limit = 3                                 1               6  510      355                                                                                                                           -155     5
5 limit = 2                                 1               0    0      200                                                                                                                                  160
6 limit = 2                                 1         SUM      510      360 # 0s        1      2        0      0       0      0      0     0               3        0        4        5        0        0      0


POC2
                                                                      Mann-Kendall Trend: Samples > 10, Normal Approx:
Evaluation                                                            Quarter    1       2       3      4      5       6      7      8      9    10      11     12                     13    14     15     16
V(S)                               492.3333333                        Data     0.1 0.027 0.011 0.0096          4     2.1    1.9    1.8    2.5      3    2.5    3.1                      0   210    320    240
Z Well                             2.613956604                        0.099         -0.072 -0.088 -0.089 3.901 2.001 1.801 1.701 2.401 2.901 2.401 3.001                          -0.099 209.9 319.9 239.9
Zalpha                                   1.645        Formula Wp      0.027                 -0.016 -0.017 3.973 2.073 1.873 1.773 2.473 2.973 2.473 3.073                         -0.027 209.97 319.97 239.97
Stable/No Trend/Exp        Increasing                       2    18   0.011                        -0.001 3.989 2.089 1.889 1.789 2.489 2.989 2.489 3.089                         -0.011 209.99 319.99 239.99
                                                            0     0    0.01                               3.9904 2.0904 1.8904 1.7904 2.4904 2.9904 2.4904 3.0904                  -0.01 209.99 319.99 239.99
S Value                                                     0     0        4                                        -1.9   -2.1   -2.2   -1.5     -1   -1.5   -0.9                     -4   206    316    236
Neg                        Pos                              0     0      2.1                                               -0.2   -0.3    0.4    0.9    0.4      1                   -2.1 207.9 317.9 237.9
                      30                   89               0     0      1.9                                                      -0.1    0.6    1.1    0.6    1.2                   -1.9 208.1 318.1 238.1
S Value                                    59               0     0      1.8                                                              0.7    1.2    0.7    1.3                   -1.8 208.2 318.2 238.2
                                                            0     0      2.5                                                                     0.5      0    0.6                   -2.5 207.5 317.5 237.5
                                                            0     0        3                                                                           -0.5    0.1                     -3   207    317    237
Count matches                                               0     0      2.5                                                                                   0.6                   -2.5 207.5 317.5 237.5
2 limit = 3                                 1               0     0      3.1                                                                                                         -3.1 206.9 316.9 236.9
3 limit = 3                                 0               0     0        0                                                                                                                210    320    240
4 limit = 3                                 0               0     0     210                                                                                                                        110     30
5 limit = 2                                 0               0     0     320                                                                                                                               -80
6 limit = 2                                 0         SUM        18     240 # 0s         0       0      0      0       0      0      0      0      0      1      0                      0     0      0      0


POC3
                                                                      Mann-Kendall Trend: Samples > 10,   Normal Approx:
Evaluation                                                            Quarter    1      2      3          4      5       6        7        8       9       10       11       12       13       14       15    16
V(S)                                       465                        Data       0      0      0          0 0.048 0.045       0.038    0.039   0.082        0    0.074    0.069        0      350      420   370
Z Well                             2.875181154                             0            0      0          0 0.048 0.045       0.038    0.039   0.082        0    0.074    0.069        0      350      420   370
Zalpha                                   1.645        Formula Wp           0                   0          0 0.048 0.045       0.038    0.039   0.082        0    0.074    0.069        0      350      420   370
Stable/No Trend/Exp        Increasing                       0    0         0                              0 0.048 0.045       0.038    0.039   0.082        0    0.074    0.069        0      350      420   370
                                                            0    0         0                                 0.048 0.045      0.038    0.039   0.082        0    0.074    0.069        0      350      420   370
S Value                                                     0    0    0.048                                         -0.003    -0.01   -0.009   0.034   -0.048    0.026    0.021   -0.048   349.95   419.95369.95
Neg                        Pos                              0    0    0.045                                                  -0.007   -0.006   0.037   -0.045    0.029    0.024   -0.045   349.96   419.96369.96
                      21                   84               0    0    0.038                                                            0.001   0.044   -0.038    0.036    0.031   -0.038   349.96   419.96369.96
S Value                                    63               0    0    0.039                                                                    0.043   -0.039    0.035     0.03   -0.039   349.96   419.96369.96
                                                            0    0    0.082                                                                            -0.082   -0.008   -0.013   -0.082   349.92   419.92369.92
                                                            0    0         0                                                                                     0.074    0.069        0      350      420   370
Count matches                                               0    0    0.074                                                                                              -0.005   -0.074   349.93   419.93369.93
2 limit = 3                                 1               0    0    0.069                                                                                                       -0.069   349.93   419.93369.93
3 limit = 3                                 1               0    0         0                                                                                                                  350      420   370
4 limit = 3                                 1               6  510      350                                                                                                                             70    20
5 limit = 2                                 1               0    0      420                                                                                                                                  -50
6 limit = 2                                 1         SUM      510      370 # 0s        1      2          3      0      0        0        0       0        4        0        0        5        0        0      0
7 Year Mann-Kendall Analysis
Contaminant:       Benzene                                          Concentration or variance inputs (don't touch white cells)                                                                                           Benzene 7 Year Time Series

                                                     Messenger Well #1:
Mann-Kendall "S"                                 Time:Quarters   1   2                               3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
"S" Value                        64   # Quarters Concentration 100 100                              50 50 10 11 12 13 14 15 16 17 200 200 200 200 21 22 23 24 25 38 37 36 35 34 33 32 Sum
                                               1           100       0                              -1 -1 -1 -1 -1 -1 -1 -1 -1 -1   1   1   1   1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -18
Variance of "S"                                2             100                                    -1 -1 -1 -1 -1 -1 -1 -1 -1 -1    1     1   1   1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -18
                   Number of                   3              50                                        0 -1 -1 -1 -1 -1 -1 -1 -1    1     1   1   1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -16
                   tied groups                 4              50                                          -1 -1 -1 -1 -1 -1 -1 -1    1     1   1   1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -16
# 2 times                        2             5              10                                              1 1 1 1 1 1 1          1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    23
# 3 times                        0             6              11                                                 1 1 1 1 1 1         1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    22
# 4 times                        1             7              12                                                    1 1 1 1 1        1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    21
# 5 times                        0             8              13                                                       1 1 1 1       1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    20
# 6 times                        0             9              14                                                          1 1 1      1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    19
# 7 times                        0            10              15                                                             1 1     1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    18
# 8 times                        0            11              16                                                                1    1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    17
# 9 times                        0            12              17                                                                     1     1   1   1    1    1    1    1    1    1    1    1    1    1    1    1    16
# 10 times                       0            13             200                                                                           0   0   0   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -12
                                              14             200                                                                               0   0   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -12
Variance V(S)         2551.333333             15             200                                    Benzene 7 Year Time Series                     0   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -12
                                              16             200                                                                                       -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -12
Trend Evaluation
                                                                       Concentration (ug/l)
                                              17               21                             250                                                           1    1    1    1    1     1 1 1 1             1    1   11
                                              18               22                                                                                                1    1    1    1     1 1 1 1             1    1   10
                                                                                              200
Z 95%              Sample Z                   19               23                                                                                                     1    1    1     1 1 1 1             1    1    9
             1.645    1.247259866             20               24                             150                                                                          1    1     1 1 1 1             1    1    8
                                              21               25                             100                                                                               1     1 1 1 1             1    1    7
Trend              Stable/No Trend            22               38                              50                                                                                    -1 -1 -1 -1         -1   -1   -6
                                              23               37                                                                                                                       -1 -1 -1         -1   -1   -5
                                                                                                0
                                              24               36                                                                                                                          -1 -1         -1   -1   -4
                                                                                                    1 3 5 7 9 11 13 15 17 19 21 23 25 27
                                              25               35                                                                                                                             -1         -1   -1   -3
                                              26               34                                             Quarters (1/4 Years)                                                                       -1   -1   -2
                                              27               33                                                                                                                                             -1   -1
                                              28               32
                                                                                                                                                                                     Mann-Kendall "S"              64
                                                                                                                                                                                        (# plus - # minus)



                                      USER NOTES:
                                      This sheet performs the 7 year Mann-Kendall evaluation** for one chemical and one well*. Place concentration
                                      inputs
                                      in the yellow cells under the "concentration" cell. The sheet will automatically calculate the Mann-Kendall "S" value.

                                      After you have entered the concentration inputs in the yellow cells, click the "Count Tied Groups" button. The sheet
                                      then completes the evaluation, and in the "Stable/Expand" box shows the results. If a trend exists, the result is
                                      Expansion, and if no trend exists, the result is Stable.

                                      * From the RISC Technical Guide Appendix 3.
                                      ** FROM: EPA Practical Methods for Data Analysis, EPA QA/G-9 QA00 UPDATE, July 2000, Section 4.3.4, Box 4-9.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:3/6/2012
language:English
pages:23