Hey there! Sign in to join this conversationNew here? Join for free

How do you add the lines for quartiles and median on a line graph in Excel? Watch

Announcements
    • Thread Starter
    Offline

    8
    ReputationRep:
    Hi there. I am making a cumulative frequency graph in Excel but can't find anything to help on how I use Excel to calculate the upper and lower quartile. Also, I am not sure how to use it to calculate the median estimate and then get Excel to show these on my graph.

    I know on a paper graph I could just use 1/4, 1/2, 3/4 rules and draw them on. I am struggling to find anything on the internet to help do this on Excel .Name:  Bloody Excel.jpg
Views: 121
Size:  129.4 KB

    I have the frequency data and the upper bounds but no raw data.
    • Very Important Poster
    • PS Reviewer
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    (Original post by jojo55)
    Hi there. I am making a cumulative frequency graph in Excel but can't find anything to help on how I use Excel to calculate the upper and lower quartile. Also, I am not sure how to use it to calculate the median estimate and then get Excel to show these on my graph.

    I know on a paper graph I could just use 1/4, 1/2, 3/4 rules and draw them on. I am struggling to find anything on the internet to help do this on Excel .Name:  Bloody Excel.jpg
Views: 121
Size:  129.4 KB

    I have the frequency data and the upper bounds but no raw data.
    Your chart isn't right at the moment because you've used a "Line" graph in excel instead of a "Scatter with smooth lines". It presents the difference between 24 and 28 as the same as the difference between 28 and 40.

    See the image for how you can plot in the interquartile values - I just tweaked these until the lines crossedName:  chart.PNG
Views: 162
Size:  53.7 KB
    • Thread Starter
    Offline

    8
    ReputationRep:
    (Original post by PQ)
    Your chart isn't right at the moment because you've used a "Line" graph in excel instead of a "Scatter with smooth lines". It presents the difference between 24 and 28 as the same as the difference between 28 and 40.

    See the image for how you can plot in the interquartile values - I just tweaked these until the lines crossedName:  chart.PNG
Views: 162
Size:  53.7 KB
    Thanks that was so helpful .
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Should Spain allow Catalonia to declare independence?
    Useful resources

    Make your revision easier

    Maths

    Maths Forum posting guidelines

    Not sure where to post? Read the updated guidelines here

    Equations

    How to use LaTex

    Writing equations the easy way

    Student revising

    Study habits of A* students

    Top tips from students who have already aced their exams

    Study Planner

    Create your own Study Planner

    Never miss a deadline again

    Polling station sign

    Thinking about a maths degree?

    Chat with other maths applicants

    Can you help? Study help unanswered threads

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.