The Excel Data Analysis Add-In

The Data Analysis add-in in Excel is another very useful Excel add-in that can improve the ability to perform certain statistical tasks. It is installed using the same procedure as installing the Solver add-in (see Sect. 8.4.1 Installing the Solver Add-In). In order to start Solver, in Excel 2007 or newer, locate the Data ribbon and go to the extreme right-hand side in the area marked Ana ly s i s. Solver should be there as shown in Fig. 8.7. In Excel 2003 or older, go to Tools — Data Analysis. [Pg.374]

The Data Analysis window is shown in Fig. 8.14. Although there are many different options, the main problem with the data analysis add-in is that the results are static and that any changes made in the original data set require the given programme to be rerun. Also, the display of information is not always the best. Nevertheless, for the purposes of this book, the only useful option is the Fourier [Pg.374]

Clear CoQtents 14 [HI Eormet Cells... 1 RswHeigM... Hiie Unhide [Pg.376]

Clear Contents Format Cells... C olumn Width.., Hide Unhide [Pg.376]

Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...