시작하기무료로 시작하기

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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작