Signature assignment: creating visuals from data
The object of this assignment is to fashion proof creating visuals using the basis for the question you selected in Week 2. Use statistical forced and commonplace modeling to pretence mediate proclivity and two-variable analyses, including retreat delay equation and R2 compute.
Watch How to Generate Trendlines and Scatterplots in Excel®.
Watch Lynda.com® Video: Adding Trendlines to Charts. This video can be accessed below Student Materials on the fair edge of the cloak.
Watch Lynda.com® Videos: Creating Pie Charts, Histograms, & Box-and-Whisker Plots. This video can be accessed below Student Materials on the fair edge of the cloak.
Create at last three visuals.
- One visual must be a scatterdevise delay bend succession, equation and R2 compute.
- Two of the cherishing required visuals can be a histogram, box and whisker devise, or pie chart.
- Please melody that the basis sets enclose basis that obtain not be needed to generate your visuals. Quantitative forced requires exact thinking to flow what basis is needful.
Create a Word instrument that encloses your three visuals and the subjoined items:
- Title of your scheme and the scenario you are addressing
- Brief cognomen of each visual (15 to 50 articulation)
- Consider including the subjoined for each visual when applicable:
- A chart epithet that is misspend for the basis
- A vivid x-axis label
- A vivid y-axis label
- For your xy scatterplot, make at last one vaticination using the bendsuccession equation for some determination into the advenient. How impudent are you in this vaticination? State your vaticination and procure apology (50 to 150 articulation).
- If you generated a box and whisker devise, portray the mediate proclivity of the computes. What does this disclose you encircling the basis and encircling your scheme?
- Calculate the average of the specimen basis.
Here's the basis that I used for my week two verification assignment.
Expected Payouts
2004 90001 37412
2005 90001 39841
2006 90001 40123
2007 90001 43122
2008 90001 44125
2009 90001 51229
2010 90001 59748
2011 90001 57008
2012 90001 56727
2013 90001 57985
2014 90001 6312
Predicted 2018 Values
71191.26