Book description
Want to take the guesswork out of analyzing data? Let Excel do all the work for you!Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool.
This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics! Once you're up to speed, you can stop worrying about how to make use of all that data you have on your hands and get down to the business of discovering meaningful, actionable insights for your business or organization.
Excel is the most popular business intelligence tool in the world, and the newest update – Microsoft Excel 2016 – features even more powerful features for data analysis and visualization. Users can slice and dice their data and create visual presentations that turn otherwise indecipherable reports into easy-to-digest presentations that can quickly and effectively illustrate the key insights you are seeking.
- Fully updated to cover the latest updates and features of Excel 2016
- Learn useful details about statistics, analysis, and visual presentations for your data
- Features coverage of database and statistics functions, descriptive statistics, inferential statistics, and optimization modeling with Solver
- Helps anyone who needs insight into how to get things done with data that is unwieldy and difficult to understand
With Excel Data Analysis For Dummies, 3rd Edition, you'll soon be quickly and easily performing key analyses that can drive organizational decisions and create competitive advantages.
Table of contents
-
- Cover
- Introduction
- Part I: Getting Started with Data Analysis
- Part II: PivotTables and PivotCharts
-
Part III: Advanced Tools
- Chapter 8: Using the Database Functions
-
Chapter 9: Using the Statistics Functions
- Counting Items in a Data Set
- Means, Modes, and Medians
- Finding Values, Ranks, and Percentiles
- Standard Deviations and Variances
- Normal Distributions
- t-distributions
- f-distributions
- Binomial Distributions
- Chi-Square Distributions
- Regression Analysis
- Correlation
- Some Really Esoteric Probability Distributions
- Chapter 10: Descriptive Statistics
- Chapter 11: Inferential Statistics
- Chapter 12: Optimization Modeling with Solver
-
Part IV: The Part of Tens
-
Chapter 13: Ten Things You Ought to Know about Statistics
- Descriptive Statistics Are Straightforward
- Averages Aren’t So Simple Sometimes
- Standard Deviations Describe Dispersion
- An Observation Is an Observation
- A Sample Is a Subset of Values
- Inferential Statistics Are Cool but Complicated
- Probability Distribution Functions Aren’t Always Confusing
- Parameters Aren’t So Complicated
- Skewness and Kurtosis Describe a Probability Distribution’s Shape
- Confidence Intervals Seem Complicated at First, but Are Useful
- Chapter 14: Almost Ten Tips for Presenting Table Results and Analyzing Data
- Chapter 15: Ten Tips for Visually Analyzing and Presenting Data
- Appendix: Glossary of Data Analysis and Excel Terms
-
Chapter 13: Ten Things You Ought to Know about Statistics
- About the Author
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel Data Analysis For Dummies
- Author(s):
- Release date: December 2015
- Publisher(s): For Dummies
- ISBN: 9781119077206
You might also like
book
Excel Data Analysis For Dummies, 2nd Edition
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For …
book
Excel Data Analysis For Dummies, 5th Edition
Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, …
book
Excel Data Analysis For Dummies, 4th Edition
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key …
book
Statistical Analysis with Excel For Dummies, 4th Edition
Learn all of Excel's statistical tools Test your hypotheses and draw conclusions Use Excel to give …