cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
JasonMLawhorn
JasonMLawhorn
Level I

Prediction Expression from DOE not matching

Created: Feb 18, 2022 12:15 PM  |  Last Modified: Jun 8, 2023 2:08 PM (562 views)

I have a prediction expression from my DOE that when popped into excel to make a calculator, the results are not consistent with what populates the imp table column when I create a "Predict Formula" column in my table. It is very close for the center values but off for the values towards the limits of the model. What am I missing??

0 Kudos
1 REPLY 1
Mark_Bailey
Staff Mark_Bailey
Staff

Re: Prediction Expression from DOE not matching

Feb 18, 2022 02:29 PM (544 views)  |  Posted in reply to message from JasonMLawhorn 02-18-2022

You are missing 'coding' probably. The JMP DOE platforms add a Coding column property to the factor data columns. Fit Least Squares uses this property to 'code' the factor levels. You can see this if you examine the column properties. And then JMP changes the labels in Fit Least Squares by appending the low and high values in parentheses after the factor name. Look at the Parameter Estimates table, for example.

 

You can prepare the formula for non-statistical software like Excel easily. Open the formula editor on the prediction formula. The entire formula should be selected (surrounded by blue rectangle.) Find the red triangle at the top center of the editor. Click it and select Simplify. Then save the formula. Actually, copy it first so you can paste it in a cell in the spreadsheet.

0 Kudos