Excel calculate Covariance, Coefficient of Correlation

This Excel tutorial explains the meaning and calculation of Covariance and Coefficient of Correlation. You may also want to read: Excel Range, Variance, Standard Deviation Covariance, Coefficient of Correlation Assume that we have two sets of data - English and Mathematics results for each student. How can we tell whether English result has any relationship with Mathematics result? Name of Student English Result Math Result John 50 60 Mary 60 70 Peter 70 80 ...
Read More

Types of data in statistics (Interval, Nominal, Ordinal)

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...
Read More

Excel Range, Variance, Standard Deviation

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 ...
Read More

Excel PERCENTILE.INC vs PERCENTILE.EXC

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...
Read More

Excel central tendency (mean mode median)

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...
Read More

Excel scatter chart using text name

This Excel tutorial explains how to ordinal data (text) in scatter chart using bar chart. Excel scatter chart using text name Excel scatter chart requires the x axis and y axis for each data point to be plotted in a diagram, and then join all those point together to analyze the trend or analyze if x and y variables are correlated, where X and Y values have to be numeric values. Below is an example showing how employee Grade is related to salary. From the graph, you can see the trend that Sa...
Read More