Community Trekker

Joined:

Mar 23, 2015

## How to make a formula (Delta / %Delta) in JMP

Hi everyone, need some help..

From JMP sample data (Raleigh Temps) shown below, I had added the last 2 columns and made a calculation in excel based on the formula for "Delta in Temp" by month  as "=C2-\$C\$2, =C3-\$C\$2, =C4-\$C\$2 and so on.."  and  for "% Delta in Temp"  as "=G2/C2" (% formatted).

Now, I would like to do the same in JMP.  Could someone show me how to make the formula or script in JMP?  Thanks in advance

 Month Year Temperature Month/Year Predicted Temperature Month Number Delta in Temp % Delta in Temp 1 1980 48.92 Jan-80 88.1859485 1 0 0% 2 1980 48.02 Feb-80 72.8224002 2 -0.9 -2% 3 1980 56.84 Mar-80 54.8639501 3 7.92 14% 4 1980 75.74 Apr-80 50.8215145 4 26.82 35% 5 1980 81.86 May-80 64.41169 5 32.94 40% 6 1980 86.54 Jun-80 83.139732 6 37.62 43% 7 1980 89.24 Jul-80 89.7871649 7 40.32 45% 8 1980 90.86 Aug-80 78.2423697 8 41.94 46% 9 1980 84.2 Sep-80 59.1195778 9 35.28 42% 10 1980 69.62 Oct-80 50.0001959 10 20.7 30% 11 1980 60.98 Nov-80 59.2685416 11 12.06 20% 12 1980 52.16 Dec-80 78.4033407 12 3.24 6% 1 1981 45.86 Jan-81 89.8121471 13 0 0% 2 1981 56.84 Feb-81 83.0057568 14 10.98 19% 3 1981 59.18 Mar-81 64.2419337 15 13.32 23% 4 1981 74.48 Apr-81 50.7720502 16 28.62 38% 5 1981 75.74 May-81 54.9802551 17 29.88 39% 6 1981 88.7 Jun-81 72.9975442 18 42.84 48% 7 1981 89.42 Jul-81 88.258905 19 43.56 49% 8 1981 83.84 Aug-81 86.7331128 20 37.98 45% 9 1981 79.34 Sep-81 69.8229738 21 33.48 42% 10 1981 69.44 Oct-81 53.0755919 22 23.58 34% 11 1981 62.24 Nov-81 51.8884328 23 16.38 26% 12 1981 48.56 Dec-81 67.352965 24 2.7 6% 1 1982 44.06 Jan-82 85.251169 25 0 0% 2 1982 55.04 Feb-82 89.1275186 26 10.98 20% 3 1982 62.96 Mar-82 75.4181158 27 18.9 30% 4 1982 69.62 Apr-82 56.7273223 28 25.56 37% 5 1982 83.84 May-82 50.2393675 29 39.78 47% 6 1982 84.02 Jun-82 61.9192471 30 39.96 48% 7 1982 88.34 Jul-82 81.0285336 31 44.28 50% 8 1982 86.36 Aug-82 89.9982372 32 42.3 49% 9 1982 80.96 Sep-82 80.5816537 33 36.9 46% 10 1982 71.06 Oct-82 61.4363466 34 27 38% 11 1982 63.5 Nov-82 50.1644229 35 19.44 31% 12 1982 57.02 Dec-82 57.1292373 36 12.96 23%
7 REPLIES

Community Trekker

Joined:

Sep 29, 2014

## Re: How to make a formula (Delta / %Delta) in JMP

I am also a beginner and need to know how to do it. As far as I know it is something related to functions"row" or "evaluate" but that's all I guess.

Probably a developer or a guru from SAS will lift you up.

Please also let me know when you've got it.

many thanks

Community Manager

Joined:

Jun 23, 2011

## Re: How to make a formula (Delta / %Delta) in JMP

You use a subscript on a column reference to index into a specific row. In your case, row 1.

So the formula for Delta in Temp looks like this:

-Jeff

-Jeff

Staff

Joined:

Mar 21, 2013

## Re: How to make a formula (Delta / %Delta) in JMP

And the percentage change may not make sense, especially as the temperature gets close to zero.  Zero Fahrenheit does not happen often in Raleigh.  But  same idea, without needing a subscript.

Craige

Community Manager

Joined:

Jun 23, 2011

## Re: How to make a formula (Delta / %Delta) in JMP

I just realized that you were resetting your Delta at the beginning of every year. In this case you'll need to index your subscript based on the month in the current row. Like this:

-Jeff

-Jeff

Community Trekker

Joined:

Mar 27, 2015

## Re: How to make a formula (Delta / %Delta) in JMP

It's not really different from Jeff's solution, but I like this:

Community Trekker

Joined:

Mar 23, 2015

## Re: How to make a formula (Delta / %Delta) in JMP

Thanks for all your helps! My question has been answered and did tried it on JMP. Thanks again.

Here's a new set of  data table below where basically do the same thing, ie, get the Delta in Data by Event Date. However, I have 3 serial numbers and 2 variables under LOC.

First, would like to convert the Event Date into Hours. Then take the Delta in Data by Hours by Serial no and Loc.

 EVENT_DATE SERIAL NO. LOC DATA 05/04/2015 9:50 PM 1 0 422 05/04/2015 9:50 PM 1 1 389 05/05/2015 11:54 AM 1 0 423 05/05/2015 11:54 AM 1 1 387 05/06/2015 2:01 AM 1 0 423 05/06/2015 2:01 AM 1 1 385 05/06/2015 4:11 PM 1 0 422 05/06/2015 4:11 PM 1 1 386 05/07/2015 6:08 AM 1 0 424 05/07/2015 6:08 AM 1 1 387 05/07/2015 7:47 PM 1 0 428 05/07/2015 7:47 PM 1 1 389 05/08/2015 9:22 AM 1 0 425 05/08/2015 9:22 AM 1 1 389 05/04/2015 9:28 PM 2 0 564 05/04/2015 9:28 PM 2 1 454 05/05/2015 10:33 AM 2 0 564 05/05/2015 10:33 AM 2 1 456 05/05/2015 11:29 PM 2 0 565 05/05/2015 11:29 PM 2 1 455 05/06/2015 12:49 PM 2 0 567 05/06/2015 12:49 PM 2 1 454 05/07/2015 2:15 AM 2 0 567 05/07/2015 2:15 AM 2 1 454 05/07/2015 3:44 PM 2 0 567 05/07/2015 3:44 PM 2 1 454 05/08/2015 5:11 AM 2 0 566 05/08/2015 5:11 AM 2 1 454 05/08/2015 6:36 PM 2 0 567 05/08/2015 6:36 PM 2 1 452 05/04/2015 9:42 PM 3 0 422 05/04/2015 9:42 PM 3 1 506 05/05/2015 11:37 AM 3 0 421 05/05/2015 11:37 AM 3 1 505 05/06/2015 1:34 AM 3 0 422 05/06/2015 1:34 AM 3 1 502 05/06/2015 3:32 PM 3 0 421 05/06/2015 3:32 PM 3 1 502 05/07/2015 5:31 AM 3 0 423 05/07/2015 5:31 AM 3 1 508 05/07/2015 7:28 PM 3 0 421 05/07/2015 7:28 PM 3 1 502 05/08/2015 9:25 AM 3 0 421 05/08/2015 9:25 AM 3 1 503

Staff

Joined:

Mar 21, 2013

## Re: How to make a formula (Delta / %Delta) in JMP

Date and Time Functions might help you get the hours you need from the date.

Craige