453383_en-US

liliconcom

average based on different colums

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,

AnalyticsData TableOtherRe: average based on different colums

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 )

Re: average based on different colums

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.