Inferential Statistics Using SQL
You have learned how to perform complex data operations such as filtering, sorting, and aggregating data using window functions in previous chapters. In this chapter, we will introduce several key concepts in inferential statistics that can help you to make an educated guess about a big group based on limited samples.
The following topics will be covered:
- Moving from analytics to statistics
- Estimating: point estimates and confidence intervals
- Testing hypotheses
- Analyzing correlation and performing regression
The goal is to get you familiar with these ideas so that, in practice, you can more easily uncover hidden patterns, draw meaningful conclusions, and make informed decisions that enhance efficiency and improve effectiveness. These tools—while statistical in nature—are deeply relevant to the kinds of questions SQL users often face when working with real-world data.
To support that connection...
