create a microsoft word document that includes your three visuals

Create at least three visuals using week 2 data set. One visual must be a scatter plot with trend line, equation, R2 value, and prediction value.Two of the remaining visuals can be a: histogram, box and whisker plot, or pie chart.

The purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2. Use statistical reasoning and mathematical modeling to show central tendency and two-variable analyses, including regression with equation and R2 value.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

In this stage you will do statistical reasoning and mathematical modeling to show central tendency and two variable analyses, including regression with equation and R squared value from the data set you chose in Week 2. The purpose of this assignment is to have you practice creating visuals using your own data. This shows you how you will be working with data in your own careers.

Weeks 2 data set

Health Services and Nursing Scenario
Topic 1 Predicting Expected Medicare Payers
Scenario 1 Review data of the expected payers that used Medicare between 2003 and 2014. Predict the percentage of expected payers that will use Medicare in 2018.
Year County Zip Code Medicare payers
2003 Humbolt 90001 35612
2004 Humbolt 90001 37412 1800
2005 Humbolt 90001 39841 2429
2006 Humbolt 90001 40123
2007 Humbolt 90001 43122
2008 Humbolt 90001 44125
2009 Humbolt 90001 51229
2010 Humbolt 90001 59748
2011 Humbolt 90001 57008
2012 Humbolt 90001 56727
2013 Humbolt 90001 57985
2014 Humbolt 90001 63123

Create at least three visuals.

  • One visual must be a scatter plot with trend line, equation, R2 value, and prediction value.
  • Two of the remaining required visuals can be of the following format: histogram, box and whisker plot, or pie chart.
  • Please note that the data set that you chose in Week 2 includes data that will not be needed to create your visuals. Quantitative reasoning requires critical thinking to decide what data is necessary.

Create a Microsoft® 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 scatter plot, make at least one prediction using the trend line equation for a date in 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.