Formualizer Docs
ReferenceFunctionsStatistics Functions

PHI

PHI: Returns the standard normal probability density at `x`.

Summary

PHI is equivalent to NORM.S.DIST(x, FALSE) and is useful in continuous-probability calculations.

Remarks

  • Evaluates the density of a standard normal variable centered at 0.
  • The result is always non-negative and symmetric around x = 0.
  • Works for any real input value.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Standard normal density at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.3989422804014327
Standard normal density at one
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.24197072451914337

Runtime metadata

Category

Statistics

Signature

PHI(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

PERCENTRANK.INC

PERCENTRANK.INC: Returns the inclusive percentile rank of `x` within a numeric data array.

POISSON.DIST

POISSON.DIST: Returns the Poisson probability for event count `x` at average rate `mean`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata