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; } } }

average based on different colums

nac

Dear all,

I have different products. And each product have different batches. And I have different containers of each batch. I analyze 3 location of each container. How can I calculate mean value of each container obtained from different batches and products. And how can I calculate the mean of each product. Please find enclosed my JMP document. I would be very grateful if you don't let me fish, teach me how can I get the fish. I mean, ı have problems with JMP formulas, they are so different compare to excel. If you let me know what are the properties of functions, it would be great.

Thanks anyone help for it.

BR,

average example jmp.jmp

Accepted answers

txnelson

Try this formula for Average of each containers of each batch, each product

Col Mean( :Result, :Product, :Batches, :Container )

and this one for Average of products

Col Mean( :Result, :Product )

All comments

txnelson

Try this formula for Average of each containers of each batch, each product

Col Mean( :Result, :Product, :Batches, :Container )

and this one for Average of products

Col Mean( :Result, :Product )

nac

Really thanks for your help. I would like to calculate the difference average of each containers of each batch, each product - average of each product then take square of it then sum of them. But when I try to make it. Average of product is written each line. Each location part. So, jmp calculate it each location because they are not empty. Is there a simple solution for it.

Please find the enclosed jmp file what I try to do.

average example jmp (1).jmp

nac

I need to put average of each product paste into 1 time for each container. Because of automatic formulation it calculate for all of the locations. Is there a simple automatic way for it

txnelson

You appear to be treating JMP as if it is Excel. That is, from the questions you are asking, you seem to be attempting to calculate the statistics, like a t-test or Anova, etc. as you would have to do it in Excel. This is not the approach to use in JMP. JMP has built in platforms that you should be using for these calculations. The Fit Y by X and/or the Fit Model platforms are what you need to be looking at. They will perform all of the calculations and provide you with the results. Please take the time to read the Discovering JMP documentation, available under the Help pull down menu.