Udemy - Inferential and Descriptive Statistical Formulas in Excel

Inferential and Descriptive Statistical Formulas in Excel

https://WebToolTip.com

Published 8/2025
Created by CreateMyExcel with Ben Scholl
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 42 Lectures ( 2h 4m ) | Size: 2.22 GB

Master Excel formulas to analyze data, calculate probabilities, and perform statistical testing.

What you'll learn
Learn to use COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS to summarize data.
Calculate averages using AVERAGE, MEDIAN, MODE, and weighted mean formulas.
Find extreme values using MAX, MIN, LARGE, and SMALL functions.
Perform top and bottom "k" value calculations for focused analysis.
Rank data and determine percentiles using Excel’s statistical tools.
Calculate range, variance, and standard deviation to measure variability.
Build frequency distributions to analyze data spread and groupings.
Use formulas to extract periodic or random samples from large datasets.
Test relationships between variables using covariance and correlation.
Explore probability, confidence intervals, and hypothesis testing basics.

Requirements
Microsoft Excel (Office 2021 or Microsoft 365) installed.
Basic knowledge of Excel (e.g., entering data, simple calculations).
Access to a computer with a stable internet connection.
No prior advanced Excel skills required; suitable for beginners.