Dave Bruns

The Excel SUMXMY2 function returns the sum of squares of differences between corresponding values in two arrays. The "m" in the function name stands for "minus", as in "sum x minus y squared". 

SUMXMY2 takes two arguments, array_x...Read more

The SUMX2MY2 function returns the sum of the difference of squares of corresponding values in two arrays. The "m" in the function name stands for "minus", as in "sum x² minus y²". 

SUMX2MY2 takes two arguments, ...Read more

The SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. The "p" in the function name stands for "plus", as in "sum x² plus y²". 

SUMX2PY2 takes two arguments, array_x...Read more

The SUMSQ function returns the sum of the squares of the numbers provided. SUMSQ takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or...Read more

The INTERCEPT function returns the point at which a line will intersect the y-axis based on known x and y values. The intercept point is based on a regression line plotted with known x and y values. A regression line is a line that best fits that known data points. Use the INTERCEPT function to...Read more

The SLOPE function returns the slope of a regression line based on known y values and known x values. A regression line is a "best fit" line based on known data points.

The slope of a line is a measure of steepness. Mathematically, slope is calculated as "rise over run", or change in y...Read more

The ENCODEURL function returns a URL-encoded string composed of US-ASCII characters. URL encoding, sometimes called "percent encoding" is a method of encoding characters in a URL using only legal US-ASCII characters. Some characters cannot be part of a URL and are "reserved". Only characters...Read more