Excel 2010 Bible

Part V: Analyzing Data with Excel

784

On the CD
The companion CD-ROM contains a workbook that shows output from all the tools discussed in this section.
The file is named atp examples.xlsx.

Analysis of Variance

Analysis of Variance (sometimes abbreviated as Anova) is a statistical test that determines whether

two or more samples were drawn from the same population. Using tools in the Analysis ToolPak,

you can perform three types of analysis of variance:

l Single-factor: A one-way analysis of variance, with only one sample for each group of

data

l Two-factor with replication: A two-way analysis of variance, with multiple samples (or

replications) for each group of data

l Two-factor without replication: A two-way analysis of variance, with a single sample (or

replication) for each group of data

Figure 38.2 shows the dialog box for a single-factor analysis of variance. Alpha represents the sta-

tistical confidence level for the test.

FIGURE 38.2

Specifying parameters for a single-factor analysis of variance.

The output for this test consists of the means and variances for each of the samples, the value of F,

the critical value of F, and the significance of F (P-value).

Correlation

Correlation is a widely used statistic that measures the degree to which two sets of data vary

together. For example, if higher values in one data set are typically associated with higher values in

the second data set, the two data sets have a positive correlation. The degree of correlation is