Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove outliers when calculating safety stock?

573145Dec 7 2012 — edited Dec 7 2012
I have a table with the following values used in calculating safety stock. For the calculation will be as good as possible, we need to remove the outliers. The question is how I do to remove them. In the example below, I would remove the value 30 and 137 165 as they differ very extreme.
Mtrl		Quantity	YearWeek
Label1	        3 100		1240
Label1		1 984		1241
Label1		5 670		1242
Label1		30		1243
Label1		3 888		1244
Label1		1 651		1245
Label1		1 881		1246
Label1		1 985		1247
Label1		3 240		1248
Label1		980		1249
Label1		137 165		1250
This post has been answered by Frank Kulash on Dec 7 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2013
Added on Dec 7 2012
3 comments
2,265 views