Univariate Analysis with Excel: Distributions, Sampling, Descriptive Statistics, ECDF

Learn how to do univariate analysis using Excel statistical functions such as
Mean, Mode, Mean, Standard Deviations.
Visually analyze your data using box and whisker plots, histograms, distribution probability and a collection of so much more. Perform a statistical T-Test to determine the difference in sample means.
Create a visual report that allow you to communicate your insights.
Find the dataset here:
www.absentdata...
1:01 Visual Report
4:20 Central Tendency Metrics
5:33 Histograms
6:04 Quartiles
7:21 Box and Whisker Plots
8:39 Data boundaries and outliers
10:38 Probability Distributions
15:48 T-Test for Independence of Means

[@patticmcconnell]

Your videos are so good. I’ve learned so much from them all! Thank you for sharing.

[@absentdata]

Awesome. I'm so glad that you are learning!!

[@tomasfroevelarguellesvigo3040]

You´re the best 👍

[@alielturk2534]

Can I have the dataset used to follow up and do the exercise?

[@absentdata]

Its in the description. Let know if you have any issues

[@felipelandim2881]

Cool!

[@absentdata]

Glad yiu like it

[@karthikeyanpalanivelu7250]

i have a doubt sir, does the number of data values need to be the same to do univariate analysis ??

[@absentdata]

Hi, if I am understanding correctly, no you don't need to have the same number of values to compare two distributions. However, if you are testing the two it makes since to compare similar values.