ExcelBanter - excel(Bin and Frequency)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel(Bin and Frequency) (https://www.excelbanter.com/excel-discussion-misc-queries/56399-excel-bin-frequency.html)

Knowledge001

excel(Bin and Frequency)

How can I find Bin and frequency with out using the histogram?.

B. R.Ramachandran

excel(Bin and Frequency)

Hi,

Make up a column containing bin values.
Use the FREQUENCY function (This is an array function. You have to confirm
it with CTRL-SHIFT-ENTER. See Excel Help for details.

Regards,
B. R. Ramachandran

"Knowledge001" wrote:

How can I find Bin and frequency with out using the histogram?.

All times are GMT +1. The time now is 05:54 PM.