Is there any way I can check each cell value in a column against the column's test limits and decide if the test has passed or failed? For example if a column has 10 rows of data and if 5 out of the 10 rows fail the test limits for that column, I would like to see a message in a box that says column 'X' failed.
I would create a new column and use the Formula Editor>Conditional argument and specify there. For instance if your response was "Yield" and Pass > 80% then in that new column I would use the formula editor and conditional argument to say If Yield > 80% then "Pass" otherwise "Fail". JMP will then assess the value in the column you specified and add the appropriate class to the new column that maps back to response.
I just used the term "Yield" as a surrogate for your response of your column of interest. I assume if you want to categorize your values as "pass" or "fail" that you had a specification you were attempting to meet. You could look at your data in a histogram. You could also use a control chart to see your upper and lower control limits and alarms for your dataset. You also have Tables>Summary and Tables>Tabulate that can be used.
Yes you can. Double click in the column header and click on the column properties pull down menu and choose the column properties>formula. The click the edit formula button.Under the functions choose conditional and you can chose the "if" statement. In the expression box choose the column that you want to characterize by clicking on the left hand side of the dialog box. Once the column is identified then on your keyboard type >= and then in the new box that pops up place the value. Then click in the then clause box and type "Pass" with quotes. The final step is to click in the else box and type "Fail" in quotes.