Pearson fucntion on excel

O

Orlando Ochoa

I am trying to run the perason function however I do not have a big database.
I have only 1 line od data and every time i try to run the function it says
#DIV/0!

I tis a must to have a databes with several lines and columns or it should
work with 1 line and several columns
 
D

David Biddulph

Seeing that the term at the bottom of the division in the formula for
PEARSON is
SQRT(SUM(X-Xmean)^2 * SUM(Y-Ymean)^2)
why wouldn't you expect a #DIV/0! when there's only one value and hence
X=Xmean and Y=Ymean?
 
Top