# Welcome to Helpful Stats!

Follow along the content using the topic names below. The topics are grouped for easier navigation.

#### The Basics

- What’s the deal about data?
- Are all data created equal?
- Describe data with central tendency
- What’s Data Visualisation?
- Common chart types
- Create awesome charts on Excel
- Create your first dashboard on Excel

- Data cleaning and preparation
- COUTIFS and SUMIFS
- AVERAGEIF and AVERAGEIFS
- PivotTables

#### Statistics Stuff

- Correlations
- What’s Probability?
- Introducing the Normal Distribution
- What are sampling techniques?

- Estimation techniques
- Confidence intervals
- Hypothesis testing
- Z tests
- Paired and Unpaired t-tests

- One-way ANOVA
- Parametric tests
- Non-parametric tests

#### More on Statistics

- Linear regression models
- Nonlinear regression models
- Multiple regression models
- What-if and Goal-seek in Excel
- Using the Analysis ToolPak
- Descrriptive statistics
- Regression analysis

- Linear optimisation
- Nonlinear optimisation
- Binary models
- Integer models
- Decision analysis
- Advanced Data Modelling with PowerPivot
- Time-series forecasting
- Seasonal decomposition
- Trend Analysis
- Build a dashboard with Pivot Charts