# Documentation/Calc Functions/RSQ

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

RSQ

## Category:

Statistical Analysis

## Summary:

Calculate the square of the sample Pearson correlation coefficient(r^{2}) based on the given value of data samples.

## Syntax:

RSQ(**DataY**; **DataX**)

## Returns:

Returns a real value which is the square of the sample Pearson correlation coefficient of values in **Datay** and **DataX**. It returns a value in the range [0,1].

## Arguments:

**DataY** is a reference to a range of cells which is considered the first data set.

**DataX** is a reference to a range of cells which is considered the second data set.

- If a cell contains text, logical values, or empty cells, then the function ignores these values. However, for logical values, TRUE is considered as 1 and FALSE as 0.
- If
**DataY**and**DataX**are empty or contain only one data point or have a different number of data points then the function returns an error value.

## Additional details:

- RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.
- The formula for is the square of sample PEARSON coefficient = r
^{2}where r is:

where x̄ and ӯ are mean values.

- For more details on the sample Pearson correlation coefficient, visit Wikipedia.

## Examples:

Data1 | Data2 | |
---|---|---|

1 | 195 | 200 |

2 | 151 | 180 |

3 | 148 | 178 |

4 | 189 | 165 |

5 | 183 | 192 |

6 | 154 | 144 |

Formula | Description | Returns |
---|---|---|

=RSQ(A1:A6;B1:B6) | The function calculates the square of the Pearson correlation coefficient of the two data sets, Data1 and Data2. Alternatively, it gives the determination coefficient for both data sets. |
0.218150635028104 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

RSQ