Spreadsheet Analysis ToolPak

Finally, the Add Ins. .. of the Data Analysis Tools gives the three methods (paired, means with equal variance, and means with unequal variance) as menu-driven options (see spreadsheet 2,4), Access Data Analysis. . . from the Tools menu (if it is not there, the Analysis ToolPak needs to be installed via the Add-Ins. . . menu, also found in the Tools menu). 

Spreadsheet 2.6. (a) Excel Data Analysis ToolPak menu showing ANOVA options, (b) Single-factor ANOVA menu. 

Spreadsheet Summary In Chapter 2 oi Applications of Microsoft Excel in Analytical Chemistry, we introduce the use of Excel s Analysis ToolPak to compute the mean, standard deviation, and other quantities. In addition, the Descriptive Statistics package finds the standard error of the mean, the median, the range, the maximum and minimum values, and parameters that reflect the symmetry of the data set. 

Spreadsheet Summary In the first exercise in Chapter 3 of Applications of Microsoft Excel in Analytical Chemistry, we use Excel to perform the t test for comparing two means assuming equal variances of the two data sets. We first manually calculate the value of t and compare it with the critical value obtained from Excel s function TINV(). We obtain the probability from Excel s TDIST() function. Then, we use Excel s built-in function TTEST() for the same test. Finally, we employ Excel s Analysis ToolPak to automate the t test with equal variances. 

Spreadsheet Summary In Chapter 3 of Applications of Microsoft Excel in Analytical Chemistiy, we use Excel s Analysis ToolPak to perform the paired t text on the data of Example 7-7. We compare the results obtained with those found without pairing. 

Spreadsheet Summary In Chapter 3 of Applications of Microsoft Excel in Analytical Chemistry, the use of Excel to perform ANOVA procedures is described. There are several ways to do ANOVA with Excel. First, the equations from this section are entered manually into a worksheet, and Excel is invoked to do the calculations. Second, the Analysis ToolPak is used to carry out the entire ANOVA procedure automatically. The results of the five analysts from Example 7-9 are analyzed by both these methods. 

Spreadsheet Summary Chapter 4 of Applications of Microsoft Excel in Analytical Chemistry introduces another way to perform a least-squares analysis. The Analysis ToolPak Regression tool has the advantage of producing a complete ANOVA table for the results. A chart of the fit and the residuals can be produced directly from the Regression window. An unknown concentration is found with the calibration curve, and a statistical analysis is used to find the standard deviation of the concentration. 

Most chapters start with a brief summary of the theory in order to put the spreadsheet exercises in perspective, and to define the nomenclature used. The standard versions of Excel 95 through Excel 2000 for Windows 95 or Windows 98 are used. Many exercises use the Solver and the Analysis ToolPak, both of which are available in the standard Excel packages but may have to be loaded separately, as add-ins, in case this was not done initially. When use of chapter 10 is contemplated, the VBA help file should also be loaded. 

There has been a realization that much of the basic data manipulation may be done in a spreadsheet, and for the present moment in the 21st century this means Microsoft Excel. The Data Analysis ToolPak... 

Excel offers a number of statistical functions, listed under the Tools menu. Go to Add-Ins, and check Analysis ToolPak. Click OK and return to the spreadsheet. Now when you go to the Tools menu, you will see Data Analysis. Go to that, and you will see 19 statistical programs listed. As you experiment with these, you will find some very useful. One Add-In that is very useful is Solver, for solving complicated formulas. Its use is described in Chapter 6. See also the text website www.wiley. com/college/christian for a list of some commercial software packages for performing basic as well as more advanced statistical calculations. 

---