Excel 2010 Bible

Chapter 37: Analyzing Data Using Goal Seeking and Solver 779 l (^) Car loans should make up at least 15 percent of the portfolio ...

...

781 CHAPTER Analyzing Data with the Analysis ToolPak IN THIS CHAPTER The Analysis ToolPak: An overview Using the Analysis ToolPa ...

Part V: Analyzing Data with Excel 782 l (^) Covariance l Descriptive statistics l (^) Exponential smoothing l F-Test l (^) Fouri ...

Chapter 38: Analyzing Data with the Analysis ToolPak 783 Using the Analysis Tools Using the procedures in the Analysis ToolPak a ...

Part V: Analyzing Data with Excel 784 On the CD The companion CD-ROM contains a workbook that shows output from all the tools di ...

Chapter 38: Analyzing Data with the Analysis ToolPak 785 expressed as a coefficient that ranges from –1.0 (a perfect negative co ...

Part V: Analyzing Data with Excel 786 FIGURE 38.4 Descriptive Statistics output. Because the output for this procedure consists ...

Chapter 38: Analyzing Data with the Analysis ToolPak 787 FIGURE 38.5 Output from the F-Test tool. Fourier Analysis The Fourier A ...

Part V: Analyzing Data with Excel 788 FIGURE 38.6 Use the Histogram tool to generate distributions and graphical output. Moving ...

Chapter 38: Analyzing Data with the Analysis ToolPak 789 FIGURE 38.7 A chart produced by the Moving Average tool. The first few ...

Part V: Analyzing Data with Excel 790 Number of Variables refers to the number of columns that you want, and Number of Random Nu ...

Chapter 38: Analyzing Data with the Analysis ToolPak 791 Regression analysis enables you to determine the extent to which one ra ...

Part V: Analyzing Data with Excel 792 This procedure has two options: periodic and random. If you choose a periodic sample, Exce ...

I f you’ve ever wanted to do a bit more or automate rou- tine operations so that you don’t always have to per- form boring, repe ...

47_474877-pp06.indd 79447_474877-pp06.indd 794 3/29/10 11:48 PM3/29/10 11:48 PM ...

795 CHAPTER Introducing Visual Basic for Applications IN THIS CHAPTER Introducing VBA macros Creating VBA macros Recording VBA m ...

Part VI: Programming Excel with VBA 796 Displaying the Developer Tab If you plan to work with VBA macros, you’ll want to make su ...

Chapter 39: Introducing Visual Basic for Applications 797 FIGURE 39.1 The Developer tab. About Macro Security Macros have the po ...

Part VI: Programming Excel with VBA 798 Note If the Visual Basic (VB) Editor window is open when you open a workbook that contai ...