STDEV calculates incorrect values

[#1]

Hi all,

I'm working on report which should represents item consumption in last 52 weeks. I have data loaded from our database in format which you can see in attached excel file on sheet1(this is export from my QV).Where OBITNO is an item number and radek is a week number. Numbers represent consumption of item in each week(QTY). I calculate STDEV for each item with standard STDEV function: stdev(QTY). I have export sample of 500 items to excel and I found out that stdev for approximately 70 items is calculated incorrectly in QV. In attached file you can find comparsion for 18 items(Sheet2). Does anyone have any idea what I'm doing wrong and how to correct it? Many thanks in advance.

[sinanozdemir]

Hi,

I got the same results as the Excel STDEV function:

In both straight and pivot tables, I used Stdev() function:

Hope this helps.

[#3]

Hi,

Could you please attach your test file here? Maybe it will help me to resolve this issue. Thanks in advance.

[sinanozdemir]

There you go.