STATS_ALPHA Function Reference: Cronbach’s Alpha in Google Sheets (ALS Stats)

Описание: This video is reference documentation for the STATS_ALPHA function in the ALS Stats add-on for Google Sheets. It focuses on how the function behaves on a concrete dataset, including column selection, report output, and error cases.

00:00 Function overview and scope
00:25 Base: all columns with defaults
00:39 Parameters description
01:03 Output structure and meaning
01:17 Include items by explicit names
01:45 Exclude by negative rules
02:08 Use a regex for item selection
02:26 Mix name, regex, and exclusion
02:51 Turn on 'Alpha if item deleted'
03:57 Typical errors and constraints
04:03 Error: only one item selected
04:40 Error: 'if item deleted' with two items
05:16 Summary
The video shows STATS_ALPHA on a Likert-style survey scale in Google Sheets, first with the default colFilter="*" (all numeric columns, including an id), then with explicit item names, negative exclusion rules ("-id"), and regex-based selection ("/^q/"). It also covers mixed rules in colFilter (combining names, regex, and exclusions) and the effect of toggling ifItemsDeleted on the resulting Cronbach’s Alpha report and the "Alpha if item deleted" table.

The scope is limited to observable behavior: which columns are treated as items, how the output report changes when items are added or removed, and what happens when the configuration is invalid. Two error scenarios are demonstrated: selecting only one item, and using ifItemsDeleted with only two items. This video does not include theory of Cronbach’s Alpha, interpretation guidance, or a step-by-step 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

#cronbachalpha #googlesheets #alsstats #statisticalanalysis #likertscale #reliabilityanalysis