While many charts only involve one variable, you can create charts that have multiple variables. To do this, you need only to create a table with multiple columns.

Two-Variable Data Table Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

You can use the RAND () function to establish probability and create a random variable with normal distribution.