MODDE regression coefficients used in equation in Excel (Q915)

The information in this article applies to: 
MODDE 12.1
MODDE 12
MODDE 11
MODDE 10
Summary: 

This KB-article describes the workflow when using the regression coefficients calculated by MODDE in an equation in for instance Excel.

More Information: 
  1. In MODDE, on the Home tab, click Coefficients | Coefficient list
  2. Right-click the list and in Properties, on the Coefficients tab click Unscaled.
  3. Copy the list to Excel.
  4. Enter the values for the main term model in original units that you want to use.
  5. Calculate interaction and square terms.
  6. Multiply the regression coefficieints with the respective value.
  7. Summarize including the constant to get your predicted value.

See an example of the calculation and the mip it is based on in the the attached .zip-file.

External Document: 
Date modified: Jan 29, 2019
Article type: 
Information