MS Excel, Second Edition, 2nd Edition

Index

Add-ins, 57

Aging of receivables, 90–93

Analysis ToolPak add-in, 14

ANOVA, 16–17

covariance, 18

Descriptive Statistics, 15–16

histogram, 19

ANOVA, 16–17

ANOVA: Single Factor, 14, 17

Audit data lying at extremes (outliers), 89

Auditors

aging of receivables, 90–93

Benford’s Law, 85

data lying at extremes (outliers), 89

illustration, 87–88

random sampling, 86

sampling, 86

scatter plots, 89–90

stratifying data in PivotTable, 87

Univariate Statistics, 85–86

AVERAGE function, 9

AVERAGEIF function, 11

AVERAGEIFS function, 10–11

Bar graph, 68–69

Basic pivot table, 36–39

Benford’s Law, 85

Bins_array argument, 13

Box and Whisker, 72

Changing cell, 57, 58

CHISQ.DIST.RT function, 9

CHISQ.TEST function, 9

CLEAN function, 75

Column Number, 25, 28

Conditional ...