{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Contents","SAMPLES","Blank samples","MP by Colour","Colour_Data_Vis","MP by Fraction","MPsediment ratio","Normality_Test","Sheet9_HID","Kruskal-Wallis Stations","Kruskal-SurfacewrtSubsurface","MP by morphology"],"not_rendered":{"charts":20,"images":4,"macros":1,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[2,2,3,10]]}
[]
[]
[null,null,"Contents Page"]
[]
[]
[]
[]
[{"$nulls":4},"DATA",null,"Worksheet Reference"]
[]
[{"$nulls":4},"RAW Data",null,"SAMPLES!A1"]
[{"$nulls":4},"MP by Colour",null,"MP by Colour'!A1"]
[{"$nulls":4},"MP by Size Fraction",null,"MP by Fraction'!A1"]
[{"$nulls":4},"MP by Morphology",null,"MP by morphology'!A1"]
[{"$nulls":4},"MP Sediment ratio",null,"MPsediment ratio'!A1"]
[]
[{"$nulls":4},"Statistics"]
[]
[{"$nulls":4},"Normality Tests",null,"Normality_Test!A1"]
[{"$nulls":4},"Kruskal Wallis Tests for:"]
[{"$nulls":4},"Stations",null,"Kruskal-Wallis Stations'!A1"]
[{"$nulls":4},"[Surface/Sub-surface]",null,"Kruskal-SurfacewrtSubsurface'!A1"]

{"sheet":"SAMPLES","index":1,"n_rows":76,"n_cols":22,"rows_kept":76}
[]
[null,"SAMPLE ID","MS01A","MS01B","MD01A","MD01B","MS02A","MS02B","MD02A","MD02B","MS03A","MS03B","MD03A","MD03B","MS04A","MS04B","MD04A","MD04B","MS05A","MS05B","MD05A","MD05B"]
[null,"Crude Mass (g)",100.03,50.15,50.08,53.1,100.12,100.39,100.19,100.3,50.21,50.38,50.07,50.77,50.24,50.47,50.49,50.27,50.27,100.53,100.07,100.4]
[null,"% Moisture",{"$f":"(22.4+32.4+43.2+37.7+24)/5","v":31.939999999999998},{"$f":"(22.4+32.4+43.2+37.7+24)/5","v":31.939999999999998},{"$f":"(22.4+32.4+43.2+37.7+24)/5","v":31.939999999999998},{"$f":"(22.4+32.4+43.2+37.7+24)/5","v":31.939999999999998},{"$f":"AVERAGE(39.8,39.8,40.1,40.8,41)","v":40.3},{"$f":"AVERAGE(39.8,39.8,40.1,40.8,41)","v":40.3},{"$f":"AVERAGE(39.8,39.8,40.1,40.8,41)","v":40.3},{"$f":"AVERAGE(39.8,39.8,40.1,40.8,41)","v":40.3},{"$f":"(34.1+40.5+39.9+40.8+30.9)/5","v":37.24},{"$f":"(34.1+40.5+39.9+40.8+30.9)/5","v":37.24},{"$f":"(34.1+40.5+39.9+40.8+30.9)/5","v":37.24},{"$f":"(34.1+40.5+39.9+40.8+30.9)/5","v":37.24},{"$f":"AVERAGE(31.1,40.4,42.9,35.8,36.4)","v":37.32},{"$f":"AVERAGE(31.1,40.4,42.9,35.8,36.4)","v":37.32},{"$f":"AVERAGE(31.1,40.4,42.9,35.8,36.4)","v":37.32},{"$f":"AVERAGE(31.1,40.4,42.9,35.8,36.4)","v":37.32},{"$f":"(47.2+45.4+43.4+46.7+54.1)/5","v":47.36},{"$f":"(47.2+45.4+43.4+46.7+54.1)/5","v":47.36},{"$f":"(47.2+45.4+43.4+46.7+54.1)/5","v":47.36},{"$f":"(47.2+45.4+43.4+46.7+54.1)/5","v":47.36}]
[null,"Moisture adjusted mass (g) ",{"$f":"((100-C4)/100)*C3","v":68.080418},34.13209,34.084447999999995,36.13986,59.77164,59.932829999999996,59.81343,59.879099999999994,31.511795999999997,31.618488,31.423931999999997,31.863252,31.490432000000002,31.634596000000002,31.647132000000003,31.509236000000005,26.462128,52.918991999999996,52.67684799999999,52.85056]
[null,">5.6mm"]
[null,"Mass of fraction (g)",{"$f":"88.0381-76.0359","v":12.002200000000002},2.2434,{"$f":"11.6965-11.6555","v":0.04100000000000037},0.8885,0.0421,0.0092,0,{"$f":"16.3789-16.3551","v":0.023800000000001376},5.9693,{"$f":"16.5763-16.2431","v":0.3332000000000015},0,0,{"$f":"13.9017-12.1784","v":1.7233},{"$f":"19.791-17.8987","v":1.8922999999999988},{"$f":"12.6093-12.2316","v":0.37769999999999904},{"$f":"18.3562-17.6884","v":0.6677999999999997},0.0323,0,0,0]
[null,"Fragment",52,24,4,3,1,0,0,0,{"$f":"3+1+4+3+1+2+2+1","v":17},4,0,0,{"$f":"1+7+1+4+1","v":14},{"$f":"2+2+1+1","v":6},{"$f":"1+1+2+3","v":7},3,0,0,0,0]
[null,"Fibre/Filament",{"$f":"19+31","v":50},3,2,5,0,1,0,1,9,1,0,0,3,2,1,0,0,0,0,0]
[null,"Foam",4,4,0,1,0,0,0,0,20,4,0,0,5,1,1,0,0,0,0,0]
[null,"Pellet/Bead",5,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Film",4,0,0,6,0,0,0,0,{"$f":"1+1+2+1","v":5},0,0,0,1,1,3,0,1,0,0,0]
[null,"Other",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",116,{"$f":"SUM(D8:D13)","v":31},6,17,1,1,0,1,51,9,0,0,23,10,12,3,1,0,0,0]
[null,"Blue",20,3,2,4,0,1,0,0,{"$f":"2+3+1","v":6},2,0,0,3,0,1,0,1,0,0,0]
[null,"Red",9,1,0,1,0,0,0,0,2,0,0,0,1,0,1,0,0,0,0,0]
[null,"Yellow",6,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0]
[null,"White",14,12,2,6,0,0,0,0,26,5,0,0,9,4,4,1,0,0,0,0]
[null,"Black ",7,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,"Brown",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Opaque",44,5,0,3,0,0,0,0,{"$f":"3","v":3},0,0,0,7,0,3,1,0,0,0,0]
[null,"Grey",1,1,1,1,0,0,0,0,2,1,0,0,0,2,0,0,0,0,0,0]
[null,"Green",5,1,0,0,0,0,0,1,5,0,0,0,1,1,2,0,0,0,0,0]
[null,"Transparent",0,7,0,2,0,0,0,0,{"$f":"4+2","v":6},1,0,0,1,3,0,0,0,0,0,0]
[null,"Orange",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cream",1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,"Metallic",0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,"Multi-coloured",5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C15:C28)","v":116},31,6,17,1,1,0,1,51,9,0,0,23,10,12,3,1,0,0,1]
[null,">2mm ",16.3155,10.2914,{"$f":"18.5008-17.844","v":0.6568000000000005},{"$f":"123.4952-121.9484","v":1.5467999999999904},0.006,{"$f":"17.782-17.7712","v":0.010799999999999699},0,0,5.8043,{"$f":"20.1633-16.247","v":3.9162999999999997},{"$f":"33.837-32.8204","v":1.016600000000004},{"$f":"16.4737-16.3117","v":0.1620000000000026},{"$f":"26.9094-17.9909","v":8.918500000000002},{"$f":"17.9136-17.5534","v":0.36019999999999897},{"$f":"20.3198-17.7906","v":2.5291999999999994},{"$f":"18.55-17.8442","v":0.7058},{"$f":"17.3207-17.3165","v":4.199999999997317E-3},0,{"$f":"17.3575-17.3117","v":0.045800000000003394},0]
[null,"Fragment",244,{"$f":"1+4+3+3+6+1+2+6+1+2+4+2+3+2+3+2+2+2+3+4+2+3+1+4+6+4+4+2+3+2+2+1+6+3+3+2+2+1+3+2+4+2+4+3+2+1+6+2+1+3+1+2+1+2+5+4+3+1+2+2+7+6+2+4+3+1+2+3+2+2","v":195},{"$f":"4+5+2+3+1+1","v":16},{"$f":"5+3+2+1+3+3+5+10+9+4+2+2","v":49},4,2,0,0,{"$f":"1+2+1+1+14+2+3+16+62+17+1+11+6","v":137},{"$f":"1+3+4+1+6+6+1+2+1","v":25},{"$f":"13","v":13},5,{"$f":"101+1+19+12+2+28+1+38+4+19+1+2+11","v":239},4,{"$f":"6+3+1+10+1+2+3","v":26},2,1,0,5,0]
[null,"Fibre/Filament",41,{"$f":"1+2+2+11+2+3+3+2","v":26},0,0,0,0,0,0,{"$f":"5+7+3+1+32","v":48},{"$f":"1+2+1","v":4},4,0,{"$f":"8+2+1+2","v":13},9,0,0,0,0,0,0]
[null,"Foam",33,{"$f":"5+1+1+2+1+2+1+2+1+2+1+3+2+2+4+3+1+3","v":37},2,6,0,0,0,0,136,{"$f":"44","v":44},{"$f":"7+2+1+6+1+2+1+1","v":21},4,212,3,32,3,0,0,0,0]
[null,"Pellet/Bead",507,{"$f":"150+62+6+1+4+5+3+3+5+16+5+2+3+5+1+1+4+2+2+3+3+3+2+4+1+4+3+5+2+3+1+3+3+4+3+4+2+2+2+7+4+1+7+3+3+3+2+3+2+1+2+6+1+4+7+1+3+4+1+3+2+1+11+3+4+5+1+3+4+4","v":443},{"$f":"17+6+2+2","v":27},{"$f":"28+3+7+2+4+3+4+1+2+1+3+3","v":61},0,0,0,0,{"$f":"2+1+119+17+10+18+1+2+1+2","v":173},{"$f":"101+3+4+11+8+4+3","v":134},{"$f":"23+2+2+1+4+1+1+3+1","v":38},5,{"$f":"195+8+21+10+10+2+1+1","v":248},0,{"$f":"4+69+1+3+10+11+1+2","v":101},{"$f":"13+2+5+1+3","v":24},0,0,0,0]
[null,"Film",14,5,0,1,0,0,0,0,0,0,0,0,10,1,3,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C31:C36)","v":839},706,45,117,4,2,0,0,496,207,76,14,722,17,162,29,1,0,5,0]
[null,"Blue",87,{"$f":"5+1+3+2+14+4+1+2+5+2+1","v":40},2,6,2,0,0,0,{"$f":"10+4+7","v":21},{"$f":"3+4+2","v":9},{"$f":"4+2+2+1+1","v":10},1,{"$f":"19+2+10","v":31},1,{"$f":"4+2","v":6},2,0,0,1,0]
[null,"Red",24,{"$f":"3+3+3","v":9},0,3,0,0,0,0,2,1,1,0,11,0,0,0,0,0,0,0]
[null,"Yellow",4,6,1,0,0,0,0,0,5,0,0,0,2,0,0,0,0,0,0,0]
[null,"White",116,109,{"$f":"2+1+2","v":5},{"$f":"2+2+4+1+1+3+1+3","v":17},0,0,0,0,{"$f":"2+136+17+32","v":187},{"$f":"4+3+44+1","v":52},{"$f":"7+2+1+6+1+1+3+1+1+1","v":24},5,{"$f":"10+212+19+8","v":249},6,{"$f":"10+32+3","v":45},4,0,0,2,0]
[null,"Black ",28,{"$f":"5+5+2+1+1+1+2+8+2+2+2+1+4+5","v":41},0,4,0,0,0,0,{"$f":"17+6","v":23},8,1,0,{"$f":"8+12","v":20},1,3,3,0,0,0,0]
[null,"Orange",0,0,0,0,0,0,0,0,1,1,0,0,3,0,0,0,0,0,0,0]
[null,"Brown",0,0,0,0,0,0,0,0,2,0,0,0,0,1,0,0,0,0,0,0]
[null,"Opaque",324,359,{"$f":"17+4","v":21},{"$f":"39-3","v":36},2,2,0,0,{"$f":"119+62+1","v":182},{"$f":"6+101","v":107},{"$f":"23+1+1+1+2+1+1+1","v":31},3,{"$f":"195+101+2","v":298},4,{"$f":"69+10","v":79},14,0,0,2,0]
[null,"Grey",96,{"$f":"3+1+1+1+1+2+6+2+3+2+5+2+2+4+2+1+2+3+7+2+3+1+9","v":65},8,{"$f":"7+2+2+2+2+2+4","v":21},0,0,0,0,{"$f":"18+11","v":29},{"$f":"6+11","v":17},6,0,{"$f":"21+28","v":49},2,12,5,0,0,0,0]
[null,"Green",{"$f":"35+1+3+1+4+1+4+2+2+6","v":59},{"$f":"2+2+15+4+3+4+4","v":34},3,7,0,0,0,0,{"$f":"2+14+5","v":21},6,2,0,{"$f":"2+38+1","v":41},0,7,1,1,0,0,0]
[null,"Transparent",90,{"$f":"1+6+5+15+8+6","v":41},5,{"$f":"25-3","v":22},0,0,0,0,{"$f":"16","v":16},5,0,0,{"$f":"4+10","v":14},2,{"$f":"1+3+1","v":5},0,0,0,0,0]
[null,"Purple",1,1,0,0,0,0,0,0,3,0,0,0,1,0,0,0,0,0,0,0]
[null,"Pink",2,1,0,0,0,0,0,0,2,1,1,0,2,0,1,0,0,0,0,0]
[null,"Cream",2,0,0,0,0,0,0,0,2,0,0,0,1,0,2,0,0,0,0,0]
[null,"Multi-coloured",6,0,0,1,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C38:C52)","v":839},706,45,117,4,2,0,0,496,207,76,9,722,17,162,29,1,0,5,0]
[null,">1mm",{"$f":"76.6219-76.1661","v":0.45579999999999643},{"$f":"13.1649-12.1168","v":1.0480999999999998},{"$f":"17.638-17.5911","v":0.04690000000000083},{"$f":"17.8618-17.8457","v":0.016099999999998005},4.3E-3,2.3E-3,1E-3,0,{"$f":"12.1626-11.7826","v":0.379999999999999},{"$f":"16.417-16.357","v":0.060000000000002274},{"$f":"17.8778-17.8454","v":0.032399999999999096},{"$f":"16.2636-16.2277","v":0.0359000000000016},1.1579,{"$f":"17.3424-17.3376","v":0.004800000000003024},{"$f":"18.0617-17.8736","v":0.1880999999999986},{"$f":"16.3031-16.2843","v":0.018799999999998818},{"$f":"16.3605-16.3481","v":0.012399999999999523},0,{"$f":"16.4109-16.3288","v":0.0821000000000005},0.0006]
[null,"Fragment",{"$f":"470+14+4+2+3+5+6+4+4+4+4+2+7+5+8+3+5+6+6+10+3+4+4+5+4+2+5+3+4+5+4+3+2+7+9+4+2+11+6+1","v":660},{"$f":"1+12+5+4+2+3+3+7+3+3+10+3+2+1+1+6+4+5+6+2+2+1+3+5+3+3+6+3+6+2+3+2+6+4+8+7+3+4+13+10+2+8+8+15+7+12+9+8+15+9+4+4+8+8+12+12+9+12+7+3+7+7+7+3+11+8+5+3+6+4+11+3+4+5+3+7+4+4+4+6+7+1+1+14+7+7+4+8+8+5+9+6+4+12+18+17+6+5+5+5+5+4+13+8+6+9+3+6+5+13+5+7+5+4+5+4+8+5+4+6+4+6+12+7+7+6+4+4+7+6+10+10+7+10+9+11+11+12+11+10+13+16+12+9+10+7+16+10+7+14+8+11+7+8+8+6+19+19+8+10+9+11+6+5+13+12+4+11+6+12+9+5+17+14+6+4+4+7+6+14+3+9+8+9+9+6+6","v":1342},{"$f":"7+3+6+6+17+3+1+1","v":44},13,6,3,2,0,{"$f":"37+44+183+13+21+7+3+15+21+1+1","v":346},{"$f":"26+5+6+1+1+4+2","v":45},{"$f":"8+16+1","v":25},{"$f":"5+2+3+1+1+1","v":13},{"$f":"589+55+70+70+77+3+49+16+9+19+3+10+1","v":971},8,{"$f":"8+19+77+26+14+7+14+13+1","v":179},{"$f":"4+5+1+1+1","v":12},5,0,14,3]
[null,"Fibre/Filament",20,{"$f":"2+1+12+3+6+2+2+1+1+6+1+1+1+4+4+3+1+1+1+1+1+2+1+1+2+2+1+2+1+1+1+1+2+1+1+2+2+2+1+2+4+4+2","v":93},0,1,0,0,0,0,{"$f":"6+4+1+1+3+2","v":17},0,0,0,{"$f":"1+6+5+1","v":13},0,1,0,0,0,0,0]
[null,"Foam",16,{"$f":"2+1+1+1+2+1+1+1+1+1+1+5","v":18},0,0,0,0,0,0,22,19,2,0,71,0,14,2,0,0,0,0]
[null,"Pellet/Bead",2,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Film",5,0,0,0,0,2,0,0,0,0,0,0,{"$f":"2+1+1+1","v":5},0,1,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C55:C60)","v":703},1456,44,14,6,5,2,0,385,64,27,13,1060,8,195,14,5,0,14,3]
[null,"Blue",69,{"$f":"2+1+12+2+5+10+2+3+10+10+7+10+5+5+1+8+6+4+11+14+2+1+1+1+1+4","v":138},6,2,4,2,2,0,{"$f":"37+6","v":43},6,3,0,{"$f":"70+1","v":71},3,19,1,1,0,3,1]
[null,"Red",16,{"$f":"5+5+10+4","v":24},1,1,1,0,0,0,7,1,0,0,16,0,8,0,0,0,2,0]
[null,"Yellow",14,{"$f":"9+6","v":15},1,0,0,0,0,0,3,0,0,1,10,0,0,0,0,0,0,0]
[null,"White",69,{"$f":"6+1+2+1+1+1+1+1+12+2+5+3+1+2+2+1+1+1+1+1+1+2+1+2+6+4+3+1+1+1+1+1+2+2+1+3+3+2+2+3+3+4+3+3+8+5+6+5+7+103+3+3+4+1+2+2+4+2+5+4+5+3+7","v":280},3,2,0,1,0,0,{"$f":"15+2+22","v":39},{"$f":"5+19","v":24},9,3,{"$f":"55+5+71+1","v":132},1,{"$f":"14+14+1","v":29},3,1,0,0,0]
[null,"Black ",36,{"$f":"2+8+6+63","v":79},0,0,0,0,0,0,{"$f":"21+3","v":24},1,0,1,77,0,7,1,0,0,0,0]
[null,"Opaque",260,645,17,2,1,1,0,0,{"$f":"183+4","v":187},26,0,5,{"$f":"589+6","v":595},2,77,5,2,0,7,0]
[null,"Grey",32,{"$f":"1+1+1+2+1+1+2+4+1+1+7+5+7","v":34},3,2,0,0,0,0,21,2,11,1,49,0,13,0,1,0,0,0]
[null,"Green",70,{"$f":"47+13+10+13+19+39+12+11+6","v":170},7,1,0,1,0,0,44,4,2,2,72,2,26,4,0,0,2,2]
[null,"Transparent",135,{"$f":"10+20+5+26","v":61},6,4,0,0,0,0,13,0,2,0,21,0,15,0,0,0,0,0]
[null,"Cream",0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0]
[null,"Brown",0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,"Pink",1,8,0,0,0,0,0,0,1,0,0,0,10,0,1,0,0,0,0,0]
[null,"Orange",1,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0]
[null,"Purple",0,1,0,0,0,0,0,0,1,0,0,0,3,0,0,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C62:C75)","v":703},1456,44,14,6,5,2,0,385,64,27,13,1060,8,195,14,5,0,14,3]

{"sheet":"Blank samples","index":2,"n_rows":10,"n_cols":5,"rows_kept":10}
[]
[]
[null,"Blank ","Date","Count of Microplastics","Morphologies present"]
[null,1,"13.07.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,2,"14.07.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,3,"23.07.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,4,"30.07.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,5,"07.08.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,6,"23.08.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]
[null,7,"31.08.2021","Zero plastics identified after exposing sample to air and passing through sieve cascade",0]

{"sheet":"MP by Colour","index":3,"n_rows":44,"n_cols":21,"rows_kept":44}
["SAMPLE ID","MS01A","MS01B","MD01A","MD01B","MS02A","MS02B","MD02A","MD02B","MS03A","MS03B","MD03A","MD03B","MS04A","MS04B","MD04A","MD04B","MS05A","MS05B","MD05A","MD05B"]
["Blue",20,3,2,4,0,1,0,0,{"$f":"2+3+1","v":6},2,0,0,3,0,1,0,1,0,0,0]
["Red",9,1,0,1,0,0,0,0,2,0,0,0,1,0,1,0,0,0,0,0]
["Yellow",6,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0]
["White",14,12,2,6,0,0,0,0,26,5,0,0,9,4,4,1,0,0,0,0]
["Black ",7,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
["Brown",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Opaque",44,5,0,3,0,0,0,0,{"$f":"3","v":3},0,0,0,7,0,3,1,0,0,0,0]
["Grey",1,1,1,1,0,0,0,0,2,1,0,0,0,2,0,0,0,0,0,0]
["Green",5,1,0,0,0,0,0,1,5,0,0,0,1,1,2,0,0,0,0,0]
["Transparent",0,7,0,2,0,0,0,0,{"$f":"4+2","v":6},1,0,0,1,3,0,0,0,0,0,0]
["Orange",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cream",1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0]
["Metallic",0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["Multi-coloured",5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Blue",87,{"$f":"5+1+3+2+14+4+1+2+5+2+1","v":40},2,6,2,0,0,0,{"$f":"10+4+7","v":21},{"$f":"3+4+2","v":9},{"$f":"4+2+2+1+1","v":10},1,{"$f":"19+2+10","v":31},1,{"$f":"4+2","v":6},2,0,0,1,0]
["Red",24,{"$f":"3+3+3","v":9},0,3,0,0,0,0,2,1,1,0,11,0,0,0,0,0,0,0]
["Yellow",4,6,1,0,0,0,0,0,5,0,0,0,2,0,0,0,0,0,0,0]
["White",116,109,{"$f":"2+1+2","v":5},{"$f":"2+2+4+1+1+3+1+3","v":17},0,0,0,0,{"$f":"2+136+17+32","v":187},{"$f":"4+3+44+1","v":52},{"$f":"7+2+1+6+1+1+3+1+1+1","v":24},5,{"$f":"10+212+19+8","v":249},6,{"$f":"10+32+3","v":45},4,0,0,2,0]
["Black ",28,{"$f":"5+5+2+1+1+1+2+8+2+2+2+1+4+5","v":41},0,4,0,0,0,0,{"$f":"17+6","v":23},8,1,0,{"$f":"8+12","v":20},1,3,3,0,0,0,0]
["Orange",0,0,0,0,0,0,0,0,1,1,0,0,3,0,0,0,0,0,0,0]
["Brown",0,0,0,0,0,0,0,0,2,0,0,0,0,1,0,0,0,0,0,0]
["Opaque",324,359,{"$f":"17+4","v":21},{"$f":"39-3","v":36},2,2,0,0,{"$f":"119+62+1","v":182},{"$f":"6+101","v":107},{"$f":"23+1+1+1+2+1+1+1","v":31},3,{"$f":"195+101+2","v":298},4,{"$f":"69+10","v":79},14,0,0,2,0]
["Grey",96,{"$f":"3+1+1+1+1+2+6+2+3+2+5+2+2+4+2+1+2+3+7+2+3+1+9","v":65},8,{"$f":"7+2+2+2+2+2+4","v":21},0,0,0,0,{"$f":"18+11","v":29},{"$f":"6+11","v":17},6,0,{"$f":"21+28","v":49},2,12,5,0,0,0,0]
["Green",{"$f":"35+1+3+1+4+1+4+2+2+6","v":59},{"$f":"2+2+15+4+3+4+4","v":34},3,7,0,0,0,0,{"$f":"2+14+5","v":21},6,2,0,{"$f":"2+38+1","v":41},0,7,1,1,0,0,0]
["Transparent",90,{"$f":"1+6+5+15+8+6","v":41},5,{"$f":"25-3","v":22},0,0,0,0,{"$f":"16","v":16},5,0,0,{"$f":"4+10","v":14},2,{"$f":"1+3+1","v":5},0,0,0,0,0]
["Purple",1,1,0,0,0,0,0,0,3,0,0,0,1,0,0,0,0,0,0,0]
["Pink",2,1,0,0,0,0,0,0,2,1,1,0,2,0,1,0,0,0,0,0]
["Cream",2,0,0,0,0,0,0,0,2,0,0,0,1,0,2,0,0,0,0,0]
["Multi-coloured",6,0,0,1,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0]
["Blue",69,{"$f":"2+1+12+2+5+10+2+3+10+10+7+10+5+5+1+8+6+4+11+14+2+1+1+1+1+4","v":138},6,2,4,2,2,0,{"$f":"37+6","v":43},6,3,0,{"$f":"70+1","v":71},3,19,1,1,0,3,1]
["Red",16,{"$f":"5+5+10+4","v":24},1,1,1,0,0,0,7,1,0,0,16,0,8,0,0,0,2,0]
["Yellow",14,{"$f":"9+6","v":15},1,0,0,0,0,0,3,0,0,1,10,0,0,0,0,0,0,0]
["White",69,{"$f":"6+1+2+1+1+1+1+1+12+2+5+3+1+2+2+1+1+1+1+1+1+2+1+2+6+4+3+1+1+1+1+1+2+2+1+3+3+2+2+3+3+4+3+3+8+5+6+5+7+103+3+3+4+1+2+2+4+2+5+4+5+3+7","v":280},3,2,0,1,0,0,{"$f":"15+2+22","v":39},{"$f":"5+19","v":24},9,3,{"$f":"55+5+71+1","v":132},1,{"$f":"14+14+1","v":29},3,1,0,0,0]
["Black ",36,{"$f":"2+8+6+63","v":79},0,0,0,0,0,0,{"$f":"21+3","v":24},1,0,1,77,0,7,1,0,0,0,0]
["Opaque",260,655,17,2,1,1,0,0,{"$f":"183+4","v":187},26,0,5,{"$f":"589+6","v":595},2,77,5,2,0,7,0]
["Grey",32,{"$f":"1+1+1+2+1+1+2+4+1+1+7+5+7","v":34},3,2,0,0,0,0,21,2,11,1,49,0,13,0,1,0,0,0]
["Green",70,{"$f":"47+13+10+13+19+39+12+11+6","v":170},7,1,0,1,0,0,44,4,2,2,72,2,26,4,0,0,2,2]
["Transparent",135,{"$f":"10+20+5+26","v":61},6,4,0,0,0,0,13,0,2,0,21,0,15,0,0,0,0,0]
["Cream",0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0]
["Brown",0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
["Pink",1,8,0,0,0,0,0,0,1,0,0,0,10,0,1,0,0,0,0,0]
["Orange",1,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0]
["Purple",0,1,0,0,0,0,0,0,1,0,0,0,3,0,0,0,0,0,0,0]

{"sheet":"Colour_Data_Vis","index":4,"n_rows":19,"n_cols":2,"rows_kept":19}
[]
[]
["Colour","TOTAL"]
["Blue",636]
["Red",143]
["Yellow",70]
["White",1500]
["Black ",367]
["Brown",5]
["Opaque",3372]
["Grey",488]
["Green",607]
["Transparent",477]
["Orange",12]
["Cream",13]
["Metallic",2]
["Multi-coloured",17]
["Pink ",31]
["Purple",11]

{"sheet":"MP by Fraction","index":5,"n_rows":6,"n_cols":21,"rows_kept":6}
[]
["SAMPLE ID","MS01A","MS01B","MD01A","MD01B","MS02A","MS02B","MD02A","MD02B","MS03A","MS03B","MD03A","MD03B","MS04A","MS04B","MD04A","MD04B","MS05A","MS05B","MD05A","MD05B"]
["Total crude mass",68.080418,34.13209,34.084447999999995,36.13986,59.77164,59.932829999999996,59.81343,59.879099999999994,31.511795999999997,31.618488,31.423931999999997,31.863252,31.490432000000002,31.634596000000002,31.647132000000003,31.509236000000005,26.462128,52.918991999999996,52.67684799999999,52.85056]
["5.6mm",{"$f":"88.0381-76.0359","v":12.002200000000002},2.2434,{"$f":"11.6965-11.6555","v":0.04100000000000037},0.8885,0.0421,0.0092,0,{"$f":"16.3789-16.3551","v":0.023800000000001376},5.9693,{"$f":"16.5763-16.2431","v":0.3332000000000015},0,0,{"$f":"13.9017-12.1784","v":1.7233},{"$f":"19.791-17.8987","v":1.8922999999999988},{"$f":"12.6093-12.2316","v":0.37769999999999904},{"$f":"18.3562-17.6884","v":0.6677999999999997},0.0323,0,0,0]
["2mm",16.3155,10.2914,{"$f":"18.5008-17.844","v":0.6568000000000005},{"$f":"123.4952-121.9484","v":1.5467999999999904},0.006,{"$f":"17.782-17.7712","v":0.010799999999999699},0,0,5.8043,{"$f":"20.1633-16.247","v":3.9162999999999997},{"$f":"33.837-32.8204","v":1.016600000000004},{"$f":"16.4737-16.3117","v":0.1620000000000026},{"$f":"26.9094-17.9909","v":8.918500000000002},{"$f":"17.9136-17.5534","v":0.36019999999999897},{"$f":"20.3198-17.7906","v":2.5291999999999994},{"$f":"18.55-17.8442","v":0.7058},{"$f":"17.3207-17.3165","v":4.199999999997317E-3},0,{"$f":"17.3575-17.3117","v":0.045800000000003394},0]
["1mm",{"$f":"76.6219-76.1661","v":0.45579999999999643},{"$f":"13.1649-12.1168","v":1.0480999999999998},{"$f":"17.638-17.5911","v":0.04690000000000083},{"$f":"17.8618-17.8457","v":0.016099999999998005},4.3E-3,2.3E-3,1E-3,0,{"$f":"12.1626-11.7826","v":0.379999999999999},{"$f":"16.417-16.357","v":0.060000000000002274},{"$f":"17.8778-17.8454","v":0.032399999999999096},{"$f":"16.2636-16.2277","v":0.0359000000000016},1.1579,{"$f":"17.3424-17.3376","v":0.004800000000003024},{"$f":"18.0617-17.8736","v":0.1880999999999986},{"$f":"16.3031-16.2843","v":0.018799999999998818},{"$f":"16.3605-16.3481","v":0.012399999999999523},0,{"$f":"16.4109-16.3288","v":0.0821000000000005},0.0006]

{"sheet":"MPsediment ratio","index":6,"n_rows":101,"n_cols":32,"rows_kept":101,"merged":[[3,1,6,1],[7,1,10,1],[11,1,14,1],[15,1,18,1],[19,1,22,1]]}
[]
[]
["Station ","Sampling Locations","Surface Duplicates","SAMPLE ID","Sediment horizon","Sediment code","Total Mass of Plastic (g)","Dry weight mass of sediments (g)","% Mass of MP in sample","mg MP/kg dry sediment"]
[1,"Hotspot 1","A","S1A","surface",1,{"$f":"SAMPLES!C7+SAMPLES!C30+SAMPLES!C54","v":28.7735},{"v":68.080418,"d":"68.0804"},{"$f":"G4/H4","v":{"v":0.4226398844965964,"d":"42.26%"}},{"$f":"(G4*1000)/(H4/1000)","v":{"v":422639.8844965964,"d":"422639.88"}},{"$nulls":20},{"$f":"SAMPLES!W7+SAMPLES!W30+SAMPLES!W54","v":{"v":0,"d":"0.00"}},{"$f":"SAMPLES!X7+SAMPLES!X30+SAMPLES!X54","v":{"v":0,"d":"0.00"}}]
[1,null,"A","SS1A","sub-surface",2,{"$f":"SAMPLES!E7+SAMPLES!E30+SAMPLES!E54","v":{"v":0.7447000000000017,"d":"0.7447"}},{"v":34.084447999999995,"d":"34.0844"},{"v":0.021848674210596043,"d":"2.18%"},{"v":21848.674210596037,"d":"21848.67"}]
[1,null,"B","S1B","surface",1,{"$f":"SAMPLES!D7+SAMPLES!D30+SAMPLES!D54","v":{"v":13.582899999999999,"d":"13.5829"}},{"v":34.13209,"d":"34.1321"},{"v":0.39795101911427044,"d":"39.80%"},{"v":397951.01911427046,"d":"397951.02"}]
[1,null,"B","SS1B","sub-surface",2,{"$f":"SAMPLES!F7+SAMPLES!F30+SAMPLES!F54","v":{"v":2.4513999999999885,"d":"2.4514"}},{"v":36.13986,"d":"36.1399"},{"v":0.06783092131513482,"d":"6.78%"},{"v":67830.92131513482,"d":"67830.92"}]
[3,"Hotspot 2","A","S3A","surface",1,{"$f":"SAMPLES!K7+SAMPLES!K30+SAMPLES!K54","v":{"v":12.153599999999997,"d":"12.1536"}},{"v":31.511795999999997,"d":"31.5118"},{"v":0.38568414190038547,"d":"38.57%"},{"v":385684.14190038544,"d":"385684.14"}]
[3,null,"A","SS3A","sub-surface",2,{"$f":"SAMPLES!M7+SAMPLES!M30+SAMPLES!M54","v":{"v":1.049000000000003,"d":"1.0490"}},{"v":31.423931999999997,"d":"31.4239"},{"v":0.03338220054702267,"d":"3.34%"},{"v":33382.200547022665,"d":"33382.20"}]
[3,null,"B","S3B","surface",1,{"$f":"SAMPLES!L7+SAMPLES!L30+SAMPLES!L54","v":{"v":4.309500000000003,"d":"4.3095"}},{"$f":"SAMPLES!L5","v":{"v":31.618488,"d":"31.6185"}},{"v":0.13629684000069844,"d":"13.63%"},{"v":136296.84000069843,"d":"136296.84"}]
[3,null,"B","SS3B","sub-surface",2,{"$f":"SAMPLES!N7+SAMPLES!N30+SAMPLES!N54","v":{"v":0.19790000000000418,"d":"0.1979"}},{"$f":"SAMPLES!N5","v":{"v":31.863252,"d":"31.8633"}},{"v":0.006210916575621477,"d":"0.62%"},{"v":6210.916575621477,"d":"6210.92"}]
[4,"Hotspot 3","A","S4A","surface",1,{"$f":"SAMPLES!O7+SAMPLES!O30+SAMPLES!O54","v":{"v":11.799700000000001,"d":"11.7997"}},{"v":31.490432000000002,"d":"31.4904"},{"v":0.3747074666997265,"d":"37.47%"},{"v":374707.4666997265,"d":"374707.47"}]
[4,null,"A","SS4A","sub-surface",2,{"$f":"SAMPLES!Q7+SAMPLES!Q30+SAMPLES!Q54","v":{"v":3.094999999999997,"d":"3.0950"}},{"v":31.647132000000003,"d":"31.6471"},{"v":0.09779717163627961,"d":"9.78%"},{"v":97797.17163627961,"d":"97797.17"}]
[4,null,"B","S4B","surface",1,{"$f":"SAMPLES!P7+SAMPLES!P30+SAMPLES!P54","v":{"v":2.2573000000000008,"d":"2.2573"}},{"$f":"SAMPLES!P5","v":{"v":31.634596000000002,"d":"31.6346"}},{"v":0.07135542366338425,"d":"7.14%"},{"v":71355.42366338424,"d":"71355.42"}]
[4,null,"B","SS4B","sub-surface",2,{"$f":"SAMPLES!R7+SAMPLES!R30+SAMPLES!R54","v":{"v":1.3923999999999985,"d":"1.3924"}},{"v":31.421484000000003,"d":"31.4215"},{"v":0.04431362948993747,"d":"4.43%"},{"v":44313.62948993746,"d":"44313.63"}]
[2,"Least Polluted","A","S2A","surface",1,{"$f":"SAMPLES!G7+SAMPLES!G30+SAMPLES!G54","v":{"v":0.052399999999999995,"d":"0.0524"}},{"v":59.77164,"d":"59.7716"},{"v":8.7666993912163024E-4,"d":"0.09%"},{"v":876.6699391216303,"d":"876.67"}]
[2,null,"A","SS2A","sub-surface",2,{"$f":"SAMPLES!I7+SAMPLES!I30+SAMPLES!I54","v":{"v":1E-3,"d":"0.0010"}},{"v":59.81343,"d":"59.8134"},{"v":1.6718653319162605E-5,"d":"0.002%"},{"v":16.718653319162605,"d":"16.72"}]
[2,null,"B","S2B","surface",1,{"$f":"SAMPLES!H7+SAMPLES!H30+SAMPLES!H54","v":{"v":0.0222999999999997,"d":"0.0223"}},{"v":59.932829999999996,"d":"59.9328"},{"v":3.7208321382453826E-4,"d":"0.04%"},{"v":372.0832138245383,"d":"372.08"}]
[2,null,"B","SS2B","sub-surface",2,{"$f":"SAMPLES!J7+SAMPLES!J30+SAMPLES!J54","v":{"v":0.023800000000001376,"d":"0.0238"}},{"v":59.879099999999994,"d":"59.8791"},{"v":3.9746756380776229E-4,"d":"0.04%"},{"v":397.4675638077623,"d":"397.47"}]
[5,"Control","A","S5A","surface",1,{"$f":"SAMPLES!S7+SAMPLES!S30+SAMPLES!S54","v":{"v":0.04889999999999684,"d":"0.0489"}},{"v":26.462128,"d":"26.4621"},{"v":0.001847923946252427,"d":"0.18%"},{"v":1847.923946252427,"d":"1847.92"}]
[5,null,"A","SS5A","sub-surface",2,{"$f":"SAMPLES!U7+SAMPLES!U30+SAMPLES!U54","v":{"v":0.1279000000000039,"d":"0.1279"}},{"v":52.67684799999999,"d":"52.6768"},{"v":2.4280116380540444E-3,"d":"0.24%"},{"v":2428.0116380540444,"d":"2428.01"}]
[5,null,"B","S5B","surface",1,{"$f":"SAMPLES!T7+SAMPLES!T30+SAMPLES!T54","v":{"v":0,"d":"0.0000"}},{"$f":"SAMPLES!T5","v":{"v":52.918991999999996,"d":"52.9190"}},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00"}]
[5,null,"B","SS5B","sub-surface",2,0.0006,{"v":52.645264,"d":"52.6453"},{"v":1.1397036588134499E-5,"d":"0.001%"},{"v":11.3970365881345,"d":"11.40"}]
{"$rows_empty":30}
[null,null,"Sample","Surface",null,"Subsurface",null,"Sediment horizon"]
[null,null,"A",0.4226398844965964,{"$f":"LOG(D55)","v":-0.3740295210095935},0.021848674210596043,{"$f":"SQRT(F55)","v":0.14781297037336083},"sub-surface",null,"surface"]
[null,null,"A",0.39795101911427044,{"$f":"LOG(D56)","v":-0.40017037877418365},0.06783092131513482,{"$f":"SQRT(F56)","v":0.26044370085516527},"sub-surface",null,"surface"]
[null,null,"A",0.38568414190038547,-0.4137682175683413,0.03338220054702267,0.18270796519862695,"sub-surface",null,"surface"]
[null,null,"A",0.13629684000069844,-0.8655142130293643,0.006210916575621477,0.07880936857773622,"sub-surface",null,"surface"]
[null,null,"A",0.3747074666997265,-0.4263076527450589,0.09779717163627961,0.3127253933345989,"sub-surface",null,"surface"]
[null,null,"B",0.07135542366338425,-1.1465730109507537,0.04431362948993747,0.21050802713896083,"sub-surface",null,"surface"]
[null,null,"B",8.7666993912163024E-4,-3.057163885081828,1.6718653319162605E-5,0.004088844985954176,"sub-surface",null,"surface"]
[null,null,"B",3.7208321382453826E-4,-3.4293599223133673,3.9746756380776229E-4,0.019936588569957555,"sub-surface",null,"surface"]
[null,null,"B",0.001847923946252427,-2.733315906710382,2.4280116380540444E-3,0.04927485807238864,"sub-surface",null,"surface"]
[null,null,"B",0,{"$f":"LOG(D64)","v":{"$error":"#NUM!"}},1.1397036588134499E-5,3.3759497312807396E-3,"sub-surface",null,"surface"]
{"$rows_empty":16}
["Sample","Sediment horizon","mg MP/kg dry sediment"]
[1,"sub-surface",{"v":21848.674210596037,"d":"21848.67"}]
[2,"sub-surface",{"v":67830.92131513482,"d":"67830.92"}]
[3,"sub-surface",{"v":33382.200547022665,"d":"33382.20"}]
[4,"sub-surface",{"v":6210.916575621477,"d":"6210.92"}]
[5,"sub-surface",{"v":97797.17163627961,"d":"97797.17"}]
[6,"sub-surface",{"v":44313.62948993746,"d":"44313.63"}]
[7,"sub-surface",{"v":16.718653319162605,"d":"16.72"}]
[8,"sub-surface",{"v":397.4675638077623,"d":"397.47"}]
[9,"sub-surface",{"v":2428.0116380540444,"d":"2428.01"}]
[10,"sub-surface",{"v":11.3970365881345,"d":"11.40"}]
["1b","surface",{"v":422639.8844965964,"d":"422639.88"}]
["2b","surface",{"v":397951.01911427046,"d":"397951.02"}]
["3b","surface",{"v":385684.14190038544,"d":"385684.14"}]
["4b","surface",{"v":136296.84000069843,"d":"136296.84"}]
["5b","surface",{"v":374707.4666997265,"d":"374707.47"}]
["6b","surface",{"v":71355.42366338424,"d":"71355.42"}]
["7b","surface",{"v":876.6699391216303,"d":"876.67"}]
["8b","surface",{"v":372.0832138245383,"d":"372.08"}]
["9b","surface",{"v":1847.923946252427,"d":"1847.92"}]
["10b","surface",{"v":0,"d":"0.00"}]

{"sheet":"Normality_Test","index":7,"n_rows":71,"n_cols":9,"rows_kept":71,"merged":[[39,1,40,9]]}
[null,"XLSTAT 2021.3.1.1183 - Normality Tests - Start time: 9/13/2021 at 12:32:33 / End time: 9/13/2021 at 12:33:09 / Microsoft Excel 16.014430"]
[null,"Y / Dependent variables: Workbook = Chessel Bay Microplastics results_Stats(AutoRecovered) (version 2).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$J$3:$J$23 / 20 rows and 1 column"]
[null,"X / Qualitative: Workbook = Chessel Bay Microplastics results_Stats(AutoRecovered) (version 2).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$A$3:$A$23 / 20 rows and 1 column"]
[null,"Constraints: an=0"]
[null,"Confidence interval (%): 95"]
[null,"Tolerance: 0.0001"]
[null,"Use least squares means: Yes"]
[]
[]
[null,"Summary statistics (Quantitative data):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"mg MP/kg dry sediment",20,0,20,{"v":0,"d":"0.000"},{"v":422639.8844965964,"d":"422639.884"},{"v":103298.42808203107,"d":"103298.428"},{"v":154608.88752431975,"d":"154608.888"}]
[]
[]
[null,"Summary statistics (Qualitative data):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Station","1",4,4,{"v":20,"d":"20.000"}]
[null,"","2",4,4,{"v":20,"d":"20.000"}]
[null,"","3",4,4,{"v":20,"d":"20.000"}]
[null,"","4",4,4,{"v":20,"d":"20.000"}]
[null,"","5",4,4,{"v":20,"d":"20.000"}]
[]
[]
[{"$nulls":4}," "]
[]
[]
[null,"Test assumptions:"]
[]
[null,"Test on the normality of the residuals (Shapiro-Wilk) (mg MP/kg dry sediment):"]
[]
[null,"W",{"v":0.892658323285439,"d":"0.893"}]
[null,"p-value (Two-tailed)",0.030103947790796573]
[null,"alpha",{"v":0.05,"d":"0.050"}]
[]
[null,"Test interpretation:"]
[null,"H0: The residuals follow a Normal distribution."]
[null,"Ha: The residuals do not follow a Normal distribution."]
[null,"As the computed p-value is lower than the significance level alpha=0.05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"LS Means for factor Station:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"1",{"v":227567.62478414946,"d":"227567.625"},{"v":70131.27414032309,"d":"70131.274"},{"v":78086.3524599995,"d":"78086.352"},{"v":377048.8971082994,"d":"377048.897"}]
[null,"2",{"v":415.73484251828563,"d":"415.735"},{"v":70131.27414032309,"d":"70131.274"},{"v":-149065.53748163168,"d":"-149065.537"},{"v":149897.00716666825,"d":"149897.007"}]
[null,"3",{"v":140393.52475593204,"d":"140393.525"},{"v":70131.27414032309,"d":"70131.274"},{"v":-9087.747568217921,"d":"-9087.748"},{"v":289874.797080082,"d":"289874.797"}]
[null,"4",{"v":147043.42287233192,"d":"147043.423"},{"v":70131.27414032309,"d":"70131.274"},{"v":-2437.849451818038,"d":"-2437.849"},{"v":296524.6951964819,"d":"296524.695"}]
[null,"5",{"v":1071.8331552233285,"d":"1071.833"},{"v":70131.27414032318,"d":"70131.274"},{"v":-148409.4391689268,"d":"-148409.439"},{"v":150553.10547937348,"d":"150553.105"}]
{"$rows_empty":19}
[{"$nulls":4}," "]

{"sheet":"Sheet9_HID","index":8,"n_rows":70,"n_cols":8,"rows_kept":70,"hidden":true}
[1,null,{"$f":"-8670.34075514696+(A1-1)*4083.35493472647","v":-8670.34075514696},{"$f":"0+1*C1-298962.5446483*(1.05+(C1-103298.428082031)^2/159070517175.939)^0.5","v":-326305.08466289786},1,null,{"$f":"332.587874014628+(E1-1)*3952.87770821688","v":332.587874014628},{"$f":"0+1*G1+298962.5446483*(1.05+(G1-103298.428082031)^2/159070517175.939)^0.5","v":316251.1992125969}]
[2,null,-4586.98582042049,-321426.7032591373,2,null,4285.465582231508,319493.2781333758]
[3,null,-503.63088569402044,-316575.9642275821,3,null,8238.343290448387,322761.66552676645]
[4,null,3579.7240490324493,-311753.0693771536,4,null,12191.220998665267,326056.53351659636]
[5,null,7663.07898375892,-306958.2150571469,5,null,16144.098706882147,329378.04898606363]
[6,null,11746.433918485389,-302191.59191818023,6,null,20096.97641509903,332726.37338079914]
[7,null,15829.78885321186,-297453.3846762774,7,null,24049.85412331591,336101.66251558944]
[8,null,19913.14378793833,-292743.7718807056,8,null,28002.731831532787,339504.06638526067]
[9,null,23996.4987226648,-288062.92568619264,9,null,31955.60953974967,342933.7289802227]
[10,null,28079.853657391268,-283411.01163015066,10,null,35908.48724796655,346390.7881071735]
[11,null,32163.20859211774,-278788.188415537,11,null,39861.36495618343,349875.3752154546]
[12,null,36246.56352684421,-274194.6076999746,12,null,43814.242664400306,353387.6152295456]
[13,null,40329.918461570676,-269630.4138917521,13,null,47767.12037261719,356927.62638817437]
[14,null,44413.273396297154,-265095.7439533139,14,null,51719.99808083407,360495.52009050833]
[15,null,48496.62833102362,-260590.72721283854,15,null,55672.875789050944,364091.40074987855]
[16,null,52579.983265750096,-256115.48518448503,16,null,59625.753497267826,367715.3656554723]
[17,null,56663.33820047656,-251670.13139787695,17,null,63578.63120548471,371367.50484241045]
[18,null,60746.69313520304,-247254.77123736095,18,null,67531.50891370159,375047.900970607]
[19,null,64830.0480699295,-242869.5017915631,19,null,71484.38662191847,378756.62921278394]
[20,null,68913.40300465598,-238514.411713731,20,null,75437.26433013535,382493.75715198944]
[21,null,72996.75793938244,-234189.58109332412,21,null,79390.14203835223,386259.344688943]
[22,null,77080.11287410892,-229895.08133927916,22,null,83343.0197465691,390053.44395949953]
[23,null,81163.46780883538,-225630.97507534415,23,null,87295.89745478598,393876.0992624965]
[24,null,85246.82274356186,-221397.31604783458,24,null,91248.77516300287,397727.34699821554]
[25,null,89330.17767828832,-217194.14904612798,25,null,95201.65287121975,401607.2156176573]
[26,null,93413.5326130148,-213021.5098361681,26,null,99154.53057943663,405515.7255827937]
[27,null,97496.88754774127,-208879.42510721038,27,null,103107.40828765351,409452.8893379266]
[28,null,101580.24248246774,-204767.91243199096,28,null,107060.28599587039,413418.7112922474]
[29,null,105663.5974171942,-200686.98024045938,29,null,111013.16370408726,417413.18781365344]
[30,null,109746.95235192069,-196636.6278071657,30,null,114966.04141230414,421436.30723384203]
[31,null,113830.30728664715,-192616.8452523459,31,null,118918.91912052102,425488.04986466444]
[32,null,117913.66222137363,-188627.61355670297,32,null,122871.7968287379,429568.38802568906]
[33,null,{"$f":"-8670.34075514696+(A33-1)*4083.35493472647","v":121997.01715610009},{"$f":"0+1*C33-298962.5446483*(1.05+(C33-103298.428082031)^2/159070517175.939)^0.5","v":-184668.90458983032},33,null,{"$f":"332.587874014628+(E33-1)*3952.87770821688","v":126824.67453695479},{"$f":"0+1*G33+298962.5446483*(1.05+(G33-103298.428082031)^2/159070517175.939)^0.5","v":433677.2860828796}]
[34,null,126080.37209082657,-180740.68115217978,34,null,130777.55224517167,437814.7004982666]
[35,null,130163.72702555303,-176842.89703042837,35,null,134730.42995338855,441980.57989044907]
[36,null,134247.0819602795,-172975.49706605123,36,null,138683.30766160542,446174.8651057305]
[37,null,138330.43689500596,-169138.41723686495,37,null,142636.1853698223,450397.4892996626]
[38,null,142413.79182973245,-165331.58475126143,38,null,146589.06307803918,454648.3780287347]
[39,null,146497.1467644589,-161554.91815481114,39,null,150541.94078625608,458927.44935191877]
[40,null,150580.50169918538,-157808.32744887387,40,null,154494.81849447294,463234.6139417515]
[41,null,154663.85663391184,-154091.71422082104,41,null,158447.69620268984,467569.7752046057]
[42,null,158747.21156863833,-150404.97178543318,42,null,162400.5739109067,471932.829409781]
[43,null,162830.5665033648,-146747.98533700933,43,null,166353.45161912357,476323.66582701885]
[44,null,166913.92143809126,-143120.63211169193,44,null,170306.32932734047,480742.1668720269]
[45,null,170997.27637281772,-139522.78155948376,45,null,174259.20703555734,485188.20825957914]
[46,null,175080.63130754422,-135954.2955254125,46,null,178212.08474377423,489661.65916374174]
[47,null,179163.98624227068,-132415.02843927353,47,null,182164.9624519911,494162.38238475984]
[48,null,183247.34117699714,-128904.82751336685,48,null,186117.840160208,498690.2345221291]
[49,null,187330.6961117236,-125423.53294762806,49,null,190070.71786842486,503245.06615336763]
[50,null,191414.05104645007,-121970.9781415404,50,null,194023.59557664173,507826.72201799386]
[51,null,195497.40598117656,-118546.98991221024,51,null,197976.47328485863,512435.04120621487]
[52,null,199580.76091590303,-115151.38871797727,52,null,201929.3509930755,517069.85735182266]
[53,null,203664.1158506295,-111783.98888693351,53,null,205882.2287012924,521730.9988288003]
[54,null,207747.47078535595,-108444.59884972236,54,null,209835.10640950926,526418.2889511366]
[55,null,211830.82572008244,-105133.02137599286,55,null,213787.98411772616,531131.5461753577]
[56,null,215914.1806548089,-101849.05381389198,56,null,217740.86182594302,535870.5843052812]
[57,null,219997.53558953537,-98592.48833198246,57,null,221693.7395341599,540635.2126985162]
[58,null,224080.89052426183,-95363.11216298907,58,null,225646.6172423768,545425.2364742345]
[59,null,228164.24545898833,-92160.707848786,59,null,229599.49495059365,550240.4567217487]
[60,null,232247.6003937148,-88985.05348605436,60,null,233552.37265881055,555080.6707094543]
[61,null,236330.95532844125,-85835.92297205646,61,null,237505.25036702742,559945.6720936935]
[62,null,240414.31026316772,-82713.08624999109,62,null,241458.1280752443,564835.2511271252]
[63,null,244497.6651978942,-79616.30955341604,63,null,245411.00578346118,569749.1948661943]
[64,null,248581.02013262067,-76545.35564924384,64,null,249363.88349167808,574687.2873773138]
[65,null,{"$f":"-8670.34075514696+(A65-1)*4083.35493472647","v":252664.37506734714},{"$f":"0+1*C65-298962.5446483*(1.05+(C65-103298.428082031)^2/159070517175.939)^0.5","v":-73499.98407884117},65,null,{"$f":"332.587874014628+(E65-1)*3952.87770821688","v":253316.76119989494},{"$f":"0+1*G65+298962.5446483*(1.05+(G65-103298.428082031)^2/159070517175.939)^0.5","v":579649.3099413905}]
[66,null,256747.7300020736,-70479.951396786,66,null,257269.6389081118,584635.0412563427]
[67,null,260831.0849368001,-67485.01140686052,67,null,261222.5166163287,589644.2576372786]
[68,null,264914.4398715265,-64514.91539488325,68,null,265175.3943245456,594676.7332140242]
[69,null,268997.794806253,-61569.412358010886,69,null,269128.27203276247,599732.240125707]
[70,null,273081.1497409795,-58648.2492301648,70,null,273081.14974097937,604810.5487121237]

{"sheet":"Kruskal-Wallis Stations","index":9,"n_rows":267,"n_cols":9,"rows_kept":267,"merged":[[53,1,54,9],[62,5,62,7],[155,1,156,9]]}
[null,"XLSTAT 2021.3.1.1183 - Comparison of k samples (Kruskal-Wallis, Friedman, ...) - Start time: 09/16/2021 at 01:52:54 / End time: 09/16/2021 at 01:53:24 / Microsoft Excel 16.014326"]
[null,"Data: Workbook = Microplastics Samples Sorted (version 1).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$A$3:$A$23,'MPsediment ratio'!$J$3:$J$23 / 20 rows and 2 columns"]
[null,"Sample identifiers: Workbook = Microplastics Samples Sorted (version 1).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$A$3:$A$23 / 20 rows and 1 column"]
[null,"Significance level (%): 5"]
[null,"p-value: Exact p-value"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Station",20,0,20,{"v":1,"d":"1.000"},{"v":5,"d":"5.000"},{"v":3,"d":"3.000"},{"v":1.4509525002200234,"d":"1.451"}]
[null,"mg MP/kg dry sediment",20,0,20,{"v":0,"d":"0.000"},{"v":422639.8844965964,"d":"422639.884"},{"v":103298.42808203107,"d":"103298.428"},{"v":154608.88752431975,"d":"154608.888"}]
[]
[]
[null,"Summary statistics (Subsamples):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Station","1",4,4,{"v":20,"d":"20.000"}]
[null,"","2",4,4,{"v":20,"d":"20.000"}]
[null,"","3",4,4,{"v":20,"d":"20.000"}]
[null,"","4",4,4,{"v":20,"d":"20.000"}]
[null,"","5",4,4,{"v":20,"d":"20.000"}]
[]
[]
[null,"Summary statistics (Data / Subsamples):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Station | Station-1",4,0,4,{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"}]
[null,"Station | Station-2",4,0,4,{"v":2,"d":"2.000"},{"v":2,"d":"2.000"},{"v":2,"d":"2.000"},{"v":0,"d":"0.000"}]
[null,"Station | Station-3",4,0,4,{"v":3,"d":"3.000"},{"v":3,"d":"3.000"},{"v":3,"d":"3.000"},{"v":0,"d":"0.000"}]
[null,"Station | Station-4",4,0,4,{"v":4,"d":"4.000"},{"v":4,"d":"4.000"},{"v":4,"d":"4.000"},{"v":0,"d":"0.000"}]
[null,"Station | Station-5",4,0,4,{"v":5,"d":"5.000"},{"v":5,"d":"5.000"},{"v":5,"d":"5.000"},{"v":0,"d":"0.000"}]
[null,"mg MP/kg dry sediment | Station-1",4,0,4,{"v":21848.674210596037,"d":"21848.674"},{"v":422639.8844965964,"d":"422639.884"},{"v":227567.62478414943,"d":"227567.625"},{"v":212069.00499051868,"d":"212069.005"}]
[null,"mg MP/kg dry sediment | Station-2",4,0,4,{"v":16.718653319162605,"d":"16.719"},{"v":876.6699391216303,"d":"876.670"},{"v":415.73484251827335,"d":"415.735"},{"v":353.0411877212203,"d":"353.041"}]
[null,"mg MP/kg dry sediment | Station-3",4,0,4,{"v":6210.916575621477,"d":"6210.917"},{"v":385684.14190038544,"d":"385684.142"},{"v":140393.524755932,"d":"140393.525"},{"v":172858.96518270383,"d":"172858.965"}]
[null,"mg MP/kg dry sediment | Station-4",4,0,4,{"v":44313.62948993746,"d":"44313.629"},{"v":374707.4666997265,"d":"374707.467"},{"v":147043.42287233195,"d":"147043.423"},{"v":153338.61634227404,"d":"153338.616"}]
[null,"mg MP/kg dry sediment | Station-5",4,0,4,{"v":0,"d":"0.000"},{"v":2428.0116380540444,"d":"2428.012"},{"v":1071.8331552236516,"d":"1071.833"},{"v":1253.646423778154,"d":"1253.646"}]
[]
[]
[null,"Results for variable Station:"]
[]
[null,"Kruskal-Wallis test / Two-tailed test (Station):"]
[]
[null,"K",19.000000000000007]
[null,"p-value (one-tailed)",3.927469650600956e-10]
[null,"alpha",{"v":0.05,"d":"0.050"}]
[null,"The p-value is computed using an exact method. Time elapsed: 0s."]
[]
[null,"Test interpretation:"]
[null,"H0: The samples come from the same population."]
[null,"Ha: The samples do not come from the same population."]
[null,"As the computed p-value is lower than the significance level alpha=0.05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Ties have been detected in the data and the appropriate corrections have been applied."]
[]
[]
[null,"Multiple pairwise comparisons using Dunn's procedure / Two-tailed test:"]
[]
[null,"Sample","Frequency","Sum of ranks","Mean of ranks","Groups"]
[null,"5",4,{"v":74,"d":"74.000"},{"v":18.5,"d":"18.500"},"A"]
[null,"4",4,{"v":58,"d":"58.000"},{"v":14.5,"d":"14.500"},"A","B"]
[null,"3",4,{"v":42,"d":"42.000"},{"v":10.5,"d":"10.500"},"A","B","C"]
[null,"2",4,{"v":26,"d":"26.000"},{"v":6.5,"d":"6.500"},null,"B","C"]
[null,"1",4,{"v":10,"d":"10.000"},{"v":2.5,"d":"2.500"},null,null,"C"]
[]
[]
[null,"Pairwise comparisons (Station):"]
[]
[null,"Differences:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1",0,{"v":-4,"d":"-4.000"},{"v":-8,"d":"-8.000"},{"v":-12,"d":"-12.000"},{"v":-16,"d":"-16.000"}]
[null,"2",{"v":4,"d":"4.000"},0,{"v":-4,"d":"-4.000"},{"v":-8,"d":"-8.000"},{"v":-12,"d":"-12.000"}]
[null,"3",{"v":8,"d":"8.000"},{"v":4,"d":"4.000"},0,{"v":-4,"d":"-4.000"},{"v":-8,"d":"-8.000"}]
[null,"4",{"v":12,"d":"12.000"},{"v":8,"d":"8.000"},{"v":4,"d":"4.000"},0,{"v":-4,"d":"-4.000"}]
[null,"5",{"v":16,"d":"16.000"},{"v":12,"d":"12.000"},{"v":8,"d":"8.000"},{"v":4,"d":"4.000"},0]
[]
[]
[null,"p-values:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1",1,0.3297192973126788,0.051252582857369555,3.4552222675230393E-3,9.6703420626953474E-5]
[null,"2",0.3297192973126788,1,0.3297192973126788,0.051252582857369555,3.4552222675230393E-3]
[null,"3",0.051252582857369555,0.3297192973126788,1,0.3297192973126788,0.051252582857369555]
[null,"4",3.4552222675230393E-3,0.051252582857369555,0.3297192973126788,1,0.3297192973126788]
[null,"5",9.6703420626953474E-5,3.4552222675230393E-3,0.051252582857369555,0.3297192973126788,1]
[null,"Bonferroni corrected significance level: 0.005"]
[]
[]
[null,"Significant differences:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1","No","No","No","Yes","Yes"]
[null,"2","No","No","No","No","Yes"]
[null,"3","No","No","No","No","No"]
[null,"4","Yes","No","No","No","No"]
[null,"5","Yes","Yes","No","No","No"]
{"$rows_empty":19}
[{"$nulls":6}," "]
{"$rows_empty":19}
[{"$nulls":6}," "]
[]
[]
[null,"Results for variable mg MP/kg dry sediment:"]
[]
[null,"Kruskal-Wallis test / Two-tailed test (mg MP/kg dry sediment):"]
[]
[null,"K",{"v":13.942857142857136,"d":"13.943"}]
[null,"p-value (one-tailed)",5.5644468559107481E-4]
[null,"alpha",{"v":0.05,"d":"0.050"}]
[null,"The p-value is computed using an exact method. Time elapsed: 14s."]
[]
[null,"Test interpretation:"]
[null,"H0: The samples come from the same population."]
[null,"Ha: The samples do not come from the same population."]
[null,"As the computed p-value is lower than the significance level alpha=0.05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Multiple pairwise comparisons using Dunn's procedure / Two-tailed test:"]
[]
[null,"Sample","Frequency","Sum of ranks","Mean of ranks","Groups"]
[null,"1",4,{"v":62,"d":"62.000"},{"v":15.5,"d":"15.500"},"A"]
[null,"4",4,{"v":58,"d":"58.000"},{"v":14.5,"d":"14.500"},"A"]
[null,"3",4,{"v":54,"d":"54.000"},{"v":13.5,"d":"13.500"},"A"]
[null,"2",4,{"v":18,"d":"18.000"},{"v":4.5,"d":"4.500"},"A"]
[null,"5",4,{"v":18,"d":"18.000"},{"v":4.5,"d":"4.500"},"A"]
[]
[]
[null,"Pairwise comparisons (mg MP/kg dry sediment):"]
[]
[null,"Differences:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1",0,{"v":11,"d":"11.000"},{"v":2,"d":"2.000"},{"v":1,"d":"1.000"},{"v":11,"d":"11.000"}]
[null,"2",{"v":-11,"d":"-11.000"},0,{"v":-9,"d":"-9.000"},{"v":-10,"d":"-10.000"},{"v":0,"d":"0.000"}]
[null,"3",{"v":-2,"d":"-2.000"},{"v":9,"d":"9.000"},0,{"v":-1,"d":"-1.000"},{"v":9,"d":"9.000"}]
[null,"4",{"v":-1,"d":"-1.000"},{"v":10,"d":"10.000"},{"v":1,"d":"1.000"},0,{"v":10,"d":"10.000"}]
[null,"5",{"v":-11,"d":"-11.000"},{"v":0,"d":"0.000"},{"v":-9,"d":"-9.000"},{"v":-10,"d":"-10.000"},0]
[]
[]
[null,"p-values:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1",1,0.008550979237125222,0.6325851216960414,0.8110701293339075,0.008550979237125222]
[null,"2",0.008550979237125222,1,0.03144373454589244,0.01682740948275696,1]
[null,"3",0.6325851216960414,0.03144373454589244,1,0.8110701293339075,0.03144373454589244]
[null,"4",0.8110701293339075,0.01682740948275696,0.8110701293339075,1,0.01682740948275696]
[null,"5",0.008550979237125222,1,0.03144373454589244,0.01682740948275696,1]
[null,"Bonferroni corrected significance level: 0.005"]
[]
[]
[null,"Significant differences:"]
[]
[null,null,"1","2","3","4","5"]
[null,"1","No","No","No","No","No"]
[null,"2","No","No","No","No","No"]
[null,"3","No","No","No","No","No"]
[null,"4","No","No","No","No","No"]
[null,"5","No","No","No","No","No"]
{"$rows_empty":19}
[{"$nulls":6}," "]
{"$rows_empty":19}
[{"$nulls":6}," "]
[]
[]
[null,"Summary (p-values):"]
[]
[null,"Variable","Kruskal-Wallis"]
[null,"Station",3.927469650600956e-10]
[null,"mg MP/kg dry sediment",5.5644468559107481E-4]
{"$rows_empty":19}
[{"$nulls":6}," "]

{"sheet":"Kruskal-SurfacewrtSubsurface","index":10,"n_rows":183,"n_cols":9,"rows_kept":183,"merged":[[44,1,45,9],[50,5,50,6],[107,1,108,9],[113,5,113,6]]}
[null,"XLSTAT 2021.3.1.1183 - Comparison of k samples (Kruskal-Wallis, Friedman, ...) - Start time: 09/15/2021 at 08:19:04 / End time: 09/15/2021 at 08:19:07 / Microsoft Excel 16.014326"]
[null,"Data: Workbook = Microplastics Samples Sorted (version 1).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$D$54:$D$64,'MPsediment ratio'!$F$54:$F$64 / 10 rows and 2 columns"]
[null,"Sample identifiers: Workbook = Microplastics Samples Sorted (version 1).xlsb / Sheet = MPsediment ratio / Range = 'MPsediment ratio'!$C$54:$C$64 / 10 rows and 1 column"]
[null,"Significance level (%): 5"]
[null,"p-value: Exact p-value"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Surface",10,0,10,{"v":0,"d":"0.000"},{"v":0.4226398844965964,"d":"0.423"},{"v":0.17917314529742603,"d":"0.179"},{"v":0.19113404703883408,"d":"0.191"}]
[null,"Subsurface",10,0,10,{"v":1.1397036588134499E-5,"d":"0.000"},{"v":0.09779717163627961,"d":"0.098"},{"v":0.027423710866636114,"d":"0.027"},{"v":0.03373884052762268,"d":"0.034"}]
[]
[]
[null,"Summary statistics (Subsamples):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Sample","A",5,5,{"v":50,"d":"50.000"}]
[null,"","B",5,5,{"v":50,"d":"50.000"}]
[]
[]
[null,"Summary statistics (Data / Subsamples):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Surface | Sample-A",5,0,5,{"v":0.13629684000069844,"d":"0.136"},{"v":0.4226398844965964,"d":"0.423"},{"v":0.34345587044233544,"d":"0.343"},{"v":0.11716930312907314,"d":"0.117"}]
[null,"Surface | Sample-B",5,0,5,{"v":0,"d":"0.000"},{"v":0.07135542366338425,"d":"0.071"},{"v":0.014890420152516567,"d":"0.015"},{"v":0.03157251670203059,"d":"0.032"}]
[null,"Subsurface | Sample-A",5,0,5,{"v":0.006210916575621477,"d":"0.006"},{"v":0.09779717163627961,"d":"0.098"},{"v":0.045413976856930924,"d":"0.045"},{"v":0.03702528041601573,"d":"0.037"}]
[null,"Subsurface | Sample-B",5,0,5,{"v":1.1397036588134499E-5,"d":"0.000"},{"v":0.04431362948993747,"d":"0.044"},{"v":0.009433444876341315,"d":"0.009"},{"v":0.019524356441258325,"d":"0.020"}]
[]
[]
[null,"Results for variable Surface:"]
[]
[null,"Kruskal-Wallis test / Two-tailed test (Surface):"]
[]
[null,"K",{"v":6.81818181818182,"d":"6.818"}]
[null,"p-value (one-tailed)",0.007936507936507929]
[null,"alpha",{"v":0.05,"d":"0.050"}]
[null,"The p-value is computed using an exact method. Time elapsed: 0s."]
[]
[null,"Test interpretation:"]
[null,"H0: The samples come from the same population."]
[null,"Ha: The samples do not come from the same population."]
[null,"As the computed p-value is lower than the significance level alpha=0.05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[]
[]
[null,"Multiple pairwise comparisons using Dunn's procedure / Two-tailed test:"]
[]
[null,"Sample","Frequency","Sum of ranks","Mean of ranks","Groups"]
[null,"A",5,{"v":40,"d":"40.000"},{"v":8,"d":"8.000"},"A"]
[null,"B",5,{"v":15,"d":"15.000"},{"v":3,"d":"3.000"},null,"B"]
{"$rows_empty":19}
[{"$nulls":6}," "]
{"$rows_empty":19}
[{"$nulls":6}," "]
[]
[]
[null,"Results for variable Subsurface:"]
[]
[null,"Kruskal-Wallis test / Two-tailed test (Subsurface):"]
[]
[null,"K",{"v":3.9381818181818176,"d":"3.938"}]
[null,"p-value (one-tailed)",0.05555555555555552]
[null,"alpha",{"v":0.05,"d":"0.050"}]
[null,"The p-value is computed using an exact method. Time elapsed: 0s."]
[]
[null,"Test interpretation:"]
[null,"H0: The samples come from the same population."]
[null,"Ha: The samples do not come from the same population."]
[null,"As the computed p-value is greater than the significance level alpha=0.05, one cannot reject the null hypothesis H0."]
[]
[]
[]
[null,"Multiple pairwise comparisons using Dunn's procedure / Two-tailed test:"]
[]
[null,"Sample","Frequency","Sum of ranks","Mean of ranks","Groups"]
[null,"A",5,{"v":37,"d":"37.000"},{"v":7.4,"d":"7.400"},"A"]
[null,"B",5,{"v":18,"d":"18.000"},{"v":3.6,"d":"3.600"},null,"B"]
{"$rows_empty":19}
[{"$nulls":6}," "]
{"$rows_empty":19}
[{"$nulls":6}," "]
[]
[]
[null,"Summary (p-values):"]
[]
[null,"Variable","Kruskal-Wallis"]
[null,"Surface",0.007936507936507929]
[null,"Subsurface",0.05555555555555552]
{"$rows_empty":19}
[{"$nulls":6}," "]

{"sheet":"MP by morphology","index":11,"n_rows":28,"n_cols":10,"rows_kept":28}
[]
[null,"SAMPLE ID","Fragment","Foam","Film","Fibre/Filament","Pellet","Total","Mass of dry sediment (g) ","Particles/kg dry sed"]
[null,"MS01A",{"$f":"(SAMPLES!C8+SAMPLES!C31+SAMPLES!C55)","v":956},{"$f":"(SAMPLES!C10+SAMPLES!C33+SAMPLES!C57)","v":53},{"$f":"(SAMPLES!C12+SAMPLES!C35+SAMPLES!C59)","v":23},{"$f":"(SAMPLES!C9+SAMPLES!C32+SAMPLES!C56)","v":111},{"$f":"(SAMPLES!C34+SAMPLES!C58)","v":509},{"$f":"SUM(C3:G3)","v":1652},{"v":68.080418,"d":"68.0804"},{"$f":"(H3/(I3/1000))","v":{"v":24265.420932051275,"d":"24265"}}]
[null,"MS01B",{"$f":"(SAMPLES!D8+SAMPLES!D31+SAMPLES!D55)","v":1561},{"$f":"SAMPLES!D10+SAMPLES!D33+SAMPLES!D57","v":59},{"$f":"SAMPLES!D12+SAMPLES!D35+SAMPLES!D59","v":5},{"$f":"SAMPLES!D9+SAMPLES!D32+SAMPLES!D56","v":122},{"$f":"SAMPLES!D11+SAMPLES!D34+SAMPLES!D58","v":446},2193,{"v":34.13209,"d":"34.1321"},{"v":64250.38724555104,"d":"64250"}]
[null,"MD01A",{"$f":"SAMPLES!E8+SAMPLES!E31+SAMPLES!E55","v":64},{"$f":"SAMPLES!E10+SAMPLES!E33+SAMPLES!E57","v":2},{"$f":"SAMPLES!E12+SAMPLES!E35+SAMPLES!E59","v":0},{"$f":"SAMPLES!E9+SAMPLES!E32+SAMPLES!E56","v":2},{"$f":"SAMPLES!E11+SAMPLES!E34+SAMPLES!E58","v":27},95,{"v":34.084447999999995,"d":"34.0844"},{"v":2787.1949107111845,"d":"2787"}]
[null,"MD01B",{"$f":"SAMPLES!F8+SAMPLES!F31+SAMPLES!F55","v":65},{"$f":"SAMPLES!F10+SAMPLES!F33+SAMPLES!F57","v":7},{"$f":"SAMPLES!F12+SAMPLES!F35+SAMPLES!F59","v":7},{"$f":"SAMPLES!F9+SAMPLES!F32+SAMPLES!F56","v":6},{"$f":"SAMPLES!F11+SAMPLES!F34+SAMPLES!F58","v":63},148,{"v":36.13986,"d":"36.1399"},{"v":4095.2012542383954,"d":"4095"}]
[null,"MS02A",{"$f":"SAMPLES!G8+SAMPLES!G31+SAMPLES!G55","v":11},{"$f":"SAMPLES!G10+SAMPLES!G33+SAMPLES!G57","v":0},{"$f":"SAMPLES!G12+SAMPLES!G35+SAMPLES!G59","v":0},{"$f":"SAMPLES!G9+SAMPLES!G32+SAMPLES!G56","v":0},{"$f":"SAMPLES!G11+SAMPLES!G58","v":0},11,{"v":59.77164,"d":"59.7716"},{"v":184.03376584614375,"d":"184"}]
[null,"MS02B",{"$f":"SAMPLES!H8+SAMPLES!H31+SAMPLES!H55","v":5},{"$f":"SAMPLES!H10+SAMPLES!H57","v":0},{"$f":"SAMPLES!H12+SAMPLES!H35+SAMPLES!H59","v":2},{"$f":"SAMPLES!H9+SAMPLES!H32+SAMPLES!H56","v":1},{"$f":"SAMPLES!H11+SAMPLES!H34+SAMPLES!H58","v":0},8,{"v":59.932829999999996,"d":"59.9328"},{"v":133.48276729131598,"d":"133"}]
[null,"MD02A",{"$f":"SAMPLES!I8+SAMPLES!I31+SAMPLES!I55","v":2},{"$f":"SAMPLES!I10+SAMPLES!I57","v":0},{"$f":"SAMPLES!I12+SAMPLES!I35+SAMPLES!I59","v":0},{"$f":"SAMPLES!I9+SAMPLES!I56+SAMPLES!I32","v":0},{"$f":"SAMPLES!I11+SAMPLES!I34+SAMPLES!I58","v":0},2,{"v":59.81343,"d":"59.8134"},{"v":33.43730663832521,"d":"33"}]
[null,"MD02B",{"$f":"SAMPLES!J8+SAMPLES!J31+SAMPLES!J55","v":0},{"$f":"SAMPLES!J8+SAMPLES!J31+SAMPLES!J55","v":0},{"$f":"SAMPLES!J12+SAMPLES!J33+SAMPLES!J57","v":0},{"$f":"SAMPLES!J9+SAMPLES!J32+SAMPLES!J56","v":1},{"$f":"SAMPLES!J11+SAMPLES!J34+SAMPLES!J58","v":0},1,{"v":59.879099999999994,"d":"59.8791"},{"v":16.70031780704787,"d":"17"}]
[null,"MS03A",{"$f":"SAMPLES!K8+SAMPLES!K31+SAMPLES!K55","v":500},{"$f":"SAMPLES!K10+SAMPLES!K33+SAMPLES!K57","v":178},{"$f":"SAMPLES!K12+SAMPLES!K35+SAMPLES!K59","v":5},{"$f":"SAMPLES!K9+SAMPLES!K32+SAMPLES!K56","v":74},{"$f":"SAMPLES!K11+SAMPLES!K34+SAMPLES!K58","v":173},930,{"v":31.511795999999997,"d":"31.5118"},{"v":29512.75769873606,"d":"29513"}]
[null,"MS03B",{"$f":"SAMPLES!L8+SAMPLES!L31+SAMPLES!L55","v":74},{"$f":"SAMPLES!L10+SAMPLES!L33+SAMPLES!L57","v":67},{"$f":"SAMPLES!L12+SAMPLES!L35+SAMPLES!L59","v":0},{"$f":"SAMPLES!L9+SAMPLES!L32+SAMPLES!L56","v":5},{"$f":"SAMPLES!L11+SAMPLES!L34+SAMPLES!L58","v":134},280,{"v":31.618488,"d":"31.6185"},{"v":8855.578419815647,"d":"8856"}]
[null,"MD03A",{"$f":"SAMPLES!M8+SAMPLES!M31+SAMPLES!M55","v":38},{"$f":"SAMPLES!M10+SAMPLES!M33+SAMPLES!M57","v":23},{"$f":"SAMPLES!M12+SAMPLES!M35+SAMPLES!M59","v":0},{"$f":"SAMPLES!M12+SAMPLES!M35+SAMPLES!M59","v":0},{"$f":"SAMPLES!M11+SAMPLES!M34+SAMPLES!M58","v":38},99,{"v":31.423931999999997,"d":"31.4239"},{"v":3150.465065924914,"d":"3150"}]
[null,"MD03B",{"$f":"SAMPLES!N8+SAMPLES!N31+SAMPLES!N55","v":18},{"$f":"SAMPLES!N10+SAMPLES!N33+SAMPLES!N57","v":4},{"$f":"SAMPLES!N12+SAMPLES!N35+SAMPLES!N59","v":0},{"$f":"SAMPLES!N9+SAMPLES!N32+SAMPLES!N56","v":0},{"$f":"SAMPLES!N11+SAMPLES!N34+SAMPLES!N58","v":5},27,{"v":31.863252,"d":"31.8633"},{"v":847.371134622417,"d":"847"}]
[null,"MS04A",{"$f":"SAMPLES!O8+SAMPLES!O31+SAMPLES!O55","v":1224},{"$f":"SAMPLES!O10+SAMPLES!O33+SAMPLES!O57","v":288},{"$f":"SAMPLES!O12+SAMPLES!O59","v":6},{"$f":"SAMPLES!O9+SAMPLES!O32+SAMPLES!O56","v":29},{"$f":"SAMPLES!O11+SAMPLES!O34+SAMPLES!O58","v":248},1795,{"v":31.490432000000002,"d":"31.4904"},{"v":57001.44094561802,"d":"57001"}]
[null,"MS04B",{"$f":"SAMPLES!P8+SAMPLES!P31+SAMPLES!P55","v":18},{"$f":"SAMPLES!P10+SAMPLES!P33+SAMPLES!P57","v":4},{"$f":"SAMPLES!P12+SAMPLES!P35+SAMPLES!P59","v":2},{"$f":"SAMPLES!P9+SAMPLES!P32+SAMPLES!P56","v":11},{"$f":"SAMPLES!P11+SAMPLES!P34+SAMPLES!P58","v":0},35,{"v":31.634596000000002,"d":"31.6346"},{"v":1106.383656677645,"d":"1106"}]
[null,"MD04A",{"$f":"SAMPLES!Q8+SAMPLES!Q31+SAMPLES!Q55","v":212},{"$f":"SAMPLES!Q10+SAMPLES!Q33+SAMPLES!Q57","v":47},{"$f":"SAMPLES!Q12+SAMPLES!Q35+SAMPLES!Q59","v":7},{"$f":"SAMPLES!Q9+SAMPLES!Q32+SAMPLES!Q56","v":2},{"$f":"SAMPLES!Q11+SAMPLES!Q34+SAMPLES!Q58","v":101},369,{"v":31.647132000000003,"d":"31.6471"},{"v":11659.824340480522,"d":"11660"}]
[null,"MD04B",{"$f":"SAMPLES!R8+SAMPLES!R31+SAMPLES!R55","v":17},{"$f":"SAMPLES!R10+SAMPLES!R33+SAMPLES!R57","v":5},{"$f":"SAMPLES!R12+SAMPLES!R35+SAMPLES!R59","v":0},{"$f":"SAMPLES!R9+SAMPLES!R32+SAMPLES!R56","v":0},{"$f":"SAMPLES!R11+SAMPLES!R34+SAMPLES!R58","v":24},46,{"v":31.509236000000005,"d":"31.5092"},{"v":1459.889411472877,"d":"1460"}]
[null,"MS05A",{"$f":"SAMPLES!S8+SAMPLES!S31+SAMPLES!S55","v":6},{"$f":"SAMPLES!S33+SAMPLES!S57","v":0},{"$f":"SAMPLES!S12+SAMPLES!S35+SAMPLES!S59","v":1},{"$f":"SAMPLES!S9+SAMPLES!S32+SAMPLES!S56","v":0},{"$f":"SAMPLES!S9+SAMPLES!S32+SAMPLES!S56","v":0},7,{"v":26.462128,"d":"26.4621"},{"v":264.52899026110066,"d":"265"}]
[null,"MS05B",{"$f":"SAMPLES!T8+SAMPLES!T31+SAMPLES!T55","v":0},{"$f":"SAMPLES!T10+SAMPLES!T33+SAMPLES!T57","v":0},{"$f":"SAMPLES!T12+SAMPLES!T35+SAMPLES!T59","v":0},{"$f":"SAMPLES!T9+SAMPLES!T32+SAMPLES!T56","v":0},{"$f":"SAMPLES!T11+SAMPLES!T34+SAMPLES!T58","v":0},0,0,0]
[null,"MD05A",{"$f":"SAMPLES!U8+SAMPLES!U31+SAMPLES!U55","v":19},{"$f":"SAMPLES!U10+SAMPLES!U33+SAMPLES!U57","v":0},{"$f":"SAMPLES!U12+SAMPLES!U35+SAMPLES!U59","v":0},{"$f":"SAMPLES!U9+SAMPLES!U32+SAMPLES!U56","v":0},{"$f":"SAMPLES!U11+SAMPLES!U34+SAMPLES!U58","v":0},19,52.67684799999999,{"v":360.6897664036391,"d":"361"}]
[null,"MD05B",{"$f":"SAMPLES!V8+SAMPLES!V31+SAMPLES!V55","v":3},{"$f":"SAMPLES!V10+SAMPLES!V33+SAMPLES!V57","v":0},{"$f":"SAMPLES!V12+SAMPLES!V35+SAMPLES!V59","v":0},{"$f":"SAMPLES!V9+SAMPLES!V32+SAMPLES!V56","v":0},{"$f":"SAMPLES!V11+SAMPLES!V34+SAMPLES!V58","v":0},3,52.645264,{"v":56.9851829406725,"d":"57"}]
[null,null,{"$f":"SUM(C3:C22)","v":4793},{"$f":"SUM(D3:D22)","v":737},{"$f":"SUM(E3:E22)","v":58},{"$f":"SUM(F3:F22)","v":364},{"$f":"SUM(G3:G22)","v":1768}]
[]
[]
[]
[null,null,"Fragment","Foam","Film","Fibre/Filament","Pellet"]
[null,null,4809,737,55,366,1768]