Spread Formula Reference
Formula Functions / Functions A to C / CONFIDENCE
In This Topic
    CONFIDENCE
    In This Topic

    This function returns the confidence interval for a population mean.

    Syntax

    CONFIDENCE(alpha,stdev,size)

    Arguments

    This function has these arguments:

    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 Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    CONFIDENCE(0.5,B4,D5)

    CONFIDENCE(0.5,R4C2,R5C4)

    CONFIDENCE(0.05,3.5,150) gives the result 0.560106363

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    AVERAGE | CHITEST | Statistical Functions