Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a histogram with frequency
how do you use the histogram function?i don't really understand bins. all i
have in my data are income groups e.g 0-10k, 11-20k etc and the frequency of each one. can i make a histogram with this data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a histogram with frequency
hannah553 -
how do you use the histogram function?i don't really understand bins. all i have in my data are income groups e.g 0-10k, 11-20k etc and the frequency of each one. can i make a histogram with this data? < To use the Histogram tool, the data range is the raw data on a worksheet, and the bins are values you enter in the worksheet to specify the upper limits for each interval of the frequency distribution. The Histogram tool creates the frequency distribution and a Column chart. You already have a frequency distribution, so you could create a Column chart to display the results. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
Need to make a plain barchart, not a histogram | Charts and Charting in Excel | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions |