Formualizer Docs
ReferenceFunctionsStatistics Functions

CONFIDENCE.NORM

CONFIDENCE.NORM: Returns the half-width of a confidence interval using a normal critical value.

Summary

CONFIDENCE.NORM computes z_crit * standard_dev / sqrt(size) for two-sided intervals.

Remarks

  • alpha must satisfy 0 < alpha < 1.
  • standard_dev must be greater than 0.
  • size must be at least 1.
  • Returns #NUM! when any input is outside valid bounds.

Examples

95% confidence half-width
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.3919927977622559
90% confidence half-width
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.644853625133699

Runtime metadata

Category

Statistics

Signature

CONFIDENCE.NORM(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

CHISQ.TEST

CHISQ.TEST: Returns the right-tail p-value from a chi-square goodness-of-fit style comparison.

CONFIDENCE.T

CONFIDENCE.T: Returns the half-width of a confidence interval using a t critical value.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata