开始使用免费开始使用

Is the data "normally" distributed?

Let's revisit the savings data. Earlier, you noted that the mean and median savings values were almost equal. The savings histogram was also roughly symmetrical and resembled a bell curve.

Now you want to use statistics to verify if the distribution is approximately symmetrical or "normally distributed". To do so, you will calculate the skew and kurtosis.

  • Kurtosis: Calculated using KURT(). Measures how the tails behave. It identifies how values are concentrated around the mean and how they trail away from it in the tails.
  • Skew: Calculated using SKEW(). Measures how symmetrical the distribution is. 0 means the distribution is exactly symmetrical. Values above or below 0 indicate that there are more values above or below the mean.

本练习是课程的一部分

Google Sheets 统计学入门

查看课程

练习说明

  • In cells F5 and F6, calculate the skew and kurtosis of the savings data.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习