Explanation

A Data Table shows how changing one or two input variables affects a formula result.

It is useful for comparing multiple possibilities at once.

Example

Suppose:

  • Quantity = 100
  • Cost per Unit = ₹300

Test different selling prices:

Selling Price

Profit

₹400

₹10,000

₹450

₹15,000

₹500

₹20,000

₹550

₹25,000

₹600

₹30,000

A Data Table can calculate these results automatically.

Two Types

One-variable Data Table

Changes one input.

Two-variable Data Table

Changes two inputs simultaneously.

Practice

Create a one-variable Data Table for selling prices:

₹400, ₹450, ₹500, ₹550, ₹600.