Hey there! Sign in to join this conversationNew here? Join for free
 You are Here: Home >< Maths

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

Announcements
1. 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 .

I have the frequency data and the upper bounds but no raw data.
2. (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 .

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 crossed
3. (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 crossed
Thanks that was so helpful .

Reply
Submit reply
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: September 27, 2016
Today on TSR

### What does it take to get into Oxbridge?

These personal statements nailed it!

### Have I wasted my time at uni?

Discussions on TSR

• Latest
• ## 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
Useful resources

## Make your revision easier

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams

Can you help? Study help unanswered threads

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest
• ## 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

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