nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

246138_en-US

liliconcom

Formula within a same categories of data

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

Re: Formula within a same categories of data

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

Re: Formula within a same categories of data

Hi Jim,

Thanks. That worked beautifully!

Comments

There are no comments yet