363 pág.

# Excel Data Analysis For Dummies. 2nd Edition

DisciplinaExcel1.285 materiais1.998 seguidores
Pré-visualização18 páginas
```with Solver
Understanding Optimization Modeling
Setting Up a Solver Worksheet
Solving an Optimization Modeling Problem
Reviewing the Solver Reports
Working with the Solver Options
Understanding the Solver Error Messages
Part IV: The Part of Tens
Chapter 13: Ten Things You Ought to Know about Statistics
Descriptive Statistics Are Straightforward
Averages Aren\u2019t 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\u2019t Always Confusing
Parameters Aren\u2019t So Complicated
Skewness and Kurtosis Describe a Probability Distribution\u2019s Shape
Confidence Intervals Seem Complicated at First, but Are Useful
Chapter 14: Almost Ten Tips for Presenting Table Results and Analyzing Data
Work Hard to Import Data
Design Information Systems to Produce Rich Data
Don\u2019t Forget about Third-Party Sources
Always Explore Descriptive Statistics
Watch for Trends
Slicing and Dicing: Cross-Tabulation
Chart It, Baby
Be Aware of Inferential Statistics
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data
Using the Right Chart Type
Using Your Chart Message as the Chart Title
Beware of Pie Charts
Consider Using Pivot Charts for Small Data Sets
Avoiding 3-D Charts
Never Use 3-D Pie Charts
Be Aware of the Phantom Data Markers
Use Logarithmic Scaling
Don\u2019t Forget to Experiment
Get Tufte
Appendix: Glossary of Data Analysis and Excel Terms
Index