keisoku

Two-Variable Function Calculator (Combine Two Columns)

Apply a two-variable operation such as sum, difference, product, quotient, power, Euclidean distance, or average to two columns of numbers (x and y) at once, and view each row's result plus the total and average in a table.

Input

Operation

Choose the two-variable operation applied to each row of column x and column y.

Separate values with line breaks, commas, or spaces. Column x and column y must have the same number of entries. Non-numeric tokens are removed automatically.

Result

Sum of the result column

67

x + y (sum) applied to 5 rows

Data rows

5 rows

Result total

67

Result average

13.4

Per-row results

Valid 5 / 5 rows

RowxyResult
1347
251217
38614
4101020
5279

How it works

  • Enter the same number of values into column x and column y, and the chosen operation (sum, difference, product, quotient, power, Euclidean distance, or average) is applied to every row to build a new result column.
  • Input accepts line breaks, commas, or spaces as separators, and tokens that cannot be read as numbers are removed automatically. You can paste a single column straight from a spreadsheet.
  • Rows where x÷y has y equal to 0, or where the result becomes infinite or not-a-number, are shown as "—" and excluded from the total and average (the excluded count appears in the results panel).
  • √(x²+y²) is the Euclidean distance (the hypotenuse of a right triangle), representing the magnitude when x and y are treated as quantities in two perpendicular directions.
  • The total and average cover only the rows that were computed successfully. Values are rounded to six decimal places for readability, but the internal calculation is performed without rounding.
  • If column x and column y have different counts, no calculation is performed and each count is shown so you can check for unpaired rows.