Efnisyfirlit

• Cover
• Introduction
  • About This Book
  • What You Can Safely Skip
  • Foolish Assumptions
  • How This Book Is Organized
  • Icons Used in This Book
  • Where to Go from Here
• Part 1: Getting Started with Statistical Analysis with Excel: A Marriage Made in Heaven
  • Chapter 1: Evaluating Data in the Real World
    • The Statistical (and Related) Notions You Just Have to Know
    • Inferential Statistics: Testing Hypotheses
    • What’s New in Excel 2016?
    • What’s Old in Excel 2016?
    • Knowing the Fundamentals
    • What’s New in This Edition?
  • Chapter 2: Understanding Excel’s Statistical Capabilities
    • Getting Started
    • Setting Up for Statistics
    • Accessing Commonly Used Functions
• Part 2: Describing Data
  • Chapter 3: Show and Tell: Graphing Data
    • Why Use Graphs?
    • Some Fundamentals
    • Excel’s Graphics (Chartics?) Capabilities
    • Becoming a Columnist
    • Slicing the Pie
    • Drawing the Line
    • Adding a Spark
    • Passing the Bar
    • The Plot Thickens
    • Finding Another Use for the Scatter Chart
    • Tasting the Bubbly
    • Taking Stock
    • Scratching the Surface
    • On the Radar
    • Growing a Treemap and Bursting Some Sun
    • Building a Histogram
    • Ordering Columns: Pareto
    • Of Boxes and Whiskers
    • 3D Maps
  • Chapter 4: Finding Your Center
    • Means: The Lore of Averages
    • Medians: Caught in the Middle
    • Statistics à la Mode
  • Chapter 5: Deviating from the Average
    • Measuring Variation
    • Back to the Roots: Standard Deviation
    • Related Functions
  • Chapter 6: Meeting Standards and Standings
    • Catching Some Zs
    • Where Do You Stand?
  • Chapter 7: Summarizing It All
    • Counting Out
    • The Long and Short of It
    • Getting Esoteric
    • Tuning In the Frequency
    • Can You Give Me a Description?
    • Be Quick About It!
    • Instant Statistics
  • Chapter 8: What’s Normal?
    • Hitting the Curve
    • A Distinguished Member of the Family
    • Graphing a Standard Normal Distribution
• Part 3: Drawing Conclusions from Data
  • Chapter 9: The Confidence Game: Estimation
    • Understanding Sampling Distributions
    • An EXTREMELY Important Idea: The Central Limit Theorem
    • The Limits of Confidence
    • Fit to a t
  • Chapter 10: One-Sample Hypothesis Testing
    • Hypotheses, Tests, and Errors
    • Hypothesis Tests and Sampling Distributions
    • Catching Some Z’s Again
    • t for One
    • Visualizing a t-Distribution
    • Testing a Variance
    • Visualizing a Chi-Square Distribution
  • Chapter 11: Two-Sample Hypothesis Testing
    • Hypotheses Built for Two
    • Revisited
    • t for Two
    • A Matched Set: Hypothesis Testing for Paired Samples
    • Testing Two Variances
    • Visualizing the F-Distribution
  • Chapter 12: Testing More Than Two Samples
    • Testing More Than Two
    • Another Kind of Hypothesis, Another Kind of Test
  • Chapter 13: Slightly More Complicated Testing
    • Cracking the Combinations
    • Cracking the Combinations Again
    • Two Kinds of Variables … at Once
    • Using Excel with a Mixed Design
    • Graphing the Results
    • After the ANOVA
  • Chapter 14: Regression: Linear and Multiple
    • The Plot of Scatter
    • Graphing Lines
    • Regression: What a Line!
    • Worksheet Functions for Regression
    • Data Analysis Tool: Regression
    • Juggling Many Relationships at Once: Multiple Regression
    • Excel Tools for Multiple Regression
  • Chapter 15: Correlation: The Rise and Fall of Relationships
    • Scatterplots Again
    • Understanding Correlation
    • Correlation and Regression
    • Testing Hypotheses About Correlation
    • Worksheet Functions for Correlation
    • Data Analysis Tool: Correlation
    • Data Analysis Tool: Covariance
    • Testing Hypotheses About Correlation
  • Chapter 16: It’s About Time
    • A Series and Its Components
    • A Moving Experience
    • How To Be a Smoothie, Exponentially
    • One-Click Forecasting!
  • Chapter 17: Non-Parametric Statistics
    • Independent Samples
    • Matched Samples
    • Correlation: Spearman’s rS
    • A Heads-Up
• Part 4: Probability
  • Chapter 18: Introducing Probability
    • What Is Probability?
    • Compound Events
    • Conditional Probability
    • Large Sample Spaces
    • Worksheet Functions
    • Random Variables: Discrete and Continuous
    • Probability Distributions and Density Functions
    • The Binomial Distribution
    • Worksheet Functions
    • Hypothesis Testing with the Binomial Distribution
    • The Hypergeometric Distribution
  • Chapter 19: More on Probability
    • Discovering Beta
    • Poisson
    • Working with Gamma
    • Exponential
  • Chapter 20: A Career in Modeling
    • Modeling a Distribution
    • A Simulating Discussion
• Part 5: The Part of Tens
  • Chapter 21: Ten Statistical and Graphical Tips and Traps
    • Significant Doesn’t Always Mean Important
    • Trying to Not Reject a Null Hypothesis Has a Number of Implications
    • Regression Isn’t Always Linear
    • Extrapolating Beyond a Sample Scatterplot Is a Bad Idea
    • Examine the Variability Around a Regression Line
    • A Sample Can Be Too Large
    • Consumers: Know Your Axes
    • Graphing a Categorical Variable as Though It’s a Quantitative Variable Is Just Wrong
    • Whenever Appropriate, Include Variability in Your Graph
    • Be Careful When Relating Statistics Textbook Concepts to Excel
  • Chapter 22: Ten Things (Twelve, Actually) That Just Didn’t Fit in Any Other Chapter
    • Graphing the Standard Error of the Mean
    • Probabilities and Distributions
    • Drawing Samples
    • Testing Independence: The True Use of CHISQ.TEST
    • Logarithmica Esoterica
    • Sorting Data
  • Appendix A: When Your Worksheet Is a Database
    • Introducing Excel Databases
    • Counting and Retrieving
    • Arithmetic
    • Statistics
    • Pivot Tables
  • Appendix B: The Analysis of Covariance
    • Covariance: A Closer Look
    • Why You Analyze Covariance
    • How You Analyze Covariance
    • ANCOVA in Excel
    • And One More Thing
• About the Author
• Advertisement Page
• Connect with Dummies
• End User License Agreement

UM RAFBÆKUR Á HEIMKAUP.IS

Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!

Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.

Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).

Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.

Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.

Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.



Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu