topic Re: Finding the mean, sigma, or median for a column certain conditions in Discussions

Finding the mean, sigma, or median for a column certain conditions

RA899 — Tue, 05 Dec 2023 21:06:02 GMT

Hi all,

I'm trying to find the mean, median and sigma for a column with certain conditions. For example, I need to get the mean for a test at certain frequency and a certain bandwidth. Something like this: Col Mean where ( :column1 < Limit & :BW == Y & :Freq == XXX );

your help is appreciated :)

Re: Finding the mean, sigma, or median for a column certain conditions

jthi — Tue, 05 Dec 2023 21:14:03 GMT

Where do you need to add these values? You can create a subset with those specific conditions and perform calculations there, you can perform the calculation using scripting or you can create formula column to calculate those values.

Re: Finding the mean, sigma, or median for a column certain conditions

RA899 — Tue, 05 Dec 2023 22:27:30 GMT

I'm using jsl code to run multiple tests and plot them using graph builder. I need to get the sigma, mean, and median values before plotting the results. I think creating a subset would make it harder to plot since I have tens of tests to plot. Is there are a different method to get those values without creating a subset ? If not, please help with reference to the syntax needed for this. Thanks!

Re: Finding the mean, sigma, or median for a column certain conditions

RA899 — Tue, 05 Dec 2023 22:36:25 GMT

So one thought I had is to use something like row exclusion functions when finding the mean as an example.

Re: Finding the mean, sigma, or median for a column certain conditions

txnelson — Tue, 05 Dec 2023 22:36:31 GMT

Here is a formula that will do what you want

Col Mean( if(:column1 < :Limit & :BW == "Y" & :Freq == 42, :column1, . ) );

Re: Finding the mean, sigma, or median for a column certain conditions

jthi — Wed, 06 Dec 2023 09:24:53 GMT

Using formula like Jim suggested is most likely the easiest option. Depending on your data, you might also consider first stacking the data and then adding the test as grouping variable.