Results 1 to 5 of 5

Math Help - Correlation Coefficients

  1. #1
    JDA
    JDA is offline
    Newbie
    Joined
    Jun 2012
    From
    chicago
    Posts
    3

    Correlation Coefficients

    Hey everyone, I was wondering if you can help me conceptualize something.

    I was running a few correlations in excel this morning and one of them returned a coefficient of 19.38. Now, I obviously have no formal education in statistics, but I was under the impression that as the coefficient approaches 1.0, the 'stronger' the relationship. So what does it mean when the coefficient is above 1?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    JDA
    JDA is offline
    Newbie
    Joined
    Jun 2012
    From
    chicago
    Posts
    3

    Re: Correlation Coefficients

    So, I just noticed both sets of values are percentages. Perhaps excel is converting the coefficient (.1938) to a percent (19.38) for me? That makes more sense, correct?
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Junior Member Sarasij's Avatar
    Joined
    Jun 2011
    From
    India
    Posts
    42
    Thanks
    2

    Re: Correlation Coefficients

    Quote Originally Posted by JDA View Post
    So, I just noticed both sets of values are percentages. Perhaps excel is converting the coefficient (.1938) to a percent (19.38) for me? That makes more sense, correct?
    Although I don't know much of excel but I guess its in percentage only...
    Follow Math Help Forum on Facebook and Google+

  4. #4
    JDA
    JDA is offline
    Newbie
    Joined
    Jun 2012
    From
    chicago
    Posts
    3

    Re: Correlation Coefficients

    ok, new question:

    I changed all the percentages to decimals (i.e. instead of 20% each cell now reads .20) and the coefficient for the same data sets now reads .164? How is the relationship now weaker? Why has it changed?
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Junior Member Sarasij's Avatar
    Joined
    Jun 2011
    From
    India
    Posts
    42
    Thanks
    2

    Re: Correlation Coefficients

    Quote Originally Posted by JDA View Post
    ok, new question:

    I changed all the percentages to decimals (i.e. instead of 20% each cell now reads .20) and the coefficient for the same data sets now reads .164? How is the relationship now weaker? Why has it changed?
    I guess this is absolutely related to excel only...not sure of it!!
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 7
    Last Post: August 31st 2010, 05:35 AM
  2. Correlation
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: April 16th 2010, 01:29 PM
  3. Average rank correlation coefficients
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: April 12th 2010, 02:41 AM
  4. sample correlation and population correlation
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: November 23rd 2008, 03:31 PM
  5. correlation coefficients
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: March 17th 2008, 05:41 AM

Search Tags


/mathhelpforum @mathhelpforum