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.