Symmetry, Skewness and Kurtosis

We consider a random variable x and a data set S = {x1, x2, …, xn} of size n which contains possible values of x. The data set can represent either the population being studied or a sample drawn from the population.

Looking at S as representing a distribution, the skewness of S is a measure of symmetry while kurtosis is a measure of peakedness of the data in S.

Symmetry and Skewness

Definition 1: We use skewness as a measure of symmetry. If the skewness of S is zero then the distribution represented by S is perfectly symmetric. If the skewness is negative, then the distribution is skewed to the left, while if the skew is positive then the distribution is skewed to the right (see Figure 1 below for an example).

Excel calculates the skewness of a sample S as follows:

Skewness Formula in Excel

where is the mean and s is the standard deviation of S. To avoid division by zero, this formula requires that n > 2.

Observation: When a distribution is symmetric, the mean = median, when the distribution is positively skewed the mean > median and when the distribution is negatively skewed the mean < median.

Excel Function: Excel provides the SKEW function as a way to calculate the skewness of S, i.e. if R is a range in Excel containing the data elements in S then SKEW(R) = the skewness of S.

Excel 2013 Function: There is also a population version of the skewness given by the formula

Skewness population

This version has been implemented in Excel 2013 using the function, SKEW.P.

It turns out that for range R consisting of the data in S = {x1, …, xn}, SKEW.P(R) = SKEW(R)*(n–2)/SQRT(n(n–1)) where n = COUNT(R).

Real Statistics Function: Alternatively, you can calculate the population skewness using the SKEWP(R) function, which is contained in the Real Statistics Resource Pack.

Example 1: Suppose S = {2, 5, -1, 3, 4, 5, 0, 2}. The skewness of S = -0.43, i.e. SKEW(R) = -0.43 where R is a range in an Excel worksheet containing the data in S. Since this value is negative, the curve representing the distribution is skewed to the left (i.e. the fatter part of the curve is on the right). Also SKEW.P(R) = -0.34. See Figure 1.

Shape: skewness and kurtosis

Figure 1 – Examples of skewness and kurtosis

Observation: SKEW(R) and SKEW.P(R) ignore any empty cells or cells with non-numeric values.


Definition 2: Kurtosis provides a measurement about the extremities (i.e. tails) of the distribution of data, and therefore provides an indication of the presence of outliers.

Excel calculates the kurtosis of a sample S as follows:

Kurtosis Formula in Excel

where is the mean and s is the standard deviation of S. To avoid division by zero, this formula requires that n > 3.

Observation: It is commonly thought that kurtosis provides a measure of peakedness (or flatness), but this is not true. Kurtosis pertains to the extremities and not to the center of a distribution.

Excel Function: Excel provides the KURT function as a way to calculate the kurtosis of S, i.e. if R is a range in Excel containing the data elements in S then KURT(R) = the kurtosis of S.

Observation: The population kurtosis is calculated via the formula


which can be calculated in Excel via the formula


Real Statistics Function: Excel does not provide a population kurtosis function, but you can use the following Real Statistics function for this purpose:

KURTP(R, excess) = kurtosis of the distribution for the population in range R1. If excess = TRUE (default) then 3 is subtracted from the result (the usual approach so that a normal distribution has kurtosis of zero).

Example 2: Suppose S = {2, 5, -1, 3, 4, 5, 0, 2}. The kurtosis of S = -0.94, i.e. KURT(R) = -0.94 where R is a range in an Excel worksheet containing the data in S. The population kurtosis is -1.114. See Figure 1.

Observation: KURT(R) ignores any empty cells or cells with non-numeric values.

Graphical Illustration

We now look at an example of these concepts using the chi-square distribution.

Chi-square distribution

Figure 2 – Example of skewness and kurtosis

Figure 2 contains the graphs of two chi-square distributions (with different degrees of freedom df). We study the chi-square distribution elsewhere, but for now note the following values for the kurtosis and skewness:

Comparison of skewness and kurtosis

Figure 3 – Comparison of skewness and kurtosis

Both curves are asymmetric, and skewed to the right (i.e. the fat part of the curve is on the left). This is consistent with the fact that the skewness for both is positive. But the blue curve is more skewed to the right, which is consistent with the fact that the skewness of the blue curve is larger.

52 Responses to Symmetry, Skewness and Kurtosis

  1. Karim says:

    Thanks for helping us understanding those basics of stat.

  2. Namo Ghate says:

    Using the scores I have, how can I do the GRAPHIC ILLUSTRATION of skewness and kurtosis on the excel?

    • Charles says:

      I am not sure what you mean by a graphic illustration. I have tried to do this with the graph of the chi-square distribution, which was done using Excel (see the details in the Examples Workbook, which you can download for free).

  3. soniya says:

    Hi Charles. I want to know ‘what is the typical sort of skew?’

  4. Gaylord Lussac says:

    “the kurtosis value of the blue curve is lower” should read “the kurtosis value of the blue curve is higher”.
    In fact, zero skew is seldom observed. See for example

  5. Professor Amir says:

    Based on my experience of teaching the statistics, you can use pearson coefficient of skewness which is = mean – mode divide by standard deviation or use this = 3(mean – median) divide by standard deviation. mostly book covered use the first formula for ungrouped data and second formula for grouped data

  6. adekola says:

    What the differences and similarities between skewness and kurtosis?

  7. sandeep says:

    I want two suggestion
    1. I have 1000 dollar money i wants to distribute it in 12 month in such a way that peak is 1.6 time the average ( using normal distribution curve)
    2. As per my knowledge the peak in bell curve is attended in mean (i.e by 6.5 month) but if i want peak at 40% month (i.e 12*40/100 time ) and peak will still remain 1.6 time the average( i.e peak= 1.6*100/12) than what will be the distribution

    • Charles says:

      The peak is usually considered to be the high point in the curve, which for a normal distribution occurs at the mean. Thus, I don’t know what it means for the peak to be 1.6 times the average (which is the mean). Please explain what you mean by the peak?

    • very dificult to compute a curtosis how to be know a sample is group or ungrouped data

      • Charles says:

        You can compute kurtosis using the KURT function. I don-t understand teh part about group or ungrouped data.

  8. Steven says:

    Hey Charles

    Say you had a bunch of returns data and wished to check the skewness of that data. In this instance, which would be appropriate – Skew() or Skew.P()

    I would imagine Skew() because Skew.P() refers to a population and you don’t have the population here, you merely have a bunch of return data don’t you. OR when dealing with financial returns do you assume that the data you have is the population?

  9. rose says:

    I want to make sure by ” n ”
    did you mean the sample size ?

  10. Your description of kurtosis is incorrect. Kurtosis measures nothing about the peak of the distribution. It only measures tails (outliers).

    The logic is simple: The average of the Z^4 values (which is the kurtosis) gets virtually no contribution from |Z| values that are less than 1.0, where any “peak” would be. It’s only the large |Z| values (the outliers) that contribute to kurtosis.

    Here is an article that elaborates :

    The “peakedness” description is an unfortunate historical error, promoted for ages, apparently by inertia. People just parroted what others said.

    • Charles says:

      Thank you very much for sharing this and setting the record straight. I will change the website accordingly.
      I will also add your article to the Bibliography.

  11. Mina says:

    the Kurtosis value on my data is above 2 (+3). i think it should be between negative and positive 2. how can I change it to obtain normality??

  12. Emmanuel says:

    I think the Kurtosis formula is too long to be crammed, can I get assistance on how go understand if?

  13. Miss Cupcake says:

    How to determine skewness for qualitative variable?

  14. Xiaobin says:

    Hi, Charles,
    The skewness formula is not shown correctly on the page.

    Are there different measures of skewness? For example, I found from this site ( that the formulas used to calculate skewness are different from the ones you show here. How can I interpret the different results of skewness from different formulas?


    • Charles says:

      The two statistics that you reference are completely different from the measurement that I have described. I have never used the measures that you have referenced. I presume that measure skewness and are easier to calculate than the standard measurement (which is the one that I describe) and so are less accurate.
      See the following webpage for further explanation:

  15. chris says:

    Sir, if the value of the SKEWNESS is zero, it means that the distribution in the curve is symmetric, if the value falls within -0.49 <SK< 0.49 (since -0.49 and 0.49 when rounded of is 0), may i say that the distribution may still be SYMMETRIC?

    how about in kurtosis, if the value is within 2.50 <KU<3.49 (since 2.50 and 3.49 when rounded of is 3), may i say that the distribution may still be MESOKURTIC?

    Thank you very much

  16. Sonali says:

    Please let me know if we have some data set with sizes with volume percentages to calculate skewness and kurtosis, Do I need to divide the data set into same size classes or different size classes is okay.

  17. Namrata says:

    How do i compare skewness and kurtosis?

  18. nazrin asri student degree says:

    can u explain more details about skewness and kurtosis.

  19. Pranjal Srivastava says:

    How can we write about line symmetry and mirror symmetry if asked separately from kurtosis & skewness?

    • Charles says:

      Pranjal Srivastava,
      To test for symmetry algebraically about the y axis you take the equation y = f(x) and substitute -x for x and see whether you get the same equation back. Similarly, you can test for symmetry about the x axis or about the origin.
      In the referenced webpage, I am not testing for 100% symmetry. I am testing whether the data is symmetric enough that I can use one of the standard statistical tests.

  20. Maree Size says:

    Hi Charles,
    How do I incorporate weights in the skewness calculation? Say the value 5 appear 3 times, 8 appears 2 times and 9 appears once. I have the formula SKEW(5, 8, 9) – using cell references, but would like the calculation to be SKEW(5, 5, 5, 8, 8, 9).
    Kind regards,

  21. hafiz says:

    hi charles,
    what happen if my skewness is -.999? what does -.999 means? it is still normal?

    • Charles says:

      The distribution is skewed to the left. Skewness of -.999 (i.e. about -1) is usually consistent with data that is normally distributed (skewness = zero), but whether the data is normally distributed depends on other factors as well.

  22. KATH says:

    Hi Sir Charles, may I know if the formula for grouped and ungrouped data of skewness and kurtosis are the same?

    • Charles says:

      I am not sure I know what you mean by grouped and ungrouped data. Say you have a range of data A1:C10 in Excel, where the data for each of three groups is the data in each of the columns in the range. Then the overall skewness can be calculated by the formula =SKEW(A1:C10), but the skewness for each group can be calculated by the formulas =SKEW(A1,A10), =SKEW(B1:B10) and =SKEW(C1:C10).

Leave a Reply

Your email address will not be published. Required fields are marked *