Std in matlab different from stdevp in excel

Question

Maggie 2011-11-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21279-std-in-matlab-different-from-stdevp-in-excel

评论： DGM 2022-7-25

 I have an array of prices i calculated the standard deviation and the mean in matlab but the results are very different from what i calculated using excel. any reason why this is the case?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

DGM 2022-7-25

@Mehri Mehrnia's comment-as-answer moved here:

Hi,

Today while submitting a last minute paper, I found out that discrepancy.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Thomas 2011-11-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21279-std-in-matlab-different-from-stdevp-in-excel#answer_28047

在 MATLAB Online 中打开

I get the same answer for stddev and mean from MATLAB and Excel

a = [ 1 1 1 1 1 3 2 4 5 6 2 6 2 6 1]
>> std(a)
ans =
        2.04
>> mean(a)
ans =
        2.80

From Excel the results are

stdev(a1:a15) = 2.042407543 and mean 2.8

do not know why you are facing a discrepancy. Are you certain that you are using the same identical data sets.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Allen 2018-5-1

I have run into the same issue with standard deviation results between MATLAB and Excel. The reason is due to using STDEV.P (standard deviation of a population) instead of STDEV.S (standard deviation of a sample). Excel does not do a very good job of explaining the differences in the Tooltips, but it simplifies down to this. Unless you are certain of the need to use STDEV.P in Excel use STDEV.S or STDEV.

请先登录，再进行评论。

Answer 2

Daniel Shub 2011-11-15

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21279-std-in-matlab-different-from-stdevp-in-excel#answer_28058

There are two ways to calculate the standard deviation. In Excel these are stdev and stdevp. In MATLAB they are std(x) and std(x, 1). The difference is the normalization factor (N or N-1). Look in the documentation of each to figure out which does which.