Howdy Everyone,
I am in the process of creating a JMP appendix for one of our processes and have found it necessary to explain how to manually set up a column formula to perform a Grubb's Test. I have done this in Excel, but i want to replicate that in JMP and have had a hard time setting up the formula correctly. We have 4 columns of independent data (1a,2a,3a,4a) that each need a Grubb's Test performed on them. Each has a max of 40 values. I woudl like to create four more columns (1b,2b,3b,4b) that each scan the appropriate column (1-1, 2-2 and so forth). I was thinking of setting up an IF formula so that i can do a column min and a column max calculation and depending on the Texp value for each, it would spit out Outlier as a result. In my excel spreadsheet i it set up this way:
have the Max and min calculated
Texp calculated: (Max/Min - column avg)/ Column Std Dev = Texp
Then the cell below it compares that Texp to the Tcrit for an N=40 (2.866), and if Texp > Tcrit it says "Yes"
In my head i can see how to do this in JMP, but i am unsure how to set it up correctly with parenthesis and so forth. If i have not eplained it very well I apologize. Sometimes the brain has a hard time describing what appear easy.
Thanks,
