“Two roads diverged in a wood, and I took the one less traveled by, and that has made all the difference. ” –Robert Frost. Day 7: Excel chapter 4. CS 101 [email protected] September 10th , 2014. Homework #1. Due this Friday 09/12 by midnight 20% penalty for each day late
What is a visual representation of numerical data?
Charts often more effectively communicate data
The four (most common) chart types:
Category Axis(X Axis)
Example: Compare revenue among different cities for one year.
Clusters of columns side by side for easy comparison.
Shows the relationship of individual data points to the whole category, one column per category.
Compares the percentage each data point contributes to the total for each category.
In Class Chart Demo
Changing the chart type:
Can be applied to already made charts.
Deals with horizontal axes.
Trendlines are useful because they can be used to predict future or past values by extrapolating the lines already plotted on a chart.
Select Data Series (In this case C grades)
(If you see it predicts negative gasoline prices, for instance, you may want to change trend types)
Gauge the accuracy of how a trendline fits the underlying data.
They range from 0 to 1, with higher numbers (closer to 1) being better fits, but you will likely never get a value of 1.
At the bottom of the Format Trendline dialog box, click on “Display R-squares value on chart”.
You can then select between the different chart types to view which fits the data the best.
Under the Format Trendline dialog box, you can also view the trendline equations.