Pearson fucntion on excel
 

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

Pearson fucntion on excel
 

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?
--
David Biddulph

"Orlando Ochoa" <Orlando wrote in message
...
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