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

    This function returns the confidence interval for a population mean.

    Syntax

    CONFIDENCE.NORM(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

    Remarks

    The #VALUE! error value is returned if any argument is nonnumeric. The #NUM! error value is returned if size < 1.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    CONFIDENCE.NORM(0.5,B4,D5)

    CONFIDENCE.NORM(0.5,R4C2,R5C4)

    CONFIDENCE.NORM(0.05,3.5,150) gives the result 0.5601063629983405

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    CONFIDENCE