You create 3 visuals from the data given in each scenario: a histogram, box-and-whisker plot, and an xy scatterplot.

hey i need you to carry through for me again maciej. The purpose of this assignment is to take the data from the topic you selected in Week 2 and create visuals using statistics. You create 3 visuals from the data given in each scenario: a histogram, box-and-whisker plot, and an xy scatterplot. You use Microsoft® Excel® to create these visuals. In this assignment you are also introduced to messy data, which means you will not need all of the data provided to create each visual. You will perform some statistical calculations to the data before creating your visuals.The Five Number SummaryHow to Create a Box-and-Whisker Plot in Excel 2013®How to Create a Histogram in Excel®How to Create Trendlines and Scatterplots in Excel®Create three visuals in Excel that include the following:1. Box-and-Whisker PlotSummary 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. HistogramSummary 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:Title of your project and the scenario you are addressingBrief 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)
mth218r3_week3_grading_guide.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
You create 3 visuals from the data given in each scenario: a histogram, box-and-whisker plot, and an xy scatterplot.
Just from $13/Page
Order Essay

Week 3 Signature Assignment Grading Guide
MTH/218 Version 3
Week 3 Signature Assignment Grading Guide
Mathematical Computations (60%)
• Mathematical computations are correct for the
following:
o Five Number Summary
o Outlier Check
o Boxes stacked Bar chart
o Frequency table for Histogram
o Frequency Table for XY Scatterplot
• There is an accurate analysis of the data in the
Word document.
o Title of your project and the scenario you are
addressing
o Brief description of your visuals (15 to 50 words)
o 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)
o 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)
o 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)
Creating Visuals (40%)
• Demonstrate sound skill in the creation of visuals to
show their ability to use mathematical principles to
interpret math forms.
• Three visuals are included with descriptive titles:
o Box-and-Whisker Plot: 4 plots exist accurately
plotting the 4 age ranges and the number of
patients or inmates
o Histogram: 4 bars exist accurately plotting the 4
age ranges and the number of patients or
inmates
o Scatterplot: Accurately plots total patients or
inmates and the year. Includes the linear
trendline, equation of the line, R2 value, and
prediction/forecast for 3 years in the future.
Points Earned (4.8 possible):
Comments:
Points Earned (3.2 possible):
Comments:
Total Points Earned:
Copyright © 2017 by University of Phoenix. All rights reserved.
1
Week 3 Signature Assignment Grading Guide
MTH/218 Version 3
Copyright © 2017 by University of Phoenix. All rights reserved.
2

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP