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
Statistics
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