cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Julianveda
Level III

Export confidence intervals of th profiler

Hi Community,

 

I was wondering if it is posible to export the information from the profiler, mainly the confidence intervales (gray region in image below). It seems to me there is a way to do it but with the Pro version. Do you know if there is a way to do it with the JMP basic version? 

 

Julianveda_0-1688654497685.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Victor_G
Super User

Re: Export confidence intervals of th profiler

Hi @Julianveda,

 

Depending on the platform you're using to build the model, it can be easily accessible.
Assuming the profiler comes from the "Fit Model" platform, you can very easily (in the red triangle next to your response name) go to "Save Columns" and then "Mean Confidence Limits Formula" (and "Prediction Formula"):

Victor_G_1-1688659296861.png

 

If you want to re-create the Profiler with the formulas, you need to have the "Prediction Formula" and the "StdErr Pred Formula" saved in your datatable. Then, going into "Graph", "Profiler", you can use these columns to recreate your profiler (click on Yes when a window pops up asking you to use PredSE to create intervals for your response) :

Victor_G_2-1688659486743.png

Victor_G_3-1688659581172.png

 

I hope this answer will help you,

 

 

Victor GUILLER
Scientific Expertise Engineer
L'Oréal - Data & Analytics

View solution in original post

2 REPLIES 2
Victor_G
Super User

Re: Export confidence intervals of th profiler

Hi @Julianveda,

 

Depending on the platform you're using to build the model, it can be easily accessible.
Assuming the profiler comes from the "Fit Model" platform, you can very easily (in the red triangle next to your response name) go to "Save Columns" and then "Mean Confidence Limits Formula" (and "Prediction Formula"):

Victor_G_1-1688659296861.png

 

If you want to re-create the Profiler with the formulas, you need to have the "Prediction Formula" and the "StdErr Pred Formula" saved in your datatable. Then, going into "Graph", "Profiler", you can use these columns to recreate your profiler (click on Yes when a window pops up asking you to use PredSE to create intervals for your response) :

Victor_G_2-1688659486743.png

Victor_G_3-1688659581172.png

 

I hope this answer will help you,

 

 

Victor GUILLER
Scientific Expertise Engineer
L'Oréal - Data & Analytics
Julianveda
Level III

Re: Export confidence intervals of th profiler

Hi @Victor_G 

 

Thank you very much . This is not exactly the answer to my question, but I accepted it as a solution because your explantations helped me a lot anyway.

 

Just in case you want some clarification about my initial objective: In a certain way, what I wanted was to reproduce exactly the profiler in Excel for other people not having JMP. With the predicted formula you can easily create the fitting curve, but I also wanted to include the gray regions that we see in the profiler.

 

With your explanation I could present things a little bit different, but it also does the job: I plotted actual vs predicted and use the columns with the formula for confidence intervals. (this is slightly different from my objective which is use the original graph and put the fitting curve and confidence interval as the profiler does).

 

Thank you again, because your solution provides the majority of elements to answer my question.