Returns the confidence interval for a population mean, using a normal distribution.
| 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. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var avg = oFunction.CONFIDENCE(0.5, 57, 8);
oWorksheet.GetRange("B2").SetValue(avg);
builder.SaveFile("xlsx", "CONFIDENCE.xlsx");
builder.CloseFile();