Creating Vusuals from Data

User Generated

Vevf86

Mathematics

MTH216

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

Health Services and Nursing Scenario Topic 1 Scenario 1 Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 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 Zip Code 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 90001 Medicare payers 35612 37412 39841 40123 43122 44125 51229 59748 57008 56727 57985 63123 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 775,900 784,400 798,200 826,100 828,200 824,100 840,700 854,600 857,800 855,200 856,900 nario ms by correctional status. sed by U.S. adult Humanities and Sciences Scenario Topic 3 Scenario 3 Year Yearly Tuition 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 $29,450 $24,444 $20,288 $17,245 $16,412 $15,984 $8,618 $7,153 $5,937 $14,658 $13,549 $12,435 Predicted College Tuition and Fees Review college data of the yearly tuition & fees. Predict the cost of yearly tuition and fees in 2018. Books & Supplies $1,250 $1,038 $861 $732 $625 $600 $1,200 $996 $827 $703 $699 $612 Living Costs $12,400 $10,292 $8,542 $7,261 $6,532 $5,899 $15,682 $13,016 $10,803 $9,183 $5,771 $5,256 Yearly Tuition & Fees $44,190 $36,679 $30,442 $25,876 $24,112 $22,984 $25,770 $21,389 $17,753 $24,702 $20,142 $18,415 nario uition and fees in 2018. Social Sciences Scenario Predicting Teen Communication Preferences Review the data on communication preferences with teens. Predict how many high-school teens will Scenario 4 prefer to use face-to-face communication in 2018. Topic 4 Communication Preference Age School Level 2000 2001 2002 Face to Face Face to Face Face to Face Teen Teen Teen HS HS HS 2003 Face to Face Teen HS 76 2004 Face to Face Teen HS 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Face to Face Teen Teen Teen Teen Teen Teen Teen Teen Teen Teen Teen HS HS HS HS HS HS HS HS HS HS HS 55 49 50 43 42 36 23 30 15 13 8 5 Logarithmic Regression 120 Number of Teens 87 98 Year 86 120 y = -12105ln(x) + 92102 R² = 0.9473 Number of Teens 100 80 60 40 20 0 1998 -20 2000 2002 2004 2006 2008 Year 2010 2012 2014 2016 ario edict how many high-school teens will Business Scenario Topic 5 Scenario 5 Year 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Predicting Tires Purchased Review the yearly data involving tires purchased at a tire shop with declining business. Predict how m tires will need to be in stock to have available for the customers in 2018. Tires Wheels Lugnuts Purchased Purchased Purchased 20,478 20,018 28,592 15,478 18,274 9,967 11,148 13,086 11,148 17,916 14,659 14,659 13,390 9,697 8,080 16,146 25,698 18,425 18,456 32,237 15,132 12,570 21,404 9,173 16,243 14,993 7,184 15,628 18,346 9,852 18,063 14,193 6,999 7,122 3,052 3,713 6,649 3,740 3,586 9,217 4,748 3,994 6,235 3,662 2,733 16,542 12,426 8,145 12,459 8,743 11,405 9,322 5,243 6,033 8,704 4,687 4,491 9,904 4,661 5,028 ng business. Predict how many Education Scenario Topic 6 Scenario 6 Predicting SAT Test Scores Review the data on the average SAT scores of college-bound seniors from 2002-2015. Predict the 2018. Average SAT-Mathematics of college-bound seniors Year 2002 2003 2004 All students Average White Black Mexican American Puerto Rican Other Hispanic Asian/Pacific Islander American Indian/Alaska Native 2005 2006 2007 2008 2009 540 530 426 460 566 467 529 531 426 458 451 465 530 533 427 457 451 464 522 534 426 457 453 464 531 531 427 458 452 465 523 536 431 463 457 469 525 536 429 465 456 463 530 534 429 466 454 463 565 566 569 575 577 580 578 578 481 479 483 482 488 493 494 494 ario 2002-2015. Predict the average SAT scores of college-bound seniors in 2010 2011 2012 2013 2014 2015 525 537 426 463 453 461 520 536 426 463 450 461 519 536 428 467 452 462 516 535 427 466 452 462 518 536 428 465 452 461 514 534 429 464 453 461 581 587 591 595 595 597 491 493 492 488 489 486
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags