[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

CONFIDENCE

Syntax:

CONFIDENCE ( alpha , standard-dev , size )

Description: Computes a value that can be used to construct a confidence interval for a population mean.

Arguments:

Name

Type

Description

alpha

number

The significance level used to compute the confidence level.

standard-dev

number

The population standard deviation for the data range.

size

number

The sample size, truncated to an integer.

 

Return Type and Value: number – A value that can be used to construct a confidence interval for a population mean.

However, if

alpha ≤ 0 or alpha ≥ 1, #NUM! is returned.

standard-dev ≤ 0, #NUM! is returned.

size < 1, #NUM! is returned.

[Example:

CONFIDENCE(0.4,5,12) results in 1.214775614
CONFIDENCE(0.75,9,7) results in 1.083909234

end example]