cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

How can I calculate area under the curve in jmp pro?

Hello!

In a recent study, I collected blood samples at baseline (fasted) and four timepoints following consumption of one of two types of fiber (each subject received both types of fiber, but on separate days).  I analyzed the blood samples to determine the concentrations of various compounds at each time point.  I would like to calculate the area under the curve for each compound following both types of fiber, for each subject.  Is there an easy way to do this in jmp pro?  I am a novice and not experienced with using code...

Any advice would be very much appreciated- thanks!

7 REPLIES 7
dale_lehman
Level VII

Re: How can I calculate area under the curve in jmp pro?

Please provide more details.  Are you wanting to calculate the AUC for an ROC curve?  It doesn't sound like that since your dependent variable appears to be continuous.  If it is indeed continuous, then you need to explain what you mean by the "area under the curve," specifically what curve are you referring to?  If you really mean the AUC, then JMP Pro provides this automatically for a number of platforms, but your dependent variable should be a nominal (categorical) variable.  From your description, it is not clear to me what you would be analyzing as a nominal dependent variable.

Re: How can I calculate area under the curve in jmp pro?

Thanks for the valuable insight. I ended up using Prism instead of JMP and managed to get the AUC, so I diverted having to learn how to do this in JMP.  Sometimes it's easier to just use what you're used to!

Re: How can I calculate area under the curve in jmp pro?

It would help other Community members who are following this discussion to understand what you were doing. We still do not know what you mean by a 'curve' in your data or your analysis. That way we can 'close the loop' with a solution for JMP users who do not use Prism.

markschahl
Level V

Re: How can I calculate area under the curve in jmp pro?

Mark:

 

Just so happens that I am trying to do the same thing.
FDE course > Capstone Study > Polymer Development example (attached below). I have molecular weight distribution data just like that. I want to know how much of the mass has MW > 10^6. Since I don't have a function, I need the numeric integral to answer the question. Is there some existing JMP platform that can do this? Or is it time to break out my numerical methods textbook and write some formulae...?

Molecular Weight Distribution.png

Re: How can I calculate area under the curve in jmp pro?

Perhaps you won't have the 'crack open' that text book after all.

 

Screen Shot 2020-10-30 at 6.06.35 AM.png

markschahl
Level V

Re: How can I calculate area under the curve in jmp pro?

Mark:

Thanks! Integrate() takes an expression as argument, f(x). I don't have an expression, just raw (x,y) data. I don't want to fit a smooth curve to it since I am really interested in the bumps in the distributions.

Re: How can I calculate area under the curve in jmp pro?

I think that you have to resort to a summation. The Summation() function is useful for this purpose. It should work with rows in the data table or rows in a matrix. I can't think of anything else.