STATS_INDEPENDENT function reference – independent t-test in Google Sheets (ALS Stats)

This video is reference documentation for the STATS_INDEPENDENT function in the ALS Stats add-on for Google Sheets. It shows the exact behavior of the independent-samples t-test report for one dataset under different parameter settings.

00:00 Function overview and scope
00:29 Basic independent t-test with defaults
00:44 Parameters description
01:34 Output structure and meaning
03:49 Select groups using regex colFilter
04:01 Regex-based selection results
04:19 Force Welch t-test
04:31 Welch t-test results
04:53 Switch to Student t-test
05:04 Student t-test results
05:24 Change confidence level
05:34 Confidence level 0.9 results
05:53 One-sided alternative: greater
06:06 One-sided greater results
06:37 One-sided alternative: less
06:46 One-sided less results
07:08 Use Levene homogeneity test
07:20 Levene homogeneity results
07:38 Typical errors and constraints
07:42 Error: unknown or empty column selection
08:19 Summary

The video covers a single numeric dataset analysed with STATS_INDEPENDENT and shows how the spilled report changes when you switch column selection (named vs regex colFilter), Welch vs Student t-test, confidence level, alternative hypothesis (two-sided, greater, less), and homogeneity test (Brown–Forsythe vs Levene). It also reproduces the "unknown or empty column selection" error so you can see how the function responds to invalid colFilter rules.

This recording does not include statistical theory, interpretation guidance, or a step-by-step tutorial; it is limited to observable function behavior and output structure.

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

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

Valid for version:
1.0

#googlesheets #ttest #independentttest #welchttest #students ttest #alsstats #statistics

Видео STATS_INDEPENDENT function reference – independent t-test in Google Sheets (ALS Stats) канала Als Stats