STATS_PEARSON Function Reference in Google Sheets | Pearson Correlation Matrix Documentation

This video is reference documentation for the STATS_PEARSON function in the ALS Stats Google Sheets add-on, focused on Pearson correlation reports and correlation matrices.

It demonstrates concrete function calls and outputs for STATS_PEARSON in Google Sheets without explaining statistical theory or providing a step-by-step tutorial.

00:00 Function overview and scope
00:27 Basic two-column Pearson test
00:44 Parameters description
01:11 Output structure and meaning
02:31 Full correlation matrix for all tests
02:42 Explain wildcard matrix changes
03:38 Select a subset via negative rules
03:50 Explain negative rule changes
04:19 Use regex to select columns by name
04:31 Explain regex selection changes
04:59 Change confidence level of intervals
05:09 Explain confidence level change
05:35 Switch to one-sided greater alternative
05:45 Explain greater alternative change
05:59 Switch to one-sided less alternative
06:08 Explain less alternative change
06:20 Typical errors and constraints
06:26 Unknown column name in colFilter
07:03 Too few numeric columns after filtering
07:37 Invalid confidence level outside 0–1
08:12 Invalid alternative hypothesis value
08:50 Summary

The video shows how STATS_PEARSON behaves for a two-column Pearson r report, then for a full 4×4 correlation matrix when using a wildcard column selector. It documents name-based filters, negative rules, and regex-based column selection, as well as how changes to ciLevel and the alternative parameter (two-sided, greater, less) affect confidence intervals and p-values.

The scope is limited to function behavior, parameters, output structure, and typical error messages (unknown column in colFilter, too few numeric columns, invalid confidence level, invalid alternative value). It does not cover Pearson correlation theory, interpretation of results, or a general Google Sheets tutorial.

Link to documentation play list: https://www.youtube.com/playlist?list=PL5GYWQjgDdVAaHF7oUzKcLXRtPfk7BK69
___________
Install ALS Stats (Google Sheets add-on):
https://workspace.google.com/marketplace/app/als_stats/558005348178

Function documentation:
https://als-stats.net/functions/stats_pearson/

Article version of this video:
https://als-stats.net/blog/functions-pearson/

Valid for version:
1.0

#STATS_PEARSON #GoogleSheets #PearsonCorrelation #CorrelationMatrix #ALSStats #PearsonsR #CorrelationCoefficient #GoogleSheetsAddOn #StatisticsInSheets

Видео STATS_PEARSON Function Reference in Google Sheets | Pearson Correlation Matrix Documentation канала Als Stats