STATS_ONE_SAMPLE Function Reference in Google Sheets | One-Sample t-Test Output

Описание: This video is reference documentation for the STATS_ONE_SAMPLE function in the ALS Stats Google Sheets add-on. It shows how the one-sample t-test report changes when you modify function arguments on a fixed numeric dataset.

00:00 Function overview and scope
00:22 Basic one-sample t-test with defaults
00:35 Parameters description
01:12 Output structure and meaning
02:44 Change hypothesized mean mu0
03:23 Adjust confidence level ciLevel
03:56 Switch to one-sided alternative: greater
04:47 Switch to one-sided alternative: less
05:33 Typical errors and constraints
05:39 Nonexistent colName
06:14 Too few numeric values in column
06:50 Non-numeric mu0 leads to empty result
07:27 Summary

The recording focuses on concrete function behavior: default settings, the effect of changing mu0, ciLevel, and alternative, and how t, p, meanDelta, and confidence intervals update for the same column in a single dataset. It also reproduces common error situations such as an unknown colName, insufficient numeric data, and non-numeric mu0 to show the exact outputs and constraints.

This video does not cover statistical theory, hypothesis testing concepts, or general Google Sheets t-test workflows, and it is not a tutorial or step-by-step guide.

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 #ttest #onesamplettest #alsstats #statistics #pvalue #confidenceinterval #dataanalysis