T02-03 - 1

T02-03 Histogram (Equal Classes)

Purpose Allows the analyst to analyze quantitative data by summarizing it in sorted format, scattergram by observation, frequency dot plot by data value, equal class width (analyst choice based on beginning, ending and number of classes) frequency histogram and relative frequency histogram.

Inputs Original Quantitative Data Number ClassesBeginning Class Ending Class

Outputs Sorted Quantitative DataSummary StatisticsOriginal Data Scattergram Frequency Dot PlotFrequency HistogramRelative Frequency Histogram

Limitations 1000 quantitative data

T02-03 - 2

An Example

An accounting firm has collected a sample of audit times from last year. To get a better feel for the distribution of the audit times the manager wants to look at a Histogram of the data using 5 equal width classifications.

Year EndAudit Times

1214191815151817202122232221332814181613

T02-03 - 3

Data can either be entered directly into the Original Data cells or copy/paste special/values into the cells.

T02-03 - 4

Once the data is entered Summary Statistics (Count, Max, Min & Range) are automatically calculated.

The Sort Macro can be run to sort the Original Data into the Sorted Data cells. This also automatically calculates the necessary information for the Dot Plot.

T02-03 - 5

The Summary Statistics (Max & Min) can be used to establish the Begin Class Point and the End Class Point. These are then entered with the Number Classes for the Histogram.

T02-03 - 6

The Equal Class Width and Histogram Bin Classifications are automatically calculated.

The Histogram Macro can be run to automatically calculate the Histogram Information.

T02-03 - 7

The Histogram Information (frequency & relative frequency) is displayed in tabular format by the classifications.

Decimal Point Accuracy can be set for the Relative Frequency

T02-03 - 8

Worksheet Tabs can be selected to view the Original Data Scattergram, Frequency Dot Plot, Frequency Histogram and Relative Frequency Histogram.

T02-03 - 9

The Scattergram displays a plot of the observations in the sequence they were entered.

T02-03 - 10

The Dot Plot displays a frequency plot of the observations.

T02-03 - 11

The Equal Width Frequency Histogram shows the histogram for the number of equal width classes chosen. The legend should be read bottom-up.

T02-03 - 12

The Equal Width Relative Frequency Histogram shows the histogram for the number of equal width classes chosen. The legend should be read bottom-up.