The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar
Highlighted
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
Highlighted

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
Article Labels

    There are no labels assigned to this post.