Computing Descriptive Statistics in Excel
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.
Data Analytics for Decision Making: An Introduction to Using Excel
Data Analytics for Decision Making: An Introduction to Using Excel
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.
