Calculating standard deviations
There is a lot of seasonal variability in the train data. To better understand this, you will now calculate the standard deviation to understand how "spread out" the data is from the mean average.
To calculate the standard deviation:
- Calculate the variance of the data.
- Take the
SQRT(), or square root, of the variance.
Building on the variance, you will first manually calculate the standard deviation before defaulting to the formula STDEVP().
이 연습은 강의의 일부입니다
Google Sheets로 배우는 통계 입문
연습 안내
- In cell
D2, calculate the variance of the data usingVARP(). - In cell
E2, calculate the square root of the variance. - Finally, in cell
F2, useSTDEVP()to automatically calculate the standard deviation.
