Analyzing Business Data with Excel

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [V] [W] [X] [Z]

categorical items

     analysis of

     changing data

     changing to scalar items

     populating pivot tables

cells

     addressing indirectly

     change events and

     named 2nd

     Solver tool changes

change event

Chart tool

charts

     application design

     bar

     display techniques 2nd

     functionality

     moving averages in

     queuing example

     X and S charts

Choose Columns dialog box

classification problem

client/server structure

color 2nd

columns

     #agg

     linking tables

     monitoring complex systems 2nd 3rd

     pivot tables and 2nd

     queuing example

     regression model errors

     XML data and

combo box controls 2nd 3rd 4th 5th

comma (,)

conditional formatting

CONFIDENCE function 2nd

confidence interval

confidence level

constraints, Solver tool

contrast

control limits

     measuring quality 2nd 3rd

     monitoring complex systems 2nd 3rd 4th 5th

     standard deviations and

controls

     display techniques and 2nd

     measuring quality

     queuing example

converting Julian dates

CORREL function

     finding lag

     functionality 2nd

     modeling

     optimizing example

COUNT function

COUNTIF function

     DAVERAGE function and

     equivalence example

     modeling 2nd

     queuing example 2nd

     truth values and