I. The range of deviation is different

1. stdev: estimates the standard deviation based on the sample.

2. stdevp: is a computer function that calculates the standard deviation based on the entire sample population given in the form of parameters.

2, the role of different

1, stdev: standard deviation reflects the degree of dispersion of values relative to the mean (mean).

2, stdevp: assuming its parameters for the entire sample overall. If the data represent samples within the sample population, STDEV should be used to calculate the standard deviation.

Three, the characteristics of different

1, stdev: in Excel 2003 and higher versions of Excel to illustrate the way the function is used, and compare the results function of Excel 2003 and higher versions of Excel in earlier versions of Excel when used in the STDEV results.

2, stdevp: return its value contained in the Excel worksheet and will be specified in its parameters or STDEVP parameters of an example of the sample standard deviation.

Baidu Encyclopedia - STDEVP function

Baidu Encyclopedia - STDEV