STATS_ANALYZE Function Reference: Several Analyses in One Formula in Google Sheets (ALS Stats)

Reference documentation for the STATS_ANALYZE function of the ALS Stats add-on for Google Sheets: several analyses written in one tests list and returned as one report, shown on one dataset. 00:00 Function overview and scope 00:22 One analysis: descriptive statistics 00:33 Parameters description 00:51 Output structure and meaning 01:11 Add a paired t-test 01:46 Pass parameters to an analysis 02:13 Add a categorical test (old syntax) 02:45 Typical errors and constraints 02:48 Error: a column that does not exist 03:18 Error: an unknown analysis name 03:45 Error: too many parameters 04:12 Summary The video shows the syntax of an analysis (the STATS function without STATS_ and without the range), several analyses in one text, parameters in the order of the STATS function, and the old syntax for crosstabs, chi-square and Cramer's V. Three errors close the video: an analysis with a column that does not exist, an unknown analysis name and too many parameters, with a failed analysis listed after the other reports. Not included: the theory of the tests. 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... Valid for version: 2.1 #googlesheets #spssalternative #statistics #alsstats #dataanalysis