Description
Here’s your step-by-step instructions:
- Consult the 2016 and 2017 City of Flint Annual Water Quality reports (on Canvas) for data on lead testing, specifically the following values.
90th percentile values for lead for each of the four test periods:
- Jan 1, 2016-June 30, 2016
- July 1, 2016-Dec 31, 2016
- Jan 1, 2017-June 30, 2017
- July 1, 2017-Dec 31, 2017
- Create a bar chart with a trend line (see Lecture for an example), which demonstrates how these measurements have changed over time.
- Design the graph so that the x-axis demonstrates the time period, and the y-axis conveys the 90th percentile lead values.
- Label each axis accordingly (e.g., “Testing date,” and “Lead values in ppb”).
- Include a key, if necessary.
- Title the graph
- Write up a 300-400 word memo explaining the graph, and relating your analysis to the theme of urban access to water.
To guide your memo, consider the following questions:
- What do values that are at the 90th percentile mean?
- What do the acronyms AL and MCLG mean?
- Did the lead measurements exceed AL and MCLG for each time period? Or were they less than the AL and MCLG? If at all, how did this change?
- What are the implications of the number of samples above AL and MCLG for understanding the evolving lead-related health risks for the City’s residents?
- Apply your analysis, by outlining one policy implication.
- Cite your sources!
You may cite the reports according to the APA format as follows:
City of Flint. (2016). Annual Water Quality Report. Flint, MI.
City of Flint. (2017). Annual Water Quality Report. Flint, MI.
By now you are likely a whiz at this. Remember to cite the sources provided as well as any other sources you might choose.
The Owl Purdue website is an excellent resource if you have questions on how to cite other sources correctly: https://owl.purdue.edu/owl/research_and_citation/resources.html (Links to an external site.)Links to an external site.
Format:
- A graph that is clearly labeled, defined, and has a title
- Font: Times New Roman, 11 or 12 point font
- Line spacing: double-spaced, 1-inch margins
- Memo number of words: 300-400
Explanation & Answer
Attached.
Running Head: DRINKING WATER DATA ANALYSIS
Drinking Water Data Analysis
Student’s Name
University Details
Date
1
DRINKING WATER DATA ANALYSIS
2
City of Flint Drinking Water Data Analysis
90 Percentile Lead content values in ppb
CITY OF FLINT DRINKING WATER LEAD CONTENT VALUES
25
20
15
90 Percentile (in ppb
units)
10
5
y = 28.284e-0.415x
Expon. (90 Percentile (in
ppb units))
0
1 Jan –
Jun 30
2016
1 July- 1 Jan – 1 JulyDec 31 Jun 30 Dec 31
2016
2017
2017
Testing Period
Figure: The graph, Lead content values in drinking water for the City of Flint
Percentiles describe the comparative standing of particu...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Fault in Our Stars
by John Green
Sounds Like Titanic
by Jessica Chiccehito Hindman
The Visible Filth
by Nathan Ballingrud
The BFG
by Roald Dahl
The House of the Seven Gables
by Nathaniel Hawthorne
Death Of A Salesmen
by Arthur Miller
Where'd You Go Bernadette
by Maria Semple
No Exit
by Taylor Adams
The Remains Of The Day
by Kazuo Ishiguro