|
Savitzky-Golay dialog box |
|
Use this dialog box to smooth a series or calculate derivatives by applying piecewise polynomials as described in Savitzky & Golay (1964). Savitzky-Golay filters are useful for smoothing data with the preservation of higher moments.
Input
Specifies the worksheet location of the input data for this operation.
Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.
Type in this box the range of cells containing the data you want to use as input for this command.
Specifies an interpretation context for the values indicated by Input Range.
Evenly Spaced
Select this option to specify that the data indicated by Input Range is spaced at equal intervals of an independent variable.
Arbitrarily Spaced
Select this option to specify that the data indicated by Input Range is spaced at arbitrary intervals of an independent variable.
 | If you choose this option you must specify a cell range containing the values of the independent variable for each term in the series. See x-Values Range on this topic for additional information on the subject. |
Check this box to indicate that the data specified by the Input Range is organized in rows as opposed to columns (the default).
Refer to Specifying Input Arguments for additional information on this subject.
Output
Specifies the worksheet location for placing the results of this operation.
Select this option to place the results of this operation in a new document workbook.
Select this option to place the results of this operation in a new worksheet.
Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.
Refer to Specifying Output Locations for additional information on this subject.
Options
Specifies the method to use for the least squares solution of the generated equations. Select one of the options from the list:
Gauss-Jordan
Select this option to use Gauss-Jordan elimination.
QR via Householder
Select this option to use QR decomposition via Householder transformations.
Specifies the initial value of the independent variable. Type in this box the x-coordinate of the first point of the independent variable.
| This option is only available when Values Context is set to Evenly Spaced. |
Specifies the increment for subsequent values of the independent variable. Type in this box the x-increment between successive points of the independent variable.
| This option is only available when Values Context is set to Evenly Spaced. |
Specifies a range of cells in the currently active worksheet that contains the values of the independent variable for each term in the input series. Type in this box the cell range where these values are found.
| This range must have the same order (column or row) and length as the input series. If the number of series in this range is equal to the number of input series, then the x-series are paired with the input series for computation; otherwise, the first x-series in the range is used for all input series. |
This option is only available when Values Context is set to Arbitrarily Spaced.
Regression Settings
Type in this box the degree of the polynomial to be fitted through the given Points for Fit points.
Type in this box the number of continuous points to use for the polynomial fit.
| The minimum number of points you may specify for this option are limited by the minimum number of points required to solve the coefficients for the indicated Polynomial Degree. |
Type in this box the polynomial point number to center about the reference points.
| The point number is restricted by the number of points indicated in Points for Fit, and honored whenever possible. |
Type in this box the number of derivatives you want this operation to output.
| The number of derivatives is restricted by the specified Polynomial Degree. |
Closes the dialog box and carries out this operation.
Closes the dialog box without carrying out this operation.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support