| 1 -Buildind Descriptive Statistical Formulas.pptx | 353.2 MB | ||
| 1 -Buildind Inferential Statistical Formulas.pptx | 782.2 MB | ||
| 1 -Building Descriptive Statistical Formulas - Complete.xlsx | 526.7 KB | ||
| 1 -Building Descriptive Statistical Formulas - Teaching File.xlsx | 515.6 KB | ||
| 1 -Building Descriptive Statistical Formulas.mp4 | 32.7 MB | ||
| 1 -Building Inferential Statistical Formulas - Complete.xlsx | 687.9 KB | ||
| 1 -Building Inferential Statistical Formulas - Teaching File.xlsx | 626.3 KB | ||
| 1 -Building Inferential Statistical Formulas.mp4 | 36.3 MB | ||
| 10 -Discrete Probability & Hypergeometric Distribution.mp4 | 32.2 MB | ||
| 10 -MEDIAN Function.mp4 | 12.8 MB | ||
| 11 -Discrete Probability & Poisson Distribution.mp4 | 16.7 MB | ||
| 11 -The MODE Function.mp4 | 10.6 MB | ||
| 12 -Calculating the Weighted Mean.mp4 | 22.1 MB | ||
| 12 -Understanding the Normal Distribution and THE NORM.DIST Function.mp4 | 41.4 MB | ||
| 13 -Calculating Extreme Values with MAX & MIN Functions.mp4 | 14.5 MB | ||
| 13 -Calculating Standard Scores.mp4 | 29.6 MB | ||
| 14 -Calculating Normal Percentiles with NORM.DIST.mp4 | 28 MB | ||
| 14 -The LARGE and SMALL Functions.mp4 | 21 MB | ||
| 15 -Performing Calculations on the Top K Values.mp4 | 23.7 MB | ||
| 15 -The Shape of The Curve I; The SKEW Function.mp4 | 49.7 MB | ||
| 16 -Performing Calculations on the Bottom K Values.mp4 | 14.2 MB | ||
| 16 -The Shape of The Curve II; The KURT Function.mp4 | 42.3 MB | ||
| 17 -Calculating Rank.mp4 | 21.8 MB | ||
| 17 -Determining Confidence Intervals & Confidence Intervals for Normal Distribution.mp4 | 44.1 MB | ||
| 18 -Calculating Percentile.mp4 | 15 MB | ||
| 18 -Determining Confidence Intervals & Confidence Intervals for T Distribution.mp4 | 16.4 MB | ||
| 19 -Calculating Measures of Variation Overview & Range Function.mp4 | 23.8 MB | ||
| 19 -Hypothesis Testing & Z - Test.mp4 | 26.8 MB | ||
| 2 -Counting Items & COUNT Function.mp4 | 11.7 MB | ||
| 2 -Understanding Inferential Statistics.mp4 | 30.9 MB | ||
| 20 -Calculating The Variance.mp4 | 25.6 MB | ||
| 20 -Hypothesis Testing & T - Test.mp4 | 24 MB | ||
| 21 -Calculating The Standard Deviation.mp4 | 26 MB | ||
| 22 -Working with Frequency Distributions.mp4 | 21 MB | ||
| 3 -COUNTA Function.mp4 | 13.4 MB | ||
| 3 -Sampling Data & Extracting a Periodic Sample.mp4 | 67.8 MB | ||
| 4 -COUNTBLANK Function.mp4 | 8.6 MB | ||
| 4 -Extracting a Random Sample.mp4 | 38.9 MB | ||
| 5 -COUNTIF Function.mp4 | 17.1 MB | ||
| 5 -Determining whether Two Variables are Related.mp4 | 22.3 MB | ||
| 6 -COUNTIFS Function.mp4 | 18.1 MB | ||
| 6 -Calculating Covariance.mp4 | 22.9 MB | ||
| 7 -Calculating Averages & AVERAGE Function.mp4 | 9.3 MB | ||
| 7 -Calculating Correlation.mp4 | 30.1 MB | ||
| 8 -AVERAGEIF Function.mp4 | 20.9 MB | ||
| 8 -Working with Probability Distributions & Calculating Probability.mp4 | 98.7 MB | ||
| 9 -AVERAGEIFS Function.mp4 | 25.6 MB | ||
| 9 -Discrete Probability & Binomial Distribution.mp4 | 31.5 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 50 total files | |||
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.
All Comments