LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 50
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Histogram function suddenly stopped working Allisonnl09 Excel Discussion (Misc queries) 2 December 17th 08 04:17 AM
Does Excel 2003 have CDF feature in its histogram plotting function? cfman Excel Discussion (Misc queries) 3 March 28th 07 03:02 AM
Problem with Histogram function of EXCEL2007 BETA Boopsie Charts and Charting in Excel 2 September 26th 06 03:22 AM
Histogram Function has a problem Boopsie Charts and Charting in Excel 6 September 2nd 06 04:03 AM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"