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.
KURTOSIS
A
statistical measure used to describe the distribution of observed data around
the mean. It is sometimes referred to as the "volatility of
volatility."
Used
generally in the statistical field, kurtosis describes trends in charts.
Kurtosis
characterizes the relative peakedness or flatness of a distribution compared
with the normal distribution. Positive kurtosis indicates a relatively peaked
distribution. Negative kurtosis indicates a relatively flat distribution.
= KURT(number1,number2,...)
Kurtosis is defined as:
where s is the sample standard deviation.
In the Data Sheet, we have Data from
A2:A101, A1 being the header of the Data.
=KURT(A2:A101)
Result is 1.6994
The result is positive highlights peaked distribution.
No comments:
Post a Comment