public static object acq_metric_ks( [ExcelArgument(Description = "Array of actual observations")] double[] actual, [ExcelArgument(Description = "Array of predicted probabilities")] double[] predicted) { double result = ACQ.Math.Metrics.KS(actual, predicted); return(ExcelHelper.CheckNan(result)); }
public static object acq_absmin( [ExcelArgument(Description = "Array")] object x) { double[] array = ExcelHelper.CheckArray <double>(x); double min = ACQ.Math.Stats.Utils.AbsMin(array); return(ExcelHelper.CheckNan(min)); }
public static object acq_max( [ExcelArgument(Description = "Array")] object x) { double[] array = ExcelHelper.CheckArray <double>(x); double max = ACQ.Math.Stats.Utils.Max(array); return(ExcelHelper.CheckNan(max)); }
public static object acq_sumofsquares( [ExcelArgument(Description = "Array")] object x) { double[] array = ExcelHelper.CheckArray <double>(x); double sum_sqr = ACQ.Math.Stats.Utils.SumOfSquares(array); return(ExcelHelper.CheckNan(sum_sqr)); }
public static object acq_stdev( [ExcelArgument(Description = "Array")] object x) { double[] array = ExcelHelper.CheckArray <double>(x); double stdev = ACQ.Math.Stats.Utils.Std(array); return(ExcelHelper.CheckNan(stdev)); }
public static object acq_binomtest( [ExcelArgument(Description = "number of successes in the binomial experiment")] int x, [ExcelArgument(Description = "number of independent trials in the binomial experiment")] int n, [ExcelArgument(Description = "Confidence level (e.g. 0.95)")] double conf_level, [ExcelArgument(Description = "Lower (TRUE) or Upper bound (FALSE)")] bool isLower) { var result = ACQ.Math.Stats.BinomTest.ConfidenceInterval(x, n, conf_level); return(ExcelHelper.CheckNan(isLower ? result.Item1 : result.Item2)); }
public static object acq_mean( [ExcelArgument(Description = "Array")] object x, [ExcelArgument(Description = "Array of Weights [optional]")] object w, [ExcelArgument(Description = "Ignore NA flag [optional] (default: false)")] object ignore_na) { double[] x_input = ExcelHelper.CheckArray <double>(x); //TODO: we need to check that correspondance between x and w is preserved double[] w_input = ExcelHelper.CheckArray <double>(w); bool na_rm = ExcelHelper.CheckValue <bool>(ignore_na, false); double result = ACQ.Math.Stats.Utils.WeightedMean(x_input, w_input, na_rm); return(ExcelHelper.CheckNan(result)); }
public static object acq_special_normalcdf(double x) { return(ExcelHelper.CheckNan(ACQ.Math.Special.NormalCdf(x))); }
public static object acq_special_erfc(double x) { return(ExcelHelper.CheckNan(ACQ.Math.Special.erfc(x))); }