Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Iterate through multiple measurements, analyze the data and create a column with...

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Iterate through multiple measurements, analyze the data and create a column with the results

Jun 14, 2018 1:57 PM
(306 views)

Hello everyone,

JMP newby here. I have a data table that has multiple measurements that are separated by "[EOF]" term in pulseVoltage column. I want to procedurally iterate through all the measurements and analyze the data with some formulas (find DUT current value at which the slope of the DUT voltage vs DUT current curve changes by x%) and want to store the corresponding value for each measurement in a new column called Icrit. How would I go about it? Is it even possible with JMP?

Thank you!

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Iterate through multiple measurements, analyze the data and create a column with the results

I am confused over what you are actually looking for. When I look at the data, each of the separate groupings that were separated by [EOF]. I don't see any slopes in the data. each of the different grouping do not change on one of the dimentions.

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Iterate through multiple measurements, analyze the data and create a column with the results

I'm sorry if I wasn't clear enough. By change in slope I mean the value of the expression DUT voltage/DUT current.

Basically I will calculate the value of DUT voltage/DUT current at each row and when it changes by a certain percentage, the corresponding DUT current value would go to Icrit column. Other rows in the Icrit column would be blank.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Iterate through multiple measurements, analyze the data and create a column with the results

What is your algorthm for the calculation of % increase? Is it based upon the % increase of one of the axes, or is it the slope from one data point to the next? Can you provide more spcifics on this?

Jim