SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / 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