Two-Function Two-Variable Table Calculator
Apply two operations at once—sum, difference, product, quotient and more—to two columns of numeric data (x and y), and review the per-row results in a table and chart.
Input
Column x (separate by line breaks or commas)
Column y (separate by line breaks or commas)
Result
Rows calculated
6
Result 1 (x + y)
Result 2 (x − y)
X axis: row number / Y axis: operation result
Results
| # | x | y | Result 1 (x + y) | Result 2 (x − y) |
|---|---|---|---|---|
| 1 | 12 | 4 | 16 | 8 |
| 2 | 18 | 6 | 24 | 12 |
| 3 | 7 | 7 | 14 | 0 |
| 4 | 25 | 5 | 30 | 20 |
| 5 | 30 | 10 | 40 | 20 |
| 6 | 16 | 8 | 24 | 8 |
Result column summary
| Statistic | Result 1 (x + y) | Result 2 (x − y) |
|---|---|---|
| Valid count | 6 | 6 |
| Sum | 148 | 68 |
| Mean | 24.6667 | 11.3333 |
| Min | 14 | 0 |
| Max | 40 | 20 |
How it works
- Enter the same number of values in column x and column y. Line breaks, commas and spaces all work as separators, and tokens that cannot be read as numbers are ignored.
- Choose Operation 1 and Operation 2, and both operations are applied at once to each (x, y) pair, producing the Result 1 and Result 2 columns.
- Beyond sum, difference, product and quotient, you can choose from operations such as power, average, greater/smaller value, hypotenuse (√(x² + y²)) and remainder.
- Rows where the divisor is 0 in division or remainder, or where the combination cannot be computed, show "—" and are excluded from the chart and summary.
- When x and y have different counts, the calculation matches the shorter count and the extra rows are not used.
- Result 1 and Result 2 are overlaid in a line chart so you can compare the difference and trend of the two operation results at a glance.
Related calculators
Flash Shooting Distance
HobbyCalculate the ideal shooting distance to your subject from a flash unit's guide number, aperture and ISO.
Open calculator →Flash Aperture Calculator
HobbyCalculate the correct f-stop for flash photography from guide number, distance, and ISO. Instantly see the nearest standard f-stop and the correct distance for each aperture.
Open calculator →Lens Focal Length Calculator
HobbyEstimate the lens focal length (mm) and 35mm equivalent you need from your subject distance, real size, and sensor width.
Open calculator →Camera Angle of View Calculator
HobbyEnter a lens focal length and image sensor size to instantly calculate how wide a scene the camera captures: the horizontal, vertical, and diagonal angle of view. Includes presets for full frame, APS-C, Micro Four Thirds and more (plus custom sensor sizes) and shows the 35mm equivalent focal length too.
Open calculator →