|
Polynomial Expansion dialog box |
|
Use this dialog box to conjugate a set of series into the terms of a polynomial of a specified degree. Typically you would do this to transform your variables when you have reason to believe that a certain model is based on a higher order polynomial of the variables. This operation uses recursion based on the number of input series and specified polynomial degree.
 | When the specified polynomial degree is high, and the average absolute value of the input values is also large, it is possible for this operation to generate #NaN's because of floating point number overflow. To avoid this condition you can resort to scaling the input values prior to carrying this operation. |
 | You might consider carrying a polynomial expansion on some independent variables to carry a least squares solution on their expanded values. |
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.
Check this box to indicate that the data specified by the Input Range box 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 degree at which to expand the input series. Type in this box the integer number corresponding to the polynomial degree you want.
Closes the dialog box and carries out this operation.
Closes the dialog box without carrying out this operation.
Examples
| · | Expanding A to a second degree polynomial, produces: |
AA, A
| · | Expanding A, B to a second degree polynomial, produces: |
AA, AB, A, BB, B
| · | Expanding A, B to a third degree polynomial, produces: |
AAA, AAB, AA, ABB, AB, A, BBB, BB, B
| · | Expanding A, B, C to a second degree polynomial, produces: |
AA, AB, AC, A, BB, BC, B, CC, C
| · | Expanding A, B, C to a third degree polynomial, produces: |
AAA, AAB, AAC, AA, ABB, ABC, AB, ACC, AC, A, BBB, BBC, BB, BCC, BC, B, CCC, CC, C
Sample Output
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support