+ Reply to Thread
Results 1 to 3 of 3

correl function and div/0

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    correl function and div/0

    Hi, I have tried variations of getting around the div/0 error to no avail. Appreciate help please, thank you. These are the two arrays:

    22 99.7
    43 94.1
    24 76.6
    3 77.2
    7 88.3
    5 55.4
    5 74.0
    2 78.7
    35 92.6
    4 53.1
    0.1 77.5
    26 57.7
    33 99.2
    0.1 84.5
    19 91.2
    20 71.2
    4 69.8
    4 52.4
    17 93.7
    19 86.4
    2 79.6
    1 59.5
    34 95.5
    5 84.8
    15 54.3
    17 87.3
    4 97.7
    1 84.5
    16 63.5
    20 69.7
    10 90.6
    4 63.2
    2 77.4
    42 72.3
    1 79.0
    13 76.2
    6 78.5
    20 95.2
    6 62.3
    35 95.7
    24 92.2

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,373

    Re: correl function and div/0

    It would probably help if you described some of your failed attempts. The CORREL() function seemed to work just fine for me on that data set (result ~0.4).

    You might review this: https://support.office.com/en-us/art...b-239d7b68ca92 and see if any of the error conditions mentioned under "Remarks" exists.
    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
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: correl function and div/0

    Mr Shorty,

    Many thanks indeed. I too have got it now.

    Sorry to trouble you.

    Alfie101

+ 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. Educate me on the correl function
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-17-2014, 04:37 PM
  2. automatically updating row information in CORREL function
    By jsstoneb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2014, 05:04 PM
  3. Excluding Zeros from CORREL Function
    By WWOL in forum Excel General
    Replies: 9
    Last Post: 07-29-2010, 02:06 PM
  4. Correl Function Confusion
    By leem in forum Excel General
    Replies: 1
    Last Post: 04-24-2008, 09:49 AM
  5. correl function
    By censura in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2007, 05:13 AM
  6. Correlation Coefficient function CORREL
    By dataperson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2006, 05:27 PM
  7. Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
    By Emmanuel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2005, 11:40 AM

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