In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.

How to Chart the Frequency of a Data Set on Excel. Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to ...

How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, you can choose your formula based ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.