standard deviation per Article - XYZ-analysis - Help please ?
StudentNeedHelp
Member Posts: 7 Newbie
in Help
Hello everybody,
I just wanted to do an XYZ analysis, but I fail because of the standard deviation ...
This is what the simplified example looks like:
At the end I need a standard deviation per article…. But I do not know how to enter it….
So far, I have grouped the articles so that article 1 only has one entry and the quantity has 60. If I then do the standard deviation, every line comes up with 0 ...
Does anyone have any idea how I can calculate the standard deviation for each article?
Many thanks
Best regards
David
0
Best Answer
-
ceaperez Member Posts: 517 UnicornHi @StudentNeedHelp,please read the definition of standard deviation.in you sampleset you have only one sample per article, so the mean is the same number and the difference between the sample and mean is zero, so the standard deviation is zero also.
Standard deviation - Wikipedia
if you try to run the process with more than one sample per article (with different values) you will obtain a non zero standard deviation
Best0
Answers
Any idea?
best,
David