About the
Data Sheet - The data in this sheet is related to marks scored by 100 Students
in a Statistical Test.
Based on
the data, we will use Microsoft Excel Statistical functions
to analyse the descriptive statistics.
In the Data Sheet, we have Data from
A2:A101, A1 being the header of the Data.
Variance
Variance (σ2) is a measure of the dispersion of a
set of data points around their mean value.
In
other words, variance is a mathematical expectation of the average squared
deviations from the mean.
Variance
measures the variability from an average (volatility).
=VAR(number1,[number2],...])
VAR uses the following formula:
where x is the sample mean AVERAGE(number1,number2,…)
and n is the sample size.
In the Data Sheet, we have Data from A2:A101, A1 being the
header of the Data.
=VAR(A2:A101)
Result is 202.7777
VAR.P is for Population
VAR.S is for Sample.
Higher the variance the more the volatility or values
are more different.
Lower the variance the lesser the volatility or values
are less different.
No comments:
Post a Comment