# Manuals/calci/PEARSON

Jump to navigation
Jump to search

**PEARSON (Array1,Array2)**

- is the array of independent values
- is the array of dependent values.
- PEARSON(),returns the Pearson product moment correlation coefficient.

## Description

- This function gives the Pearson Product-Moment Correlation Coefficient.
- It is denoted by PPMC, which shows the linear relationship between two variables.
- It is a measure of the strength of a linear association between two variables .
- The two variables and , giving a value between +1 and −1 inclusive.
- Here

+1 indicates the perfect positive correlation, 0 indicates no correlation -1 indicates the perfect negative correlation.

- The formula for PPMC, is defined by:

where and are Average of the two Samples and .

- In , the value of and must be either numbers or names, array,constants or references that contain numbers.
- Suppose the array contains text, logicl values or empty cells, like that values are not considered.
- This function will return the result as error when the number of values are different for and .

## Examples

A | B | C | |
---|---|---|---|

1 | 5 | 9 | 10 |

2 | 8 | 12 | 15 |

=PEARSON(A1:C1,A2:C2) = 0.968619605

2.

A | B | C | D | |
---|---|---|---|---|

1 | 17 | 0 | 19 | 25 |

2 | 10 | 11 | 7 | 13 |

=PEARSON(A1:D1,A2:D2) = 0.034204238054579846

3.

A | B | C | |
---|---|---|---|

1 | 1 | 2 | 3 |

2 | 4 | 5 |

=PEARSON(A1:C1,A2:B2) = NAN

## Related Videos

## See Also

## References