From the course: SQL for Exploratory Data Analysis Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Testing hypothesis with statistics - PostgreSQL Tutorial
From the course: SQL for Exploratory Data Analysis Essential Training
Testing hypothesis with statistics
- [Presenter] Now let's turn our attention to testing hypotheses with statistics. Broadly speaking, there are two things we can do with statistics. The first we've already covered which is descriptive statistics, which is describing the shape and properties of a data set. The second is hypothesis testing. Hypothesis testing can help when you have hunches about subsets of the data, and how it differs from the overall set or other subsets. For example, we could use hypothesis testing to understand if customers in the Southeastern United States make more purchases than customers in the Northwestern states. We can also look at if customers over the age of 40 spend more per year than customers under the age of 30. Another example is, are customers more likely to click on an ad that includes images than on ads that are only text. We can use the sequel query language to help us evaluate hypotheses. Let's assume we have a table that includes a customer ID, name, address, city, state, we'll…
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.