topic Mean of stacked continuous data in Discussions

Mean of stacked continuous data

WhiteCow2000 — Wed, 07 May 2025 10:09:25 GMT

Hi,

I have stacked continuous data with 12 experiments in total. I have my experiments done in triplicates and have a column with replicate number.

Experiment 1, 5 and 9 are replicates

Experiment 2, 6 and 10 are replicates

Experiment 3, 7 and 11 are replicates

Experiment 4, 8 and 12 are replicates.

How to get new columns with calculated mean and standard deviation of the columns that are replicates? So the mean is calculated for each data point in the continuous data. Ultimately I want to plot the mean in a graph with the standard deviation.

I have tried using 'summary' but it does not calculate the mean for each data point of the experiment but instead the mean for the whole experiment.

Hope someone have a suggestion.

btw I use JMP 18

Re: Mean of stacked continuous data

jthi — Wed, 07 May 2025 10:51:17 GMT

You should be able to do this in Summary/Tabulate/Graph Builder if you can separate the different groups you wish to calculate the mean/stddev over. You can also do this in data table into separate column by using right click menu for new formulas, adding grouping column and then aggregation.

Re: Mean of stacked continuous data

statman — Wed, 07 May 2025 12:54:44 GMT

First point, if you actually attach the data table we can help to organize the data table and perform the tasks you want.

Second, why are you summarizing replicates? You will be throwing away DF's. If those are repeats then, yes, stack and summarize, but not for replicates. If those are randomized replicates they will provide a theoretically unbiased estimate of the MSE over the experimental space.