SUMX2PY2
Formulas / SUMX2PY2Calculate 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.
Need help with Formulas?
Frequently Asked Questions
What is the SUMX2PY2 function?
What elements does the SUMX2PY2 function ignore?
What is the result of the SUMX2PY2 function?
What are some examples of when the SUMX2PY2 function can be used?
- Calculating the variance of a set of data
- Testing for correlation between two data sets
- Calculating the standard deviation of a set of data
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.