|
| 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
November 13th, 2009, 05:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
November 13th, 2009, 06:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
