Using Excel’s PivotTable to look at Bivariate Categorical Data

Fortunately, Excel offers a very powerful sensitivity analysis tool called Data Table, which can be readily used to analyze how a change in one variable affects another variable. Data Table combined with Excel’s Chart feature can readily help students understand and visualize the nonlinear relationship between future value and compounding period. ................
................