Description
Create at least three visuals. I have attached the numbers on the excel spreadsheet it is to be used with topic 1 Humboldt county Expected Medicare Payers
- One visual must be a scatterplot with trend line, equation and R2 value.
- Two of the remaining required visuals can be a histogram, box and whisker plot, or pie chart.
- Please note that the data sets include data that will not be needed to create your visuals. Quantitative reasoning requires critical thinking to decide what data is necessary.
Create a Word document that includes your three visuals and the following items:
- Title of your project and the scenario you are addressing
- Brief description of each visual (15 to 50 words)
- Consider including the following for each visual when applicable:
- A chart title that is appropriate for the data
- A descriptive x-axis label
- A descriptive y-axis label
- For your xy scatterplot, make at least one prediction using the trendline equation for some date into the future. How confident are you in this prediction? State your prediction and provide justification (50 to 150 words).
- If you created a box and whisker plot, describe the central tendency of the values. What does this tell you about the data and about your project?
- Calculate the mean of the sample data.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is my answer :)
Health Services and Nursing Scenario
Topic 1
Scenario 1
Year
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Year
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Total
Min
Q1
Median
Q3
Max
Predicting Expected Medicare Payers
Review data of the expected payers that used Medicare 2003 to 2014. Predict the percentage of
expected payers that will use Medicare in 2018.
County
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Humbolt
Medicare payers
35612
37412
39841
40123
43122
44125
51229
59748
57008
56727
57985
63123
586055
Medicare payers
35612
40052.5
47677
57252.25
63123
Zip Code
90001
90001
90001
90001
90001
90001
90001
90001
90001
90001
90001
90001
Relative Frequency
0.0608
0.0638
0.0680
0.0685
0.0736
0.0753
0.0874
0.1019
0.0973
0.0968
0.0989
0.1077
1.0000
Medicare payers
35612
37412
39841
40123
43122
44125
51229
59748
57008
56727
57985
63123
Cumulative Relative
Frequency
0.0608
0.1246
0.1926
0.2610
0.3346
0.4099
0.4973
0.5993
0.6966
0.7934
0.8923
1.0000
Box 1 - hidden
Box 2 - lower
Box 3 - upper
40052.5
7624.5
9575.25
Whisker Top
Whisker Bottom
5870.75
4440.5
Mean
48837.92
o
ict the percentage of
Linear Model
70000
Medicare payers
60000
50000
y = 2613.2x - 5E+06
R² = 0.9224
40000
30000
20000
10000
0
2002
2004
2006
2008
2010
2012
2014
Year
Histogram
0.1200
Relative Freuency
0.1000
0.0800
0.0600
0.0400
0.0200
0.0000
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
Year
Box and Whisker Plot
70000
Medicare payers
60000
50000
40000
2016
Medicare payers
30000
20000
10000
0
Security and Criminal Justice Scenario
Predicting Total US correctional population
Review the data on persons supervised by U.S. adult correctional systems by correctional status.
Scenario 2 Predict the number of the United States population that will be supervised by U.S. adult
correctional system in 2018.
Topic 2
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Total US
correctional
population
6,467,800
6,584,900
6,730,900
6,886,800
6,997,000
7,055,600
7,199,700
7,339,600
7,313,600
7,235,200
7,086,500
6,989,200
6,945,100
6,903,200
6,851,000
Probation
3,839,400
3,934,500
3,995,000
4,073,800
4,140,400
4,162,300
4,236,800
4,293,000
4,270,100
4,196,200
4,053,600
3,969,400
3,940,800
3,910,600
3,864,100
Parole
725,500
731,100
753,100
773,500
77...