How can i do a frequency distribution by machine automatically?

[Steve]

Machine Speed Mac 1 Mac 2 Mac 3
Mac 1 100 100
Mac 1 200 200
Mac 3 300 300
Mac 1 400 400
Mac 2 500 500
Mac 2 100 100
Mac 2 200 200
Mac 1 500 500
Mac 3 800 800
Mac 3 1100 1100
Mac 3 1400 1400
Mac 3 1700 1700
Mac 3 700 700

How can i do a frequency distribution by machine automatically?
Current i use the index function to group them under the same machine
and follow by a "frequency" function. However, this way it will be
very slow,as the column under Mac 1, Mac 2 and Mac 3 need
to have the function "index". This get more slower when you have 6K
rows of data. How can i do it more efficiently ?

 

[vandenberg p]

Hello:

Why do you need an index? The following would work:

Assume that "Machine" is in column A and Col B contains "Mac 1"; col C "Mac 2" etc

=IF(A2=C$1,B2,0)

This will put the values in columns. Use the Histogram wizard on the data analysis menu
and it will create the histogram (be sure that the bin values include zero). Ignore the
zero bin when you are done and you have the histogram you wanted.

Alternative

Why not just sort the values on column A and then create the histograms(or frequency)
by selecting the appropriate groups of cells.


Pieter Vandenberg
(e-mail address removed)
-----------------------------------------------
Anti-spam
Please do not reply to this message's address.
If you wish to contact me use the above address.
Thank you.
------------------------------------------------


: Machine Speed Mac 1 Mac 2 Mac 3
: Mac 1 100 100
: Mac 1 200 200
: Mac 3 300 300
: Mac 1 400 400
: Mac 2 500 500
: Mac 2 100 100
: Mac 2 200 200
: Mac 1 500 500
: Mac 3 800 800
: Mac 3 1100 1100
: Mac 3 1400 1400
: Mac 3 1700 1700
: Mac 3 700 700

: How can i do a frequency distribution by machine automatically?
: Current i use the index function to group them under the same machine
: and follow by a "frequency" function. However, this way it will be
: very slow,as the column under Mac 1, Mac 2 and Mac 3 need
: to have the function "index". This get more slower when you have 6K
: rows of data. How can i do it more efficiently ?