09 Oct There are concerns among industrialists who are benefiting from dams

S222 HIT140 FOUNDATIONS OF DATA SCIENCE

Top of Form

Bottom of Form

Assignment Content

1.

Top of Form

About

This assignment should be completed in a group of 4 students.

This is the first of a two-part assessment,  the second part being the "Data science group project 2". Since professional projects often require that you work together with others, the assessments must be completed a team.

The current assignment evaluates your ability to:

· utilizese essential data wrangling techniques (Learning Outcome 2)

· perform descriptive and inferential statistical analyses (Learning Outcome 3)

In addition, it seeks to develop the following attributes:

· ability to work effectively in a team

· professionalism

· ethical conduct

Bottom of Form

2.

Top of Form

The Case Study

The district of Fairfield conducted an environmental study on freshwater reservoirs in its region. These include lakes, creeks, and public ponds. The study was instigated by recent concerns voiced by a local environmental protection group that fish in these reservoirs may have been contaminated by mercury that they are no longer safe for human consumption. 

Mercury is a toxic metal that occurs naturally in the environment. At times, however, human activities may result in unnatural releases of mercury into water bodies, which could in turn enter fish. Consuming mercury-contaminated fish can lead to severe neurological and physiological disorders in humans.

Fairfield’s officials identified 943 water reservoirs (including natural lakes) that have significant fisheries and are relatively accessible, based on information found in a previous survey carried out a decade ago. Of these, using the simple random sampling technique, 142 reservoirs were selected for the current study. Then, samples of fish were collected from only 122 reservoirs that contained a targeted group of predator fish species that the researchers are interested in. There are certain criteria that the researchers used for deciding the targeted fish species.

Fish were collected by angling, gill nets, trap nets, dip nets or beach seines. Up to 5 fish from the hierarchical order of preferred predator species were obtained. Care was taken to keep fish clean and free of contamination. In the laboratory, the fish fillet (muscle) of each fish was extracted and the fillets from each reservoir were ground up, combined and homogenised. Then, the tissue was subsampled to analyse the mercury levels.

In addition to collecting fish samples, the officials examined other possible factors that could contribute to elevated mercury levels in fish. They reckoned that this information could be useful for policy-making by members of the Fairfield legislature.

Following completion of the field study, you were handed a dataset containing 122 records of the studied reservoirs. Each record is described by the following variables: 

· Reservoir: name of the reservoir

· Fish: number of fish sampled

· Mercury: mercury level from sampled fish in parts per million (ppm)

· Elevation: reservoir’s elevation (in feet)

· Drainage: drainage area (in square miles). A drainage area is the area of land which collects and drains the rainwater which falls on it, such as the area around a reservoir.

· Surface Area: surface area of a reservoir (in acres)

· Max. Depth: maximum depth of a reservoir (in feet)

· RF: Runoff Factor. Runoff is the amount of rainwater or melted snow that flows into rivers and streams. Higher runoff factors may lead to more surface waters from the reservoir watershed reaching reservoirs, influencing mercury concentration in fish.

· FR: Flushing Rate. The flushing rate is the number of times all water in a reservoir is theoretically exchanged during a year.

· Dam: Impoundment class (1 = no functional dam present; all natural flowages. 0 = at some man-made flowage in the drainage area)

· RT: Reservoir Type. Three types of reservoirs are identified (1 = oligotrophic. 2 = eutrophic. 3 = mesotrophic)

· RS: Reservoir Stratification. Two indicators are used (1 = reservoir is stratified. 0 = reservoir is not stratified). A reservoir is considered ‘stratified’ if a temperature decrease of ≥1 degree per meter exists with depth.

Bottom of Form

Tasks

4. There are concerns among industrialists who are benefiting from dams and dam constructions that there will be claims that high mercury levels in fish are related to the presence of dams in the reservoir’s drainage. Does the data support or refute this claim? Provide some justifications.

,

Reservoir	Fish	Mercury	Elevation	Drainage Area	Surface Area	Max Depth	RF	FR	Dam	RT	RS
Abilene	3	0.053	196	6	74	36	0.44	1.1	1	2	0
Abraham Lake	4	0.35	345	15	360	80	0.51	1.7	0	3	1
Academy	5	0.54	487	1	175	10	0.57	1.5	0	3	0
Acadia	5	0.29	165	131	5543	100	0.51	1.1	0	2	1
Acadia Valley	5	0.91	1273	65	700	106	0.62	4.3	0	1	1
Acheson	5	0.36	1150	1	60	11	0.56	2.9	1	2	0
Acme	5	0.19	15	0	46	11	0.60	1.7	0	2	0
Adair Creek	4	0.21	54	57	4381	114	0.59	0.5	0	3	1
Adams Creek	2	0.28	298	226	14340	128	0.56	0.5	0	1	1
Bangs Lake	5	0.23	270	2	20	13	NA	NA	1	2	0
Bank Bay	5	0.62	717	4	272	13	0.56	2.7	1	3	0
Bank Creek	5	0.44	574	762	5581	136	0.50	3.2	1	1	1
Bankfoot Creek	4	0.05	1390	4	41	14	0.66	19.4	1	2	0
Bankhead	5	0.68	312	2	153	14	0.57	1.8	1	2	0
Bankview	5	0.6	362	14	239	15	0.06	1.2	1	3	0
Bannerman	5	0.19	296	1	87	15	0.47	2.0	1	2	0
Barnegat	2	0.43	634	6	227	150	0.53	0.5	1	1	1
Barnes Ridge	3	0.57	416	22	1568	158	0.53	0.3	0	1	1
Barnett Lake	3	0.071	212	2	53	16	0.62	6.8	0	3	0
Barnwell	3	0.14	1045	21	980	16	0.61	5.4	0	3	0
Fork Lake	5	0.29	203	23	430	8	0.51	20.1	0	2	0
Fort Creek	4	0.16	1373	0	30	8	0.61	2.3	1	2	0
Fox Creek	6	1.8	1154	19	201	42	0.62	0.9	NA	1	1
Gadois Lake	5	0.25	1244	39	713	80	0.46	2.0	1	1	1
Gap Creek	5	0.11	1189	4	388	85	0.56	0.3	1	1	1
Gardiner Creek	5	0.22	519	6	1222	88	NA	NA	1	1	1
Geikie Lake	5	0.18	122	10	25	9	0.51	58.8	1	2	0
Geraldine Lakes	5	0.57	910	2	45	9	NA	NA	1	2	0
Gerard Creek	5	0.41	913	41	225	90	0.61	7.3	1	1	1
Gertrude Lake	5	0.41	319	21	1574	92	0.50	0.5	NA	1	1
Giants Mirror	5	0.26	1486	1	91	96	0.76	0.8	0	1	1
Halach	4	0.43	882	15	630	17	0.61	2.9	1	2	0
Halcreek	5	0.9	683	10	93	18	0.59	18.9	0	3	0
Halfway Creek	5	0.28	101	0	49	18	0.51	0.9	1	3	0
Halifax Coulee	3	0.13	1633	0	14	18	0.71	1.8	1	2	0
Hamilton Hill	5	0.25	824	5	401	19	0.52	1.1	1	2	0
Hamptons	5	0.18	1095	0	24	19	0.46	0.8	1	2	1
Ice Water Creek	5	0.58	247	5	102	NA	NA	NA	NA	NA	NA
Junction Creek	4	0.82	204	14	102	6	0.57	50.9	1	2	0
Jutland Brook	5	0.45	419	6	605	60	0.58	0.7	1	3	1
Kakina Lake	5	0.26	922	298	2923	62	0.51	5.8	0	1	1
Kakut Creek	5	0.34	929	13	390	62	0.61	2.2	0	3	1
Kamisak Lake	3	0.37	17	21	392	63	0.58	2.3	0	3	1
Katchemut Creek	4	0.09	1209	5	280	68	0.76	0.9	1	1	1
Kaufmann Creek	3	0.77	311	6	564	74	0.61	0.8	0	2	1
Keane Creek	5	0.16	756	4	331	75	0.61	0.5	0	1	1
Keith Lake	5	0.27	397	2	128	8	0.61	7.9	1	3	0
Owl Lake	5	0.71	221	14	282	19	0.49	6.2	0	2	0
Owlseye Lake	5	0.36	377	2	109	19	0.58	2.2	1	2	0
Oxbow Lake	3	0.8	454	2	202	20	0.58	1.1	1	2	0
Oxley Creek	5	0.23	177	NA	44	20	NA	NA	0	2	0
Pair Lakes	3	0.1	1690	4	17	21	0.56	64.1	1	2	1
Pans Lake	5	0.37	637	3	13	21	0.50	25.2	1	3	1
Paradise Basin	5	0.49	67	11	135	21	0.58	5.9	0	3	1
Paradise Creek	5	0.79	417	123	6944	22	0.57	2.0	1	2	0
Parker Lake	4	2.5	50	1	35	22	0.63	3.9	1	2	1
Parlby Lake	5	0.52	271	9	203	22	0.58	10.1	0	3	0
Parsons Creek	4	0.79	1235	182	2627	24	0.61	13.1	0	2	0
Partridge Lake	5	0.86	76	19	234	24	0.66	12.6	0	3	0
Pasque Creek	5	0.31	446	7	576	25	0.56	1.1	1	2	0
Pastecho Lake	4	0.91	500	5	685	25	0.51	0.6	1	2	0
Plante Creek	5	0.47	778	23	638	25	0.56	4.2	1	3	0
Plover Lake	2	0.025	1494	1	47	26	0.69	0.8	1	2	0
Poboktan Creek	5	1.12	311	66	1539	26	0.56	4.7	1	3	0
Poison Creek	3	1.08	425	2	83	27	0.60	2.8	1	3	1
Pony Creek	5	0.41	328	NA	315	27	0.58	0.7	1	3	0
Popular Point Lake	4	0.94	263	NA	1823	27	0.47	0.2	0	2	NA
Stimson Creek	5