Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    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
    Offline

    14
    ReputationRep:
    Scatter graph is best, with a line of best fit if appropriate. Or a bar chart.
    • Community Assistant
    Offline

    20
    ReputationRep:
    Community Assistant
    (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.
    • Thread Starter
    Offline

    2
    ReputationRep:
    (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
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: November 16, 2008

University open days

  1. University of Cambridge
    Christ's College Undergraduate
    Wed, 26 Sep '18
  2. Norwich University of the Arts
    Undergraduate Open Days Undergraduate
    Fri, 28 Sep '18
  3. Edge Hill University
    Faculty of Health and Social Care Undergraduate
    Sat, 29 Sep '18
Poll
Which accompaniment is best?
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

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