Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Histogram Function
Does anyone know what the underlying formula/macro is that this function uses
to determine bin size. I have a normal distribution for which I am using a formalized calculation to determine the bin size, but it is not turning out to be optimal. I tried using the histogram function and it produces bin sizes that are ideal. Now I would like to incorporate this process into my calculation of bins. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Histogram function suddenly stopped working | Excel Discussion (Misc queries) | |||
Does Excel 2003 have CDF feature in its histogram plotting function? | Excel Discussion (Misc queries) | |||
Problem with Histogram function of EXCEL2007 BETA | Charts and Charting in Excel | |||
Histogram Function has a problem | Charts and Charting in Excel | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel |