Closed Thread
Results 1 to 2 of 2

How do I create a more than cumulative frequency polygon ?

  1. #1
    yahoo
    Guest

    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. #2
    Guest

    Re: 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 ?




Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1