Back when I was at the Goodyear Tech Center "enjoying" a dependable but
modest salary, we had partitioned cubicles. The partitions were sound
absorbing, so they were soft and perfect for banging my head against.
When they moved me back to the Research Building I had to be careful about
the plaster walls. Now that I'm an independent consultant I'll have to
negotiate a wallbanger spot with my wife.
-------------------------------------------
Emil M Friedman, PhD
2304 Richmond Road
Beachwood, OH 44122
emil.friedman@alum.mit.edu
emilfrie@alumni.princeton.edu
216-591-1750
http://www.statisticalconsulting.org
----- Original Message -----
From: <Gunter.Hartel@csl.com.au>
To: <jmp-l@lists.biostat.wustl.edu>
Sent: Thursday, September 08, 2005 9:06 PM
Subject: Re: [jmp-l] Need help creating a JMP formula
Jim,
You are most welcome. JMP can be wonderful at times and frustrating at
other times, so when I've spent hours hitting my head against the wall
trying to figure something out, it's actually quite nice to be able to share
it with someone.
Yup, I'm in Australia, Melbourne to be exact. Australia is a great place to
visit, esp Queensland Gold Coast, Great barrier reef, etc, but, as the
Aussies would say, it's a bloody long flight.
Cheers
Gunter
-----Original Message-----
From: jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu]On Behalf Of James T Metz
Sent: Thursday, 8 September 2005 12:10 PM
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: Re: [jmp-l] Need help creating a JMP formula
Gunter,
Woah! You are da man !!!
Yes, your formula is EXACTLY what I was looking for ( I made a
mistake for Bob in my manual counts using ">=" vs purely ">",
but I see my mistake now).
I could not figure out how to do this - my brain must have burped.
Thanks for the tremendously quick and helpful response. I owe you
if I ever make it to Austrailia (I think that is where you are
judging from your email)
Thanks again!
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.
<Gunter.Hartel@csl.com.au>
Sent by: jmp-l-owner@lists.biostat.wustl.edu
09/07/2005 08:55 PM
Please respond to jmp-l
To: <jmp-l@lists.biostat.wustl.edu>
cc:
Subject: Re: [jmp-l] Need help creating a JMP formula
Jim,
IS the following what you're looking for?
k = 100; Sum( :Bowling Score A >= k, :Bowling Score B >= k, :Bowling Score
C >= k)
Cheers
Gunter
-----Original Message-----
From: jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu]On Behalf Of James T Metz
Sent: Thursday, 8 September 2005 11:47 AM
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: [jmp-l] Need help creating a JMP formula
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.
|