Skip to content

Helpers

These lambda functions do work for other CLS-Stats functions and are not meant to be called directly. They are copied into a workbook as hidden Names along with the functions that need them, so they don’t appear in the Name Manager or in formula autocomplete. Their source code is listed here so that the functions that use them can be inspected in full.

FunctionDescription
BootObsReshapes a sample the way the bootstrap functions see it
BCaPercentilesBCa confidence interval from a bootstrap distribution
_PolyFitPolynomial least-squares fit used by the Poly* functions
_PolyStretchFinds where a fitted polynomial stops rising or falling
_InvLimitSearches for the confidence limits of an inverse prediction
_BisectRoot finding by bisection
_NumJacNumerical Jacobian for NLS
_LMFitLevenberg-Marquardt iterations for NLS
FSolveBumpFleishman coefficients, nudging the kurtosis if needed
FSolveLadderRetries FSolve from several starting values
FSolveFleishman power-method coefficients by Newton's method
FSolveMonotonicChecks that Fleishman coefficients give a monotonic transformation