The purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2.

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.

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

Lynda.com® Video: Adding Trendlines to Charts
• Not completed (REQUIRED)
• Video

• Instructions
• Video
Access Lynda.com® by clicking on the Video tab.
1. In the search bar within Lynda.com® along the header, paste in the following: “Data-Analysis Fundamentals with Excel.”
2. Click the top course in the search research labeled “Data-Analysis Fundamentals with Excel with Curt Frye.”
3. In the “Contents” area, scroll down to “2. Visualizing Data”
4. Watch “Adding trendlines to charts,” the fourth video under 2. Visualizing Data.

Lynda.com® Videos: Creating Pie Charts, Histograms, & Box-and-Whisker Plots
Not completed (REQUIRED)
Video
Instructions
Video
The following videos will show examples of how to create pie charts, histograms and box-and-whisker plots in Excel®. These plots are needed for your Signature Assignment.

Access Lynda.com® by clicking on the Video tab.
In the search bar within Lynda.com® along the header, paste in the following: “Excel 2016: Charts in Depth”
Click the top course in the search research labeled “Excel 2016: Charts in Depth with Dennis Taylor”
In the “Contents” area, scroll down to “6. Adjusting Specific Chart Types”
Watch the video “Customize pie charts,” the third video under 6. Adjusting Specific Chart Types.
In the “Contents” area, scroll down to “8. New Chart Types in Excel 2016″”
Watch the videos “Histogram chart” and “Box and Whisker chart,” the fifth and seventh videos under 8. New Chart Types in Excel 2016.

Leave a Reply

Your email address will not be published. Required fields are marked *