Functions
MARGINOFERROR
Margin of error
Try it
When to use it
When should I use MARGINOFERROR?
Use MARGINOFERROR when you have a sample of numeric measurements and need to report the ± range of a confidence interval — for example, summarising survey responses, A/B test metrics, or quality-control sample results.
Used in
Syntax
MARGINOFERROR(data,confidence)Examples
=MARGINOFERROR({8,4,3,6},0.95) // => 3.5283078589306944
=MARGINOFERROR({1,2,3;4,5,6;7,8,9},0.99) // => 3.0630355508972618