SUMX2PY2

Formulas / SUMX2PY2
Calculate the sum of the sum of squares of corresponding values in two arrays.
=SUMX2PY2(array_x,array_y)
  • array_x - required argument which is the first set of numbers in a range or array
  • array_y - required argument which is the second set of numbers in a range or array

Examples

  • =SUMX2PY2({1,2},{1,2})

    The SUMX2PY2 function is used to sum the products of two ranges. For example, this will return 10. This is because it calculates the product of each corresponding element in the two ranges, and then adds the results together. In this example, 1 * 1 = 1, 1 * 2 = 2, 2 * 1 = 2, and 2 * 2 = 4. When added together, these results equal 10.

  • =SUMX2PY2({1,2,3},{1,2,3})

    This will return 28. This is because it calculates the product of each corresponding element in the two ranges, and then adds the results together. In this example, 1 * 1 = 1, 1 * 2 = 2, 1 * 3 = 3, 2 * 1 = 2, 2 * 2 = 4, 2 * 3 = 6, 3 * 1 = 3, 3 * 2 = 6, and 3 * 3 = 9. When added together, these results equal 28.

Summary

The SUMX2PY2 function is used to calculate the sum of the sum of squares of two data sets. It can be used with array constants or ranges, with array_x being the first range and array_y being the second.

  • The SUMX2PY2 function takes two arguments which can be constants, cell references, or ranges and returns the sum of the sum of squares of values in these two arrays.
  • The arguments for the SUMX2PY2 function can be of mixed types.

Frequently Asked Questions

What is the SUMX2PY2 function?
The SUMX2PY2 function is a mathematical formula that calculates the sum of the sum of squares of corresponding values in two arrays. This is a common term used in many statistical calculations.
What elements does the SUMX2PY2 function ignore?
The SUMX2PY2 function ignores text, logical values, and empty cells.
What is the result of the SUMX2PY2 function?
The result of the SUMX2PY2 function is the sum of the sum of squares of corresponding values in two arrays.
What are some examples of when the SUMX2PY2 function can be used?
The SUMX2PY2 function can be used in many statistical calculations, such as:
  • Calculating the variance of a set of data
  • Testing for correlation between two data sets
  • Calculating the standard deviation of a set of data

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.