| Home |
| Search |
| Today's Posts |
|
#1
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the fucntion or formula to capture username into excel she | Excel Discussion (Misc queries) | |||
| how i calculate pearson correlation coefficient for excel graph | Charts and Charting in Excel | |||
| Excel Functions Correl and Pearson are identical | Excel Worksheet Functions | |||
| is there a memory plus (like a calculator) fucntion in excel? | Excel Worksheet Functions | |||
| Thank you Chip Pearson | Excel Discussion (Misc queries) | |||
Linear Mode
