Solved by verified expert:NO PLAGIARISM (0%REQUIRED!!), NO GRAMMAR ERRORS, REFERENCE ONLY FROM U.S and the THREE VIDEOS listed below, NO OVERDUEThe purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2 – This paper with my topic will be sent to tutor upon assigned, PLEASE ASK ME FOR IT PRIOR TO STARTING THE WORK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Use statistical reasoning and mathematical modeling to show central tendency and two-variable analyses, including regression with equation and R2 value. Watch How to Create Trendlines and Scatterplots in Excel®.Watch Lynda.com® Video: Adding Trendlines to Charts. This video can be accessed under Student Materials on the right side of the screen.Watch Lynda.com® Videos: Creating Pie Charts, Histograms, & Box-and-Whisker Plots. This video can be accessed under Student Materials on the right side of the screen.Create at least three visuals.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 addressingBrief 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 dataA descriptive x-axis labelA descriptive y-axis labelFor 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. Check attachment 2 to view an example of the of visuals expected for this assignment.The assignment will be graded using the attached grade guide.
attached_2.docx

grading_guide.docx

Unformatted Attachment Preview

MTH/216r3 Example of Visuals
MTH/216r3 Example of Visuals
MTH/216r3 Example of Visuals
Mathematical Computations (60%)
• There is a sound demonstration of
the ability to perform mathematical
computations.
• There is an accurate summarization
of data.
Points Earned: x.x/2.4
Comments:
Creating Visuals (40%)
• At least three visuals are included
with one being a scatterplot with
trend line, equation, and R square
value.
• At least one prediction is made
using the trend line equation.
• Demonstrate sound skill in the
creation of visuals to show their
ability to use mathematical principles
to interpret math forms.
• Visuals have proper labeling on both
the x- and y- axis.
• Visuals have proper heading.
Points Earned: x.x/3.6
Comments:

Purchase answer to see full
attachment