1 / 39

Day 7: Excel chapter 4

“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 cody.cutright@mail.wvu.edu September 10th , 2014. Homework #1. Due this Friday 09/12 by midnight 20% penalty for each day late

cecilia-avila
Download Presentation

Day 7: Excel chapter 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. “Two roads diverged in a wood, and I took the one less traveled by, and that has made all the difference. ”–Robert Frost

  2. Day 7:Excel chapter 4 CS 101 cody.cutright@mail.wvu.edu September 10th, 2014

  3. Homework #1 • Due this Friday 09/12 by midnight • 20% penalty for each day late • Only accepted through the CS101 website • You must set-up your analysis questions tab correctly!

  4. ? What is a visual representation of numerical data? A CHART!

  5. Why use a chart? • “A picture is worth a thousand words” Charts often more effectively communicate data • Charts can contain enough data to be useful, but not overwhelm people

  6. Chart basics The four (most common) chart types: • Column – compares data vertically • Bar – compares data horizontally • Line – uses a line to connect data points • Pie – shows each data point in proportion to the whole data series

  7. Chart elements Chart Area Plot Area Category Axis(X Axis) Value Axis (Y Axis)

  8. Column charts • Displays data vertically in columns • More effective with a limited of number of categories (too many and the columns run together) Example: Compare revenue among different cities for one year.

  9. Cluster column chart Clusters of columns side by side for easy comparison.

  10. Stacked column chart Shows the relationship of individual data points to the whole category, one column per category.

  11. 100% stacked column chart Compares the percentage each data point contributes to the total for each category.

  12. 3-d COLUMN CHART Looks pretty.

  13. Bar charts • Displays data horizontally in rows. (bars) • Similar to column charts, they can be stacked, clustered, 100% stacked…

  14. Line charts • Displays lines connecting data points to show trends over equal time periods. • The category axis represents time • The value axis represents the value

  15. Single data series

  16. Multiple data series

  17. PIE Charts • Shows each data point in a proportion to the whole data series. • The larger the slice, the larger the percentage.

  18. Basic pie chart

  19. Exploded 3d pie

  20. Stop: Project time In Class Chart Demo

  21. Chart design Changing the chart type: • Select the chart • Click the Design tab • Click Change Chart Type in the Type group • Select the desired type, click OK

  22. Changing/Adding/deleting data series • Select Chart • Design Ribbon • Data Group -> Select Data • Remove/Add/Delete

  23. Switching rows/columns • Select Chart • Design Ribbon • Data Group -> Switch Row/Column

  24. Chart styles Can be applied to already made charts. • Select Chart • Design Ribbon • Chart Style Group -> Select Style

  25. Embed an Excel chart • Insert Ribbon • Click Object • Create New • Microsoft Excel Chart • Click OK • Replace the Sample Data in Sheet 1

  26. Sample chart

  27. You can also, copy/paste

  28. Supplemental content Deals with horizontal axes.

  29. Trendlines Trendlines are useful because they can be used to predict future or past values by extrapolating the lines already plotted on a chart.

  30. Trendline types • Linear Trendline • Exponential Trendline • Linear Forecast Trendline • Two Period Average Trendline

  31. Adding trendlines Select Data Series (In this case C grades)

  32. Adding trendlines - cont’d

  33. The trendline

  34. Predicting the future/past with trendlines • Right-click on the trendline you want to predict the values into the future or past • Click on Format Trendline • Forecast Group -> Set Periods • You can click on the different Trend types to view how they will predict the data (If you see it predicts negative gasoline prices, for instance, you may want to change trend types)

  35. R-Squared values 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.

  36. Viewing the r-SquareD values 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.

  37. Trendline equations Under the Format Trendline dialog box, you can also view the trendline equations.

  38. Due dates • Homework I: 09/12/2014 • MyITLab B: 09/15/2014 • Homework II: 09/19/2014

  39. next class • Excel Chapter 5 / Chapter 6 • Look over Supplemental Content discussed today

More Related