# Which graph?Watch

#1
What kind of graph should i use to show the distribution of continuous data, that i can draw using excel07.

I wanted to do a boxplot but excel doesnt draw boxplots *easily* (please noone link me to that horible tutorial of how to do a sideaway bar chart and make bits invisible to make it look like a crappy boxplot)

edit: btw there are like 400 bits of data so a scatter graph isnt really ideal
0
10 years ago
#2
Scatter graph is best, with a line of best fit if appropriate. Or a bar chart.
0
10 years ago
#3
(Original post by Callipygian)
What kind of graph should i use to show the distribution of continuous data, that i can draw using excel07.

I wanted to do a boxplot but excel doesnt draw boxplots *easily* (please noone link me to that horible tutorial of how to do a sideaway bar chart and make bits invisible to make it look like a crappy boxplot)

edit: btw there are like 400 bits of data so a scatter graph isnt really ideal
Excel does histograms - look in the help section to get started.
0
#4
(Original post by James)
Scatter graph is best, with a line of best fit if appropriate. Or a bar chart.
Sorry i didnt make it very clear, the data is life expectancy, so i just have 400 bit of data that at like 70.4, 69.3 etc. a bar chart wouldnt work at all, and a scatter graph is impossible since what do i plot life expectancy against.....

I wanted to avoid grouping the data but i guess a histrogram is probably my best option, its so stupid excel doesn't do box plots theyre way more commonly used than some of the random charts they have got
0
X

new posts
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

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

### University open days

• University of East Anglia
All Departments Open 13:00-17:00. Find out more about our diverse range of subject areas and career progression in the Arts & Humanities, Social Sciences, Medicine & Health Sciences, and the Sciences. Postgraduate
Wed, 30 Jan '19
• Aston University
Wed, 30 Jan '19
• Solent University
Sat, 2 Feb '19

### Poll

Join the discussion

Remain (1047)
79.02%
Leave (278)
20.98%