+ Reply to Thread
Results 1 to 4 of 4

Frequency Polygon

  1. #1
    Registered User
    Join Date
    02-15-2021
    Location
    england
    MS-Off Ver
    Excel 2008
    Posts
    4

    Frequency Polygon

    Hi, I have been asked to produce frequency polygon for my data. I have two groups of participants(high stress(6participants) & low stress (4 participants) and 10 participants altogether. The frequency polygon I produced seems to look wrong as it does not highlight which group is low/high stress results. It shows generalised result. I tried to divide into two groups but it states data too small to calculate. My graph also shows 6 participants but I have 10 altogether. Can some of guide me please? Thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Frequency Polygon

    I reallly don't know what you are trying to achieve... but for starters, the values need to be SEPARATE for high & low... not COMBINED...

    seesheet.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-15-2021
    Location
    england
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: Frequency Polygon

    Thank you Glenn.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Frequency Polygon

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hypothetical Polygon
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2020, 10:05 AM
  2. Area of closed polygon (from Autocad to Excel)
    By rajatds31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2020, 09:15 AM
  3. How to draw Irregular Polygon
    By gaului in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2017, 11:19 AM
  4. Need a VBA func. that tells if a point lies above/below 3D polygon surface
    By gonurvia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2017, 10:41 AM
  5. [SOLVED] create polygon/FREE FORM by cell inputs
    By riz4u in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2016, 01:45 PM
  6. [SOLVED] Formula to label the points of a polygon.
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-17-2013, 08:51 AM
  7. [SOLVED] How do I create a more than cumulative frequency polygon ?
    By yahoo in forum Excel General
    Replies: 1
    Last Post: 05-22-2006, 03:15 PM

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