cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
rs
rs
Level II

Table>Summary>Custom formula?

My apologies if this question is too trivial.  I have a table as shown below. In JMP, under 'Tables'>'Summary' I can apply any summary statistic that I would like; however, I would like to apply a custom formula

(1/LOG( SUM(group)/COUNT(group) )) stratified by Name and Group

 

 

The table

NameWeekStipend
A110
A111
A112
A250
A251
A252
B3101
B3102
B3103
B4501
B4502
B4503
C11
C12
C13

 

Will be summarized as

NameWeekSummary
A10.960253
A20.585627
B30.497859
B40.370274
C13.321928

 

Any ideas on how to do this in JMP?

 

Thank you,

1 REPLY 1

Re: Table>Summary>Custom formula?

Go to Tables > Summary.

Specify Name and Week as the Group variables.

Click on Stipend and choose Statistics > Sum.

Click OK.

In the resulting table, add a column and indicate that it will be based on a formula.

Build your formula. Remember that the Sum(Stipend) column is your sum and the N Rows column will be the equivalent to your "COUNT" function as follows.

1 / Log10( :Name( "Sum(Stipend)" ) / :N Rows )

 

I should add that you can accomplish this without using Tables > Summary if you don't mind the repeated values from your formula evaluation. Your formula column could look like this:

1 / Log10( Col Sum( :Stipend, :Name, :Week ) / Col Number( :Stipend, :Name, :Week ) )

 

Dan Obermiller