TWO-DIMENSIONAL STATISTICS FUNCTIONS IN A SPREADSHEET
- SUMPRODUCT (data_x;data_y) → Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
- COVAR (data_ x; data_y) → Calculates the covariance of a dataset.
- CORREL (data_x;data_y) → Correlation coefficient.