| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a more than cumulative frequency polygon ?
I know how to do it on paper, but I am having trouble figuring out how to do
it on excel. Can someone please help ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a more than cumulative frequency polygon ?
Assuming you know how to create a histogram (Data Analysis Add-in)
-Create histogram; -Add up the number of pieces of data (frequency) - Divide each population by the total number of pieces of data, -Add this value to the preceding value -Total should add up to 1.0 (100%) Graph the total as y axis and the bin as the X-axis- and there's your cumulative frequency graph http://www.cob.sjsu.edu/anaya_j/Graphs.htm http://mathworld.wolfram.com/Cumulat...cyPolygon.html http://cnx.org/content/m11214/latest/ "yahoo" <u22041@uwe wrote in message news:6082b68d8bc26@uwe... I know how to do it on paper, but I am having trouble figuring out how to do it on excel. Can someone please help ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
| 3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
| Frequency for Histograms in Excel | Charts and Charting in Excel | |||
| how can I create a histogram with relative frequency? | Excel Discussion (Misc queries) | |||
Linear Mode
