From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Hypothesis test exercise: Proportions
From the course: Complete Guide to Excel Statistics with Copilot
Hypothesis test exercise: Proportions
- [Instructor] In this video, we'll be looking at hypothesis tests for proportions. We'll compare a sample proportion to an expected outcome. In this scenario, we'll investigate whether an upcoming election is still undecided based on a recent poll of likely voters. We will, of course, use Excel to perform our hypothesis test. But before we head over to Excel, let me show you a formula we'll utilize for this hypothesis test. Here's the formula for our Z score, which will be our test statistic. p hat is the sample proportion, p naught is the expected population proportion, and n is our sample size. As usual, don't worry, I'll show you this formula again in Excel when we need it. Okay, let's head over to Excel and conduct a hypothesis test. All right, so first let's go through our scenario. We have a candidate X. Candidate X is in an election here, and candidate X's team just got access to data from a recent voter's poll. And what they found is that in this voter's poll, 500 people were…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
