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 ans = oFunction.CONFIDENCE_NORM(0.5, 57, 8); oWorksheet.GetRange("B2").SetValue(ans); builder.SaveFile("xlsx", "CONFIDENCE_NORM.xlsx"); builder.CloseFile();