Friday, September 4, 2020

Correction Eqns for the Logistic Eqn


  The Logistic Function is simple enough to illustrate the computation of corrections to the assumed coefficients. One starts by computing δ, the difference between the calculated value of X and the observed value. Then one computes the two fit functions, φ0 and φ1, as well as the single auxiliary function, φ2, forming an array of numbers.

This first array is used to compute a reduced array for the data which is in turn used to solve for the coefficients using worksheet functions to solve a set of linear equations as shown above. The corrections are then added to the assumed values. Using copy and paste to replace the assumed values repeats the process.


No comments: