{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Monitoring Data","t-test","non-parametric procedure","DO NOT EDIT-tolerance factors","DO NOT EDIT-Shapriro-Wilk table","test for normality"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Monitoring Data","index":0,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[3,0,3,1],[1,0,1,4],[0,0,0,4]]}
["Vapor Monitoring - Data Distribution"]
["PLEASE READ CAREFULLY BEFORE STARTING. If you see a message about macros, please click \"Enable Content.\" Use this workbook to calculate the upper tolerance limit (UTL) for a vapor monitoring well and to investigate suspected releases, if measurements are taken which exceed the UTL. Complete Steps 1, 2, and 3 to get the UTL for a given well. A separate workbook should be prepared for each individual well, as each well will have its own UTL based on previous contamination. Please save this workbook to a safe document library, as it can be used to recalculate the UTL periodically (as more data is collected) and to investigate suspected releases. If a measurement is taken which exceeds the UTL, please refer to \"Investigating a Suspected Release\" below."]
[]
["Step 1: Enter at least 20 background measurements (in ppm) in Column A. You can enter up to 50. If \"outlier, delete and re-sample\" appears, do not include the data point. Take another measurement and use it instead.",null,"Step 2: Press \"Sort\" and \"Sort2\" once background data is entered in Column A. DO NOT LOOK AT STEP 3 OR 4 BEFORE COMPLETING - they will not be accurate until Step 2 is complete.","Step 3: Find your upper tolerance limit for the sampled monitoring well displayed below.","Investigating a Suspected Release: If you get a measured vapor concentration ABOVE the UTL (Cell D6) - go to the tab specificied below (non-parametric procedure OR t-test)."]
["Vapor Monitoring Background Data (Cells A6 -A55)","Outlier?",null,"Upper Tolerance Limit","Data Distribution"]
[null,{"$f":"IF((A6-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}},"Background data - ascending order (Xi)",{"$f":"IF(E6=\"use non-parametric procedure\",'non-parametric procedure'!B6,'t-test'!A17)","v":{"$error":"#N/A"}},{"$f":"IF('test for normality'!G9=0,\"use non-parametric procedure\",'test for normality'!G18)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF((A7-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A8-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A9-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A10-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}},"Background Data - Descending order (X(n-i+1))"]
[null,{"$f":"IF((A11-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A12-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A13-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A14-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A15-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A16-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A17-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A18-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A19-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A20-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A21-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A22-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A23-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A24-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A25-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A26-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A27-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A28-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A29-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A30-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A31-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A32-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A33-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A34-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A35-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A36-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A37-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A38-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A39-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A40-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A41-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A42-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A43-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A44-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A45-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A46-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A47-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A48-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A49-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A50-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A51-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A52-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A53-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A54-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF((A55-A62)/A64>A66,\"outlier, delete and re-sample\",\"ok, not an outlier\")","v":{"$error":"#DIV/0!"}}]
[]
[]
["info. for outlier calculations"]
["# of background data observations"]
[{"$f":"COUNT(A6:A55)","v":0}]
["background mean"]
[{"$f":"AVERAGE(A6:A55)","v":{"$error":"#DIV/0!"}}]
["background std"]
[{"$f":"STDEV(A6:A55)","v":{"$error":"#DIV/0!"}}]
["critical point for outlier"]
[{"$f":"HLOOKUP(A60,'DO NOT EDIT-tolerance factors'!A9:AE10,2)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
["Clear all data"]

{"sheet":"t-test","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[19,0,22,0]]}
["T-Test"]
["Use this tab to investigate suspected releases, if cell E6 on the Monitoring Data tab said \"use normal distribution, go to t-test.\" If a measurement is taken which exceeds the UTL, you must investigate a suspected release. In the highlighted range below, fill in your measurement that exceeded the UTL and at least 4 follow-up measurements taken in the next 5 days. Then see the Action Required box (A19)."]
["Number of Background Vapor Readings",null,"Monthly vapor reading > upper 95% CI and followup vapor readings (cells c4 - c15)","t"]
[{"$f":"COUNT('Monitoring Data'!A6:A55)","v":0},null,null,{"$f":"(C20-A7)/(SQRT(C22/C18+A9/A4))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"degrees of freedom"]
["Background Mean",null,null,{"$f":"(POWER(C22/C18+A9/A4,2))/(POWER(C22/C18,2)/(C18-1)+(POWER(A9/A4,2))/(A4-1))","v":{"$error":"#DIV/0!"}}]
[{"$f":"AVERAGE('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}},null,null,"degrees of freedom rounded to nearest integer"]
["Background Variance",null,null,{"$f":"ROUND(D6,0)","v":{"$error":"#DIV/0!"}}]
[{"$f":"VAR('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}},null,null,"Critical t value"]
["Background Standard Deviation",null,null,{"$f":"TINV(0.1,D8)","v":{"$error":"#DIV/0!"}}]
[{"$f":"STDEV('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}}]
["tolerance factor (k) "]
[{"$f":"HLOOKUP(A4,'DO NOT EDIT-tolerance factors'!A4:K5,2,TRUE)","v":{"$error":"#N/A"}}]
["Upper 95% TL for background"]
[{"$f":"A7+(A13*A11)","v":{"$error":"#DIV/0!"}}]
["Upper TL for release detection"]
[{"$f":"IF(A15>50,A15,50)","v":{"$error":"#DIV/0!"}},null,"# of vapor readings - initial exceedance + follow up readings"]
[null,null,{"$f":"COUNT(C4:C15)","v":0}]
["Action Required",null,"mean - initial sample +follow up"]
[{"$f":"IF(D4>D10,\"report suspected release to DEQ within 24 hours\",\"Release is not suspected, report results to DEQ within the time specified by the Regional Office, maintain records, then return to monthly monitoring\")","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(C4:C15)","v":{"$error":"#DIV/0!"}}]
[null,null,"variance - initial sample + follow up"]
[null,null,{"$f":"VAR(C4:C15)","v":{"$error":"#DIV/0!"}}]

{"sheet":"non-parametric procedure","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,0,21,0],[1,0,2,5],[0,0,0,5]]}
["Non-Parametric Tests"]
["Use this tab to investigate suspected releases, if cell E6 on the Monitoring Data tab said \"use non-parametric procedure.\" If a measurement is taken which exceeds the UTL, you must investigate a suspected release. In the highlighted range below, fill in your measurement that exceeded the UTL and at least 4 follow-up measurements taken in the next 5 days. Then see the Action Required box (A15)."]
[]
[]
["Upper Tolerance limit for background data",{"$f":"'Monitoring Data'!A66*'Monitoring Data'!A64+'Monitoring Data'!A62","v":{"$error":"#N/A"}},null,"monthly vapor reading > UCL plus additional vapor readings"]
["Upper TL for release det.",{"$f":"IF(B5>50,B5,50)","v":{"$error":"#N/A"}}]
["background mean",{"$f":"AVERAGE('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}}]
["background std",{"$f":"STDEV('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}}]
["n background",{"$f":"COUNT('Monitoring Data'!A6:A55)","v":0}]
["k",4.3600000000000003]
["sqrt n",{"$f":"SQRT(B9)","v":0}]
["UCL mean",{"$f":"B7+(B10*B8)/B11","v":{"$error":"#DIV/0!"}}]
[]
[]
["Action Required"]
[{"$f":"IF(D21>B12,\"Report Suspected Release to DEQ within 24 hours\",\"Release is not suspected, Report results to DEQ within the time specified by the Regional Office, maintain records, then continue with monthly monitoring\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,"mean"]
[null,null,null,{"$f":"AVERAGE(D6:D17)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(#REF!)=TRUE,\" \",RANK(#REF!,$D$6:$D$55,1))","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(D29)=TRUE,\" \",RANK(D29,$D$6:$D$55,1))","v":" "}]

{"sheet":"DO NOT EDIT-tolerance factors","index":3,"n_rows":10,"n_cols":31,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Tolerance Factors (Lieberman, 1958)"]
[]
[]
[20,21,22,23,24,25,30,35,40,45,50]
[2.3959999999999999,2.371,2.35,2.3290000000000002,2.3090000000000002,2.2919999999999998,2.2200000000000002,2.1659999999999999,2.125,2.0920000000000001,2.0649999999999999]
[]
[]
["Alpha level critical points for one tailed outlier test at the .05 significance level"]
[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[2.5569999999999999,2.58,2.6030000000000002,2.6240000000000001,2.6440000000000001,2.6629999999999998,2.681,2.698,2.714,2.73,2.7450000000000001,2.7589999999999999,2.7730000000000001,2.786,2.7989999999999999,2.8109999999999999,2.823,2.835,2.8460000000000001,2.8570000000000002,2.8660000000000001,2.8769999999999998,2.887,2.8959999999999999,2.9049999999999998,2.9140000000000001,2.923,2.931,2.94,2.948,2.956]

{"sheet":"DO NOT EDIT-Shapriro-Wilk table","index":4,"n_rows":31,"n_cols":31,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[0.47339999999999999,0.46429999999999999,0.45900000000000002,0.45419999999999999,0.44929999999999998,0.44500000000000001,0.44069999999999998,0.43659999999999999,0.43280000000000002,0.42909999999999998,0.4254,0.42199999999999999,0.41880000000000001,0.41560000000000002,0.41270000000000001,0.40960000000000002,0.40679999999999999,0.40400000000000003,0.40150000000000002,0.39889999999999998,0.39639999999999997,0.39400000000000002,0.39169999999999999,0.38940000000000002,0.38719999999999999,0.38500000000000001,0.38300000000000001,0.38080000000000003,0.37890000000000001,0.377,0.37509999999999999]
[0.3211,0.31850000000000001,0.31559999999999999,0.31259999999999999,0.30980000000000002,0.30690000000000001,0.30430000000000001,0.30180000000000001,0.29920000000000002,0.29680000000000001,0.2944,0.29210000000000003,0.2898,0.28760000000000002,0.28539999999999999,0.28339999999999999,0.28129999999999999,0.27939999999999998,0.27739999999999998,0.27550000000000002,0.2737,0.27189999999999998,0.27010000000000001,0.26840000000000003,0.26669999999999999,0.2651,0.26350000000000001,0.26200000000000001,0.26040000000000002,0.25890000000000002,0.25740000000000002]
[0.25650000000000001,0.25779999999999997,0.2571,0.25629999999999997,0.25540000000000002,0.25430000000000003,0.25330000000000003,0.25219999999999998,0.251,0.24990000000000001,0.2487,0.2475,0.24629999999999999,0.24510000000000001,0.24390000000000001,0.2427,0.24149999999999999,0.24030000000000001,0.23910000000000001,0.23799999999999999,0.23680000000000001,0.23569999999999999,0.23449999999999999,0.2334,0.23230000000000001,0.23130000000000001,0.23019999999999999,0.2291,0.2281,0.2271,0.22600000000000001]
[0.20849999999999999,0.21190000000000001,0.21310000000000001,0.21390000000000001,0.2145,0.21479999999999999,0.21510000000000001,0.2152,0.21510000000000001,0.215,0.21479999999999999,0.2145,0.21410000000000001,0.2137,0.2132,0.2127,0.21210000000000001,0.21160000000000001,0.21099999999999999,0.2104,0.20979999999999999,0.20910000000000001,0.20849999999999999,0.20780000000000001,0.2072,0.20649999999999999,0.20580000000000001,0.20519999999999999,0.20449999999999999,0.20380000000000001,0.20319999999999999]
[0.1686,0.1736,0.1764,0.1787,0.1807,0.1822,0.18360000000000001,0.18479999999999999,0.1857,0.18640000000000001,0.187,0.18740000000000001,0.18779999999999999,0.188,0.1822,0.1883,0.1883,0.1883,0.18809999999999999,0.188,0.18779999999999999,0.18759999999999999,0.18740000000000001,0.18709999999999999,0.18679999999999999,0.1865,0.1862,0.18590000000000001,0.1855,0.18509999999999999,0.1847]
[0.13339999999999999,0.1399,0.14430000000000001,0.14799999999999999,0.1512,0.15390000000000001,0.15629999999999999,0.15840000000000001,0.16009999999999999,0.16159999999999999,0.16300000000000001,0.1641,0.1651,0.16600000000000001,0.16669999999999999,0.1673,0.1678,0.16830000000000001,0.1686,0.16889999999999999,0.1691,0.16930000000000001,0.1694,0.16950000000000001,0.16950000000000001,0.16950000000000001,0.16950000000000001,0.16950000000000001,0.16950000000000001,0.16919999999999999,0.1691]
[0.1013,0.10920000000000001,0.115,0.1201,0.1245,0.1283,0.13159999999999999,0.1346,0.13719999999999999,0.13950000000000001,0.14149999999999999,0.14330000000000001,0.1449,0.14630000000000001,0.14749999999999999,0.1847,0.14960000000000001,0.15029999999999999,0.15129999999999999,0.152,0.15260000000000001,0.15310000000000001,0.1535,0.15390000000000001,0.1542,0.1545,0.15479999999999999,0.155,0.15509999999999999,0.15529999999999999,0.15540000000000001]
[7.1099999999999997E-2,8.0399999999999999E-2,8.7800000000000003E-2,9.4100000000000003E-2,9.9699999999999997E-2,0.1046,0.1089,0.1128,0.1162,0.1192,0.12189999999999999,0.12429999999999999,0.1265,0.12839999999999999,0.13009999999999999,0.13170000000000001,0.1331,0.13439999999999999,0.1356,0.1366,0.1376,0.1384,0.13919999999999999,0.13980000000000001,0.14050000000000001,0.14099999999999999,0.14149999999999999,0.14199999999999999,0.14230000000000001,0.14269999999999999,0.14299999999999999]
[4.2200000000000001E-2,5.2999999999999999E-2,6.1800000000000001E-2,6.9599999999999995E-2,7.6399999999999996E-2,8.2299999999999998E-2,8.7599999999999997E-2,9.2299999999999993E-2,9.6500000000000002E-2,0.1002,0.1036,0.1066,0.10929999999999999,0.1118,0.114,0.11600000000000001,0.1179,0.1196,0.1211,0.1225,0.1237,0.1249,0.12590000000000001,0.12690000000000001,0.1278,0.12859999999999999,0.1293,0.13,0.13059999999999999,0.13120000000000001,0.13170000000000001]
[1.4E-2,2.63E-2,3.6799999999999999E-2,4.5900000000000003E-2,5.3900000000000003E-2,6.0999999999999999E-2,6.7199999999999996E-2,7.2800000000000004E-2,7.7799999999999994E-2,8.2199999999999995E-2,8.6199999999999999E-2,8.9899999999999994E-2,9.3100000000000002E-2,9.6100000000000005E-2,9.8799999999999999E-2,0.1013,0.1036,0.1056,0.1075,0.10920000000000001,0.1108,0.1123,0.11360000000000001,0.1149,0.11600000000000001,0.11700000000000001,0.11799999999999999,0.11890000000000001,0.1197,0.1205,0.1212]
[0,0,1.2200000000000001E-2,2.2800000000000001E-2,3.2099999999999997E-2,4.0300000000000002E-2,4.7600000000000003E-2,4.2999999999999997E-2,5.9799999999999999E-2,6.5000000000000002E-2,6.9699999999999998E-2,7.3899999999999993E-2,7.7700000000000005E-2,8.1199999999999994E-2,8.4400000000000003E-2,8.7300000000000003E-2,0.09,9.2399999999999996E-2,9.4700000000000006E-2,9.6699999999999994E-2,9.8599999999999993E-2,0.1004,0.10199999999999999,0.10349999999999999,0.10489999999999999,0.1062,0.10730000000000001,0.1085,0.1095,0.1105,0.1113]
[0,0,0,0,1.0699999999999999E-2,0.02,2.8400000000000002E-2,3.5799999999999998E-2,4.24E-2,4.8300000000000003E-2,5.3699999999999998E-2,5.8500000000000003E-2,6.2899999999999998E-2,6.6900000000000001E-2,7.0599999999999996E-2,7.3899999999999993E-2,7.6999999999999999E-2,7.9799999999999996E-2,8.2400000000000001E-2,8.48E-2,8.6999999999999994E-2,8.9099999999999999E-2,9.0899999999999995E-2,9.2700000000000005E-2,9.4299999999999995E-2,9.5899999999999999E-2,9.7199999999999995E-2,9.8599999999999993E-2,9.98E-2,0.10100000000000001,0.10199999999999999]
[0,0,0,0,0,0,9.4000000000000004E-3,1.78E-2,2.53E-2,3.2000000000000001E-2,3.8100000000000002E-2,4.3499999999999997E-2,4.8500000000000001E-2,5.2999999999999999E-2,5.7200000000000001E-2,6.0999999999999999E-2,6.4500000000000002E-2,6.7699999999999996E-2,7.0599999999999996E-2,7.3300000000000004E-2,7.5899999999999995E-2,7.8200000000000006E-2,8.0399999999999999E-2,8.2400000000000001E-2,8.4199999999999997E-2,8.5999999999999993E-2,8.7599999999999997E-2,8.9200000000000002E-2,9.06E-2,9.1899999999999996E-2,9.3200000000000005E-2]
[0,0,0,0,0,0,0,0,8.3999999999999995E-3,1.5900000000000001E-2,2.2700000000000001E-2,2.8899999999999999E-2,3.44E-2,3.95E-2,4.41E-2,4.8399999999999999E-2,5.2299999999999999E-2,5.5899999999999998E-2,5.9200000000000003E-2,6.2199999999999998E-2,6.5100000000000005E-2,6.7699999999999996E-2,7.0099999999999996E-2,7.2400000000000006E-2,7.4499999999999997E-2,7.7499999999999999E-2,7.85E-2,8.0100000000000005E-2,8.1699999999999995E-2,8.3199999999999996E-2,8.4599999999999995E-2]
[0,0,0,0,0,0,0,0,0,0,7.6E-3,1.44E-2,2.06E-2,2.6200000000000001E-2,3.1399999999999997E-2,3.61E-2,4.0399999999999998E-2,4.4400000000000002E-2,4.8099999999999997E-2,5.1499999999999997E-2,5.4600000000000003E-2,5.7500000000000002E-2,6.0199999999999997E-2,6.2799999999999995E-2,6.5100000000000005E-2,6.7299999999999999E-2,6.9400000000000003E-2,7.1300000000000002E-2,7.3099999999999998E-2,7.4800000000000005E-2,7.6399999999999996E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,6.7999999999999996E-3,1.3100000000000001E-2,1.8700000000000001E-2,2.3900000000000001E-2,2.87E-2,3.3099999999999997E-2,3.7199999999999997E-2,4.0899999999999999E-2,4.4400000000000002E-2,4.7600000000000003E-2,5.0599999999999999E-2,5.3400000000000003E-2,5.6000000000000001E-2,5.8400000000000001E-2,6.0699999999999997E-2,6.2799999999999995E-2,6.4799999999999996E-2,6.6699999999999995E-2,6.8500000000000005E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,6.1999999999999998E-3,1.1900000000000001E-2,1.72E-2,2.1999999999999999E-2,2.64E-2,3.0499999999999999E-2,3.4299999999999997E-2,3.7900000000000003E-2,4.1099999999999998E-2,4.4200000000000003E-2,4.7100000000000003E-2,4.7899999999999998E-2,5.2200000000000003E-2,5.4600000000000003E-2,5.6800000000000003E-2,5.8799999999999998E-2,6.08E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.7000000000000002E-3,1.0999999999999999E-2,1.5800000000000002E-2,2.0299999999999999E-2,2.4400000000000002E-2,2.8299999999999999E-2,3.1800000000000002E-2,3.5200000000000002E-2,3.8300000000000001E-2,4.1200000000000001E-2,4.3900000000000002E-2,4.65E-2,4.8899999999999999E-2,5.11E-2,5.3199999999999997E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.3E-3,1.01E-2,1.46E-2,1.8800000000000001E-2,2.2700000000000001E-2,2.63E-2,2.9600000000000001E-2,3.2800000000000003E-2,3.5700000000000003E-2,3.85E-2,4.1099999999999998E-2,4.36E-2,4.5900000000000003E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.8999999999999998E-3,9.4000000000000004E-3,1.3599999999999999E-2,1.7500000000000002E-2,2.1100000000000001E-2,2.4500000000000001E-2,2.7699999999999999E-2,3.0700000000000002E-2,3.3500000000000002E-2,3.61E-2,3.8600000000000002E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.4999999999999997E-3,8.6999999999999994E-3,1.26E-2,1.6299999999999999E-2,1.9699999999999999E-2,2.29E-2,2.5899999999999999E-2,2.8799999999999999E-2,3.1399999999999997E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.1999999999999997E-3,8.0999999999999996E-3,1.18E-2,1.5299999999999999E-2,1.8499999999999999E-2,2.1499999999999998E-2,2.4400000000000002E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.8999999999999998E-3,7.6E-3,1.11E-2,1.43E-2,1.7399999999999999E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.7000000000000002E-3,7.1000000000000004E-3,1.04E-2]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.5000000000000001E-3]
[]
[]
["Shapiro Wilk Critical Values"]
[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[0.90500000000000003,0.90800000000000003,0.91100000000000003,0.91400000000000003,0.91600000000000004,0.91800000000000004,0.92,0.92300000000000004,0.92400000000000004,0.92600000000000005,0.92700000000000005,0.92900000000000005,0.93,0.93100000000000005,0.93300000000000005,0.93400000000000005,0.93500000000000005,0.93600000000000005,0.93799999999999994,0.93899999999999995,0.94,0.94099999999999995,0.94199999999999995,0.94299999999999995,0.94399999999999995,0.94499999999999995,0.94499999999999995,0.94599999999999995,0.94699999999999995,0.94699999999999995,0.94699999999999995]

{"sheet":"test for normality","index":5,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Background data - ascending order (Xi)","Background Data - Descending order (X(n-i+1))","X(n-i+1) -Xi","a n-i+1","bi"]
[null,null,{"$f":"B6-A6","v":0},{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,2)","v":{"$error":"#N/A"}},{"$f":"C6*D6","v":{"$error":"#N/A"}},null,"background s"]
[null,null,{"$f":"B7-A7","v":0},{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,3)","v":{"$error":"#N/A"}},{"$f":"C7*D7","v":{"$error":"#N/A"}},null,{"$f":"STDEV('Monitoring Data'!A6:A55)","v":{"$error":"#DIV/0!"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,4)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"sum bi"]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"SUM(E6:E55)","v":{"$error":"#N/A"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"sq. root n-1"]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"SQRT('Monitoring Data'!A60-1)","v":{"$error":"#NUM!"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,8)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"W"]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"POWER(G9/(G7*G11),2)","v":{"$error":"#N/A"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Shapiro-Wilk Critical Value"]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,11)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A30:AE31,2)","v":{"$error":"#N/A"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Data Distribution"]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,14)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(G13>G15,\"use normal distribution, go to t-test\",\"use non-parametric procedure\")","v":{"$error":"#N/A"}}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,15)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,16)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,17)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,18)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,19)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,20)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,21)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,22)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,23)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,24)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,25)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,0,{"$f":"HLOOKUP('Monitoring Data'!A60,'DO NOT EDIT-Shapriro-Wilk table'!A1:AE26,26)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]