Get the a modeled output in a use-able form?

feldybikes

I have a data set that comes close to fitting neatly in a tabulate output. All of the X's are categorical. All of the Y's are continuous. There are some combinations of x's, however that have very few data points or no data points, so I get an unreliable or non-existent Y.

To solve this problem, I want to use Fit Model. I can get a very reasonably looking model

Prediction Expression

One point for example:

But I don't know how to output this efficiently. I could look at every point by hand. Or I could take the Parameter Estimates or the Prediction Expression and write a long series of if/then code. But I figure there must be something I'm missing. What I would like is an output like the tabulate I started with but with but filled in with the estimated values. Is there a way to do that in JMP or am I using the wrong tool?

Thanks.

ron_horne

hi feldybikes​,

Perhaps one option for you could be "Output grid table" under the red triangle of the prediction profiler.

alternatively, one of the LSmeans options can be useful. you will find them under the red triangle of the leverage plots.

best,

ron