CONFIDENCE_NORM
function CONFIDENCE_NORM(arg1: number = null, arg2: number = null, arg3: number = null): numberDescription
Returns the confidence interval for a population mean, using a normal distribution.
Parameters
- arg1
numberdefault: null The significance level used to compute the confidence level, a number greater than 0 and less than 1.
- arg2
numberdefault: null The population standard deviation for the data range and is assumed to be known. This value must be greater than 0.
- arg3
numberdefault: null The sample size.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.CONFIDENCE_NORM(0.5, 57, 8);
oWorksheet.GetRange("B2").SetValue(ans);