Poetry Month!
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to our Specials newsletter for a chance to win.
Privacy Policy

More at Powell's

Recently Viewed clear list

Q&A | April 17, 2013

Augusten Burroughs: IMG Powell's Q&A: Augusten Burroughs

0 comments By Augusten Burroughs

Note: Augusten Burroughs will present his new book at Powell's City of Books on Sunday, April 28, at 2 p.m. Describe your latest book. This Is How... Continue »
  1. $10.50 Sale Trade Paper add to wish list

    This Is How: Surviving What You Think You Can't

    Augusten Burroughs 9781250032102
spacer
Ships free on qualified orders.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Microsoft Windows- Windows 95 General
2 Burnside - Bldg. 2 Microsoft Windows- Applications
25 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Statistical Analysis with Excel for Dummies (For Dummies)

by

Statistical Analysis with Excel for Dummies (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

Learn to:
  • Understand common statistical terms
  • Interpret sales figures, gambling odds, sports stats, and more
  • Use Excel formulas, functions, charts, and PivotTables
  • Develop a grading curve or medical correlations

Forget the mumbo-jumbo!

Statistical analysis with Excel can be easy — and useful, too

Stunned by statistics? Exhausted by Excel? Relax! This book makes it easy to learn statistical analysis and actually use it to interpret the statistics of everyday life. Take your Excel knowledge to a new level as you discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and much more.

  • The scoop on stats — learn about statistical concepts such as samples and populations, variables, and probability
  • New Excel stuff — check out naming conventions, new functions, and other elements that are different in Excel 2013
  • Striking sparks — discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trends
  • Means to an end — understand means, medians, and modes and the worksheet functions associated with them
  • Reasonable estimation — work with sampling distributions for estimation and understand the all-important Central Limit Theorem
  • It's probable — explore Excel's rich set of built-in capabilities for understanding and applying probability
  • Send in the data — see how to import data from databases, the web, or from text

Open the book and find:

  • A roundup of new Excel capabilities
  • Different types of hypothesis testing
  • Tools and instructions just for Mac users
  • What ANOVA means and why you must know
  • Statistical and graphical tips and traps
  • How Excel can pinch-hit as a database
  • What to do with random variables
  • Appendixes that delve into specific tools and tricks

Synopsis:

Take the mystery out of statistical terms and put Excel to work!

If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything from sports stats to medical correlations.

  • Statistics have a reputation for being challenging and math-intensive; this friendly guide makes statistical analysis with Excel easy to understand
  • Explains how to use Excel to crunch numbers and interpret the statistics of everyday life: sales figures, gambling odds, sports stats, a grading curve, and much more
  • Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations
  • Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations

Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.

back to top

About the Author

Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. An adjunct professor at the University of North Florida, he is a former member of the American Statistical Association and has taught statistics at the undergrad, honors undergrad, and graduate levels.
back to top

Table of Contents

Introduction  1

Part I: Getting Started with Statistical Analysis with Excel  7

Chapter 1: Evaluating Data in the Real World 9

Chapter 2: Understanding Excel’s Statistical Capabilities 31

Part II: Describing Data  63

Chapter 3: Show and Tell: Graphing Data 65

Chapter 4: Finding Your Center 97

Chapter 5: Deviating from the Average 113

Chapter 6: Meeting Standards and Standings 131

Chapter 7: Summarizing It All 147

Chapter 8: What’s Normal? 173

Part III: Drawing Conclusions from Data 185

Chapter 9: The Confi dence Game: Estimation 187

Chapter 10: One-Sample Hypothesis Testing 203

Chapter 11: Two-Sample Hypothesis Testing 219

Chapter 12: Testing More Than Two Samples 251

Chapter 13: Slightly More Complicated Testing 279

Chapter 14: Regression: Linear and Multiple 293

Chapter 15: Correlation: The Rise and Fall of Relationships 331

Part IV: Probability  353

Chapter 16: Introducing Probability 355

Chapter 17: More on Probability 379

Chapter 18: A Career in Modeling 393

Part V: The Part of Tens  413

Chapter 19: Ten Statistical and Graphical Tips and Traps 415

Chapter 20: Ten Things (Thirteen, Actually) That Just Didn’t Fit in Any Other Chapter 421

Appendix A: When Your Worksheet Is a Database 451

Appendix B: The Analysis of Covariance  467

Index  481

Bonus Appendix 1: When Your Data Live Elsewhere

Bonus Appendix 2: Tips for Teachers (And Learners)

back to top
back to top

Product Details

ISBN:
9781118464311
Author:
Schmuller, Joseph, Ph.d.
Publisher:
For Dummies
Author:
Schmuller, Joseph
Subject:
Spreadsheets - General
Subject:
Microsoft Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, lear
Subject:
n to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel functions, use PivotTables, learn Excel statistical tools, understanding statistics, books by Joseph Schmuller, statistics reference, using Excel for sta
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Subject:
books on statistical analysis, statistical analysis with Excel, learn statistical analysis, books on Excel, create statistics, interpret statistics, learn to analyze statistics, statistical terms, use Excel for statistical analysis, Excel formulas, Excel
Copyright:
2013
Edition Description:
WebSite Associated w/Book
Publication Date:
20130409
Binding:
TRADE PAPER
Language:
English
Pages:
528
Dimensions:
236.2 x 188 x 27.9 mm 26.56 oz
back to top

Related Subjects

Business » Real Estate
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Science and Mathematics » Mathematics » Probability and Statistics » Statistics

Statistical Analysis with Excel for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 528 pages For Dummies - English 9781118464311 Reviews:
"Synopsis" by , Take the mystery out of statistical terms and put Excel to work!

If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything from sports stats to medical correlations.

  • Statistics have a reputation for being challenging and math-intensive; this friendly guide makes statistical analysis with Excel easy to understand
  • Explains how to use Excel to crunch numbers and interpret the statistics of everyday life: sales figures, gambling odds, sports stats, a grading curve, and much more
  • Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations
  • Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations

Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.