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

Glossary Item Box

CONFIDENCE


Name

Confidence

Description

Returns confidence interval for a population mean.

Syntax

CONFIDENCE(alpha,stdev,size)

Argument Description
alpha Alpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)%
stdev Population standard deviation for the range
size Number representing the size of the sample; if not an integer, the number is truncated

Data Type

Accepts numeric data for all arguments. Returns numeric data.

Example

CONFIDENCE(0.5,B4,D5)
CONFIDENCE(0.5,R4C2,R5C4)

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