Help creating a Histogram

[Jakkov]

Hello,

I need to create a Histogram using 6 classes.

I'm using in excel 2003, tools, data analysis, histogram. But my
problem is that when I use the function it's show me 7 classes instead
of 6, any ideas how can I do it?

Thanks and here are the numbers:

17
17
31
12
44
9
27
18
14
10
33
19
14
31
16
20
17
22
10
6
25
26
14
42
18
11
13
15
7
21
10
59
14
22
20
14
24
18
16
12

 

[Michael R Middleton]

Jakkov -

I need to create a Histogram using 6 classes. I'm using in excel 2003,

tools, data analysis, histogram. But my problem is that when I use the
function it's show me 7 classes instead of 6, any ideas how can I do it? <

Specify your own bins. Enter 10, 20, 30, 40, 50 in a column for your Bin
Range.

Excel appends an extra bin "More" at the end.

- Mike Middleton, www.usfca.edu/~middleton

 

[Jakkov]

Michael,

Thanks a lot!.

Jakkov -

tools, data analysis, histogram. But my problem is that when I use the
function it's show me 7 classes instead of 6, any ideas how can I do it? <

Specify your own bins. Enter 10, 20, 30, 40, 50 in a column for your Bin
Range.

Excel appends an extra bin "More" at the end.

- Mike Middleton, www.usfca.edu/~middleton