|
JMP Users, Can someone please help me create the following formulas? I have a JMP data table for which I need to create 4 separate formulas to generate counts across a row, for each row, using selected columns according to particular numeric selection criteria (IF statements, I would assume?). Somehow I need to create a summation according to the specific column names and use IF statements with an incrementing counter, but I can not figure out how to do this using the Formula editor in JMP. I have attached a small, sample JMP file and a comma-separated text file (for those of you who can not receive the JMP file) below to illustrate what I need to be able to do. The JMP file is, of course, made-up data. Essentially, I need to create formulas for the last 4 columns i.e., Number of Bowling Scores > 100, Number of Bowling Scores > 150, etc. I have manually entered the counts so that you will understand the numbers that should appear using the formulas. I would be most grateful for any and all suggestions! Regards, Jim Metz James T. Metz, Ph.D. Research Investigator Chemist GPRD R46Y AP10-2 Abbott Laboratories 100 Abbott Park Road Abbott Park, IL 60064-6100 U.S.A. Office (847) 936 - 0441 FAX (847) 935 - 0548 james.metz@abbott.com This communication may contain information that is legally privileged, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, use, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or return email and delete it from his or her computer.
|
