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

If I read your question correctly, see
http://peltiertech.com/Excel/Charts/RunChtLines.html

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"WRCLEBANON" <(E-Mail Removed)> wrote in message
news:113E40E1-BEC7-4234-A860-(E-Mail Removed)...
> Has anyone figured out how to do an Analysis of Means using Excel?

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?

I don't know of any free solution out there, but check out this link
below...

http://www.excel-spc-software.com/qi...ans-chart.html


Mark Ivey



"WRCLEBANON" <(E-Mail Removed)> wrote in message
news:5A103314-D786-480C-A59F-(E-Mail Removed)...
> 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?

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" <(E-Mail Removed)> wrote in message
news:5A103314-D786-480C-A59F-(E-Mail Removed)...
> 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?

On Jun 8, 1:04 pm, "Mark Ivey" <wmivey6...@hotmail.com_(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" <WRCLEBA...@discussions.microsoft.com> wrote in message
>
> news:5A103314-D786-480C-A59F-(E-Mail Removed)...
>
> > 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