topic Re: Retrieving formula for "Mean Confidence Interval" from Fit Model in Discussions

Retrieving formula for "Mean Confidence Interval" from Fit Model

Light — Wed, 14 Dec 2016 19:09:35 GMT

Hello,

After doing a fit model, I can easily save a new column for the prediction formula by going:

Red Triangle -> Save Columns -> Prediction Formula

I would also like to save the formula for the Mean Confidence Interval, but it seems like that is not available.

I can generate static columns for the Mean Confidence Interval by going:

Red Triangle -> Save Columns -> Mean Confidence Interval

Is there a way to get the formula used to generate these values, or any kind of workaround known that will eventually allow me to find this formula?

Thank you,

-Tom

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Mark_Bailey — Wed, 14 Dec 2016 20:15:27 GMT

In the same Save Columns menu, do you see the StdErr Pred Formula and the Mean Confidene Limit Formula commands? These commands should help.

What version of JMP are you using?

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Light — Wed, 14 Dec 2016 20:27:49 GMT

Hi Mark,

I have StdErr Prediction Formula, but not Mean Confidence Limit Formula.

I'm using JMP non-Pro 12.1.0. I could get 13 installed if necessary, although it's not officially "approved software" where I work yet. Would this be in 13?

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Mark_Bailey — Thu, 15 Dec 2016 04:05:16 GMT

I cannot check JMP 12 at the moment. I also cannot keep track of the features in every version of JMP! But I see it in JMP 13. Maybe another JMP staffer will pipe up to confirm if JMP 13 is necessary!

In the mean time, though, it is easy to calculate yourself. Follow these steps:

Fit your model.
Save the Prediction Formula.
Save the StdErr Prediction Formula.
Examine the Analysis of Variance table and note the Error DF.
Add a new column to the data table for the lower limit.
Add a formula to this column.
1. Select the column with the Prediction Formula and click the Subtract button.
2. Select Probability > t Quantile.
3. Enter 0.975 for the p argument.
4. Enter the error DF you noted for the DF argument.
5. Select the t Quantle function in your formula and click the Multiply button.
6. Select the StdErr Prediction Formula column.
7. Click OK.

Now, do the same for the upper bound, just add instead of subtract. (I assumed that you wanted two-sided limits.)

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Light — Thu, 15 Dec 2016 14:50:15 GMT

This is perfect, thanks!

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

mpb — Thu, 15 Dec 2016 15:14:17 GMT

Using JMP Pro 12.1.0 on a Win 7 pc I do see the option to save the mean confidence interval formula. I hope this doesn't mean that the Pro version is required to get the mean confidence interval formula!

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Light — Thu, 15 Dec 2016 15:17:10 GMT

Also: I just discovered that "Mean Confidence Limit Formula" does show up in JMP 12 as long as the model does not contain Random effects.

Re: Retrieving formula for "Mean Confidence Interval" from Fit Model

Tina — Tue, 03 Apr 2018 11:55:19 GMT

Hi, I just read this comment and was wondering how the confidence intervals would be calculated in case of a mixed model (with one random effect)?