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.

Five steps of hypothesis testing

Five steps of hypothesis testing - Microsoft Excel Tutorial

From the course: Excel Statistics Essential Training: 2

Start my 1-month free trial Buy for my team

Five steps of hypothesis testing

“

- [Instructor] Statistics help us draw sound conclusions, conclusions that are based on evidence. To do this properly though, we need to have a fair trial. In statistics, this trial is called a hypothesis test. And to properly perform a hypothesis test, we need to follow five steps. Let's discover the five steps by performing a simple hypothesis test. Suppose the college basketball association states that the average height of a male college basketball player is 195 centimeters. A random sample is taken with a sample size of 25. The sample mean for the sample is 201 centimeters. We begin to doubt the college basketball association stated average. This looks like a good opportunity for a hypothesis test. Hypothesis testing is a five-step process. In an effort to keep you focused on each step, we're going to keep the math very simple. So let's get started. In our first step, we need to set up our hypothesis. There…

Contents