Help creating a Histogram

J

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
 
M

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
 
J

Jakkov

Michael,

Thanks a lot!.

Michael R Middleton said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top