PEARSON

About This Document
The Gnumeric Manual, version 1.8
- Welcome!
- How to Use this Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- Graphics: Plots, Images, Widgets, and Drawings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
  - Number Theory
  - Random Numbers
  - Statistics
    
    AVEDEV
    
    AVERAGE
    
    AVERAGEA
    
    BERNOULLI
    
    BETADIST
    
    BETAINV
    
    BINOMDIST
    
    CAUCHY
    
    CHIDIST
    
    CHIINV
    
    CHITEST
    
    CONFIDENCE
    
    CORREL
    
    COUNT
    
    COUNTA
    
    COVAR
    
    CRITBINOM
    
    CRONBACH
    
    DEVSQ
    
    EXPONDIST
    
    EXPPOWDIST
    
    FDIST
    
    FINV
    
    FISHER
    
    FISHERINV
    
    FORECAST
    
    FREQUENCY
    
    FTEST
    
    GAMMADIST
    
    GAMMAINV
    
    GAMMALN
    
    GEOMDIST
    
    GEOMEAN
    
    GROWTH
    
    HARMEAN
    
    HYPGEOMDIST
    
    INTERCEPT
    
    KURT
    
    KURTP
    
    LANDAU
    
    LAPLACE
    
    LARGE
    
    LINEST
    
    LOGEST
    
    LOGFIT
    
    LOGINV
    
    LOGISTIC
    
    LOGNORMDIST
    
    LOGREG
    
    MAX
    
    MAXA
    
    MEDIAN
    
    MIN
    
    MINA
    
    MODE
    
    NEGBINOMDIST
    
    NORMDIST
    
    NORMINV
    
    NORMSDIST
    
    NORMSINV
    
    PARETO
    
    PEARSON
    
    PERCENTILE
    
    PERCENTRANK
    
    PERMUT
    
    POISSON
    
    PROB
    
    QUARTILE
    
    R.DBETA
    
    R.DBINOM
    
    R.DCAUCHY
    
    R.DCHISQ
    
    R.DEXP
    
    R.DF
    
    R.DGAMMA
    
    R.DGEOM
    
    R.DHYPER
    
    R.DLNORM
    
    R.DNBINOM
    
    R.DNORM
    
    R.DPOIS
    
    R.DT
    
    R.DWEIBULL
    
    R.PBETA
    
    R.PBINOM
    
    R.PCAUCHY
    
    R.PCHISQ
    
    R.PEXP
    
    R.PF
    
    R.PGAMMA
    
    R.PGEOM
    
    R.PHYPER
    
    R.PLNORM
    
    R.PNBINOM
    
    R.PNORM
    
    R.PPOIS
    
    R.PT
    
    R.PWEIBULL
    
    R.QBETA
    
    R.QBINOM
    
    R.QCAUCHY
    
    R.QCHISQ
    
    R.QEXP
    
    R.QF
    
    R.QGAMMA
    
    R.QGEOM
    
    R.QHYPER
    
    R.QLNORM
    
    R.QNBINOM
    
    R.QNORM
    
    R.QPOIS
    
    R.QT
    
    R.QWEIBULL
    
    RANK
    
    RAYLEIGH
    
    RAYLEIGHTAIL
    
    RSQ
    
    SKEW
    
    SKEWP
    
    SLOPE
    
    SMALL
    
    SSMEDIAN
    
    STANDARDIZE
    
    STDEV
    
    STDEVA
    
    STDEVP
    
    STDEVPA
    
    STEYX
    
    SUBTOTAL
    
    TDIST
    
    TINV
    
    TREND
    
    TRIMMEAN
    
    TTEST
    
    VAR
    
    VARA
    
    VARP
    
    VARPA
    
    WEIBULL
    
    ZTEST
  - String
  - Time Series Analysis
- Keybinding Reference

PEARSON —

PEARSON(array1,array2)

PEARSON returns the Pearson correlation coefficient of two data sets.

Strings and empty cells are simply ignored.
This function is Excel compatible.

INTERCEPT, LINEST, RSQ, SLOPE, STEYX.