Skip main navigation

Hurry, only 3 days left to get one year of Unlimited learning for £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

Computing Descriptive Statistics in Excel

Adrian Gepp demonstrates the use of Excel to calculate measures of central location, spread and shape.

We’ve now covered various descriptive statistics, and now you should also be able to calculate them yourselves using Excel.

Note that while most common statistics can be produced automatically using the analysis toolpack in Excel, those values don’t automatically update. By calculating the statistics individually with the easy to use Excel formulas, they will automatically update when you make changes to your data. If you think there is a chance you will have to make changes to your data, then it’s probably best to do it this way.

In the next step we’ll introduce the final descriptive statistic, which measures the association between variables.

This article is from the free online

Data Analytics for Decision Making: An Introduction to Using Excel

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now