s ANALYZE DATA in Font

Generation ECC200 in Font s ANALYZE DATA

Excel includes a set of statistical data analysis tools that you can use to create a wide variety of statistical and engineering data analysis reports based on your selected data values. Some of these statistical data analysis tools include the following: The Descriptive Statistics tool provides a report displaying statistics such as the mean, median, mode, standard deviation, minimum, maximum, sum, count, and the largest and smallest data values. The Histogram tool provides a report displaying the frequency of specific data values. The Rank and Percentile tool provides a report displaying the ordinal and percentage ranking of specific data values.

To perform statistical data analysis, do one of the following and complete the steps in the Data Analysis dialog box: In Excel 2007, click Data (Analysis) Data Analysis. In Excel 2003, click Tools Data Analysis.

Since the Data Analysis tools may not always be available when Excel is installed, you should confirm that they are available before you try to use them. If the Data Analysis command doesn t appear in the Data (Analysis) group (in Excel 2007) or on the Tools menu (in Excel 2003), do one of the following: In Excel 2007, click Office Button Excel Options. In the left pane, click Add-Ins. With the Manage list toward the bottom of the screen showing Excel Add-Ins, click Go. Select the Analysis ToolPak check box, click OK, and then click Data (Analysis) Data Analysis. In Excel 2003, click Tools Add-Ins, select the Analysis ToolPak check box, click OK, and then click Tools Data Analysis. If, however, the Analysis ToolPak check box is not visible in the Add-Ins dialog box s AddIns available list, you must install the Analysis ToolPak by running the Microsoft Office Setup program again and selecting Analysis ToolPak from the list of available Excel add-ins. Then you can start Excel and click Data (Analysis) Data Analysis (in Excel 2007) or Tools Data Analysis (in Excel 2003).

To perform statistical data analysis, do the following:

1. In Excel 2007, click Data (Analysis) Data Analysis. In Excel 2003, click Tools Data Analysis 2. In the Data Analysis dialog box, select an available analysis tool, and then click OK. 3. Follow the onscreen directions to run the selected analysis tool.

In this exercise, you will practice running the Descriptive Statistics tool on a set of data: 1. Start Excel. 2. Click Office Button Open (in Excel 2007) or click File Open (in Excel 2003), browse to and select the ExcelDB_Ch06_15.xls file, and click Open. 3. In Excel 2007, click Data (Analysis) Data Analysis. In Excel 2003, click Tools Data Analysis. 4. In the Data Analysis dialog box, select Descriptive Statistics, and then click OK. 5. Click the Input Range dialog box, and then type or select the cell reference for cells B2 through B41. 6. For the Grouped By options, click the Columns option. 7. Leave the Labels in First Row check box cleared. 8. In the Output options area, select the New Worksheet Ply option and the Summary Statistics check box. Leave the other check boxes in this area cleared. 9. Click OK. A new worksheet is created with the summary statistics displayed, including statistics such as the mean, median, mode, standard deviation, minimum, maximum, sum, and count of the selected data values.

he more you use Excel, the greater the chance that you will be performing the same sets of actions over and over again. For instance, you may frequently change the visual format of a selected set of worksheet cells to a similar font style, row height, and border style. Or perhaps you frequently sort data records that relate to sales transactions by transaction date. In this chapter, you will learn how to use Excel s macro recorder and the Excel programmatic object model with Visual Basic for Applications to automate these types of actions. By recording your Excel interactions and then customizing these recordings to automate Excel to get the desired results, you can save time and reduce errors when you want to do similar actions in the future.