From the course: Excel Statistics Essential Training: 1
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Discrete: Mean - Microsoft Excel Tutorial
From the course: Excel Statistics Essential Training: 1
Discrete: Mean
- [Instructor] Imagine a study that is tracking the number of drinks each individual customer orders at a popular local cafe between 10:00 a.m. and 12:00 p.m. This study is tracking discreet random variables. Each customer's order is presently unknown. Thus, each order will give us a random variable, and each customer will order a discreet number of drinks, one, two, three, six, perhaps even zero if they are just ordering food. The important thing to realize is that all orders will result in a discreet number of drinks, whole numbers, integers, no fractions or decimals. You can't order 0.35 drinks. Let's head over to Excel and look at the data collected in this study. As you can see, we've been given a Frequency Table. The Frequency Table has told us here that three customers in this two-hour period ordered zero drinks, 24 customers ordered one drink, and so on. And so what we want to find out is what's the average number…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.