Join TSR now and get all your revision questions answeredSign up now

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

    • Thread Starter
    Offline

    2
    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: 40
Size:  129.4 KB

    I have the frequency data and the upper bounds but no raw data.
    Offline

    3
    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: 40
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: 55
Size:  53.7 KB
    • Thread Starter
    Offline

    2
    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: 55
Size:  53.7 KB
    Thanks that was so helpful .
 
 
 
Poll
Which party will you be voting for in the General Election 2017?
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

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.