T-test, ANOVA test, Regression in Excel

In this video we will look at Data Analysis Toolpak in Excel. How to use it to quickly get descriptive statistics (st dev, mean, min, max), how to perform T-test, ANOVA test and regression. We will discuss differences between various tests and how to read the results/metrics of the analysis. #statistics #dataanlytics #stats ---------------------- Dataset used in this video - https://www.kaggle.com/datasets/rohitsahoo/sales-forecasting ---------------------- 🐼 Pandas Cheat Sheet - https://stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet 💻 Data Analysis with Python Masterclass - https://stan.store/KarinaDataScientist/p/start-programming-with-python 💌 Join my newsletter and get access to various freebies - https://stan.store/KarinaDataScientist ---------------------- Timestamps: ---------------------- 00:00 Intro 01:30 Install Analysis ToolPak 02:06 Descriptive statistics 04:10 T-test 05:12 Differences between T-tests (paired two sample for means, two-sample assuming equal and unequal variances) 8:07 How to read results of T-test 11:10 ANOVA test 13:10 How many observations you need 14:26 Single Factor ANOVA, Two-factor with and without replication 16:23 Read results of ANOVA test 19:14 Linear Regression 21:53 Reading the results of regression 🎥 Other videos you might be interested in ---------------------- https://youtu.be/-8stRxINNeY https://youtu.be/cWpgaIeF8pU ---------------------- About me ---------------------- Hi, my name is Karina and I'm a finance person turned data person. My mission is to transform intimidating tech into accessible tools. I aim to empower 1 million people to harness the power of AI, Python, SQL, and Excel to work smarter, not harder. Contact ---------------------- Youtube: youtube comments are by far the best way to get a response from me! email for business inquiries only: [email protected] ---------------------- Social Media: ---------------------- TikTok: https://www.tiktok.com/@karinadatascientist Instagram: https://www.instagram.com/karinadatascientist/ Linkedin: https://www.linkedin.com/in/karina-samsonova/