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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Histogram Function
Hi,
The Analysis ToolPak was written by another company for Microsoft years and years ago (the 1980's?). You might contact Microsoft, but it may be futile. Or you might try running a password cracker aganst the add-in and then look at the underlying code. I sure someone has made a routine to crack add-in passwords. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "iperlovsky" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Histogram Function
iperlovsky -
When you don't specify a bin range for the Histogram tool, Excel uses INT(SQRT(n)) bins plus one "More" bin. The first bin is the minimum value of the data set. The step size for successive bins is (MaximumValue - MinimumValue)/INT(SQRT(n)) An Excel "bin" value is the inclusive upper limit for an interval. The first bin contains only the minimum value of the data set, so the frequency for the first bin is 1. If you are working with continuous-valued data, you may prefer the histogram produced by my free Better Histogram add-in, available from http://www.treeplan.com. - Mike http://www.MikeMiddleton.com "iperlovsky" wrote in message ... 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? |
Reply |
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 |