how to find the sum of squares (with an offset value) in excel.
Suppose i have a table - a1 - a10, then b1 to b10 and so on till e1-e10.
I want to output in a11 the following -
sum of ((a1-<number of my choice>)^2 : (a10-<number of my choice>)^2))
Similarly for b11 through e11. So the answers will be = (4.5-3)^2 +(5.87-3)^2 + (1.25-3)^2 + and so on, 3 here being the offset value.
each time I want the 11th row to output the sum of the squares of the (number minus an offset value) along a column
How to do it. Does sumsq have a way of entering the offset value
Bookmarks