View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark Ivey[_3_] Mark Ivey[_3_] is offline
external usenet poster
 
Posts: 22
Default How do I do an Analysis of Means computation using Excel?

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?