Requirements:
-data table with a numeric continuous column containing some missing values.
The Column Interpolation Add-In will:
- Bring up a dialog for column selection.
- The selected column will be copied.
- The original column will have it's missing values imputed by linear interpolation.
This script of this add-in was a patchwork of the following JMP Community conversations:
*https://community.jmp.com/t5/Discussions/Replacing-missing-data-by-regressed-values/td-p/19440
*https://community.jmp.com/t5/Discussions/How-to-duplicate-a-column-exact-copy-except-header/td-p/209825
*https://community.jmp.com/t5/Discussions/Column-Dialog-box-to-select-and-save-column-name-for-selected/td-p/252496
Why doesn't it work when I use it, it does not interpolate, but just copies a new column, and the missing values are not filled.
In addition, it would be great if more interpolation methods (such as polynomial interpolation, spline interpolation, etc.) can be implemented.
@wwh The new column appears to be a copy and the interpolated data is in the original column.
