Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    6
    ReputationRep:
    Does anyone know the best graph/diagram to show trend and correlation between variables?? And also the best calculation (standard deviation, Quartiles or whatever else that's not too complicated and is in AQA GCSE sttistics) to show the same thing, which is correlation between two variables. (excluding scatter graphs and spearman's rank because i've done those already!) :erm:
    If anyone know the answer then please PLEASE help me i'm really stuck!
    Thanks in advance for any replies!! :gthumb:
    Offline

    11
    (Original post by Lumos24520)
    Does anyone know the best calculation to show the correlation between two variables?
    Back from my days of doing Edexcel GCSE statistics, I used Pearson's correlation coefficient on top of the techniques you used. It's not terribly complicated, but it takes some work to use - best to confirm your calculations using an Excel spreadsheet.

    Also, there's more information in the following article.

    http://en.wikipedia.org/wiki/Correlation_and_dependence

    That said you may want to look up books which cover a broad range of statistical techniques. A friend of mine did this to improve his coursework and got marginally better scores than me in GCSE statistics, but that's entirely down to you.

    It should be noted that these things may not be in your syllabus, but if you are doing coursework much like I was then top marks are achieved by doing things which are related to, but not explicitly covered in, the syllabus.

    I hope that helps.

    Darren
    Offline

    3
    ReputationRep:
    (Original post by Lumos24520)
    Does anyone know the best graph/diagram to show trend and correlation between variables?? And also the best calculation (standard deviation, Quartiles or whatever else that's not too complicated and is in AQA GCSE sttistics) to show the same thing, which is correlation between two variables. (excluding scatter graphs and spearman's rank because i've done those already!) :erm:
    If anyone know the answer then please PLEASE help me i'm really stuck!
    Thanks in advance for any replies!! :gthumb:
    If you have a Casio 991ES you can go to Stat mode>a+bx mode type in the data for both the variables. Then press AC, shift stat and then regression and the r value. that will give you the product moment coerrelation coefficient.
    The b value will give you the gradient.
    Offline

    18
    ReputationRep:
    (Original post by Lumos24520)
    Does anyone know the best graph/diagram to show trend and correlation between variables?? And also the best calculation (standard deviation, Quartiles or whatever else that's not too complicated and is in AQA GCSE sttistics) to show the same thing, which is correlation between two variables. (excluding scatter graphs and spearman's rank because i've done those already!) :erm:
    If anyone know the answer then please PLEASE help me i'm really stuck!
    Thanks in advance for any replies!! :gthumb:
    You could add a line of best fit to the scatter graph and work out the equation of the line. You would usually plot the mean of each variable as a point on the graph to help you with fitting the line (it should pass through this point). The equation can be used to interpolate values within the range of your data. You could use Microsoft Excel to add the line of best fit and determine the equation - Excel will produce a more accurate result than fitting by eye.

    There are other correlation calculations you could do (e.g. PMCC) but they are outside what is expected at GCSE. Plotting histograms, cumulative frequency, box plots etc and working out mean, standard deviation, quartiles may be appropriate for your project they don't have anything to do with showing correlation.
    • Thread Starter
    Offline

    6
    ReputationRep:
    (Original post by DPLSK)
    Back from my days of doing Edexcel GCSE statistics, I used Pearson's correlation coefficient on top of the techniques you used. It's not terribly complicated, but it takes some work to use - best to confirm your calculations using an Excel spreadsheet.

    Also, there's more information in the following article.

    http://en.wikipedia.org/wiki/Correlation_and_dependence

    That said you may want to look up books which cover a broad range of statistical techniques. A friend of mine did this to improve his coursework and got marginally better scores than me in GCSE statistics, but that's entirely down to you.

    It should be noted that these things may not be in your syllabus, but if you are doing coursework much like I was then top marks are achieved by doing things which are related to, but not explicitly covered in, the syllabus.

    I hope that helps.

    Darren
    Thanks so much for your advice!! It really did help!! I might do the syllabus thing, i'll look it up!
    Again, thank you for your help it is much appreciated!!
    • Thread Starter
    Offline

    6
    ReputationRep:
    (Original post by StUdEnTIGCSE)
    If you have a Casio 991ES you can go to Stat mode>a+bx mode type in the data for both the variables. Then press AC, shift stat and then regression and the r value. that will give you the product moment coerrelation coefficient.
    The b value will give you the gradient.
    Thanks for trying but unfortunately i have a really old casio so i doubt that'll work :/
    Thanks anyway!
    • Thread Starter
    Offline

    6
    ReputationRep:
    (Original post by gdunne42)
    You could add a line of best fit to the scatter graph and work out the equation of the line. You would usually plot the mean of each variable as a point on the graph to help you with fitting the line (it should pass through this point). The equation can be used to interpolate values within the range of your data. You could use Microsoft Excel to add the line of best fit and determine the equation - Excel will produce a more accurate result than fitting by eye.

    There are other correlation calculations you could do (e.g. PMCC) but they are outside what is expected at GCSE. Plotting histograms, cumulative frequency, box plots etc and working out mean, standard deviation, quartiles may be appropriate for your project they don't have anything to do with showing correlation.
    Oh my god!! Thank you so much!! i'd completely forgotten to do the line of best fit and that would definately lose me marks!! Yeah i'll definitely do that and I will take your advice on board and do the Excel thing that'll help a lot!!

    And about the histogram, cumulative freqency, standard deviation and everything else, yes, they are mentioned in the guide but they don't show correlation which is what i'm most annoyed about!! I think the scatter diagrams and the spearman's rank showing the same thing will be enough to be honest because they kind of support each other in a way so I have proved my hypothesis already!!

    Thanks for your advice it was VERY helpful!! I a bit more confident with my scatter graph now!!
    :awesome:
 
 
 
  • 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
    Would you like to hibernate through the winter months?
    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.