Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Frequency for Histograms in Excel
I am using Excel 2002. There is a problem with the frequency function, which
is used for histograms. The frequency counts for some (not all) bins is incorrect. The case that I learned of in another posting involves 101 data values: 0, 10, and values in between that are created by using an increment of 0.1. The frequency value for the first bin is (correctly) 11, and most of the other bins have the correct frequency (10). However, the bin representing the interval from 1 to 2 has a frequency of 9, which the bin representing the interval from 4 to 5 has a frequency of 11! I have also used the "Better Histrogram" downloadable file for this same problem, but apparently the "Better Histogram" procedure starts with the Frequency function, as it ends up with a histogram with the same results. Any suggestions for correctly calculating all bin frequencies? -- Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Displaying frequency polygons in Excel (Statistics) | Charts and Charting in Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |