Skip to content

Instantly share code, notes, and snippets.

@ncalm

ncalm/excel-lambda-StandardErrorofMean.txt

Created January 4, 2024 15:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ncalm/595625883413469a13497c262d4d8ee5 to your computer and use it in GitHub Desktop.
Save ncalm/595625883413469a13497c262d4d8ee5 to your computer and use it in GitHub Desktop.
Download ZIP
This Excel LAMBDA function calculates the standard error of the mean
Raw
excel-lambda-StandardErrorofMean.txt
/*
Standard error of the mean
Usage:
For a measurement from a sample of 100:
Initialize:
MYSAMPLE_SEM = SEM(100);
Use:
MYSAMPLE_SEM(B1:B100)
Or simply:
=SEM(100)(B1:B100)
*/
SEM = LAMBDA(n, LAMBDA(x, STDEV.S(x) / SQRT(n)));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment