Google Sheets can be used to calculate descriptive statistics for small data sets. However, with large data sets we recommend using statistical software made for analyzing large data sets, such as R, Tableau, SAS, STATA, SPSS, and other such software.
In the video below, we show how to calculate these seven descriptive statistics.
- Mean (Average)
- Median
- Mode
- Range
- Standard Deviation
- Coefficient of Variation
- Z-Score
In conclusion, Google Sheets can be used to quickly and conveniently calculate descriptive statistics like the seven discussed in this article when working with small data sets.