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.
SKEWNESS
Describe
asymmetry from the normal distribution in a set of statistical data. Skewness
characterizes the degree of asymmetry of a distribution around its mean.
Skewness
can come in the form of "negative skewness" or "positive
skewness", depending on whether data points are skewed to the left
(negative skew) or to the right (positive skew) of the data average.
Positive
skewness indicates a distribution with an asymmetric tail extending toward more
positive values. Negative skewness indicates a distribution with an asymmetric
tail extending toward more negative values.
= SKEW(number1,number2,...)
The equation for skewness is defined as:
In the Data Sheet, we have Data from
A2:A101, A1 being the header of the Data.
=SKEW(A2:A101)
Result is
-0.8347
The result is negative highlights more negative values
in the data.
No comments:
Post a Comment