This tutorial explains the types of data in statistics, such as Interval, Nominal, Ordinal data. You may also want to read: Excel Range, Variance, Standard Deviation Excel central tendency (mean mode median) Types of data in statistics (Interval, Nominal, Ordinal) This tutorial is nothing related to Excel, but it is the foundation for my other Excel statistics tutorial. Understanding the data type is the first step to understand statistics, because it affects what data we should coll...

This Excel tutorial explains how to measure variability using Range, Variance, Standard Deviation. You may also want to read: Excel calculate Covariance, Coefficient of Correlation Excel Range, Variance, Standard Deviation In the previous post, I have explained how to measure the central tendency using Mean, Mode, Median. In this tutorial, I will explain how to measure variability using Range, Variance, Standard Deviation. Variability is also known as dispersion, it is to measure of how ...

This Excel tutorial explains how to use Percentile related Functions, include PERCENTILE, PERCENTILE.INC, PERCENTILE.EXC. Excel Percentile Percentile is a statistics term used to describe the Nth observation in a data set after sorting in ascending order. For example, 40th percentile (P40) refers to the approximately 40th data of the 100 data. If the data set is not exactly 100, say 200, we find the location of observation at 40% of total data. Percentile is commonly used in salary survey t...

This Excel tutorial explains how to use mean, mode and median to measure Central Tendency. Excel Central Tendency Central Tendency is a statistics term to describe the central point of probability distribution. Central Tendency can be measured by mean, mode and median. This tutorial explains how to use Excel to measure mean, mode and median using Excel formula. Arithmetic Mean Definition Arithmetic Mean is also known as mean or average. Simply speaking, it is sum of all numbers and then div...