Nonlinear Regression in Microsoft Excel

A three parameter (a,b,c) model y = a + b/x + c ln(x) is fit to a set of data with the Excel solver add-in. This tutorial walks through the process of installing the solver, setting up the objective (normalized sum of squared errors), and adjusting the parameter values to minimize the SSE.

Видео Nonlinear Regression in Microsoft Excel канала APMonitor.com