Spread 8.0 Documentation
STANDARDIZE
Support Options
Formula Reference > Built-In Functions > STANDARDIZE

Glossary Item Box

STANDARDIZE


Name

Standardize

Description

Returns a normalized value from a distribution characterized by mean and standard deviation.

Syntax

STANDARDIZE(x,mean,stdev)

Remarks

This function has these arguments:

Argument Description
x Value to normalize
mean Arithmetic mean of the distribution
stdev Standard deviation of the distribution Must be greater than zero

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

STANDARDIZE(15.6,A4,B2)
STANDARDIZE(B4,C5,D5)
STANDARDIZE(88,48,1.6)=25

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.