Formulas and Functions
આ કંટ્રોલમાં ફેરફાર કરવાથી આ પેજ ઑટોમૅટિક રીતે અપડેટ થઈ જશે.

SUMXMY2

The SUMXMY2 function returns the sum of the squares of the differences between corresponding values in two collections.

SUMXMY2(set-1-values, set-2-values)

set-1-values: A collection containing the first set of number values.

set-2-values: A collection containing the second set of number values.

Example

Given the following table:

A

B

1

2

7

2

9

5

3

3

6

4

11

8

5

1

12

6

5

9

=SUMXMY2(A1:A6, B1:B6) returns 196, the sum of the squares of the differences of the values in set-1-values (the collection A1:A6) and the values in set-2-values (the collection B1:B6). The formula for the first such difference is (A1 - B1)2 or (2 - 7)2, which is 25.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
મદદરૂપ થયું?
અક્ષરની સીમા 250
મહત્તમ અક્ષરની સીમા 250 છે.
તમારા પ્રતિસાદ બદલ ખૂબ ખૂબ આભાર.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.