Day 7: Excel chapter 4

1 / 39

# Day 7: Excel chapter 4 - PowerPoint PPT Presentation

“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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Day 7: Excel chapter 4' - cecilia-avila

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### 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
• Only accepted through the CS101 website
• You must set-up your analysis questions tab correctly!
?

What is a visual representation of numerical data?

A CHART!

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
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
Chart elements

Chart Area

Plot Area

Category Axis(X Axis)

Value Axis

(Y Axis)

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.

Cluster column chart

Clusters of columns side by side for easy comparison.

Stacked column chart

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

100% stacked column chart

Compares the percentage each data point contributes to the total for each category.

3-d COLUMN CHART

Looks pretty.

Bar charts
• Displays data horizontally in rows. (bars)
• Similar to column charts, they can be stacked, clustered, 100% stacked…
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
PIE Charts
• Shows each data point in a proportion to the whole data series.
• The larger the slice, the larger the percentage.
Stop: Project time

In Class Chart Demo

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
• Select Chart
• Design Ribbon
• Data Group -> Select Data
Switching rows/columns
• Select Chart
• Design Ribbon
• Data Group -> Switch Row/Column
Chart styles

• Select Chart
• Design Ribbon
• Chart Style Group -> Select Style
Embed an Excel chart
• Insert Ribbon
• Click Object
• Create New
• Microsoft Excel Chart
• Click OK
• Replace the Sample Data in Sheet 1

### Supplemental content

Deals with horizontal axes.

Trendlines

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

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

Select Data Series (In this case C grades)

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)

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.

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.

Trendline equations

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

Due dates
• Homework I: 09/12/2014
• MyITLab B: 09/15/2014
• Homework II: 09/19/2014
next class
• Excel Chapter 5 / Chapter 6
• Look over Supplemental Content discussed today