Methods for analyzing data using univariate variables in Excel tables

methods for analyzing data using univariate variables in Excel tables

1. Open the workbook, create the worksheet, and enter the data in the worksheet, and enter the formula "=sum (B3:B9)" In the B10 cell to calculate the total cost, as shown in Figure 1.

Figure 1 Creating a worksheet

2. On the Data tab, in the Data Tools group, click the Simulate Analysis button and select the Single variable solution option in the Open Drop-down list, as shown in Figure 2.

Figure 2 Selecting the "Single Variable Solver" option

3. Open the Single Variable Solver dialog box, enter the cell reference address in the target cell and the Changing cells text box, and enter the target value for the solution in the Target Value text box, as shown in Figure 3. When you finish setting up, click OK to close the dialog box.

Figure 3 setting for the single-Variable Solver dialog box

4. Excel 2013 gives the "single Variable Solver status" dialog box, and the result of the solution is displayed in the dialog box, as shown in Figure 4. Click the OK button to close the single variable solve status dialog box to complete the creation of this instance.

Figure 4 shows the solution result