Table>Summary>Custom formula?

rs

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,

Dan_Obermiller

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