Excel Data Analysis For Dummies. 2nd Edition
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
	Just Add It
	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
	About the Authors