Statistical functions: stdev, stdeva, stdevp, stdevpa, steyx
Excel Function STDEV
The STDEV() function is used to calculate the standard deviation of a set of values.
The standard deviation is a measure of deviation of set of values from the average value.
The syntax of the function is as given below:
STDEV(num1,num2,�num255)
Excel Function STDEVA
The STDEVA() function is used to calculate the standard deviation of set of values.
The thing is , this function can include text, TRUE or FALSE values also unlike STDEV() which takes only numbers.
The syntax of the function is as given below:
STDEVA(value1,value2,..)
Excel Function STDEVP
The STDEVP() function is used to calculate the standard deviation of entire set of population.
This differs from STDEV() in the sense that, STDEV() calculates for a sample set of values only.
The syntax of this function is given below:
STDEVP(num1,num2,�num255)
Excel Function STDEVPA
The STDEVPA() function is used to calculate the standard deviation of entire set of population.
The thing is , this function can include text, TRUE or FALSE values also unlike STDEVP() which takes only numbers.
This differs from STDEVP() in the sense that, STDEVP() calculates SD of entire population of numbers only.
The syntax of this function is given below:
STDEVPA(value1,value2,..value3)
Excel Function STEYX
The STEYX() function is used to calculate the standard error for the line of best fit.
This calculation depends on a given set of x and y values.
The syntax of the function is as given below:
STEYX(x_array,y_array)