PEARSON (PQL - xl)

This function returns the Pearson product moment correlation coefficient, a dimensionless index between -1.0 to 1.0 inclusive indicative of the linear relationship of two data sets

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

PEARSON(array1, array2)

Function Arguments

Name

Description

Type

Optional

array1

Array of independent values (x’s)

StringOrNumber

array2

Array of dependent values (y’s)

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'PEARSON' function - using the same inputs, logic and outputs.