Microsoft Office Tutorials and References
In Depth Information
Table 6.9 New matched pairs analysis
analysis, our independent variables were the state (SC or TX), status of freedom
(prisoner and non-prisoner), and exposure to training (standard or special). These
categorical independent variables are also known as factors , and depending on the
level of the factor, they can affect the scores of the call center employees. Thus in
summary, the levels of the various factors for the call center problem are: (1) pris-
oner and non-prisoner status for the freedom factor, (2) standard and special for the
training factor, (3) SC and TX for state affiliation factor.
Excel permits a number of ANOVA analyses— single factor , two-factor without
replication , and two-factor with replication . Single factor ANOVA is similar to
the t-Tests we previously performed, and it provides an extension of the t-Tests
analysis to more that two samples means; thus, the ANOVA tests of hypothesis
permit the testing of equality of three or more sample means. It is also found in the
Data Analysis tool in the Data Ribbon. This reduces the annoyance of constructing
many pair-wise t-Tests to fully examine all sample relationships. The two-factor
ANOVA, with and without replication, extends ANOVA beyond the capability of
t-Tests. Now, let us begin with a very simple example of the use of single factor
6.6.1 ANOVA: Single Factor Example
A shipping firm is interested in the theft and loss of refrigerated shipping containers,
commonly called reefers , that they experience at three similar sized terminal facili-
ties at three international ports—Port of New York/New Jersey, Port of Amsterdam,
and Port of Singapore. Containers, especially refrigerated, are serious investments of
capital, not only due to their expense, but also due to the limited production capacity
Search JabSto ::

Custom Search