+ Reply to Thread
Results 1 to 3 of 3

why do i get div by 0 errors on correl-function?

  1. #1
    Registered User
    Join Date
    02-23-2004
    Location
    helsinki, finland
    MS-Off Ver
    2016
    Posts
    59

    why do i get div by 0 errors on correl-function?

    why do i get div by 0 errors on correl-function? see attached...

    on some seemingly similar columns it works, but not in the ones as my example file.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: why do i get div by 0 errors on correl-function?

    It appears to be a quirk of this data set. If you recall from your statistics courses, the Pearson correlation coefficient is calculated as covariance(x,y)/stdev(x)/stdev(y). In your data set, the A and B columns consists only of -1 values, so the stdev(A)=0 and stdev(B)=0, and you cannot divide by 0.

    It's more of a statistics question, but I would wonder what exactly a correlation coefficient is supposed to mean when one column/variable never varies. I might suggest that you revisit the statistics side of your problem and review what exactly you are trying to do here.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-23-2004
    Location
    helsinki, finland
    MS-Off Ver
    2016
    Posts
    59

    Re: why do i get div by 0 errors on correl-function?

    i guess i have to change my data set - and take that statistics course...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use of the correl function with a lag
    By baudet_bel in forum Tips and Tutorials
    Replies: 0
    Last Post: 07-13-2021, 09:38 AM
  2. correl function and div/0
    By Alfie101 in forum Excel General
    Replies: 2
    Last Post: 03-29-2016, 03:11 AM
  3. Educate me on the correl function
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-17-2014, 04:37 PM
  4. Excluding Zeros from CORREL Function
    By WWOL in forum Excel General
    Replies: 9
    Last Post: 07-29-2010, 02:06 PM
  5. Correl Function Confusion
    By leem in forum Excel General
    Replies: 1
    Last Post: 04-24-2008, 09:49 AM
  6. correl function
    By censura in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2007, 05:13 AM
  7. Correlation Coefficient function CORREL
    By dataperson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2006, 05:27 PM

Tags for this Thread

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