From the course: Learning Excel: Data Analysis
Join today to access over 23,100 courses taught by industry experts.
Solution: Formulate and test a hypothesis - Microsoft Excel Tutorial
From the course: Learning Excel: Data Analysis
Solution: Formulate and test a hypothesis
(upbeat entertaining music) - [Instructor] In the previous movie, I gave you a challenge to create an alternative hypothesis. You want to know if an ad campaign was effective. And the question was whether sales for ad recipients increased by at least 10%? I invited you to create a null hypothesis, an alternative hypothesis that examines the question in the second point. And then also identify if your hypothesis is one tailed or two tailed, and whether you can test it. So here's how I might approach the problem. The null hypothesis says advertising did not increase sales by 10% or more. In other words, there was no effect. The alternative hypothesis says advertising increased sales by 10% or more. Also, this alternative hypothesis is directional. We are testing for an increase. And it can be tested by analyzing sales data from ad viewers. As long as you are collecting the data that you need, you'll be able to identify individuals who saw the ads and whether or not they're spending…
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.