Standard Deviation

HI Everyone,

I am trying to write a report that will give some insight into exceptionally large transactions that should be excluded from demand forecasting.

Essentially, I would like to bring back a list of transactions from item ledger entry that are more than 3 standard deviations from normal for that item no. Any help is appreciated.

What I think I should do is

1. list all items that have transactions within the date range
2. Use excel function stdev.p to dertmine the standard deviation for that item
3. Query the table for entry no that are >3(stdev.p)

The thing is, I have no idea how to do it.

Thanks in advance
Dan