Good morning,

I have this DOE data to analyse. Experiment in triplicate.

1st question: In excel sheet, I can easily calculate the standard deviation of each condition in triplicate (see below first screenshot). But in JMP, it will not allow me to arrange the data array and calculate like in excel, JMP put all Y (response) in one column including triplicate Y values (see below second screenshot). I don't know how to calculate the standard deviation of the triplicates of each condition in JMP in a nice and easy way.

2nd question: After calculated the std of each condition, how to put in JMP data sheet as data and do further calculation? The purpose of me doing this is to use the std dev data to further calculate to see which condition contributes to the std deviation the most. In other software, especially excel based software, it can be easily done. But how to do this in JMP?

3rd question: I kind of find a clumsy method to do std dev in JMP, use data "distribution" function did the standard deviation calculation (see below 3rd screenshot). But the std dev data is scattered in each section of conditions, how to extract those data to the DOE data sheet and do further calculation seems still a difficult thing. Does anybody know how to do this in a nice and easy way?

Thank you