DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel
The following article introduces you to the DEVSQ function - one of the functions in the statistical function group is very popular in Excel.
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 1
Description: Returns the sum of squares of deviations of data points from the sample mean.
Syntax: DEVSQ (number1, [number2], .)
Inside:
- number1, number1: The value you want to sum the squares of their deviations, where number1 is the required value, from number1 onwards is optional and contains up to 255 number arguments .
Attention:
- The argument must be either a number or a reference array that contains numbers.
- If text or logical values are typed directly into the argument list -> it is still calculated in the function.
- If the reference form or array containing logical values and text will be ignored, the case of the value of 0 is still calculated.
- The function will give an error if the arguments are text or an error value cannot be converted into a number.
- The function using the equation to calculate the square of deviation is:
[DEVSQ = sum {{{left ({x - overline x} right)} ^ 2}}]
For example:
Calculate the sum of squares of deviations of data points in the table below:
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 2
- In the cell to calculate enter the formula : = DEVSQ (C6: C10)
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 3
- Press Enter -> the sum of squares of deviations of data points is:
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 4
- Where the data points are non-adjacent cells. For example, calculate the sum of squares of deviations of data points in cells C6, C8, C10 -> enter the formula: = DEVSQ (C6, C8, C10)
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 5
Above are instructions and some specific examples when using DEVSQ function in Excel.
Good luck!
You should read it
- DEVSQ function in Excel The function returns the sum of squares of deviations between data points from their average
- COVARIANCE.S function - Returns the covariance pattern, the average of product deviations for each pair of data points in two data sets in Excel
- COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel
- STDEV function - The function of estimating standard deviations based on a sample in Excel
- ZTEST function - Returns the probability value on one side of the z test in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- SLOPE function - The function returns the slope of a linear regression line through data points in Excel
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
- AVEDEV function - The function returns the average absolute deviation of data points from their midpoint in Excel
- TTEST - Returns the probability associated with a Student's t-Test in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
- STDEVP function - The function of calculating standard deviations in Excel
May be interested
The EXPON.DIST function - The function returns the exponential distribution in Excel
F.DIST - The function returns the probability distribution F in Excel
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
F.INV function - The function returns the inverse of the probability distribution F in Excel
F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
F.TEST function - The function returns the result of the F - test in Excel