Data Analysis with Microsoft Excel: Updated for Office 2007

28 Excel Loading the Data Analysis ToolPak Now that you’ve seen how to load the StatPlus add-in, you can load the Data Analysis ...

Chapter 1 Getting Started with Excel 29 When activated, the Data Analysis ToolPak appears in a new group named Analysis on the D ...

30 Excel Unloading an Add-In If at any time, you want to unload the Data Analysis ToolPak or StatPlus, you can do so by returnin ...

Chapter 1 Getting Started with Excel 31 If you want to unload all of the modules, click the Remove All checkbox. If you want to ...

32 Excel Linked Formulas Many of the StatPlus commands use custom formulas to calculate statistical and mathematical values. One ...

Chapter 1 Getting Started with Excel 33 The Input sheet allows you to specify the default method used for ref- erencing the data ...

34 Excel Exiting Excel When you are fi nished with an Excel session, you should exit the program so that all the program-related ...

35 Chapter 2 WORKING WITH DATA Objectives In this chapter you will learn to: Enter data into Excel from the keyboard Work with E ...

36 Excel I n this chapter you’ll learn how to enter data in Excel through the keyboard and by importing data from text fi les an ...

Chapter 2 Working with Data 37 Entering Data with Autofi ll If you’re inserting a column or row of values that follow some seque ...

38 Excel or dates. You can use Autofi ll to generate automatically columns containing data values such as: 1, 2, 3, 4,... 9, 10; ...

Chapter 2 Working with Data 39 EXCEL TIPS If you want to create a geometric sequence of numbers, drag the fi ll handle with your ...

40 Excel Inserting New Data Sometimes you will want to add new data to your data set. For example, you discover that there is a ...

Chapter 2 Working with Data 41 3 Verify that the Shift cells down option button is selected. 4 Click OK. Excel shifts the values ...

42 Excel The Bold and Center buttons on the Home tab give you one-click access to two of Excel’s popular formatting commands. Ot ...

Chapter 2 Working with Data 43 Comma Style Add comma separators to values (i.e., 43215 = 43,215). Increase Decimal Increase the ...

44 Excel 5 Click OK to close the Format Cells dialog box. 6 Click cell D1 to unselect the cells. Figure 2-7 displays the fi nal ...

Chapter 2 Working with Data 45 text in a red-colored font Figure 2-7 Formatted column titles Before going further, this would be ...

46 Excel Table 2-4 Mathematical Operators Operator Description 1 Addition 2 Subtraction / Division * Multiplication ^ Exponentia ...

Chapter 2 Working with Data 47 This example illustrates a simple formula involving the addition of two numbers. What if you want ...