+ Reply to Thread
Results 1 to 2 of 2

Correlation Coefficient function CORREL

  1. #1
    Registered User
    Join Date
    08-31-2006
    Posts
    1

    Unhappy Correlation Coefficient function CORREL

    I have two columns of numbers and I tried to use the correlation coefficient function and I keep getting a #DIV/0! sign. What could I possibly be doing wrong?

    column A column b

    1 5
    2 5
    3 5
    4 5
    5 5

  2. #2
    Forum Contributor
    Join Date
    07-13-2006
    Posts
    400
    correlation depends on the standard deviation of two groups of numbers, as well as their deviation from the expected norm
    your group 55555 has a standard deviation of zero.

    the standard deviation appears in the denominator of the correlation expression, hence your error

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1