View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?