Learn how to take on statistical analysis in Excel with these tutorials. Every concept will be explained in plain English, followed by how to take the concept on in Excel. As with all of the tutorials on ThatExcelSite.com, you’ll be given step-by-step instructions using screenshots.
The coefficient of variation (CV) is a measure of how spread out values in a dataset are relative to the average value. It’s a common calculation that, unfortunately, doesn’t have a built-in function in Excel. Thankfully, this post will simplify that for you! By reading this tutorial, you’ll learn how to calculate the coefficient of …
How to Calculate the Coefficient of Variation in Excel Read More »
The R-squared (or r2) is a measure that represents how much variation of a dependent variable is explained by the independent variable. The higher the value of r-squared, the more of one variable’s variance is explained by the variance of another. In this tutorial, you’ll learn how to use Excel to calculate the r-squared value. …
The mean squared error is frequently used to measure the accuracy of the prediction of a dataset. In this tutorial, you’ll learn how to calculate the mean squared error in Excel. First, you’ll learn how the MSE is calculated and what it represents. Then, you’ll learn how to calculate the mean squared error using Excel. By …
How to Calculate the Mean Squared Error (MSE) in Excel Read More »
By the end of this tutorial, you’ll have learned: What a z-score is and why it matters How to calculate the z-score in Excel for a single value How to calculate the z-score in Excel for an entire column How to interpret z-scores in Excel What are Z-Scores and Why Do They Matter? A z-score …
The standard deviation is a measure of variation in a dataset. It tells you how similar or dissimilar your data is. In this tutorial, you’ll learn how to use Excel to calculate the standard deviation. Thankfully, Excel makes calculating the standard deviation very simple and straightforward. However, there are a number of different functions available …
The interquartile range, or IQR, represents the spread of the middle 50% of the dataset. In particular, the interquartile range represents the difference between the first quartile and the third quartile. In this tutorial, you’ll learn how to use Excel to calculate the interquartile range. Excel makes this easy by using the QUARTILE() function, which …
How To Calculate the Interquartile Range (IQR) In Excel Read More »
