## MTH218 University of Phoenix Health Services and Nursing Scenario Worksheet

Create three visuals in Excel that include the following:

1. Box-and-Whisker Plot

Summary of visual: Combine yearly data for age ranges so that your visual has age ranges on the vertical axis and the number of patients or inmates on the horizontal axis. There should be one box-and-whisker plot for each of the 4 age ranges, and all 4 of the plots should be on the same visual chart. Include a descriptive title for the visual. Some of the data provided is not needed. Only include data from the location requested in the scenario. The calculations for this visual should be produced from the Five Number Summary, the Outlier Check, and the Boxes stacked Bar chart tables in the Excel® file for the topic you chose.

Five Number Summary: Fill out the Five Number Summary table in the Excel® file for the topic you chose.

Outlier Check: Fill out the Outlier Check table in the Excel® file for the topic you chose. Include the outliers in the box-and-whisker plots.

Boxes stacked Bar chart: Fill out the Boxes stacked Bar chart table in the Excel® file for the topic you chose.

2. Histogram

Summary of visual: Similar to the Box-and-Whisker Plot, combine yearly data for age ranges so that your visual has age ranges on the vertical axis and the number of patients or inmates on the horizontal axis. Include a descriptive title for the visual. Some of the data provided is not needed. Only include data from the location requested in the scenario. The calculations for this visual should be produced from the Frequency Table for Histogram in the Excel® file for the topic you chose.

Frequency Table for Histogram: Fill out the Frequency Table for Histogram in the Excel® file for the topic you chose. This requires manual calculations to add up the total patients or inmates for each age range from the data given in the scenario.

3. Scatterplot

Summary of visual: Unlike the Box-and-Whisker Plot and the Histogram, this visual requires that you combine age range data for each year so that your visual has total patients or inmates on the vertical axis and the year on the horizontal axis. Include a descriptive title for the visual. Some of the data provided is not needed. Only include data from the location requested in the scenario. The calculations for this visual should be produced from the Frequency Table for XY Scatterplot in the Excel® file for the topic you chose.

Frequency table for XY Scatterplot: Fill out the Frequency table in the Excel® file for the topic you chose. This requires manual calculations to add up the total patients or inmates per year from the data given in the scenario.

Trend line: A linear trend line (regression) must be present in the visual including the equation and the R2 value. The trend line must extend for at least 3 years in the future to make a prediction.

Create a Word document that includes the following items:

Brief description of your visuals (15 to 50 words)

Box-and-whisker plot: Describe the central tendency and outliers of the values. What does this information tell you about the data and about your project? (100 to 150 words)

Histogram: Describe the shape of the plot and the spread of the numbers. How is this visual useful compared to the Box-and-whisker plot? (50 to 150 words)

Scatterplot: How is this visual useful compared to the Box-and-whisker plot and the histogram? What is the prediction/forecast for the trend line for 3 years in the future? How confident are you in the prediction/forecast for 3 years in the future? State your prediction and provide justification. (50 to 150 words)

Part 2

Create a 5- to 7-minute presentation with speaker notes for each slide that must include:

Introduction (approximately 1 minute):

What should the audience learn from your presentation?

Visuals/Evidence (approximately 4 to 5 minutes):

Show your tables, visuals, calculations, and any other evidence to support your conclusion(s).

Discuss the strengths of each visual.

Conclusion (approximately 1 minute)

How confident are you that your scatterplot prediction for 3 years in the future is sound?

What work would need to be done to increase your confidence?

Discuss what you learned from this project.

Include detailed speaker notes for each slide.

CLICK ORDER NOW TO GET A CUSTOMIZED PAPER ON THIS TOPIC JUST FOR YOU!! 0%PLAGIARISM 100% ORIGINAL PAPER

### 6 Responses to “MTH218 University of Phoenix Health Services and Nursing Scenario Worksheet”

1. Celsa Leon says:

My brother recommended I might like this web site. He was entirely right. This post actually made my day. You can not imagine simply how much time I had spent for this information! Thanks!

2. 184179 523988I discovered your weblog site on google and verify some of your early posts. Continue to maintain up the superb operate. I just extra up your RSS feed to my MSN News Reader. Searching for forward to reading extra from you in a while! 71301

3. 130872 926500Hello. superb job. I did not anticipate this. This really is a splendid articles. Thanks! 343523

4. 21976 577982I feel other site proprietors should take this website as an model, quite clean and superb user genial style . 709652

5. Urban Nido says:

208823 536955Hi! Someone in my Facebook group shared this site with us so I came to check it out. Im undoubtedly loving the data. Im book-marking and will be tweeting this to my followers! Outstanding blog and wonderful style and style. 13029

6. 626308 657830Attractive portion of content material. I just stumbled upon your weblog and in accession capital to assert that I get in fact loved account your weblog posts. Anyway I will likely be subscribing to your augment and even I success you get admission to constantly speedily. 88555