Helen’s rMarkdown Document

MBA676 Data Management & Analytics

Assignment 1

Created Sept 24, 2017

This assignment uses Maine Aresnic and Floride well data from the state database for private well water samples tested by the State of Maine Health and Environmental Testing Laboratory (HETL) between the years 1999 and 2013.

For locations with fewer than 20 wells tested, only the number of wells tested and the maximum value are displayed. All test results reported as less than the laboratory’s limit of detection were replaced with a value that is one-half of the detection limit. Unit abbreviations are: mg/L for milligrams per liter, ug/L for micrograms per liter.

Maine’s Maximum Exposure Guideline for fluoride is 2 milligrams per liter (mg/L). For arsenic is 10 micrograms per liter (ug/L).

Towns where the Max Aresnic level is below the Maximum Exposure Guideline (10 ug/L)
183
Towns where the Max Aresnic level is above the Maximum Exposure Guideline (10 ug/L)
370
Towns where Max Aresnic level is not listed
364
Towns where the Max Floride level is above the Maximum Exposure Guideline (2m/L)
343
Towns where the Max Floride level is below the Maximum Exposure Guideline (2 mg/L)
211
Towns where Max Floride level is not listed
363
Location NumA_Wells_Tested NumF_Wells_Tested
Moosehead Junction Twp 1 0
Seven Ponds Twp 1 0
Number of towns where wells tested with median levels for both Floride and Aresnic within acceptable levels
338
Towns where the median levels for Floride is acceptable and Aresnic level is not
Location NumA_Wells_Tested A_Median NumF_Wells_Tested F_Median
Gorham 467 10.5 452 0.1
Manchester 275 14.0 276 0.3
Monmouth 277 10.0 288 0.3
Top 20 towns with the highest median Aresnic level
Location NumA_Wells_Tested A_Median Aresnic_Max
Manchester 275 14.00 200
Gorham 467 10.50 460
Monmouth 277 10.00 368
Columbia 42 9.80 200
Eliot 73 9.70 45
Hallowell 65 8.60 431
Winthrop 424 8.20 240
Columbia Falls 25 8.10 71
Mariaville 30 7.20 57
Readfield 344 7.20 280
Blue Hill 241 7.00 930
Litchfield 262 7.00 400
Millinocket 29 6.80 62
Buxton 334 6.00 670
Surry 181 6.00 470
Rome 79 5.50 55
Orland 123 5.40 160
Belgrade 401 5.25 220
Hollis 133 5.25 400
Top 20 towns with the highest median Floride level
Location NumF_Wells_Tested F_Median Floride_Max
Eastbrook 31 1.290 3.3
Otis 60 1.130 3.6
Marshfield 31 1.000 4.4
Dedham 102 0.940 7.0
Surry 175 0.800 6.9
Prospect 57 0.785 2.7
Fryeburg 52 0.760 4.1
Mercer 32 0.600 6.1
Rome 82 0.600 4.5
Stockton Springs 56 0.600 3.3
Ellsworth 503 0.500 7.0
Millinocket 29 0.495 3.4
Charlotte 24 0.490 5.3
Stoneham 25 0.490 3.0
Denmark 46 0.450 3.9
Smithfield 79 0.450 3.3
Casco 119 0.445 3.5
Chesterville 81 0.440 4.7
Otisfield 62 0.440 5.2
Lovell 43 0.435 4.9

This document was created with rMarkdown.