# Excel Data Table for One and Multiple Variable Sensitivity Analysis

Learn how an Excel Data Table runs one-variable and two-variable sensitivity analysis so you can see how changes in inputs shift repair cost outputs.

An Excel Data Table is the What-If Analysis tool that recalculates a formula across a range of input values, so you can see how one and multiple variable sensitivity analysis works without rebuilding the sheet. You point the table at the result cell and at the input cells, and Excel fills in the outcomes for each value you supply. This page explains the one-variable and two-variable setups, which input cell goes where, and how the results help you compare repair estimate scenarios. 

## Setting up a one-variable data table 

A one-variable data table shows how a single input drives one or more result cells. You list the values you want to test in a column or row, then open the Data Table dialog and set the column input cell or row input cell to the cell the formula reads. Excel substitutes each listed value into that input and writes the matching result beside it. You can compare several repair cost outputs at once by placing their formulas across the top of the table. 

## Running a two-variable data table 

A two-variable data table varies two inputs at the same time and returns one result for each pair of values. One set of values sits down the left side and points to the row input cell, while the other set runs across the top and points to the column input cell. The single formula cell in the corner links to the result you want to watch. Each cell in the grid then shows the outcome for that combination of the two inputs. 

## Reading results for repair estimates 

Data table results let you line up repair cost outputs against several input values in one view. Comparing those outputs side by side shows which input moves the total and by how much, which helps you frame questions for a local service provider. Keep the source formula and its input cells clearly labeled so a reader can trace any figure back to its assumption. Larger tables recalculate whenever the sheet changes, so a focused set of values stays easier to read. 

## Questions about Excel sensitivity analysis 

### How do I do a sensitivity analysis in Excel with one variable? 

A one-variable sensitivity analysis in Excel uses the Data Table command under What-If Analysis. You enter the test values in a row or column, select the table range, and set the matching row input cell or column input cell. Excel then recalculates the formula for each value and fills in the results. 

### Can an Excel data table handle two variables at once? 

Yes, a two-variable data table in Excel varies two inputs together and returns one result per pair. You place one value set down the side and the other across the top, then assign the row input cell and the column input cell. The corner cell holds the formula that links to your result. 

### How does sensitivity analysis work with multiple variables in Excel? 

Sensitivity analysis with multiple variables in Excel is handled by building a separate data table for each pair of inputs you want to test. A single data table holds one or two input cells, so more variables mean more tables. Each table isolates two inputs while the others stay fixed. 

### What is the difference between the row input cell and the column input cell? 

The row input cell and the column input cell tell Excel which formula input receives the values in your table. The row input cell takes the values across the top row, and the column input cell takes the values down the left column. A one-variable table uses only the cell that matches the direction of your value list.
