Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate a Five Number Summary in Excel
A five number summary is a way to summarize a dataset using the following five values:
The minimum
The first quartile
The median
The third quartile
The maximum
The five number summary...
Descriptive Statistics in Excel
How to Calculate Conditional Probability in Excel
The conditional probability that event A occurs, given that event B has occurred, is calculated as follows:
P(A|B) = P(A∩B) / P(B)
where:
P(A∩B) = the probability that event A and event B both occur.
P(B) = the...
Descriptive Statistics in Excel
How to Calculate Skewness in Excel
Skewness is a measure of the asymmetry of a dataset or distribution. This value can be positive or negative. It’s useful to know because...
Descriptive Statistics in Excel
How to Calculate the Coefficient of Variation in Excel
A coefficient of variation, often abbreviated as CV, is a way to measure how spread out values are in a dataset relative to the...
Descriptive Statistics in Excel
How to Calculate the Interquartile Range (IQR) in Excel
This tutorial explains how to calculate the interquartile range of a dataset in Excel.
What is the Interquartile Range?
The interquartile range, often denoted IQR, is a way to...
Descriptive Statistics in Excel
How to Easily Calculate the Dot Product in Excel
This tutorial explains how to calculate the dot product in Excel.
What is the Dot Product?
Given vector a = and vector b = ,...
Descriptive Statistics in Excel
How to Create a Survival Curve in Excel
A survival curve is a chart that shows the proportion of a population that is still alive after a given age, or at a...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read