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)));
}
