Expected shortfall is a commonly-used tool to measure risk in financial portfolios. Let’s learn how to calculate expected shortfall in Microsoft Excel.
As a business owner or investor, it’s important to easily understand the top profit streams. Here's how to do a Profit Pool Analysis in Excel.
Factor analysis helps you determine how independent and dependent variables fit together. Let’s learn how to do factor analysis in Microsoft Excel.
Linear regression is a commonly used tool in statistics. Let’s learn how to calculate the Durbin-Watson statistic in Microsoft Excel.
In finance and banking, it’s important to measure and understand credit risk. Let’s learn how to do vintage analysis in Microsoft Excel.
Upper and lower specification limits (USL and LSL) are important measurements in process control. Here's how to calculate USL and LSL in Microsoft Excel.