markdown_files/Correlation_with_Excel.md

---

title: "Correlation with Excel"
original_url: "https://tds.s-anand.net/#/correlation-with-excel?id=correlation-with-excel"
downloaded_at: "2025-06-08T23:24:31.921246"
---


[Correlation with Excel](#/correlation-with-excel?id=correlation-with-excel)
----------------------------------------------------------------------------

[![Correlation with Excel](https://i.ytimg.com/vi_webp/lXHCyhO7DmY/sddefault.webp)](https://youtu.be/lXHCyhO7DmY)

You’ll learn to calculate and interpret correlations using Excel, covering:

* **Enabling the Data Analysis Tool Pack**: Steps to enable the Excel data analysis tool pack.
* **Correlation Analysis**: Understanding statistical association between variables.
* **Creating a Correlation Matrix**: Steps to generate and interpret a correlation matrix.
* **Scatterplots and Trendlines**: Plotting data and adding trend lines to visualize correlations.
* **Analyzing Results**: Comparing correlation coefficients and understanding their implications.
* **Insights and Further Analysis**: Interpreting scatterplots and planning further analysis for deeper insights.

Here are the links used in the video:

* [Understand correlation](https://www.khanacademy.org/math/ap-statistics/bivariate-data-ap/correlation-coefficient-r/v/correlation-coefficient-intuition-examples)
* [COVID-19 vaccinations data explorer - Website](https://ourworldindata.org/covid-vaccinations?country=OWID_WRL)
* [COVID-19 vaccinations - Correlations Excel file](https://docs.google.com/spreadsheets/d/1_vQF2i5ubKmHQMBqoTwsu6AlevWsQtTD/view#gid=790744269)

[Previous

6. Data Analysis](#/data-analysis)

[Next

Regression with Excel](#/regression-with-excel)