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

    4
    ReputationRep:
    Hi everyone Im using the Pearsons correlation method to find the correlation of to variables x being Rating and y being votes however I keep messing up the formula can someone please input this for me into a suitable programme/calculator and tell me the answer?

    Pearsons Corrleation





    x= 249.3
    y= 7635372
    xy= 63925204.9
    x2 ( x squared)= 2073.61
    y2 ( y squared)= 3062783060420
    n= 30

    here are the needed values
    • Study Helper
    Offline

    13
    Study Helper
    (Original post by Rhy)
    ...
    I get 11.94722272

    So, unless I made a mistake, there's an error in the data.
    • Study Helper
    Offline

    13
    Study Helper
    (Original post by smiley321)
    YA GET ME I GOT 18.156, GOT a* MATHS ALEVEL, ITE LOVE
    We could both be wrong.

    I'd be more convinced if we both had the same answer.

    Do we have a third vote?
    Offline

    16
    ReputationRep:
    (Original post by ghostwalker)
    We could both be wrong.

    I'd be more convinced if we both had the same answer.
    He is a troll GW, posting nonsense on threads
    Offline

    16
    ReputationRep:
    (Original post by ghostwalker)

    Do we have a third vote?
    I got 0.32358

    but on an annoying calculator so will try again



    Checked using a spreadsheet and get the same
    • Study Helper
    Offline

    13
    Study Helper
    (Original post by TenOfThem)
    He is a troll GW, posting nonsense on threads
    Thanks. No red gem to give them away - damn!

    (Original post by TenOfThem)
    I got 0.32358

    but on an annoying calculator so will try again

    Checked using a spreadsheet and get the same
    Yep, I had input the data incorrectly. 0.323581962
    Thank god spreadsheets are easy to correct.

    PRSOM.
    • Study Helper
    Offline

    16
    ReputationRep:
    Study Helper
    (Original post by TenOfThem)
    I got 0.32358

    but on an annoying calculator so will try again



    Checked using a spreadsheet and get the same
    I get the same as you on a calculator
    • Thread Starter
    Offline

    4
    ReputationRep:
    I'm not a troll at all haha, that is the answer I needed thankyou It shows there is a mild positive correlation is thanks guys
    • Thread Starter
    Offline

    4
    ReputationRep:
    Would anyone mind giving me the steps on how they got 0.323581962 as for some reason when I try I keep getting it wrong
    Offline

    16
    ReputationRep:
    (Original post by Rhy)
    I'm not a troll at all haha
    No-one suggested that you were

    It shows the correlation is negative
    erm

    no it doesn't
    Offline

    16
    ReputationRep:
    (Original post by Rhy)
    Would anyone mind giving me the steps on how they got 0.323581962 as for some reason when I try I keep getting it wrong
    Just put those values in ... I cannot really give you steps

    Are you using enough ()
    • Thread Starter
    Offline

    4
    ReputationRep:
    Is it possible for you to type the way you are doing as I may be misusing the formula for example enough brackets
    • Thread Starter
    Offline

    4
    ReputationRep:
    Oh and how did you manage to calculate this on a spreadsheet, which programme did you use excel?
    • Study Helper
    Offline

    13
    Study Helper
    (Original post by Rhy)
    Oh and how did you manage to calculate this on a spreadsheet, which programme did you use excel?
    I used excel.

    Put in the numbers (correctly - not like what I did), put in the formula appropriately, and out pops the answer.
    Offline

    16
    ReputationRep:
    (Original post by Rhy)
    Ah I've used the pearson function on excel
    erm

    you only have 18 y-values there

    And x^2 in your original post is incorrect
 
 
 
  • 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.