Transcript T02-04 Histogram (User Selected Classes)

T02-06 Histogram (6 SD)
Purpose
Allows the analyst to analyze quantitative data by
summarizing it in sorted format, scattergram by observation,
frequency dot plot by data value, frequency histogram and
relative frequency histogram based the following 6 standard
deviation classifications: (-3,-2), (-2,-1), (-1,0), (0,1), (1,2) and
(2,3). The template also compares the resulting relative
frequency histogram to the normal relative frequency
histogram.
Inputs
Original Quantitative Data
Outputs
Sorted Quantitative Data Summary Statistics
Original Data Scattergram Frequency Dot Plot
Histogram based on following classifications:
Mean – 3*SD to Mean – 2*SD
Mean – 1*SD to Mean
Mean + 1*SD to Mean + 2*SD
Limitations
1000 quantitative data
Mean – 2*SD to Mean – 1*SD
Mean to Mean + 1*SD
Mean + 2*SD to Mean + 3*SD
T02-06 - 1
An Example
Test
Scores
99
98
96
93
92
85
82
76
75
74
72
68
66
64
62
61
50
46
48
45
A college professor has given an exam with the
test scores shown here. Are the grades normally
distributed.
She wants to examine this within 5 standard
deviations of the mean.
T02-06 - 2
An Example
The classifications that must be calculated are arranged from smallest to
largest as shown below:
Excel Bins
Mean – 5*SD to Mean – 4*SD
Mean – 5*SD
Mean – 4*SD to Mean – 3*SD
Mean – 4*SD
Mean – 3*SD to Mean – 2*SD
Mean – 3*SD
Mean – 2*SD to Mean – 1*SD
Mean – 2*SD
Mean – 1*SD to Mean
Mean – 1*SD
Mean to Mean + 1*SD
Mean
Mean + 1*SD to Mean + 2*SD
Mean + 1*SD
Mean + 2*SD to Mean + 3*SD
Mean + 2*SD
Mean + 3*SD to Mean + 4*SD
Mean + 3*SD
Mean + 4*SD to Mean + 5*SD
Mean + 4*SD
Mean + 5*SD
T02-06 - 3
Data can either be entered directly
into the Original Data cells or
copy/paste special/values into the
cells.
T02-06 - 4
Once the data is entered Summary Statistics (Mean, Standard
Deviation, Count, Max, Min & Range) are automatically calculated.
Also, the Bins and Classifications are automatically calculated.
T02-06 - 5
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-06 - 6
The Histogram Macro can be run to
automatically calculate the Histogram
Frequency Information.
T02-06 - 7
The Histogram Frequency Information is displayed along with
an interpretation of the “hard to read” EXCEL output (e.g. the
number of data observations greater than 72.8 and less than or
equal to 90.2438 is 5).
T02-06 - 8
The Observed Proportion and Normal Proportion
within each classification is also automatically calculated.
T02-06 - 9
Worksheet Tabs can be selected to view the Original
Data Scattergram, Frequency Dot Plot, Frequency
Histogram & Observed vs Normal Histogram
T02-06 - 10
The Scattergram displays a plot of the
observations in the sequence they were entered.
T02-06 - 11
The Dot Plot displays a frequency
plot of the observations.
T02-06 - 12
The Frequency Histogram shows the histogram for the
Classifications. The legend should be read bottom-up.
T02-06 - 13
The Observed vs Normal Histogram shows the observed Histogram
compared to the Normal Histogram. The legend should be read
bottom-up.
T02-06 - 14