Results 1 to 3 of 3

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

Threaded View

  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

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