Results 1 to 5 of 5

Math Help - Correlation Coefficient - Have I done this right?

  1. #1
    Newbie
    Joined
    Nov 2007
    Posts
    12

    Correlation Coefficient - Have I done this right?

    Hey,

    I have an exam on tuesday, and just revising.

    I would like to know if I have done this right.

    The reason I have wrote down the whole number from the calculator throughout the working out is a longggg story... basically because I am using a different formula to the one we have revised at university, where I have to find the value of X in this one....yes I do know how to round up but this wont give a definate answer as to whether the correlation is negative or positive.. but anyway here it is, I done it on Word and then print screened it...




    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,830
    Thanks
    123
    Quote Originally Posted by leaaa View Post
    Hey,

    I have an exam on tuesday, and just revising.

    I would like to know if I have done this right.

    ...
    Hello,

    1. why don't you use the build-in function of Excel to calculate the correlation coefficient?
    It will return r = 0,877458866

    2. I've got a different value for \sum \gamma^2 = 15.05

    3. All other calculations seem to be OK.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Nov 2007
    Posts
    12
    Quote Originally Posted by earboth View Post
    Hello,

    1. why don't you use the build-in function of Excel to calculate the correlation coefficient?
    It will return r = 0,877458866

    2. I've got a different value for \sum \gamma^2 = 15.05

    3. All other calculations seem to be OK.
    Hey, thanks for your reply, I cant use excel in my exam its a written one. I dont really understand where they got those values from, how did you get 15.05?

    Thanks x
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,830
    Thanks
    123
    Quote Originally Posted by leaaa View Post
    Hey, thanks for your reply, I cant use excel in my exam its a written one. I dont really understand where they got those values from, how did you get 15.05?

    Thanks x
    Hello,

    1. I've made a silly typo. But the final result I got differs slightly from your's.

    2. To show you where these values come from I attach the complete spread-sheet.

    I hope this will help a little bit further on.
    Attached Thumbnails Attached Thumbnails Correlation Coefficient - Have I done this right?-corr_tabcalc.gif  
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Nov 2007
    Posts
    12
    hey thanks for your reply and your help, i understand where this value comes from now.

    So would you say that i got this question wrong? As the difference between my reult and yours is 0.1 or something? x
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 0
    Last Post: February 25th 2011, 01:15 AM
  2. Replies: 1
    Last Post: December 11th 2010, 11:16 PM
  3. Correlation coefficient?
    Posted in the Statistics Forum
    Replies: 4
    Last Post: June 28th 2010, 10:13 PM
  4. correlation coefficient help
    Posted in the Advanced Statistics Forum
    Replies: 6
    Last Post: January 7th 2010, 05:57 PM
  5. Correlation coefficient
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: October 10th 2009, 10:23 AM

Search Tags


/mathhelpforum @mathhelpforum