From the course: Excel Statistics Essential Training: 2
Unlock the full course today
Join today to access over 24,200 courses taught by industry experts.
Comparing two populations (proportions) - Microsoft Excel Tutorial
From the course: Excel Statistics Essential Training: 2
Comparing two populations (proportions)
- [Instructor] All right, so in this video, what I'm going to do is I'm going to do a hypothesis test when we have two populations, two independent populations, and in this case our populations are characterized by two proportions. All right, so let's begin with the scenario. A new drug is being tested to see if it can reduce the chance of heart attacks. So what they do is they create two groups. In one group, they put people and they give them the new drug. In the other group, they give them a placebo. Now the first group, the new group, the new drug group, rather, they have 2,219 participants and of those 2,219 participants, 26 of them, when tracked over time, 26 of them had a heart attack. The placebo group, they had 2,035 participants. You might say, "Well, why are the sample sizes different?" Well, because in these long studies, sometimes people drop out of the studies, people don't report. But let's say in this…
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.