“Two
Download
1 / 39

Day 7: Excel chapter 4 - PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on

“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

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

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


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

“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

Day 7:Excel chapter 4

CS 101

[email protected]

September 10th, 2014


Homework 1
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
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
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 elements

Chart Area

Plot Area

Category Axis(X Axis)

Value Axis

(Y Axis)


Column charts
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
Cluster column chart

Clusters of columns side by side for easy comparison.


Stacked column chart
Stacked column chart

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


100 stacked column chart
100% stacked column chart

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


3 d column chart
3-d COLUMN CHART

Looks pretty.


Bar charts
Bar charts

  • Displays data horizontally in rows. (bars)

  • Similar to column charts, they can be stacked, clustered, 100% stacked…


Line charts
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
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
Stop: Project time

In Class Chart Demo


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


Changing adding deleting data series
Changing/Adding/deleting data series

  • Select Chart

  • Design Ribbon

  • Data Group -> Select Data

  • Remove/Add/Delete


Switching rows columns
Switching rows/columns

  • Select Chart

  • Design Ribbon

  • Data Group -> Switch Row/Column


Chart styles
Chart styles

Can be applied to already made charts.

  • Select Chart

  • Design Ribbon

  • Chart Style Group -> Select Style


Embed an excel chart
Embed an Excel chart

  • Insert Ribbon

  • Click Object

  • Create New

  • Microsoft Excel Chart

  • Click OK

  • Replace the Sample Data in Sheet 1




Supplemental content

Supplemental content

Deals with horizontal axes.


Trendlines
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
Trendline types

  • Linear Trendline

  • Exponential Trendline

  • Linear Forecast Trendline

  • Two Period Average Trendline


Adding trendlines
Adding trendlines

Select Data Series (In this case C grades)


Adding trendlines cont d
Adding trendlines - cont’d


The trendline
The trendline


Predicting the future past with trendlines
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
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
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
Trendline equations

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


Due dates
Due dates

  • Homework I: 09/12/2014

  • MyITLab B: 09/15/2014

  • Homework II: 09/19/2014


Next class
next class

  • Excel Chapter 5 / Chapter 6

  • Look over Supplemental Content discussed today


ad