CONFIDENCE (PQL - xl)

This function returns the confidence interval for a population mean

Syntax

CONFIDENCE(alpha, standard dev, size)
Function Arguments

Name

Description

Type

Optional

alpha

Alpha, significance level used in calculating confidence level, where the confidence level is 100 times (1-alpha)%

Number

standard dev

Population standard deviation for the range

Number

size

Number representing the size of the sample; if not an integer, the number is truncated

Number

Comments

This function is the same as the Microsoft Excel 'CONFIDENCE' function - using the same inputs, logic and outputs.