If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|