Skip to Content
Statistical Analysis with Excel® For Dummies®, 2nd Edition
book

Statistical Analysis with Excel® For Dummies®, 2nd Edition

by Joseph Schmuller
June 2009
Beginner
500 pages
9h 40m
English
For Dummies
Content preview from Statistical Analysis with Excel® For Dummies®, 2nd Edition

Chapter 16. Introducing Probability

In This Chapter

  • Defining probability

  • Working with probability

  • Dealing with random variables and their distributions

  • Focusing on the binomial distribution

Throughout this book, I toss around the concept of probability, because it's the basis of hypothesis testing and inferential statistics. Most of the time, I represent probability as the proportion of area under part of a distribution. For example, the probability of a Type I error (a/k/a α) is the area in a tail of the standard normal distribution or the t distribution.

In this chapter, I explore probability in greater detail, including random variables, permutations, and combinations. I examine probability's fundamentals and applications, zero in on a couple of specific probability distributions, and I discuss probability-related Excel worksheet functions.

What is Probability?

Most of us have an intuitive idea about what probability is all about. Toss a fair coin, and you have a 50-50 chance it comes up "Head." Toss a fair die (one of a pair of dice) and you have a one-in-six chance it comes up "2."

If you wanted to be more formal in your definition, you'd most likely say something about all the possible things that could happen, and the proportion of those things you care about. Two things can happen when you toss a coin, and if you only care about one of them (Head), the probability of that event happening is one out of two. Six things can happen when you toss a die, and if you only care about one ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Statistics For Dummies®, 2nd Edition

Statistics For Dummies®, 2nd Edition

Deborah J. Rumsey
Statistics, 3E

Statistics, 3E

Robert A. Donnelly, Fatma Abdel-Raouf

Publisher Resources

ISBN: 9780470454060