Formula within a same categories of data

Ashraff

Hi, 

 

Im new to JSL and JMP, and i have a problem to write a formula to process a raw data that i have: 

For example for the Big Class Sample data, I would like to create a formula of "Weight uniformity within a the same age and sex ". 

 

The formula would be 

Weight Uniformity = [Weight - (average weight for same age and sex)] / Weight 

hope that some expert members could help me on this. 

 

thanks 

Regards

Ashraff 

txnelson

Here is the formula

(:weight - Col Mean( :weight, :age, :sex )) / :weight

Documentation for the Col Mean() function can be found in the Scripting Index

     Help=>Scripting Index