STATS_ZSCORES Function Reference in Google Sheets (ALS Stats Add-on)

This video is reference documentation for the STATS_ZSCORES function in the ALS Stats add-on for Google Sheets. It focuses on concrete input ranges, column selection rules, and resulting z-score columns without explaining statistics theory.

00:00 Function overview and scope
00:28 Base: z-scores for all columns
00:43 Parameters description
01:04 Output structure and meaning
01:56 Include only selected columns by name
02:31 Exclude one column using negative rule
03:12 Select columns by regex pattern
03:52 Combine name, regex, and negative rules
04:35 Change postfix for new z-score columns
05:13 Summary

The video shows how STATS_ZSCORES generates z-scores for numeric columns given a data range, how the colFilter parameter behaves with name-based, negative, and regex selectors, and how the postFix parameter changes the names of the generated columns. It demonstrates full-range selection, inclusion by header, exclusion of identifier columns, regex-based groups of score columns, and mixed selector expressions on a single sample dataset.

This recording does not include theory of z-scores, statistical explanations, or a step-by-step tutorial; it is limited to visual reference of function calls and their exact tabular outputs.

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_zscores/

Article version of this video:
https://als-stats.net/blog/functions-zscores
Valid for version:
1.0

#googlesheets #zscore #zscores #dataanalysis #googleworkspacemarketplace #alsstats #statsfunctions

Видео STATS_ZSCORES Function Reference in Google Sheets (ALS Stats Add-on) канала Als Stats