1. First be sure your computer has the data analysis tools
add in installed. Look in the tools menu - if data analysis is not listed
follow the directions in the help menu under tools for statistical analysis
- installing.
2. Place your class data in the first three columns of Excell as shown
in the example:
A B
C
1 Name
Hand Sex
2 Tucker
19 m
3 Rosie
13 f
4 Greg
18 m
5 Sophia
14 f
6 Julia
15 f
You can adjust the column width as necessary for your labels.
Your Hand Span label can say Hand Span in centimeters even if it doesn't
all show on the cell.
3. On another place on the spread sheet make a column of the bin
range. For the class data example it would be appropriate to list
the integers from 12 to 20:
12
13
14
15
16
17
18
19
20
Later you can experiment with adjusting the bin range.
4. Now you will use the histogram tool. To find this tool go to the tool pulldown menu select data analysis, then select histogram.
5. A dialog will pop up asking you to select the input, bin and output ranges. Highlight the column of data with the hand span measurements as the input range. Select the column where you listed the bin range as your bin range and select an unused area of your worksheet for the output.
6. When you have all the ranges selected click ok. A bin frequency chart will appear in the output range you have selected.
7. Now select the whole frequency chart and click on the chart wizard. (If you don't click on the headings it won't give you a histogram type option ).
8. Choose the column chart and progress through the chart wizard.
You can adjust the titles etc as necessary. Your completed chart
should look something like this.
9. To make separate bars for males and females you need to sort the data and count each sex separately. Before sorting always make a backup copy of your data. Then to sort, select (Highlight) all three columns of Data and choose Sort on the pulldown menu under Data. Remember to check the button that says your data has a header column.
10. The Sort Order dialog will pop up. Choose column C (Sex) to sort by.
11. Repeat steps four, five and six separately for males and females.
12. Move (use copy and paste) the male frequency column next to the female frequency column so that it looks something like this:
Bin Frequency Frequency
12 1
0
13 3
1
14 3
0
15 3
2
16 1
0
17 1
4
18 0
5
19 0
5
20 0
1
More 0
0
13. Then repeat step 7 and 8. Your chart should appear something
like this:
