Formula for trimmed meanI have a data set that has a sample number in the first column, and then 180 columns of various measurements of the sample. I want to get the 5% trimmed mean for each of 100 samples in the table.
Because of the large number of samples, going through Distributions > Summary Statistics is very impractical. Is there a way I can pull this directly using a formula?
Alternatively, I could stack my columns and use the Summary function if possible, but I can't see how to get a trimmed mean here either.
AnalyticsData TableScriptingRe: Formula for trimmed meanHi @HarriBradbeer ,
I'm sure this should be easy to do with either a column formula or a JSL script.
However, to help a little more, what do you mean by a 5% trimmed mean? Does this mean you cut out the bottom 5% and top 5% of the data?
Thanks,
DS
Re: Formula for trimmed meanI think using Distribution is fairly easy option. Create Distribution with measurement data as Y, Columns and sample number as By column (using Probe data), if you have lots of data this will be slow and might in worse case crash JMP, so scripting this might be a better option (you could script this same process, use matrix calculations or some other method).
After you have your Distributions, hold down ctrl + alt and click red triangle next to one of the distributions and disable everything else besides Summary Statistics (should make this a bit faster) and press OK:
After that. hold down ctrl + alt and press red triangle next to one of Summary Statistics.
Enable Customize Summary Statistics and press OK
Remove everything else besides Trimmed Mean:
and press OK.
Now we have this beautiful distribution report:
Right click on one of Trimmer means and choose Make combined data table:
You should end up with datatable with 5% Trimmed Means for all parameters and groups:
Re: Formula for trimmed meanYes, the mean is taken from the middle 90% of data
