Microsoft Excel’s mathematical capabilities often go far beyond the needs of most everyday users. However, Excel’s built-in statistical functions make it an essential tool for anyone who works with ...

Standard deviation is a measurement of market volatility. Learn how investors use standard deviation in the MoneySense Glossary.

If you are looking for a guide on how to calculate standard error in Microsoft Excel, this one lists a couple of simple solutions.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Grasp risk management—find out how to annualize standard deviation and refine your investment strategies. Start stabilizing your portfolio now!

Luckily, Microsoft Excel has a handy function designed to calculate the variance of a set of numbers automatically, so you can organize your data in no time! But how exactly do you do it? If you want ...

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

While Excel still doesn't have an automatic formula for calculating a dataset’s z-score, we can use other Excel formulas to calculate the mean and then the standard deviation. The entire process may ...

We show you how to calculate percent change in Excel using a percentage change formula and some handy formatting tools.

In other words, it is the standard deviation of the sampling distribution of the mean. Calculating SEM in Excel is a useful skill for anyone who wants to analyze and understand their data more ...