Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Statistics and Probabilities in Excel

via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course aims to teach students how to perform various statistical analyses and calculations using Excel. By the end of the course, learners will be able to calculate descriptive statistics, conduct hypothesis tests, create different types of charts, generate random numbers, analyze correlations, perform regression analysis, and interpret various statistical functions in Excel. The course covers a wide range of topics including probability distributions, data transformation, outlier detection, and hypothesis testing. The teaching method involves step-by-step demonstrations and explanations, along with hands-on practice exercises. This course is intended for individuals who want to enhance their statistical analysis skills using Excel, such as researchers, data analysts, students, and professionals working with data.

Syllabus

Calculating Descriptive Statistics Using Excel.
Calculating Percentile Rank Using Excel.
Random Number Generation and Random Sampling in Excel.
Calculating a Correlation Coefficient Using Excel.
Chi-Square Test in Excel.
T-Test in Excel including Testing for Equality of Variances.
ANOVA in Excel.
Regression in Excel.
Pretest and Posttest Analysis Using Excel.
Histogram in Excel.
Calculating Cohen's d Using Microsoft Excel.
Calculating Measures of Central Tendency using Excel.
Calculating Z Scores using Excel.
Calculating Confidence Intervals in Excel.
Calculating Probabilities Using the Normal Distribution Function in Excel.
Estimating Sample Size Using Excel.
Poisson Function in Excel.
Binomial Distribution Function in Excel.
Frequency Function in Excel.
The SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS Functions in Excel.
The COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS Functions in Excel.
Creating Pie Charts in Microsoft Excel.
Creating Line Charts in Excel.
Creating Bar Charts in Excel.
Configuring the Scroll Bar Form Control in Excel.
Conducting a Levene's Test in Excel.
Conducting a Modified Levene's Test in Excel.
Conducting a T-Test using the T.TEST Function in Excel.
Calculating the Standard Deviation in Excel.
Calculating a Correlation Coefficient in Excel Step-by-Step and with the CORREL Function.
Calculating the Coefficient of Determination in Excel.
The "z Test: Two Sample for Means" Analysis in Excel.
Predicting Values with the TREND Function in Excel.
Predicting Values with the LINEST Function in Excel.
Combinations and Permutations in Excel.
Creating and Interpreting Scatterplots in Excel.
Multiple Mode (MODE.MULT) Function in Excel.
RANK.AVG and RANK.EQ Functions in Excel.
RAND and RANDBETWEEN Functions in Excel.
Data Transformation for Skewed Variables Using the LOG10 Function in Excel.
Calculating the Standard Error of the Mean in Excel.
Calculating and Interpreting Cohen's Kappa in Excel.
Identifying and Highlighting Outliers in Excel.
The NORM.DIST and Related Functions in Excel.
Adding Ordinal Notation to Integers in Excel.
Weighted and Unweighted Averages in Excel.
Spearman's Rank Correlation Coefficient in Excel.
Creating Random Numbers that Follow a Normal Distribution Using Excel.
Creating Random Numbers that Follow a Discrete Distribution Using Excel.
Creating Random Numbers that Follow a Poisson Distribution Using Excel.
Creating a Boxplot in Excel.
Creating a Histogram in Microsoft Excel 2016.
Creating a Boxplot in Excel 2016.
Arithmetic, Harmonic, and Geometric Means in Excel.
Conducting a Square Root Transformation in Excel.
FORECAST.ETS Function (Exponential Triple Smoothing) in Excel.
Normality Testing in Excel Compared with SPSS Output.
Creating a Graph of the Standard Normal Distribution in Excel.
Calculating Mahalanobis Distance Critical Values in Excel.
ANOVA Step-by-Step in Excel with Interpretation of Results and Comparison to SPSS Output.
Levene's Test of Homogeneity of Variance using Only Excel Functions Compared to SPSS.
Reflection of a Negatively Skewed Variable using Excel.
Jarque-Bera Test of Normality in Excel.
95% Confidence Interval in Excel using CONFIDENCE.NORM and Standard Error of the Mean.
Formula Auditing including Trace Precedents and Trace Dependents in Excel.
Calculating and Interpreting the Standard Error of Measurement using Excel.
Calculating and Interpreting the Standard Error of the Estimate (SEE) in Excel.
Calculating Percentage Change in Excel.
Calculating Effect Size (Cohen's d) for a Paired-Samples T Test.
Calculating Effect Size (Cohen's d) for a One-Sample T Test.
Moving (Rolling) Average in Excel 2016.
Formatting and Counting Dates Occurring Before or After a Specified Date.
Conditional Formatting with Icon Sets to Indicate Score Differences in Excel.
Excel Data Validation to Facilitate Correct Entry of Research Data.
Using the REPT Function in Excel to Display Data Graphically.
Using Data Bars to Compare Pretest and Posttest Variables in Excel.
Using the Ink Equation Feature in Excel to Write Equations.
Manually Calculate Independent-Samples T Test in Excel.
Manually Calculate Paired-Samples (Dependent-Samples) T Test in Excel.
Calculating Critical Values for T Distribution in Excel and Building Chart.
INDEX and MATCH Functions in Excel to Return Value in Different Column than Search Value.
Reverse Coding a Likert Scale in Excel.
Understanding Sample (STDEV.S) and Population (STDEV.P) Standard Deviation using Excel.
One-Way ANOVA (ANOVA: Single Factor) using Excel 2016 Data Analysis Tools.
Two-Way ANOVA with Replication using Excel 2016 Data Analysis Tools.
Two-Way ANOVA without Replication using Excel Data Analysis Tools.
Random Number Generation Function in Excel 2016 to Produce Multiple Distributions.
Drawing Random Samples with the Sampling Function in Excel 2016.
Calculating and Understanding Covariance (COVARIANCE.S) in Excel.
Creating and Interpreting Scatterplot (Scatter Chart) in Excel 2016.
Calculating and Understanding the Coefficient of Variation COV in Excel.
Calculating Type II Error (Beta) and Power using Excel.
Independent Samples T-Test from Only Sample Size, Mean, and Standard Deviation in Excel.
One-Sample T Test using Excel.
Calculating the 95% Confidence Interval after a T Test using Excel.
Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools.
Predict Outcome Value with SLOPE and INTERCEPT Functions in Excel.
Creating Waterfall Charts in Microsoft Excel 2016.
Managing Histogram Bins in Microsoft Excel Including Bin Width and Number.
Mean Deviation Compared to Standard Deviation in Excel.
Median Absolute Deviation using Microsoft Excel.
Array Formulas for Complex Calculations in Microsoft Excel.
Graphing a Rolling (Moving) Average Dynamically using Microsoft Excel.
Calculating Cronbach's Alpha in Microsoft Excel Compared to SPSS.
Interquartile Range (IQR), Outlier Detection, and Boxplots in Excel.
Stem and Leaf Plot (Stemplot) using COUNTIF and REPT Functions in Excel.
One-Way ANOVA with LSD (Least Significant Difference) Post Hoc Test in Excel.
Calculating the Sample Size with a Finite Population in Excel.
Mann-Whitney U Test in Excel.
Wilcoxon Signed-Rank Test in Excel.
McNemar Test in Excel.
Sign Test as a Non-Parametric Alternative to a One-Sample T Test in Excel.
Kendall's Coefficient of Concordance (Kendall's W) in Excel.
Calculating the Number of Unique Numbers and Unique Values in a Range using Excel.

Taught by

Dr. Todd Grande

Reviews

Start your review of Statistics and Probabilities in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.