{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SoilDataSpreadSheet_2005_11_18 Changed II

SoilDataSpreadSheet_2005_11_18 Changed II - DIST LEAD 2500...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
0 20 40 60 80 100 120 140 160 180 200 0 500 1000 1500 2000 2500 f(x) = 5.0220972992x - 48.2018273911 R² = 0.0616460401 DIST LEAD Column P Linear Regression for Column P
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
0 0.05 0.1 0.15 0.2 0.25 0.3 0.35 0.4 0.45 0.5 0 200 400 600 800 1000 1200 1400 1600 f(x) = -328.5642174777x + 899.8190832726 R² = 0.0108270598 Distance from Factory versus Lead Concentrations Distance from the Factory (degrees) Lead Concentrations (ppm)
Background image of page 2
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0 20 40 60 80 100 120 140 160 180 f(x) = 4.2961042924x + 31.5570248488 R² = 0.0003477969 Chart Title Distance (degrees) Chromium (ppt)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
0 0.002 0.004 0.006 0.008 0.01 0.012 0.014 0.016 0 5000 10000 15000 20000 25000 30000 f(x) = 70776.1016617601x + 17425.4220748995 R² = 0.0020715099 Chart Title dist lead
Background image of page 4
-87.9 -87.8 -87.7 -87.6 -87.5 -87.4 -87.3 -87.2 40.8 41 41.2 41.4 41.6 41.8 42 42.2 Locations graphed Longitude Latitude
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
GOOD DATA RESULTS SampleID Kram Long Kram Lat Longitute Latitude D Long D Lat Distance Mass Iron (l) Iron (soil) Lead(l) Lead (soil) Arsenic(l) Arsenic (soil) Chromium (l) Chromium (soil) Moisture Section Hood B13 -87.66008 41.85405 -87.6575 41.85647 -0.00258 -0.00242 0.0035373436 1.0013 177.958 17772.7 5.20516 519.84020773 0.095488 9.5364026765 0.330648 33.021871567 14.02 23 1 C14 -87.66008 41.85405 -87.65972 41.80417 -0.00036 0.04988 0.0498812991 1.006 56.1376 5580.278 5.23162 520.041749503 0.01876 1.864801193 0.047185 4.6903578529 7.1 25 10 C14 -87.66008 41.85405 -87.658 41.804 -0.00208 0.05005 0.0500932021 1.002 56.1376 5602.555 5.23162 522.1177644711 0.01876 1.872255489 0.047185 4.7090818363 5.931 25 39 C14 -87.66008 41.85405 -87.65 41.8 -0.01008 0.05405 0.0549818961 1.002 56.13761 5602.556 5.23162 522.1177644711 0.01876 1.872255489 0.047185 4.7090818363 5.93 25 37 F14 -87.66008 41.85405 -87.66036 41.85222 0.00028 0.00183 0.0018512968 1.004 220.967 22008.67 5.32925 530.8017928287 0.002091 0.2082669323 0.459659 45.7827689243 3.4 24 24 B9 -87.66008 41.85405 -87.6709 41.8532 0.01082 0.00085 0.0108533359 1.005 185.668 18474.43 5.37331 534.6577114428 0.098987 9.8494527363 0.182055 18.1149253731 10.87 24 31 B10 -87.66008 41.85405 -87.669 41.854 0.00892 0.00005 0.0089201401 1.0103 253.189 25060.77 5.47483 541.9014154212 0.0787986 7.7995248936 0.157481 15.587548253 8.7 23 17 F4 -87.66008 41.85405 -87.664 41.862 0.00392 -0.00795 0.00886391 1.002 129.802 12954.29 5.57221 556.1087824351 0.045866 4.57744511 0.226304 22.5852295409 23.341 23 9 B3 -87.66008 41.85405 -87.6634 41.852687 0.00332 0.001363 0.0035888952 1.0312 187.137 18147.5 5.73632 556.2761830877 0.05095 4.94079713 0.332198 32.2147013189 5.79 21 15 F21 -87.66008 41.85405 -87.656595 41.852105 -0.003485 0.001945 0.0039910212 1.02 187.137 18346.76 5.73632 562.3843137255 0.05095 4.9950980392 0.332198 32.5684313725 9.3 23 26 F4 -87.66008 41.85405 -87.394965 41.511127 -0.265115 0.342923 0.4334537428 1.0022 150.795 15046.4 5.65703 564.4611853921 0.032251 3.217990421 0.30542 30.4749550988 6.672 23 40 B13 -87.66008 41.85405 -87.66 41.86 -0.00008 -0.00595 0.0059505378 1.002 183.231 18286.53 5.6577 564.6407185629 0.116819 11.65858283 0.185759 18.5388223553 11.39 21 20 F8 -87.66008 41.85405 -87.6639 41.8525 0.00382 0.00155 0.0041224871 1.0556 303.048 28708.6 6.1596 583.5164835165 0.06325 5.9918529746 0.582131 55.1469306556 5.57 22 43 A3 -87.66008 41.85405 -87.66027 41.85722 0.00019 -0.00317 0.0031756889 1.047 212.717 20316.81 6.33741 605.2922636103 0.074315 7.0978987584 0.243359 23.2434574976 3.9 26 33 G17 -87.66008 41.85405 -87.65 41.85 -0.01008 0.00405 0.0108631901 1.006 126.999 12624.16 6.10438 606.7972166998 1.7501 173.9662028 0.2339 23.2504970179 4.927 22 8 G8 -87.66008 41.85405 -87.6618 41.8562 0.00172 -0.00215 0.0027533434 1.0076 132.462 13146.29 6.11719 607.1050019849 0.062548 6.2076220723 0.258733 25.6781460897 7.6 25 2 B8 -87.66008 41.85405 -87.7 41.9 0.03992 -0.04595 0.0608687843 1.003 199.613 19901.6 6.2386 621.9940179462 0.040416 4.029511466 0.176879 17.634995015 6.79 24 6 C7 -87.66008 41.85405 -87.653925 41.858792 -0.006155 -0.004742 0.0077698513 1.0127 191.021 18862.55 6.72837 664.3991310358 0.028725 2.836437247 0.496781 49.0551002271 32.098 26 5 D15 -87.66008 41.85405 -87.665952 41.851932 0.005872 0.002118 0.0062422999 1 164.48 16448 6.71101 671.101 0.05546 5.546 0.37598 37.598 7.73 22 13 B4 -87.66008 41.85405 -87.665958 41.852204 0.005878 0.001846 0.0061610551 1.0119 208.24 20579.11 6.83346 675.3098132227 0.085292 8.4288664888 0.312259 30.8586816879 5.23 25 5 B19 -87.66008 41.85405 -87.6547 41.8523 -0.00538 0.00175 0.0056574641 1.0073 259.576 25769.48 7.25698 720.4387967835 0.431776 42.86468778 0.292868 29.0745557431 0.333 26 13 F8 -87.66008 41.85405 -87.66 41.85 -0.00008 0.00405 0.00405079 1.001 379.373 37899.4 7.40442 739.7022977023 0.003866 0.3862137862 0.68105 68.036963037 0.523 24 9 F12 -87.66008 41.85405 -87.664 41.852 0.00392 0.00205 0.0044236749 0.998 375.126 37587.78 7.4362 745.1102204409 0.003573 0.358016032 0.735271 73.6744488978 15.7 24 27 G4 -87.66008 41.85405 -87.666 41.855 0.00592 -0.00095 0.0059957402 1.009 45.8127 4540.406 7.82587 775.6065411298 0.002145 0.2125748266 0.135064 13.3859266601 30.41 21 27 F7 -87.66008 41.85405 -87.66405556 41.85258333 0.0039756 0.0014667 0.0042374755 1.0087 179.441 17789.33 7.9323 786.3884207396 0.0366786 3.6362248439 0.400709 39.7252899772 9.991 23 12 D20 -87.66008 41.85405 -87.65774 41.85973 -0.00234 -0.00568 0.0061431262 1.0413 201.885 19387.78 8.23498 790.836454432 0.0989973 9.5070872947 0.28636 27.5002400845 7.73 26 30 F10 -87.66008 41.85405 -87.85 41.66 0.18992 0.19405 0.271523496 1.0056 347.381 34544.65 7.96561 792.1250994431 0.008079 0.803400955 0.554442 55.1354415274 6.79 24 38 C23 -87.66008 41.85405 -87.66 41.84 -0.00008 0.01405 0.0140502278 1.051 202.982 19313.23 8.46936 805.8382492864 0.043382 4.1276498573 0.209074 19.8928639391 3.8 26 23 A7 -87.66008 41.85405 -87.65603 41.85675 -0.00405 -0.0027 0.0048674942 1.0658 156.269 14662.13 8.68758 815.1229123663 0.061447 5.7653405892 0.176254 16.5372490148 13.58 26 16 C19 -87.66008 41.85405 -87.6548 41.8552 -0.00528 -0.00115 0.0054037857 1.09 254.873 23382.84 8.94493 820.6357798165 0.080792 7.41212844 0.184902 16.9634862385 11.3 26 22 F16 -87.66008 41.85405 -87.6611 41.8533 0.00102 0.00075 0.0012660569 1.0183 221.037 21706.47 8.35849 820.8278503388 0.048496 4.762447216 0.238215 23.393400766 19.4 23 21 F2 -87.66008 41.85405 -87.66233611 41.8537138889 0.0022561 0.0003361 0.0022810103 1 188.621 18862.1 8.93645 893.645 0.001292 0.1292 0.353491 35.3491 7.8 24 28 D22 -87.66008 41.85405 -87.657687 41.859667 -0.002393 -0.005617 0.0061055006 0.9574 212.769 22223.63 8.63586 902.0116983497 0.077775 8.1235638187 0.268413 28.0356172968 7.08 25 12 F9 -87.66008 41.85405 -87.7 41.9 0.03992 -0.04595 0.0608687843 0.9984 297.531 29800.78 9.05603 907.054286859 0.004928 0.4935897436 0.466303 46.7050280449 3.21 24 10 B16 -87.66008 41.85405 -87.83 42.08 0.16992 -0.22595 0.2827122369 1 234.118 23411.8 9.12913 912.913 0.066014 6.60135 1.65876 165.876 9.97 22 40 C17 -87.66008 41.85405 -87.65478161 41.8559255572 -0.005298 -0.001876 0.0056205528 1.079 100.663 9329.286 9.88178 915.827618165 0.058455 5.417479147 0.0600672 5.5669323448 1.4 26 12 H2 -87.66008 41.85405 -87.682175 41.84924 0.022095 0.00481 0.0226124993 0.9991 172.495 17265 9.20906 921.7355620058 0.036401 3.643379041 0.287486 28.7744970473 10.244 24 48 B6 -87.66008 41.85405 -87.6685 41.8523 0.00842 0.00175 0.008599936 1.001 235.54 23530.47 9.24462 923.5384615385 0.071619 7.154745255 0.19936 19.9160839161 3.8 21 16 C22 -87.66008 41.85405 -87.6535 41.8545 -0.00658 -0.00045 0.0065953696 1.006 174.625 17358.35 9.29871 924.3250497018 0.030384 3.02027833 0.117918 11.721471173 7.09 26 48 A6 -87.66008 41.85405 -87.708056 41.924722 0.047976 -0.070672 0.0854179616 1.033 117.863 11409.78 9.56707 926.1442400774 0.049448 4.786863504 0.0960365 9.2968538238 2.5269 26 17 C12 -87.66008 41.85405 -87.661 41.8541 0.00092 -0.00005 0.0009213577 1.0013 145.572 14538.3 9.55273 954.0327574154 0.032504 3.246179966 0.193237 19.2986118047 4.93 24 5 A13 -87.66008 41.85405 -87.7 41.9 0.03992 -0.04595 0.0608687843 1.008 181.265 17982.64 9.75612 967.869047619 0.055179 5.47406746 0.239659 23.7756944444 12.1 25 41 G24 -87.66008 41.85405 -87.66 41.854 -0.00008 0.00005 9.4339811319E-005 1.0143 164.08 16176.67 10.0104 986.9269446909 0.02506 2.4706694272 0.38632 38.0873508824 2.24 22 28 B18 -87.66008 41.85405 -87.6547 41.8525 -0.00538 0.00155 0.0055988302 1.0035 348.267 34705.23 9.97173 993.6950672646 0.002366 0.2357747882 0.228266 22.7469855506 3.007 24 34 F16 -87.66008 41.85405 -87.66 41.85 -0.00008 0.00405 0.00405079 1.0029 187.503 18696.08 10.0544 1002.5326552996 0.039405 3.9291055938 0.200018 19.9439625087 13.6 23 28 B10 -87.66008 41.85405 -87.666 41.865 0.00592 -0.01095 0.0124478472 0.916 263.602 28777.51 9.20688 1005.1179039301 0.03503 3.8242358079 0.513194 56.0255458515 10.14 23 32 D24 -87.66008 41.85405 -87.6659 41.8565 0.00582 -0.00245 0.0063146576 1.02 223.652 21926.67 10.3545 1015.1470588235 0.068172 6.6835294118 0.147859 14.4959803922 2.5 25 16 F15 -87.66008 41.85405 -87.3661 41.8542 -0.29398 -0.00015 0.2939800383 0.998 261.874 26239.88 10.1703 1019.0681362726 0.049862 4.996172345 0.507978 50.8995991984 2.3 23 38 B5 -87.66008 41.85405 -87.666 41.851 0.00592 0.00305 0.006659497 1.0005 340.109 33993.9 10.3232 1031.804097951 0.002686 0.2684357821 0.673872 67.3535232384 10.68 24 19 E9 -87.66008 41.85405 -87.656252 41.855032 -0.003828 -0.000982 0.0039519499 1.002 210.684 21026.35 10.3927 1037.1956087824 0.058995 5.8876846307 0.323941 32.3294411178 6 26 46 F23 -87.66008 41.85405 -87.65 41.85 -0.01008 0.00405 0.0108631901 1.0319 168.98 16375.62 10.74 1040.7985269891 0.03 2.9072584553 0.31 30.0416707045 0.908 26
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}