This is an old revision of the document!
Nonlinear least squares data fitting (nonlinear regression) can be performed using Fit Plot.
To create a Fit Plot, select your X and Y columns in Table, then select
Table → Create Fit Plot in the main menu, or use the same item in the Table context menu, or use
Create Fit Plot button in the toolbar.
National Institute of Standards and Technology (NIST) has created the Statistical Reference Datasets Project which includes 26 datasets for testing the nonlinear fit algorithms. MagicPlot has been successfully tested on these datasets. Our report on MagicPlot testing with NIST datasets is available here: Report.
'Nonlinear' means here that analytical fitting function depends nonlinearly on varying parameters (fit parameters). Fit procedure iteratively varies the parameters of the fit function to minimize the residual sum of squares. The nonlinear fitting algorithm needs the user to set the initial values of fit parameters.
To fit the data, implement these steps:
You can undo fit and also undo changing initial parameters as any other action using
Undo function. It is a handy feature when experimenting with different models and initial parameters.
This manual does not completely cover the complex nonlinear fitting methodology. We recommend you to take a look at this book:
Addbutton to add new Fit Curve to the list. There is a number of predefined Fit Curves types (Line, Parabola, Gauss, Lorentz, etc.) You can also create a Custom Equation Fit Curve and manually enter the formula (Pro edition only). Baseline fitting components may be added to the fitting sum, too. Fit Plot window contains the list of Fit Curves. Each Fit Curve in the list has three checkboxes: *
Show: Specifies whether to show this Fit Curve on the plot. Active only if Baseline checkbox is not set *
Baseline: Toggles the subtracting of this Fit Curve from experimental data. You also can use
Residualbutton to subtract all Fit Sum from data *
Sum: Specifies whether to use this Fit Curve in sum fit function Below the Fit Curves list, is a parameters table which shows names, values, and descriptions of parameters relating to the selected Fit Curve. ==== Fitting by Sum and Fitting One Curve ==== MagicPlot allows two alternatives buttons to run the fit: *
Fit by Sumbutton will fit the data with the sum of Fit Curves for which the
Sumcheckbox is set. Data interval from
Fit Intervaltab will be used. This button must be used for example to fit the spectrum with the sum of peaks. *
Fit One Curvebutton will fit the data with the one currently selected Fit Curve. The individual interval for each Fit Curve will be used. Set
Edit Intervalcheckbox to edit individual interval for each Fit Curve. ==== Copying and Pasting Fit Curves ==== You can copy and paste Fit Curves from one Fit Plot to another Fit Plot or Figure. You can also paste the copied Fit Curves to the same Fit Plot to create a copy. * The copy of Fit Curves with the same parameters and styles will be created if you paste Fit Curves to a Fit Plot. * A link to the source Fit Curves will be inserted if you paste Fit Curves in a Figure. ==== Fit Curves Reordering ==== You can reorder Fit Curves by dragging them in the table. The data curve is always drawn the first and fit sum is drawn the last. ===== Setting Initial Values of Parameters ===== Nonlinear fitting assumes that certain initial values of parameters are set before fitting. This procedure is very easy if you use Fit Curves of predefined types (not custom equation): you can drag curves on the plot. Initial parameters values for each Fit Curve can also be set in the parameter table. ==== Adjusting Parameters with Mouse Wheel ==== You can adjust Parameters in the table using mouse wheel scrolling when the mouse cursor is on the desired parameter: Hold Ctrl key (Cmd key on Mac) and scroll. If the Shift key is also pressed the parameter step for one wheel 'click' will be increased. ===== Guessing Peaks ===== If you are fitting a spectrum with multiple peaks, MagicPlot may automatically add and approximately locate peaks before fitting (Pro edition only). See Guessing Peaks for details. Guessed peaks should be used only as of the initial estimate for fitting: don't forget to click the Fit button after peaks are added. ===== Parameter Locking ===== You can lock (fix) parameter(s) to prevent varying this parameter(s) during the fit and to prevent its changing due to set initial values by mouse dragging (for built-in functions). Set the checkbox in
Lockcolumn in the parameter list to lock parameter. ===== Parameters Joining ===== MagicPlot allows joining (sometimes referred to as coupling, binding, linking) of fit parameters of different Fit Curves. See Joining the Parameters of Fit Curves for details. ===== Weighting of Data Points Using Y Errors ===== MagicPlot allows the weighting of data points with Y error data. You can specify Y error data in Fit Plot properties dialog. If no Y error data are specified weighting is not used. Weights are calculated as
1 / Yerror2for every point. See Fitting Algorithm and Computational Formulas for details. Weights must be positive and finite for all points so the Y error values must be positive and non-zero (to prevent infinite weights). MagicPlot checks this condition before fitting and shows an error message if Y errors cannot be used to compute weights. ===== Specifying Fit Intervals ===== You can set the X intervals of the data which will be used for fitting. Data points outside these intervals are not used to compute the minimizing residual sum of squares. You can use this feature if some data points (especially in the beginning or the end) are inaccurate, e.g. noisy. Select
Fit Intervaltab to set intervals visually or edit accurate borders values in the table. * Double click on the interval to split it * Drag the interval border to move it. If intervals intersect, they will be merged * Use context menu on the plot to create, delete and split intervals Note: Data intervals from the
Fit Intervaltab are used for fitting Sum only. To set individual data intervals for the one Curve fitting use
Edit Intervalcheckbox. ===== Baseline Fitting and Extraction ===== Fit Interval is also usable when baseline fitting. Before baseline fitting, you can specify the interval which does not contain any signal points and contains baseline only. Set
Baselinecheckboxes at baseline Fit Curves after baseline fitting to subtract baseline from data. Then specify the whole interval and fit the data. Note that if you use data processing (integration, FFT, etc.) on Fit Plot, then the difference between the data and baseline curves (which you do see on the plot) will be processed. You can use this behavior to exclude baseline from data before integrating, see Integration for more information. ===== 'Data-Baseline' Table Column ===== The 'Data-Baseline' column is appended to the Table with initial (X and Y) data when you create a Fit Plot. The 'Data-Baseline' column contains the difference between initial Y data and baseline approximation (the sum of Fit Curves for which
Baselinecheckbox is set). It is 'Data-Baseline' column that is actually plotted on Fit Plot as data. Use 'Data-Baseline' column in Table if you want to process the data without baseline. This column is also used as initial data if you use
Processingmenu when Fit Plot is active. ===== Viewing the Residual Plot ===== Residual means here the difference between initial data, baseline function and Fit Sum function. MagicPlot offers two different ways to view the residual: * Press and hold the
Residualbutton. The residual will be shown while the button is pressed. You can use either mouse or space key (if the button is selected) to hold
Residualbutton. * You can either set
Baselinecheckboxes for all summed Fit Curves to subtract them from data and explore the residual plot ===== Fitting ===== To execute the fit click the
Fit by Sumbutton of
Fit One Curvebutton (see below). MagicPlot indicates the fit process with a special window. Fitting curves are periodically updated on the plot while fitting so you can see how fit converges. MagicPlot shows the current iteration number and deviation decrement with two progress bars while the fit is performed. The fit process stops when one of these progress bars reaches the end. You can see two buttons on fit progress window: *
Break Iterations: Breaks iterations after current iteration. Use this button if you suspect that further iterations will not change the result. *
Undo Fit: Breaks iterations and reverts fit parameters to their initial (before fit) values. Use this button if you see that fit process converges to wrong result; change initial values of parameters and run fit again. ===== Fitting One Curve ===== You can use MagicPlot to fit the data with single selected Fit Curve by pressing
Fit One Curvebutton. In this case, a specific data interval for each Fit Curve is used and the main fitting data interval (from
Fit Intervaltab) is ignored. Select
Edit Intervalcheckbox in the bottom of the Fit Plot panel to set specific fit intervals for each Fit Curve. Because of using individual data interval this method is useful for baseline fitting. In order to fit baseline specify the intervals which do not contain signal (peaks) and contain only noise. ===== Why My Fit is Not Converged? ===== In some cases, the fit procedure may fail to find the optimal parameters values. The actual mathematical reason for this error is the impossibility to invert the matrix α calculated from partial derivatives of the fit function with respect to fit parameters. This inverted matrix is used to compute the new values of parameters for the next step of fit (like gradient descent). In most cases, this error occurs when the matrix α is ill-conditioned or nearly singular and the inverse cannot be calculated accurately enough with used floating-point arithmetic. === The origin of this error may be: === * Fit is not converged through one or more parameters: some parameters were taking unrealistically great values during iterations. There is no local minimum of residual sum of squares near the initial values of these parameters. MagicPlot highlights the suspicious Fit Curve in this case. * Mutual dependency exists between some parameters. The algorithm cannot resolve which parameter to vary. * Fit function is ill-conditioned: the minimized residual sum of squares depends on some parameters much more than on other ones. * Numeric overflow (or underflow) when calculating fit function with initial parameter values or on the next steps. === Try one of the following: === * Specify more accurate initial values of parameters. * Simplify the fit function (e.g. remove some peaks). * Lock some parameters. ===== See Also ===== * Fitting Algorithm and Computational Formulas * Specifying Custom Fit Equation * Using Spline for Baseline Subtraction * Joining the Parameters of Fit Curves * Guessing Peaks * Predefined Fit Curves Equations * Calculating Integrals and Statistics on Intervals using Fit Plot * Export Curves as Table