From the course: Learning Excel: Data Analysis
Join today to access over 23,100 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
(upbeat music) - [Instructor] 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…
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.