Home » Food Investing Ideas » How Do You Do a Single Variable Data Table

How Do You Do a Single Variable Data Table

Chloe Bennett • • 8 min read
How Do You Do a Single Variable Data Table

Select cell B12 and type =D10 (refer to the total profit cell).Type the different percentages in column A.Select the range A12:B17. … On the Data tab, in the Forecast group, click What-If Analysis.Click Data Table.

How do you create a one variable table in Excel?

  1. Select any cell within your data set.
  2. On the Insert tab, in the Tables group, click the Table button or press the Ctrl + T shortcut.
  3. The Create Table dialog box appears with all the data selected for you automatically; you can adjust the range if needed. …
  4. Click OK.

What is a one variable data?

One-Variable Data vs. Two-Variable Data: Variable: an attribute that can be measured. One Variable Data Sets: give measures of one attribute (ex. Eye colour, height, or grade). Two Variable Data Sets: give measures of two attributes for each item in a sample (ex.

Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.