People trying nonlinear regression to fit a nonlinear
function to data usually face the problem of finding special programs and "pacquages" and invest time to learn and
Why not to try a nonlinear regression in Excel?
In this page we introduce a program of Nonlinear
Regression Analysis in Excel for the estimation of parameters of models fitting to the age distribution of deaths for specific
Many applications refer to the data provided by the National Statistics or Health Statistics or the Bureau
of the Census of various countries or by specialized institutes (The data used in our applications are mainly from the Human
Mortality Database, www.mortality.org
The annual data per age of death, usually from 0 to 110 are divided by their total number so that there appear a probability
distribution which makes easy the comparisons between different time periods or various countries or population groups.
We also give two models based on the First Exit Time Theory of a stochastic process which in this case is the
Human Health State.
The first model avoids the infant mortality while provides good fitting for the remaining part of
the data sets: http://www.cmsim.net/sitebuildercontent/sitebuilderfiles/skiadasamodelingapproach.pdf whereas the second model (IM) takes into account the infant mortality (see Skiadas, C. and Skiadas, C. H., Development,
Simulation and Application of First Exit Time Densities to Life Table Data, Communications in Statistics - Theory and Methods,
Volume 39, Issue 3 January 2010, pages 444 - 451. This paper can be downloaded from: http://www.informaworld.com/smpp/content~db=all~content=a918382403~frm=titlelink).
We also provide
a Nonlinear Regression Analysis Program in Excel for the Weibull Model for applications with Life Table Data.
This method for nonlinear regression uses the method proposed in Skiadas 1986: