SOLVED

New Contributor

CORREL function returning a result >1 in office365 for mac

Hi,

I have a case of CORREL(array1,array2) function on office365 for mac that return a result greater than 1, which is normally impossible, bug ????

3 Replies
Best Response confirmed by MHL15 (New Contributor)
Solution

Re: CORREL function returning a result >1 in office365 for mac

CORREL itself is returning a value less than 1.
The formulas that return greater than 1 are:
N9: =0.823345142+CORREL(E1:E52,D1:D52)
X9: =0.823345142+CORREL(E1:E52,B1:B52)
They return 1.61867951024453 and 1.6288521538516 respectively.
So, subtracting 0.823345142 or using F9 in the Formula Bar, CORREL returns 0.79533436824453 and 0.805507011851603 respectively.

-----

PS.... Those are the values that I see when I open your workbook in Excel 2010 on a PC.  If you see different results with Office 365 for Mac, I suggest that you add cells that calculate only =CORREL(...), and show us the results, displaying 15 significant digits.

Re: CORREL function returning a result >1 in office365 for mac

Thank you, didn't notice the change in the formula. Now the good question is why (I didn't).

Re: CORREL function returning a result >1 in office365 for mac

@MHL15   Re: ``Now the good question is why (I didn't).``

Sorry, can't answer that. (wink)  Seriously, been there, done that. (sigh)  For me, it's called "a senior moment". (smile)