Explanation
A Data Table shows how changing one or two input variables affects a formula result.
One-Variable Data Table
Example:
Calculate profit for quantities:
100, 200, 300, 400, 500
The Data Table shows the corresponding profit for each quantity.
Two-Variable Data Table
Analyze profit based on:
- Quantity
- Selling Price
Example:
|
Quantity / Price |
₹900 |
₹1,000 |
₹1,100 |
|
100 |
— |
— |
— |
|
200 |
— |
— |
— |
|
300 |
— |
— |
— |
Practice
Create a two-variable Data Table for Quantity vs Selling Price.