Fit Line automatically to data table

ndowidar

Hello, 

 I would like to use the Fit Line function in JMP to automatically save the equation to my data table. The catch is that I need to do this hundreds of times, so the "Save Predicteds" option isn't very feasible. What would be the easiest way to write bivariate formula in the data table that would calculate it automatically? I am somewhat limited to the formula builder in JMP since I don't know how to write a script in JSL, unless there are clear instructions how to implement the simple Fit line code. 

 I was also made aware of the JMP Profiler feature. This would be fantastic if I could use it to optimize a variable that's is broken about 100 times. Here’s an example of the data table I put together to show how the variables are broken up.

 Briefly, I have a Response variable for a given concentration. So, fitting the X by Y would produce an equation that I could use, but since I have this equation measured about a 100 times for each Mix and Method. I want to find a way to populate those specific equations in the JMP data table so that I can calculate the Optimal Conc. for a Response equal to 1.

Fit Y by X Example.jmp

Jeff_Perkinson

I feel like we can get you where you want to be fairly easily but I'm not sure where that is.

First questions from me:

With the data table you've shared here, what Fit Y by X are you doing? I think that Response is your Y and Conc. is your X but what role are you giving to Method and Mix?

 

Second questions:

You said you want to know what Conc. will give you a prediction of 1. Do you want to know that for each combination of Method and Mix? The reason I ask is because in your sample data set you only have one Conc. and Response for each unique combination of Method and Mix. I realize that this is a mock data table but, in your real data table do you have multiple Conc. and Response values for each combination of Method and Mix?

 

Finally, I'll tell you two directions I think that may help, but the answers to the questions above will help greatly in pointing you in the best direction.

 

1) The Ctrl (Window) or Cmd (Mac) key will broadcast commands. For example if you open the Big Class data table (from Help->Sample Data Library) and run Fit Y by X with Height and Weight in Y and X, respectively, and Age in the By role. You'll get one Height by Weight platform for each Age. If you hold down the Ctrl/Cmd key as you choose Fit Line and also Save Predicteds you'll get a prediction formula that takes Age into account:

 

2) Fit Model will allow you to build a prediction equation that considers Method and Mix and give you a single prediction profiler. Again, use Big Class choose Fit Model and put Height in the Y role and add Sex, Age, and Weight as effects.

You'll get a Least Squares report.

You can use the red triangle menu at the top to add a Profiler.

The Profiler may help you optimize but, again these are only directions. Until we understand exactly what you have and what you're looking for with getting the value for Concentation that will likely result in a response of 1 we can't be give you specific instruction. We just need to know more about your situation and what you're trying to get at.