standard deviation per Article - XYZ-analysis - Help please ?
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
Find more posts tagged with
Sort by:
1 - 6 of
61
Hi @StudentNeedHelp,
you can work with Aggregate Operator. There you have a lot of functionalities, also standard deviation.
Best
Hi @StudentNeedHelp,
working with the dataset that you shown, a possible configuration for the Aggregate Operator can be:
the aggregation attributes -> Amount
aggregation function -> standard_deviation
in group by attributes select -> Article.
please find attached a simple sample.
regards
Hi @StudentNeedHelp,
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
Best
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
Best
Sort by:
1 - 1 of
11
Hi @StudentNeedHelp,
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
Best
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
Best