Topic: Title: “Adur Estuary Sediment Characterisation – Fate and Transport of particles”

profiletutorthammy
Copy_of_DATA.xlsx
Home>Geology homework help>Topic: Title: “Adur Estuary Sediment Characterisation – Fate and Transport of particles”

Sheet1

PSA: runs sameple 3 times 0.1: is smaller than 3.3 microns - mm - phi (use for each equation folk and ward) do not necessarily use mean when comparing, can use raw indvidual data
Percentiles (µm)
Sample name D(0.01) D(0.05) D(0.1) D(0.16) D(0.25) D(0.5) D(0.75) D(0.84) D(0.90) D(0.95) (φ) (mm) Mean Grain Size Sorting coefficient
HIGH TIDE 1(1) 1.2346 2.2224 3.40669 5.1824 8.5005 27.37119 71.1031 97.4473 130.7105 182.7468
HIGH TIDE 1(2) 1.2248 2.1857 3.32478 5.0283 8.2102 25.2339 68.6377 94.0901 125.3124 174.9683
HIGH TIDE 1(3) 1.221 2.1654 3.27027 4.9088 7.9843 24.1187 67.3481 92.7324 123.4294 172.4263
Mean 1.2268 2.1911666667 3.3339133333 5.0398333333 8.2316666667 25.5745966667 69.0296333333 94.7566 126.4841 176.7138
HIGH TIDE 2(1) 1.2418 2.2449 3.3613 4.8559 7.3471 16.5043 39.0805 54.4839 70.8261 96.5108
HIGH TIDE 2(2) 1.1944 2.1733 3.22945 4.6237 6.941 15.2814 35.7149 49.5337 63.7208 84.1374
HIGH TIDE 2(3) 1.186 2.146 3.17597 4.5323 6.7801 14.7098 34.304 48.4924 63.3622 85.0854
Mean 1.2074 2.1880666667 3.2555733333 4.6706333333 7.0227333333 15.4985 36.3664666667 50.8366666667 65.9697 88.5778666667
HIGH TIDE 3(1) 1.2406 2.2026 3.30745 4.8744 7.5709 17.1294 38.524 52.7278 67.6173 91.7329
HIGH TIDE 3(2) 1.2361 2.1841 3.26251 4.7837 7.4054 16.7179 37.3933 51.1329 65.861 89.4435
HIGH TIDE 3(3) 1.2414 2.1964 3.28481 4.8214 7.4714 16.9958 38.6461 53.3178 69.8281 101.356
Mean 1.2393666667 2.1943666667 3.2849233333 4.8265 7.4825666667 16.9477 38.1878 52.3928333333 67.7688 94.1774666667
HIGH TIDE 4(1) 0.6531 1.6585 2.5705 3.8738 6.698 21.5561 55.4665 72.6696 89.3621 115.5072
HIGH TIDE 4(2) 0.642 1.6398 2.53148 3.7894 6.497 20.5579 53.5741 70.425 86.8037 112.1548
HIGH TIDE 4(3) 0.6406 1.6314 2.51432 3.754 6.4148 20.1853 53.0307 69.5537 85.3975 108.7924
Mean 0.6452333333 1.6432333333 2.5387666667 3.8057333333 6.5366 20.7664333333 54.0237666667 70.8827666667 87.1877666667 112.1514666667
MID TIDE 1(1) 1.2548 2.2857 3.606 5.61 10.2113 21.2339 68.5465 89.0901 101.6386 126.798
MID TIDE 1(2) 1.33 2.149 3.491 5.61 9.6637 33.9 66.4895 88.484 98.8698 126.798
MID TIDE 1(3) 1.18 2.423 3.4599 4.976 9.5068 30.069 66.1572 78.484 98.8017 112.468
Mean 1.2549333333 2.2859 3.5189666667 5.3986666667 9.7939333333 28.4009666667 67.0644 85.3527 99.7700333333 122.0213333333
MID TIDE 2(1) 0.452 1.5 2.6612 4.414 7.4147 26.67 61.747 66.9185 100.6705 112.468
MID TIDE 2(2) 0.51 1.691 2.6055 3.915 7.1577 23.656 66.8281 78.484 103.4349 126.798
MID TIDE 2(3) 0.575 1.5 2.5743 4.414 6.9998 26.67 66.0928 88.484 101.8363 126.798
Mean 0.5123333333 1.5636666667 2.6136666667 4.2476666667 7.1907333333 25.6653333333 64.8893 77.9621666667 101.9805666667 122.0213333333
MID TIDE 3(1) 1.047 1.906 3.4479 5.61 10.2455 30.069 69.4074 61.747 105.5928 126.798
MID TIDE 3(2) 0.823 2.149 3.3423 4.976 9.063 33.9 68.9661 88.484 106.3846 142.954
MID TIDE 3(3) 1.18 2.423 3.2832 6.325 9.3744 38.219 68.6989 99.758 107.1307 161.168
Mean 1.0166666667 2.1593333333 3.3578 5.637 9.5609666667 34.0626666667 69.0241333333 83.3296666667 106.3693666667 143.64
MID TIDE 4(1) 0.315 0.73 1.7136 2.423 4.8425 23.656 65.8175 88.484 107.9484 126.798
MID TIDE 4(2) 0.28 0.823 1.6771 2.732 4.6721 20.983 64.4329 78.484 105.8096 142.954
MID TIDE 4(3) 0.356 0.928 1.6609 3.08 4.5981 23.656 64.1103 99.758 106.0585 144.864
Mean 0.317 0.827 1.6838666667 2.745 4.7042333333 22.765 64.7869 88.9086666667 106.6055 138.2053333333
LOW TIDE 1(1) 0.575 1.691 3.0916 4.414 7.5505 18.611 63.0227 78.484 109.7919 126.798
LOW TIDE 1(2) 0.73 1.906 3.0567 4.216 7.3726 20.983 62.113 88.484 109.5851 142.954
LOW TIDE 1(3) 0.575 1.867 3.0341 4.619 7.2676 19.743 61.723 86.386 110.3866 135.932
Mean 0.6266666667 1.8213333333 3.0608 4.4163333333 7.3969 19.779 62.2862333333 84.4513333333 109.9212 135.228
LOW TIDE 2(1) 1.18 2.149 3.6626 5.61 10.0923 38.219 87.3379 88.484 130.9308 161.168
LOW TIDE 2(2) 1.282 2.102 3.572 5.529 9.6786 38.046 86.0769 88.4068 131.5862 160.1281
LOW TIDE 2(3) 0.978 1.985 3.436 5.783 9.3851 39.236 88.0763 89.6528 132.2492 162.5436
Mean 1.1466666667 2.0786666667 3.5568666667 5.6406666667 9.7186666667 38.5003333333 87.1637 88.8478666667 131.5887333333 161.2799
LOW TIDE 3(1) 1.33 2.423 3.7949 5.61 8.9381 33.9 86.8793 112.468 137.5919 181.704
LOW TIDE 3(2) 1.3165 2.3695 3.7092 5.598 8.6443 32.6851 85.6158 113.6745 135.1463 182.6842
LOW TIDE 3(3) 1.3097 2.2489 3.6691 5.3942 8.5094 31.9417 85.2939 110.6542 135.1725 180.9575
Mean 1.3187333333 2.3471333333 3.7244 5.5340666667 8.6972666667 32.8422666667 85.9296666667 112.2655666667 135.9702333333 181.7819
LOW TIDE 4(1) 1.33 2.423 3.5259 5.61 9.0561 33.9 74.6453 93.5845 114.1811 142.954
LOW TIDE 4(2) 1.2967 2.2515 3.4284 5.4684 8.6535 31.9142 73.3744 92.9641 112.295 141.4951
LOW TIDE 4(3) 1.2792 2.3951 3.3877 5.5632 8.4912 32.944 72.4847 92.845 113.4527 142.596
Mean 1.3019666667 2.3565333333 3.4473333333 5.5472 8.7336 32.9194 73.5014666667 93.1312 113.3096 142.3483666667
Salt-marsh Core
Depth (cm)
0-10(1) 0.823 1.906 2.6378 3.472 5.4919 12.988 32.8494 48.579 65.716 88.484
0-10(2) 0.8268 1.895 2.6105 3.4724 5.404 12.854 31.8914 48.3967 63.0719 88.5974
0-10(3) 0.889 1.959 2.5925 3.284 5.3544 12.893 31.1565 48.3971 61.4723 89.641
Mean 0.8462666667 1.92 2.6136 3.4094666667 5.4167666667 12.9116666667 31.9657666667 48.4576 63.4200666667 88.9074666667
10-20 (1) 1.33 2.149 3.1842 4.976 7.6019 20.983 55.7325 78.484 101.3548 142.954
10-20 (2) 1.3095 2.0869 3.0198 4.638 6.7211 18.7954 43.9567 75.469 84.1496 135.8572
10-20 (3) 1.2987 1.9815 2.9798 4.5795 6.5349 17.9427 41.2063 75.068 79.2103 134.6552
Mean 1.3127333333 2.0724666667 3.0612666667 4.7311666667 6.9526333333 19.2403666667 46.9651666667 76.3403333333 88.2382333333 137.8221333333
20-30 (1) 1.18 2.149 2.9595 4.414 6.9765 16.508 45.2362 61.747 85.6085 126.798
20-30 (2) 1.0672 2.0671 2.695 4.0385 5.8147 14.9274 31.5039 56.292 65.2197 119.6741
20-30 (3) 1.2597 2.394 3.5269 4.6851 6.7136 17.641 32.3104 59.747 73.1169 123.7591
Mean 1.1689666667 2.2033666667 3.0604666667 4.3792 6.5016 16.3588 36.3501666667 59.262 74.6483666667 123.4104
30-40 (1) 1.33 2.423 3.1928 4.414 5.9341 11.52 20.963 30.069 39.1806 54.768
30-40 (2) 1.2595 2.3685 3.1037 4.3985 5.5972 11.1085 18.2105 29.5164 33.5587 53.986
30-40 (3) 1.2189 2.3185 3.0813 4.2985 5.505 10.9456 17.6194 29.2651 32.4214 53.2658
Mean 1.2694666667 2.37 3.1259333333 4.3703333333 5.6787666667 11.1913666667 18.9309666667 29.6168333333 35.0535666667 54.0066
40-50(1) 2.149 3.915 5.9011 8.039 14.1404 88.484 149.3409 170.394 190.9958 221.9641
40-50(2) 2.1258 3.7895 5.6718 7.9856 13.1696 87.2892 148.3903 172.674 192.4953 220.6952
40-50(3) 2.0968 3.7695 5.6143 7.89568 12.9126 87.2185 148.3669 172.524 192.704 220.2589
Mean 2.1238666667 3.8246666667 5.7290666667 7.9734266667 13.4075333333 87.6639 148.6993666667 171.864 192.0650333333 220.9727333333
5.0398333333 25.5745966667 94.7566
0.00504 0.0255745967 0.0947566
7.63
3961.533,0.000,100.000
4537.433,0.000,100.000
5000.000,0.000,100.000

Sheet5

0.8462666667 1.3127333333 1.1689666667 1.2694666667 2.1238666667
1.92 2.0724666667 2.2033666667 2.37 3.8246666667
2.6136 3.0612666667 3.0604666667 3.1259333333 5.7290666667
3.4094666667 4.7311666667 4.3792 4.3703333333 7.9734266667
5.4167666667 6.9526333333 6.5016 5.6787666667 13.4075333333
12.9116666667 19.2403666667 16.3588 11.1913666667 87.6639
31.9657666667 46.9651666667 36.3501666667 18.9309666667 148.6993666667
48.4576 76.3403333333 59.262 29.6168333333 171.864
63.4200666667 88.2382333333 74.6483666667 35.0535666667 192.0650333333
88.9074666667 137.8221333333 123.4104 54.0066 220.9727333333

Sheet3

1.2268 1.2074 0.6452333333 1.2549333333 0.5123333333 1.0166666667 0.6266666667 0.317 1.1466666667 1.3187333333 1.3019666667
2.1911666667 2.1880666667 1.6432333333 2.2859 1.5636666667 2.1593333333 1.8213333333 0.827 2.0786666667 2.3471333333 2.3565333333
3.3339133333 3.2555733333 2.5387666667 3.5189666667 2.6136666667 3.3578 3.0608 1.6838666667 3.5568666667 3.7244 3.4473333333
5.0398333333 4.6706333333 3.8057333333 5.3986666667 4.2476666667 5.637 4.4163333333 2.745 5.6406666667 5.5340666667 5.5472
8.2316666667 7.0227333333 6.5366 9.7939333333 7.1907333333 9.5609666667 7.3969 4.7042333333 9.7186666667 8.6972666667 8.7336
25.5745966667 15.4985 20.7664333333 28.4009666667 25.6653333333 34.0626666667 19.779 22.765 38.5003333333 32.8422666667 32.9194
69.0296333333 36.3664666667 54.0237666667 67.0644 64.8893 69.0241333333 62.2862333333 64.7869 87.1637 85.9296666667 73.5014666667
94.7566 50.8366666667 70.8827666667 85.3527 77.9621666667 83.3296666667 84.4513333333 88.9086666667 88.8478666667 112.2655666667 93.1312
126.4841 65.9697 87.1877666667 99.7700333333 101.9805666667 106.3693666667 109.9212 106.6055 131.5887333333 135.9702333333 113.3096
176.7138 88.5778666667 112.1514666667 122.0213333333 122.0213333333 143.64 135.228 138.2053333333 161.2799 181.7819 142.3483666667

MM and Phi conversion s

Sample name D(0.16) D(0.5) D(0.84) D(0.95) Sample name D(0.16) D(0.5) D(0.84) D(0.95) Sample name D(0.16) D(0.5) D(0.84) D(0.95) Sample name Folk & Ward (1957) Mean Sample name Folk & Ward (1957) Mean
HIGH TIDE 1(1) 5.1824 27.37119 97.4473 182.7468 HIGH TIDE 1(1) 0.0051824 0.02737119 0.0974473 0.1827468 HIGH TIDE 1(1) 7.5921639114 5.1911980306 3.3592339769 2.4520819509 HIGH TIDE 1(1) 5.3808653063 HIGH TIDE 1(1)
HIGH TIDE 1(2) 5.0283 25.2339 94.0901 174.9683 HIGH TIDE 1(2) 0.0050283 0.0252339 0.0940901 0.1749683 HIGH TIDE 1(2) 7.6357135578 5.3084929919 3.4098132567 2.5148345304 HIGH TIDE 1(2) 5.4513399355 HIGH TIDE 1(2)
HIGH TIDE 1(3) 4.9088 24.1187 92.7324 172.4263 HIGH TIDE 1(3) 0.0049088 0.0241187 0.0927324 0.1724263 HIGH TIDE 1(3) 7.6704138967 5.3737040418 3.4307826961 2.5359482509 HIGH TIDE 1(3) 5.4916335449 HIGH TIDE 1(3)
Mean 5.0398333333 25.5745966667 94.7566 176.7138 Mean 0.0050398333 0.0255745967 0.0947566 0.1767138 Mean 7.6324082599 5.2891447022 3.3996297562 2.5005133871 Mean 5.4403942394 Mean
HIGH TIDE 2(1) 4.8559 16.5043 54.4839 96.5108 HIGH TIDE 2(1) 0.0048559 0.0165043 0.0544839 0.0965108 HIGH TIDE 2(1) 7.6860455729 5.9210142392 4.1980262135 3.3731657942 HIGH TIDE 2(1) 5.9350286752 HIGH TIDE 2(1)
HIGH TIDE 2(2) 4.6237 15.2814 49.5337 84.1374 HIGH TIDE 2(2) 0.0046237 0.0152814 0.0495337 0.0841374 HIGH TIDE 2(2) 7.7567364903 6.0320794684 4.3354458003 3.5711089529 HIGH TIDE 2(2) 6.0414205863 HIGH TIDE 2(2)
HIGH TIDE 2(3) 4.5323 14.7098 48.4924 85.0854 HIGH TIDE 2(3) 0.0045323 0.0147098 0.0484924 0.0850854 HIGH TIDE 2(3) 7.7855409261 6.0870785585 4.366097532 3.554944592 HIGH TIDE 2(3) 6.0795723389 HIGH TIDE 2(3)
Mean 4.6706333333 15.4985 50.8366666667 88.5778666667 Mean 0.0046706333 0.0154985 0.0508366667 0.0885778667 Mean 7.7421660934 6.0117275967 4.2979867531 3.4969099384 Mean 6.0172934811 Mean
HIGH TIDE 3(1) 4.8744 17.1294 52.7278 91.7329 HIGH TIDE 3(1) 0.0048744 0.0171294 0.0527278 0.0917329 HIGH TIDE 3(1) 7.6805596392 5.8673815715 4.2452923864 3.4464169406 HIGH TIDE 3(1) 5.9310778657 HIGH TIDE 3(1)
HIGH TIDE 3(2) 4.7837 16.7179 51.1329 89.4435 HIGH TIDE 3(2) 0.0047837 0.0167179 0.0511329 0.0894435 HIGH TIDE 3(2) 7.707657368 5.9024625535 4.289604339 3.4828795466 HIGH TIDE 3(2) 5.9665747535 HIGH TIDE 3(2)
HIGH TIDE 3(3) 4.8214 16.9958 53.3178 101.356 HIGH TIDE 3(3) 0.0048214 0.0169958 0.0533178 0.101356 HIGH TIDE 3(3) 7.696332159 5.878677918 4.2292389366 3.3024965999 HIGH TIDE 3(3) 5.9347496712 HIGH TIDE 3(3)
Mean 4.8265 16.9477 52.3928333333 94.1774666667 Mean 0.0048265 0.0169477 0.0523928333 0.0941774667 Mean 7.6948069058 5.8827666936 4.2544867067 3.4084742745 Mean 5.944020102 Mean
HIGH TIDE 4(1) 3.8738 21.5561 72.6696 115.5072 HIGH TIDE 4(1) 0.0038738 0.0215561 0.0726696 0.1155072 HIGH TIDE 4(1) 8.0120348135 5.5357600052 3.7825042246 3.1139453118 HIGH TIDE 4(1) 5.7767663478 HIGH TIDE 4(1)
HIGH TIDE 4(2) 3.7894 20.5579 70.425 112.1548 HIGH TIDE 4(2) 0.0037894 0.0205579 0.070425 0.1121548 HIGH TIDE 4(2) 8.0438148493 5.6041632898 3.8277685312 3.1564367287 HIGH TIDE 4(2) 5.8252488901 HIGH TIDE 4(2)
HIGH TIDE 4(3) 3.754 20.1853 69.5537 108.7924 HIGH TIDE 4(3) 0.003754 0.0201853 0.0695537 0.1087924 HIGH TIDE 4(3) 8.0573556345 5.630551161 3.8457289269 3.2003503183 HIGH TIDE 4(3) 5.8445452408 HIGH TIDE 4(3)
Mean 3.8057333333 20.7664333333 70.8827666667 112.1514666667 Mean 0.0038057333 0.0207664333 0.0708827667 0.1121514667 Mean 8.0376098087 5.5896027374 3.8184212741 3.1564796074 Mean 5.8152112734 Mean
MID TIDE 1(1) 5.61 21.2339 89.0901 126.798 MID TIDE 1(1) 0.00561 0.0212339 0.0890901 0.126798 MID TIDE 1(1) 7.4777835138 5.5574868165 3.4885910664 2.979396105 MID TIDE 1(1) 5.5079537989 MID TIDE 1(1)
MID TIDE 1(2) 5.61 33.9 88.484 126.798 MID TIDE 1(2) 0.00561 0.0339 0.088484 0.126798 MID TIDE 1(2) 7.4777835138 4.8825709164 3.4984395844 2.979396105 MID TIDE 1(2) 5.2862646715 MID TIDE 1(2)
MID TIDE 1(3) 4.976 30.069 78.484 112.468 MID TIDE 1(3) 0.004976 0.030069 0.078484 0.112468 MID TIDE 1(3) 7.6507977992 5.0555793005 3.6714576182 3.1524135184 MID TIDE 1(3) 5.4592782393 MID TIDE 1(3)
Mean 5.3986666667 28.4009666667 85.3527 122.0213333333 Mean 0.0053986667 0.0284009667 0.0853527 0.1220213333 Mean 7.5331811424 5.1379161551 3.5504193984 3.0347946946 Mean 5.4071722319 Mean
MID TIDE 2(1) 4.414 26.67 66.9185 112.468 MID TIDE 2(1) 0.004414 0.02667 0.0669185 0.112468 MID TIDE 2(1) 7.823697655 5.2286383649 3.9014510825 3.1524135184 MID TIDE 2(1) 5.6512623675 MID TIDE 2(1)
MID TIDE 2(2) 3.915 23.656 78.484 126.798 MID TIDE 2(2) 0.003915 0.023656 0.078484 0.126798 MID TIDE 2(2) 7.9967719771 5.4016500412 3.6714576182 2.979396105 MID TIDE 2(2) 5.6899598789 MID TIDE 2(2)
MID TIDE 2(3) 4.414 26.67 88.484 126.798 MID TIDE 2(3) 0.004414 0.02667 0.088484 0.126798 MID TIDE 2(3) 7.823697655 5.2286383649 3.4984395844 2.979396105 MID TIDE 2(3) 5.5169252014 MID TIDE 2(3)
Mean 4.2476666667 25.6653333333 77.9621666667 122.0213333333 Mean 0.0042476667 0.0256653333 0.0779621667 0.1220213333 Mean 7.8791137288 5.2840351918 3.6810820043 3.0347946946 Mean 5.6147436416 Mean
MID TIDE 3(1) 5.61 30.069 61.747 126.798 MID TIDE 3(1) 0.00561 0.030069 0.061747 0.126798 MID TIDE 3(1) 7.4777835138 5.0555793005 4.0174871452 2.979396105 MID TIDE 3(1) 5.5169499865 MID TIDE 3(1)
MID TIDE 3(2) 4.976 33.9 88.484 142.954 MID TIDE 3(2) 0.004976 0.0339 0.088484 0.142954 MID TIDE 3(2) 7.6507977992 4.8825709164 3.4984395844 2.8063771063 MID TIDE 3(2) 5.3439361 MID TIDE 3(2)
MID TIDE 3(3) 6.325 38.219 99.758 161.168 MID TIDE 3(3) 0.006325 0.038219 0.099758 0.161168 MID TIDE 3(3) 7.3047188049 4.7095661591 3.3254236482 2.6333627705 MID TIDE 3(3) 5.113236204 MID TIDE 3(3)
Mean 5.637 34.0626666667 83.3296666667 143.64 Mean 0.005637 0.0340626667 0.0833296667 0.14364 Mean 7.4708567172 4.875664806 3.5850259807 2.7994705368 Mean 5.3105158346 Mean
MID TIDE 4(1) 2.423 23.656 88.484 126.798 MID TIDE 4(1) 0.002423 0.023656 0.088484 0.126798 MID TIDE 4(1) 8.6889898799 5.4016500412 3.4984395844 2.979396105 MID TIDE 4(1) 5.8630265018 MID TIDE 4(1)
MID TIDE 4(2) 2.732 20.983 78.484 142.954 MID TIDE 4(2) 0.002732 0.020983 0.078484 0.142954 MID TIDE 4(2) 8.515826801 5.5746352308 3.6714576182 2.8063771063 MID TIDE 4(2) 5.9206398834 MID TIDE 4(2)
MID TIDE 4(3) 3.08 23.656 99.758 144.864 MID TIDE 4(3) 0.00308 0.023656 0.099758 0.144864 MID TIDE 4(3) 8.3428539337 5.4016500412 3.3254236482 2.7872289781 MID TIDE 4(3) 5.6899758744 MID TIDE 4(3)
Mean 2.745 22.765 88.9086666667 138.2053333333 Mean 0.002745 0.022765 0.0889086667 0.1382053333 Mean 8.5089781354 5.4570387304 3.4915321324 2.8551148046 Mean 5.8191829994 Mean
LOW TIDE 1(1) 4.414 18.611 78.484 126.798 LOW TIDE 1(1) 0.004414 0.018611 0.078484 0.126798 LOW TIDE 1(1) 7.823697655 5.7477006139 3.6714576182 2.979396105 LOW TIDE 1(1) 5.7476186291 LOW TIDE 1(1)
LOW TIDE 1(2) 4.216 20.983 88.484 142.954 LOW TIDE 1(2) 0.004216 0.020983 0.088484 0.142954 LOW TIDE 1(2) 7.8899094177 5.5746352308 3.4984395844 2.8063771063 LOW TIDE 1(2) 5.6543280776 LOW TIDE 1(2)
LOW TIDE 1(3) 4.619 19.743 86.386 135.932 LOW TIDE 1(3) 0.004619 0.019743 0.086386 0.135932 LOW TIDE 1(3) 7.7582037385 5.6625149621 3.5330586664 2.8790429713 LOW TIDE 1(3) 5.6512591223 LOW TIDE 1(3)
Mean 4.4163333333 19.779 84.4513333333 135.228 Mean 0.0044163333 0.019779 0.0844513333 0.135228 Mean 7.8229352176 5.6598867026 3.565735989 2.8865341912 Mean 5.6828526364 Mean
LOW TIDE 2(1) 5.61 38.219 88.484 161.168 LOW TIDE 2(1) 0.00561 0.038219 0.088484 0.161168 LOW TIDE 2(1) 7.4777835138 4.7095661591 3.4984395844 2.6333627705 LOW TIDE 2(1) 5.2285964191 LOW TIDE 2(1)
LOW TIDE 2(2) 5.529 38.046 88.4068 160.1281 LOW TIDE 2(2) 0.005529 0.038046 0.0884068 0.1601281 LOW TIDE 2(2) 7.498765713 4.7161114071 3.4996988479 2.6427015942 LOW TIDE 2(2) 5.2381919893 LOW TIDE 2(2)
LOW TIDE 2(3) 5.783 39.236 89.6528 162.5436 LOW TIDE 2(3) 0.005783 0.039236 0.0896528 0.1625436 LOW TIDE 2(3) 7.4339661825 4.6716782194 3.4795075483 2.6211013425 LOW TIDE 2(3) 5.1950506501 LOW TIDE 2(3)
Mean 5.6406666667 38.5003333333 88.8478666667 161.2799 Mean 0.0056406667 0.0385003333 0.0888478667 0.1612799 Mean 7.4699186008 4.6989852532 3.4925190538 2.6323614455 Mean 5.2204743026 Mean
LOW TIDE 3(1) 5.61 33.9 112.468 181.704 LOW TIDE 3(1) 0.00561 0.0339 0.112468 0.181704 LOW TIDE 3(1) 7.4777835138 4.8825709164 3.1524135184 2.4603379157 LOW TIDE 3(1) 5.1709226495 LOW TIDE 3(1)
LOW TIDE 3(2) 5.598 32.6851 113.6745 182.6842 LOW TIDE 3(2) 0.005598 0.0326851 0.1136745 0.1826842 LOW TIDE 3(2) 7.4808727978 4.9352230787 3.1370194365 2.4525762314 LOW TIDE 3(2) 5.184371771 LOW TIDE 3(2)
LOW TIDE 3(3) 5.3942 31.9417 110.6542 180.9575 LOW TIDE 3(3) 0.0053942 0.0319417 0.1106542 0.1809575 LOW TIDE 3(3) 7.5343752715 4.9684150919 3.1758698837 2.4662771917 LOW TIDE 3(3) 5.2262200824 LOW TIDE 3(3)
Mean 5.5340666667 32.8422666667 112.2655666667 181.7819 Mean 0.0055340667 0.0328422667 0.1122655667 0.1817819 Mean 7.497444261 4.9283024891 3.1550125929 2.4597195372 Mean 5.1935864477 Mean
LOW TIDE 4(1) 5.61 33.9 93.5845 142.954 LOW TIDE 4(1) 0.00561 0.0339 0.0935845 0.142954 LOW TIDE 4(1) 7.4777835138 4.8825709164 3.4175865876 2.8063771063 LOW TIDE 4(1) 5.2593136726 LOW TIDE 4(1)
LOW TIDE 4(2) 5.4684 31.9142 92.9641 141.4951 LOW TIDE 4(2) 0.0054684 0.0319142 0.0929641 0.1414951 LOW TIDE 4(2) 7.5146655083 4.9696577059 3.4271824924 2.8211760017 LOW TIDE 4(2) 5.3038352355 LOW TIDE 4(2)
LOW TIDE 4(3) 5.5632 32.944 92.845 142.596 LOW TIDE 4(3) 0.0055632 0.032944 0.092845 0.142596 LOW TIDE 4(3) 7.4898693125 4.9238404547 3.4290319713 2.809994582 LOW TIDE 4(3) 5.2809139128 LOW TIDE 4(3)
Mean 5.5472 32.9194 93.1312 142.3483666667 Mean 0.0055472 0.0329194 0.0931312 0.1423483667 Mean 7.494024543 4.9249181488 3.4245916219 2.8125021555 Mean 5.2811781046 Mean

Sheet2

Sample name D(0.16) D(0.5) D(0.84) D(0.95) Sample name Folk & Ward (1957) Mean Sample name Weighted Percentile difference
HIGH TIDE 1(1) 7.5921639114 5.1911980306 3.3592339769 2.4520819509 HIGH TIDE 1(1) 5.3808653063 HIGH TIDE 1(1) -1.4732500715
HIGH TIDE 1(2) 7.6357135578 5.3084929919 3.4098132567 2.5148345304 HIGH TIDE 1(2) 5.4513399355 HIGH TIDE 1(2) -1.4797566603
HIGH TIDE 1(3) 7.6704138967 5.3737040418 3.4307826961 2.5359482509 HIGH TIDE 1(3) 5.4916335449 HIGH TIDE 1(3) -1.4898707988
Mean 7.6324082599 5.2891447022 3.3996297562 2.5005133871 Mean 5.4403942394 Mean -1.4807145221
HIGH TIDE 2(1) 7.6860455729 5.9210142392 4.1980262135 3.3731657942 HIGH TIDE 2(1) 5.9350286752 HIGH TIDE 2(1) -1.258042483
HIGH TIDE 2(2) 7.7567364903 6.0320794684 4.3354458003 3.5711089529 HIGH TIDE 2(2) 6.0414205863 HIGH TIDE 2(2) -1.228196993
HIGH TIDE 2(3) 7.7855409261 6.0870785585 4.366097532 3.554944592 HIGH TIDE 2(3) 6.0795723389 HIGH TIDE 2(3) -1.2385175101
Mean 7.7421660934 6.0117275967 4.2979867531 3.4969099384 Mean 6.0172934811 Mean -1.2420778136
HIGH TIDE 3(1) 7.6805596392 5.8673815715 4.2452923864 3.4464169406 HIGH TIDE 3(1) 5.9310778657 HIGH TIDE 3(1) -1.225629636
HIGH TIDE 3(2) 7.707657368 5.9024625535 4.289604339 3.4828795466 HIGH TIDE 3(2) 5.9665747535 HIGH TIDE 3(2) -1.2211167431
HIGH TIDE 3(3) 7.696332159 5.878677918 4.2292389366 3.3024965999 HIGH TIDE 3(3) 5.9347496712 HIGH TIDE 3(3) -1.2571038083
Mean 7.6948069058 5.8827666936 4.2544867067 3.4084742745 Mean 5.944020102 Mean -1.2349728405
HIGH TIDE 4(1) 8.0120348135 5.5357600052 3.7825042246 3.1139453118 HIGH TIDE 4(1) 5.7767663478 HIGH TIDE 4(1) -1.4243242675
HIGH TIDE 4(2) 8.0438148493 5.6041632898 3.8277685312 3.1564367287 HIGH TIDE 4(2) 5.8252488901 HIGH TIDE 4(2) -1.4248792403
HIGH TIDE 4(3) 8.0573556345 5.630551161 3.8457289269 3.2003503183 HIGH TIDE 4(3) 5.8445452408 HIGH TIDE 4(3) -1.4211189258
Mean 8.0376098087 5.5896027374 3.8184212741 3.1564796074 Mean 5.8152112734 Mean -1.4234521534
MID TIDE 1(1) 7.4777835138 5.5574868165 3.4885910664 2.979396105 MID TIDE 1(1) 5.5079537989 MID TIDE 1(1) -1.3879179166
MID TIDE 1(2) 7.4777835138 4.8825709164 3.4984395844 2.979396105 MID TIDE 1(2) 5.2862646715 MID TIDE 1(2) -1.2831958023
MID TIDE 1(3) 7.6507977992 5.0555793005 3.6714576182 3.1524135184 MID TIDE 1(3) 5.4592782393 MID TIDE 1(3) -1.2831934971
Mean 7.5331811424 5.1379161551 3.5504193984 3.0347946946 Mean 5.4071722319 Mean -1.3143452027
MID TIDE 2(1) 7.823697655 5.2286383649 3.9014510825 3.1524135184 MID TIDE 2(1) 5.6512623675 MID TIDE 2(1) -1.2951411653
MID TIDE 2(2) 7.9967719771 5.4016500412 3.6714576182 2.979396105 MID TIDE 2(2) 5.6899598789 MID TIDE 2(2) -1.4483367619
MID TIDE 2(3) 7.823697655 5.2286383649 3.4984395844 2.979396105 MID TIDE 2(3) 5.5169252014 MID TIDE 2(3) -1.4221087995
Mean 7.8791137288 5.2840351918 3.6810820043 3.0347946946 Mean 5.6147436416 Mean -1.3903019458
MID TIDE 3(1) 7.4777835138 5.0555793005 4.0174871452 2.979396105 MID TIDE 3(1) 5.5169499865 MID TIDE 3(1) -1.1796473036
MID TIDE 3(2) 7.6507977992 4.8825709164 3.4984395844 2.8063771063 MID TIDE 3(2) 5.3439361 MID TIDE 3(2) -1.3526643734
MID TIDE 3(3) 7.3047188049 4.7095661591 3.3254236482 2.6333627705 MID TIDE 3(3) 5.113236204 MID TIDE 3(3) -1.3094000602
Mean 7.4708567172 4.875664806 3.5850259807 2.7994705368 Mean 5.3105158346 Mean -1.2860325734
MID TIDE 4(1) 8.6889898799 5.4016500412 3.4984395844 2.979396105 MID TIDE 4(1) 5.8630265018 MID TIDE 4(1) -1.664645746
MID TIDE 4(2) 8.515826801 5.5746352308 3.6714576182 2.8063771063 MID TIDE 4(2) 5.9206398834 MID TIDE 4(2) -1.6305253449
MID TIDE 4(3) 8.3428539337 5.4016500412 3.3254236482 2.7872289781 MID TIDE 4(3) 5.6899758744 MID TIDE 4(3) -1.6504819749
Mean 8.5089781354 5.4570387304 3.4915321324 2.8551148046 Mean 5.8191829994 Mean -1.6485923986
LOW TIDE 1(1) 7.823697655 5.7477006139 3.6714576182 2.979396105 LOW TIDE 1(1) 5.7476186291 LOW TIDE 1(1) -1.4575000863
LOW TIDE 1(2) 7.8899094177 5.5746352308 3.4984395844 2.8063771063 LOW TIDE 1(2) 5.6543280776 LOW TIDE 1(2) -1.5173005075
LOW TIDE 1(3) 7.7582037385 5.6625149621 3.5330586664 2.8790429713 LOW TIDE 1(3) 5.6512591223 LOW TIDE 1(3) -1.4780244484
Mean 7.8229352176 5.6598867026 3.565735989 2.8865341912 Mean 5.6828526364 Mean -1.4845047331
LOW TIDE 2(1) 7.4777835138 4.7095661591 3.4984395844 2.6333627705 LOW TIDE 2(1) 5.2285964191 LOW TIDE 2(1) -1.3094122534
LOW TIDE 2(2) 7.498765713 4.7161114071 3.4996988479 2.6427015942 LOW TIDE 2(2) 5.2381919893 LOW TIDE 2(2) -1.3139197182
LOW TIDE 2(3) 7.4339661825 4.6716782194 3.4795075483 2.6211013425 LOW TIDE 2(3) 5.1950506501 LOW TIDE 2(3) -1.2993081248
Mean 7.4699186008 4.6989852532 3.4925190538 2.6323614455 Mean 5.2204743026 Mean -1.3074747061
LOW TIDE 3(1) 7.4777835138 4.8825709164 3.1524135184 2.4603379157 LOW TIDE 3(1) 5.1709226495 LOW TIDE 3(1) -1.448347499
LOW TIDE 3(2) 7.4808727978 4.9352230787 3.1370194365 2.4525762314 LOW TIDE 3(2) 5.184371771 LOW TIDE 3(2) -1.4621219535
LOW TIDE 3(3) 7.5343752715 4.9684150919 3.1758698837 2.4662771917 LOW TIDE 3(3) 5.2262200824 LOW TIDE 3(3) -1.46873815
Mean 7.497444261 4.9283024891 3.1550125929 2.4597195372 Mean 5.1935864477 Mean -1.459635637
LOW TIDE 4(1) 7.4777835138 4.8825709164 3.4175865876 2.8063771063 LOW TIDE 4(1) 5.2593136726 LOW TIDE 4(1) -1.3296240513
LOW TIDE 4(2) 7.5146655083 4.9696577059 3.4271824924 2.8211760017 LOW TIDE 4(2) 5.3038352355 LOW TIDE 4(2) -1.3473982849
LOW TIDE 4(3) 7.4898693125 4.9238404547 3.4290319713 2.809994582 LOW TIDE 4(3) 5.2809139128 LOW TIDE 4(3) -1.335489013
Mean 7.494024543 4.9249181488 3.4245916219 2.8125021555 Mean 5.2811781046 Mean -1.3374212596

Sheet4

High Tide Average Mid Tide Average Low Tide Average
1.0797 0.7752333333 1.0985083333
2.0542083333 1.708975 2.1509166667
3.1032941667 2.793575 3.44735
4.585675 4.5070833333 5.2845666667
7.3183916667 7.8124666667 8.6366083333
19.6968075 27.7234916667 31.01025
49.4019166667 66.4411833333 77.2202666667
67.2172166667 83.8883 94.6739916667
86.8525916667 103.6813666667 122.6974416667
117.90515 131.472 155.1595416667
those can be used in minitab for comparison methods