Building a Histogram in Excel ie 1225 R. Lindeke

Building a Histogram in Excel

• IE 1225

• R. Lindeke

After Opening Excel …

Enter Team/Individual Averages:

Determine Overall Range: Excel Formulas!

Excel Formula Too! Largest ‘Max’ to Smallest ‘Min’

Tools … Data Analysis … Histogram … ok!

In Histogram Box Click the ICON then highlight Ranges for Data (Input Range box) and Segment Limits (Bin Range box) … Put Histogram on Separate WorkSheet!

Also: Check Chart Output & Cumulative Percentage

Final Output:

Using 10 Bins not 6!

Leads to a More “Normal-Like” Distribution