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: