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...
Excel
How to Calculate Root Mean Square Error (RMSE) in Excel
In statistics, regression analysis is a technique we use to understand the relationship between a predictor variable, x, and a response variable, y.
When we...
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...
Excel
How to Apply the Empirical Rule in Excel
The Empirical Rule, sometimes called the 68-95-99.7 rule, states that for a given dataset with a normal distribution:
68% of data values fall within one standard deviation...
Excel
How to Find a P-Value from a Z-Score in Excel
Many hypothesis tests in statistics result in a z-test statistic. Once we find this z-test statistic, we typically find the p-value associated with it....
Excel
How to Calculate Z-Scores in Excel
In statistics, a z-score tells us how many standard deviations away a value is from the mean. We use the following formula to calculate...
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 = ,...
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