Formualizer Docs
ReferenceFunctionsStatistics Functions

CONFIDENCE.T

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

Summary

CONFIDENCE.T is typically used when population standard deviation is unknown and sample size is limited.

Remarks

  • alpha must satisfy 0 < alpha < 1.
  • standard_dev must be greater than 0.
  • size must be at least 2 so that df = size - 1 is valid.
  • Returns #NUM! when inputs are outside valid bounds.

Examples

95% t-interval half-width
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.8256636934020788
90% t-interval half-width
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.9158049866307585

Runtime metadata

Category

Statistics

Signature

CONFIDENCE.T(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

CONFIDENCE.NORM

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

CORREL

Returns the Pearson correlation coefficient between two numeric arrays.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata