Std in matlab different from stdevp in excel
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Akzeptierte Antwort
Thomas
am 15 Nov. 2011
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 Kommentar
Allen
am 1 Mai 2018
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.
Weitere Antworten (1)
Daniel Shub
am 15 Nov. 2011
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.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!