Documentation/Calc Functions/RSQ

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

RSQ

Category:

Statistical Analysis

Summary:

Returns the square of the Pearson correlation coefficient based on the given values.

Syntax:

RSQ(DataY; DataX)

Returns:

Arguments:

DataY is an array or range of data points.

DataX is an array or range of data points.

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.

Examples:

=RSQ(A1:A20;B1:B20) calculates the determination coefficient for both data sets in columns A and B.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: