On Jun 8, 1:04 pm, "Mark Ivey" (do_not_spam)
wrote:
This website describes why Excel's CI calculations do not fit the bill to
perform a true ANOM...

http://webche.ent.ohiou.edu/che408/ANOM.ppt

Mark Ivey

"WRCLEBANON" wrote in message

...

Thanks for taking the time to respond to my request. The information
provided
was of help; however, it does not quite meet my need. What I am looking
for
is a variant of a control chart; i.e., essentually a muti-dimensional
control
chart. Analysis of Means, or ANOM, provides a way to determine the Upper
and
Lower Natural Process limits whereby more than one variable can be
evaluated
at a time as to whether its variation is more than be expected to happen
by
chance alone. This is a valuable tool that has been growing in use however
it
regretably is not currently part of the Excel data analysis package. Until
this deficency is corrected, or a workaround developed, the only recourse
is
to purchase a spreadsheet program (such as minitab).

"WRCLEBANON" wrote:

Has anyone figured out how to do an Analysis of Means using Excel?

The guy in the last reference you quote gives you the exact set of
equations to perform the analysis! Why don't you just create the same
equation set in Excel?

Duh...?

SteveM