|
Free ebooks
 More computer ebooks Office Wiley - Excel 2007 Data Analysis For Dummies
|
||||||
 In Part I, I discuss how you get data into Excel workbooks so that you can begin to analyze it. This is important stuff, but fortunately most of it is pretty straightforward. If you’re new to data analysis and not all that fluent yet in working with Excel, you definitely want to begin in Part I.In the second part of this book, I cover what are perhaps the most powerful data analysis tools that Excel provides: its cross-tabulation capabilities using the PivotTable and PivotChart commands. No kidding, I don’t think any Excel data analysis skill is more useful than knowing how to create pivot tables and pivot charts. In Part III, I discuss some of the more sophisticated tools that Excel supplies for doing data analysis. Some of these tools are always available in Excel, such as the statistical functions. Some of the tools come in the form of Excel add-ins, such as the Data Analysis and the Solver add-ins. I don’t think that these tools are going to be of interest to most readers of this book. But if you already know how to do all the basic stuff and you have some good statistical and quantitative methods, training, or experience, you ought to peruse these chapters. Some really useful whistles and bells are available to advanced users of Excel. And it would be a shame if you didn’t at least know what they are and the basic steps that you need to take to use them. In my mind, perhaps the most clever element that Dan Gookin, the author of the original and first Dummies book, DOS For Dummies, came up with is the part with chapters that just list information in David Letterman-ish fashion. These chapters let us authors list useful tidbits, tips, and factoids for you. Excel 2007 Data Analysis For Dummies includes three such chapters. In the first, I provide some basic facts most everybody should know about statistics and statistical analysis. In the second, I suggest ten tips for successfully and effectively analyzing data in Excel. Finally, in the third chapter, I try to make some useful suggestions about how you can visually analyze information and visually present data analysis results. The Part of Tens chapters aren’t technical. They aren’t complicated. They’re very basic. You should be able to skim the information provided in these chapters and come away with at least a few nuggets of useful information. The appendix contains a handy glossary of terms you should understand when working with data in general and Excel specifically. From kurtosis to histograms, these sometimes baffling terms are defined here. Download free pdf ebooks for office:Excel 2007 Data Analysis For Dummies
|
| More free ebooks | |