Excel®2007 Data Analysis FOR DUMmIES by Stephen L. Nelson
Contents at a Glance
Introduction .................................................................1
Part I: Where’s the Beef? ..............................................7
Chapter 1: Introducing Excel Tables ................................................................................9
Chapter 2: Grabbing Data from External Sources ........................................................31
Chapter 3: Scrub-a-Dub-Dub: Cleaning Data .................................................................57
Part II: PivotTables and PivotCharts.............................79
Chapter 4: Working with PivotTables ............................................................................81
Chapter 5: Building PivotTable Formulas....................................................................107
Chapter 6: Working with PivotCharts ..........................................................................127
Chapter 7: Customizing PivotCharts............................................................................143
Part III: Advanced Tools............................................157
Chapter 8: Using the Database Functions ...................................................................159
Chapter 9: Using the Statistics Functions ...................................................................181
Chapter 10: Descriptive Statistics ................................................................................223
Chapter 11: Inferential Statistics ..................................................................................245
Chapter 12: Optimization Modeling with Solver ........................................................263
Part IV: The Part of Tens ...........................................287
Chapter 13: Almost Ten Things You Ought to Know about Statistics .....................289
Chapter 14: Almost Ten Tips for Presenting Table Results
and Analyzing Data ......................................................................................................299
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data...........................305
Part V: Appendix ......................................................319
Glossary of Data Analysis and Excel Terms................................................................321
Index .......................................................................331