STATS_KENDALL function reference in Google Sheets (ALS Stats add-on)

Описание: This video is reference documentation for the STATS_KENDALL function in the ALS Stats add-on for Google Sheets, showing its behavior on a fixed dataset. It focuses on how the function reacts to different column filters, confidence levels, and alternative hypotheses rather than explaining Kendall correlation theory.

00:00 Function overview and scope
00:28 Base: all data, defaults
00:38 Parameters description
01:13 Output structure and meaning
02:40 Include only selected columns
03:13 Exclude helper column via negative rule
03:45 Select columns by regex pattern
04:18 Mix direct names, regex, and exclusion
04:49 Change confidence level to 0.90
05:14 Use one-sided alternative: greater
05:42 Typical errors and constraints
05:50 Unknown column in colFilter
06:26 Too few numeric columns selected
06:56 Invalid confidence level
07:29 Unsupported alternative value
08:02 Summary

The video demonstrates STATS_KENDALL on one numeric dataset, including the default call, limiting analysis to selected columns via colFilter, excluding helper columns with negative rules, and selecting variables by regex. It also shows how changing ciLevel and the alternative hypothesis (two-sided vs greater) affects the report output and confidence intervals.

The error section reproduces common failure cases: referencing unknown headers in colFilter, selecting too few numeric columns, using an invalid confidence level outside (0,1), and passing unsupported alternative values. This is reference behavior only; it does not provide statistical theory, step-by-step training, or a general Google Sheets tutorial.

Link to documentation play list:    • ALS Stats — Statistics in Google Sheets (V...  
___________
Install ALS Stats (Google Sheets add-on):
https://workspace.google.com/marketpl...

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

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

Valid for version:
1.0

#googlesheets #kendallcorrelation #alsstats #kendalltau #correlationmatrix #ranksCorrelation #sheetsaddOn