Unit Three: Graphing

Now that you have gathered all of your data you are going to create a frequency table and histogram.

Lesson 1: Create Frequency Table

On your spreadsheet please create your frequency table for any of the three sets of data. It should look something like this:

Now that you have created that you need to use a formula to calculate your data. Please open Frequency in a new tab by right-clicking. Then follow the directions to complete your frequency table.

Lesson 2: Create a Histogram

Creating charts (graphs) in Excel is really easy!!!

Highlight your INTERVALS, hold the CTRL key, and highlight your FREQUENCY
Click the INSERT tab, then insert a COLUMN chart.

Just like in class it is important that you include:

An appropriate title
Axes lables

Lesson 3: Formatting

There are so many different ways to format your graph!! The three main toolbars are as follows:

Design

Layout

Format

Other Formatting Tips

You can easily format anything on the chart by right-clicking on ANY part of the chart and then clicking FORMAT DATA SERIES This will open a very easy to follow box.

Histogram bars are always suppose to touch. Please make sure that you right-click on the bars and adjust the width.

You can insert pictures into your graphs by either saving a picture or from clipart. Pictures in the background or in the bars can make it clearer to the reader what the graph is depicting.

Lesson 4: Finishing

Now that you know how to create a histogram. Please create a cumulative frequency histogram.
Please format this one appropriately.
Please SAVE everything.
Print out your workbook.
Email me your project as an attachment.

On to Reflection on Excel

Back to Unit Two: Spreadsheets

Back to Using Excel for Statistics