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).
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.