close

Вход

Забыли?

вход по аккаунту

?

Building a Histogram in Excel

код для вставкиСкачать
Building a
Histogram in Excel
IE 1225
R. Lindeke
After Opening Excel …
Click:
Tools … Add-Ins …
Then
Check: Analysis Toolpak Box
Enter Team/Individual Averages:
Each Team has noreplicates? Need
Averages for both
Diameter & Length –
we will build a
histogram of each!
Determine Overall Range: Excel Formulas!
=Max(C3:C32)
=Min(C3:C32)
Both Columns – diameter & Length
Excel Formula Too! Largest �Max’ to
Smallest �Min’
Examine the
Overall Range
– Want 6 to 10
“Bins” covering
this Range
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:
Experiment with
Smaller Bins
sizes (more bins
across Overall
Range)
Using 10 Bins not 6!
Leads to a More “Normal-Like” Distribution
Документ
Категория
Презентации
Просмотров
6
Размер файла
1 206 Кб
Теги
1/--страниц
Пожаловаться на содержимое документа