From the course: Learning Excel: Data Analysis
Join today to access over 24,700 courses taught by industry experts.
Challenge: Formulate and test a hypothesis - Microsoft Excel Tutorial
From the course: Learning Excel: Data Analysis
Challenge: Formulate and test a hypothesis
In this chapter, I have described how to formulate a hypothesis and also given an overview of how to test it. As a reminder, a hypothesis is an educated guess about a relationship between two values in your dataset. The null hypothesis says that factor A has no effect on factor B, and the alternative hypothesis says that, in fact, factor A does affect factor B. The alternative hypothesis can be directional, where you look for less than or greater than, or non-directional, where you're looking for a difference of any kind, up or down, from a particular value. So in this movie, I would like to set a challenge, which is to create an alternative hypothesis. You want to know if an ad campaign was effective. And the question is, did sales for ad recipients increase by at least 10%. So what I'd like you to do is to create a null hypothesis, create an alternative hypothesis that answers the question that we're testing for, and then identify if your hypothesis is one-tailed or two-tailed and…
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.
