These are some curve functions that can be used to generate curve fits to data that doesn’t lend itself to the built in Excel curve fits.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
Function CalculateWeibull(X As Double, A As Double, B As Double, C As Double, D As Double) As Double CalculateWeibull = A - B * Exp(-C * X ^ D) End Function Function CalculateRichards(X As Double, A As Double, B As Double, C As Double, D As Double) As Double CalculateRichards = A / ((1 + (B * Exp(-C * X))) ^ (1 / D)) End Function Function CalculateGompertz(X As Double, A As Double, B As Double, C As Double) As Double CalculateGompertz = A * Exp(-Exp(B - C * X)) End Function Function CalculateHill(X As Double, A As Double, B As Double, C As Double, D As Double) As Double CalculateHill = A + (B * X ^ D) / (C ^ D + X ^ D) End Function Function CalculateMMF(X As Double, A As Double, B As Double, C As Double, D As Double) As Double CalculateMMF = (A * B + C * X ^ D) / (B + X ^ D) End Function Function CalculateLogistic(X As Double, A As Double, B As Double, C As Double) As Double CalculateLogistic = A / (1 + B * Exp(-C * X)) End Function |