If I increase B4:B6 to show 14 decimal places, the values
will only be 1.90000000000000 - Why would that make a
difference?
-----Original Message-----
See Help for CORREL worksheet function. The denominator
is the product
of standard deviations for x and y. The standard
deviation of B12:B14
is zero ...
Format B4:B6 to show 14 decimal places. You will find
that they are not
all equal, hence the standard deviation is small, but
not zero.
Jerry
Diane wrote:
I have a formula in cell C7, the formula is:
CORREL(B4:B6,C4:C6)
The cells have the follwing values:
B4: 1.90
B5: 1.90
B6: 1.90
C4: 2.13
C5: 1.83
C6: 3.02
Cell C7 returns: 0.000
Here's where the problem comes in.
The formula in cell C15 is: CORREL(B12:B14,C12:C14)
The cells have the follwing values:
B12: 9.50
B13: 9.50
B14: 9.50
C12: 9.56
C13: 10.26
C13: 10.16
Cell C15 returns the error: #DIV/0!
Why is the formula producing the #DIV/0! error in the
second set and not the first or vice versa?
ANY help would be greatly appreciated.
Thanks, Diane
.
|