CONFIDENCE_NORM

CONFIDENCE_NORM(arg1, arg2, arg3) → { number }

Returns the confidence interval for a population mean, using a normal distribution.

Parameters:

Name Type Description
arg1 number

The significance level used to compute the confidence level, a number greater than 0 and less than 1.

arg2 number

The population standard deviation for the data range and is assumed to be known. This value must be greater than 0.

arg3 number

The sample size.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var avg = oFunction.CONFIDENCE_NORM(0.5, 57, 8);
oWorksheet.GetRange("B2").SetValue(avg);
builder.SaveFile("xlsx", "CONFIDENCE_NORM.xlsx");
builder.CloseFile();

Resulting document