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

 Name Week Stipend A 1 10 A 1 11 A 1 12 A 2 50 A 2 51 A 2 52 B 3 101 B 3 102 B 3 103 B 4 501 B 4 502 B 4 503 C 1 1 C 1 2 C 1 3

Will be summarized as

 Name Week Summary A 1 0.960253 A 2 0.585627 B 3 0.497859 B 4 0.370274 C 1 3.321928

Any ideas on how to do this in JMP?

Thank you,

Highlighted
Staff

## 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.