cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Extract confidence interval values from a graph to data table - help needed please

AgnieszkaL
Level II

Hi All

 

I'm looking to extract the CI data that is computed from JMP17 and shown in the graph. When fitting y by x model and getting CI from there, it seems like the values do not match what is shown in the graph (but I appreciate I'm eyeballing the graph data hence may be mistaken here..).

Could someone provide an advice please? I don't seem to find applicable answer here. 

AgnieszkaL_0-1712309836302.png

 

AgnieszkaL_3-1712309925197.png

 

Cheers

Agnieszka

 

Note: I'm a newbie, no scripting experience. 

6 REPLIES 6
dlehman1
Level V


Re: Extract confidence interval values from a graph to data table - help needed please

I'm not sure, but I believe your graph builder interval is treating your X variable as nominal while your Fit Y by X is built using X as continuous.  If I am correct, then the slight differences are due to the continuous treatment of X as using more information than the nominal treatment (the fit line uses all of the data while the nominal treatment uses only each discrete X value to estimate the means and confidence intervals).  I'll defer to a better statistician to confirm or deny my speculation.

AgnieszkaL
Level II


Re: Extract confidence interval values from a graph to data table - help needed please

Thank you for the insight.

MRB3855
Super User


Re: Extract confidence interval values from a graph to data table - help needed please

Hi @AgnieszkaL : To extend @dlehman1  response, the graph builder is not using the same model as the Fit Y  by X model; i.e., it is treating each set of data (the X's in your Graph Builder plot) independently, with each interval based on the respective sample means and sample SD's from each X so there is no overall estimate of error (based on the total sample) like you'd find in your fit Y by X model; so, you are comparing apples and oranges.     

AgnieszkaL
Level II

Re: Extract confidence interval values from a graph to data table - help needed please

 @MRB3855 Thanks! So, I need to CI to be from the individual set of values corresponding to each level of relative potency. Is there a way to get the CI from the graph into a data table? Or alternatively, calculate the CI from these data sets?
MRB3855
Super User

Re: Extract confidence interval values from a graph to data table - help needed please

Hi @AgnieszkaL : I'm not sure how to get those intervals from the graph into the table (probably doable via JSL, but I'm no JSL expert); but, why do you not want to use the model driven intervals given by Fit Y by X Model?

AgnieszkaL
Level II

Re: Extract confidence interval values from a graph to data table - help needed please

Think I finally got it! the CI for each data set one can get from the distribution platform..

Why I do not want to use the model driven intervals given by Fit Y by X Model - is to align with historical data that were computed this way using Excel and following regulatory guidelines. 

 

Thanks a lot for getting involved