xxxii
Contents
Chapter 32: Analyzing Data Using Goal Seeking and Solver. . . . . . . . . . . . . . . . . . . . . . 733
Exploring What-If Analysis, in Reverse ................................................................ 733
Using Single-Cell Goal Seeking ............................................................................ 734
Looking at a goal-seeking example ............................................................. 734
Learning more about goal seeking .............................................................. 736
Introducing Solver ............................................................................................. 737
Looking at appropriate problems for Solver .................................................. 737
Seeing a simple Solver example .................................................................. 738
Exploring Solver options ............................................................................ 743
Seeing Some Solver Examples .............................................................................. 744
Solving simultaneous linear equations ........................................................ 745
Minimizing shipping costs ......................................................................... 747
Allocating resources .................................................................................. 750
Optimizing an investment portfolio ............................................................ 751
Chapter 33: Analyzing Data with the Analysis ToolPak. . . . . . . . . . . . . . . . . . . . . . . . . . 755
The Analysis ToolPak: An Overview ..................................................................... 755
Installing the Analysis ToolPak Add-In ................................................................ 756
Using the Analysis Tools ..................................................................................... 756
Introducing the Analysis ToolPak Tools ............................................................... 757
Analysis of variance .................................................................................. 757
Correlation ................................................................................................ 758
Covariance ................................................................................................ 759
Descriptive statistics ................................................................................. 759
Exponential smoothing .............................................................................. 759
F-test (two-sample test for variance) .......................................................... 760
Fourier analysis ......................................................................................... 760
Histogram ................................................................................................. 761
Moving average ......................................................................................... 761
Random number generation ....................................................................... 763
Rank and percentile .................................................................................. 765
Regression ................................................................................................ 765
Sampling .................................................................................................. 766
T-test ....................................................................................................... 766
Z-test (two-sample test for means) .............................................................. 767
Chapter 34: Protecting Your Work. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 769
Types of Protection ............................................................................................ 769
Protecting a Worksheet ...................................................................................... 770
Unlocking cells.......................................................................................... 770
Sheet protection options ............................................................................ 772
Assigning user permissions ........................................................................ 773
Protecting a Workbook ....................................................................................... 774
Requiring a password to open a workbook ................................................... 774
Protecting a workbook’s structure .............................................................. 776
