Home |
Search |
Today's Posts |
#1
|
|||
|
|||
which better: Frequency vs Histogram
I read "Explore Histograms" in
http://office.microsoft.com/en-us/as...109481033.aspx and found it educational. However, I can't see a difference in output between using a Histogram and using the Frequency function. Can anybody share the pros and cons of each? |
#2
|
|||
|
|||
I think you have missed the point. The article says that the table
produced by the ATP histogram tool is exactly the same as the table (with same bin definitions) produced by the FREQUENCY function. The difference is not in the values calculated, but in the fact that the histogram table is a static table that will not update if you subsequently change the data, whereas the FREQUENCY function gives a live formula that would update. Jerry Melissa wrote: I read "Explore Histograms" in http://office.microsoft.com/en-us/as...109481033.aspx and found it educational. However, I can't see a difference in output between using a Histogram and using the Frequency function. Can anybody share the pros and cons of each? |
#3
|
|||
|
|||
oooh.... now I get it! Thanks!
"Jerry W. Lewis" wrote: I think you have missed the point. The article says that the table produced by the ATP histogram tool is exactly the same as the table (with same bin definitions) produced by the FREQUENCY function. The difference is not in the values calculated, but in the fact that the histogram table is a static table that will not update if you subsequently change the data, whereas the FREQUENCY function gives a live formula that would update. Jerry Melissa wrote: I read "Explore Histograms" in http://office.microsoft.com/en-us/as...109481033.aspx and found it educational. However, I can't see a difference in output between using a Histogram and using the Frequency function. Can anybody share the pros and cons of each? |
#4
|
|||
|
|||
You're welcome, glad it helped.
Jerry Melissa wrote: oooh.... now I get it! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
How do I create a Histogram for relative frequency distributions? | Excel Discussion (Misc queries) | |||
Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Cumulative Frequency | Charts and Charting in Excel | |||
how can I create a histogram with relative frequency? | Excel Discussion (Misc queries) |