Excel - Skewness Kurtosis

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • Skewness and Kurtosis in Excel

Комментарии • 12

  • @peterwestfall6924
    @peterwestfall6924 6 лет назад +11

    Actually, Pearson's kurtosis tells you nothing about "flatness" or "peakedness". It measures tails (outliers) only. Your distribution graphs actually just show differences in variance, not differences in kurtosis. You need to make the distributions have the same variance for adequate comparison. But even when you do that, it is difficult to distinguish differences in kurtosis because the tails are close to zero, even when the distribution has fat tails. (And height of peak is irrelevant, because you can have infinitely high peaks with low kurtosis and low peaks with high kurtosis). A better way to distinguish low and high kurtosis is to look at normal quantile-quantile plots, where it is easy to see the difference.

  • @sohailmirza2134
    @sohailmirza2134 3 года назад

    Thanks for explaining the interpretation of skewness and kurtosis

  • @E-Academy
    @E-Academy 3 года назад

    Can you provide the reference for this talk? I wanna quote it by reference so, Would you help?

  • @versace1589
    @versace1589 6 лет назад +5

    can you provide the file for that please :(

  • @ceellama
    @ceellama 3 года назад +1

    You should share that excel file
    :) how do you make the lines for the kurtosis?

    • @5eanalytics
      @5eanalytics  3 года назад +1

      The lines are just drawn. I’ll make the excel files available on our blog website

  • @4Dul69
    @4Dul69 3 года назад +2

    This was really helpful for my excel class but I have one question. Why aren't you outside in some party dude it's Sunday 8:33 come on !!

  • @Rob-kx5yx
    @Rob-kx5yx 5 лет назад

    Many thanks!!

  • @villwang8005
    @villwang8005 3 года назад

    can curtosis be exactly 0?