Stdev In Excel & Access

[Guest]

I have a set of numbers which gives different results when I call the
function stdev from excel and access.

2000.0068, 2000.0069, 2000.0068, 2000.0070, 2000.0068,
2000.0068, 2000.0067, 2000.0068, 2000.0068, 2000.0068

I get like 0.0001117 from Access but 0.0000788 from Excel. Why is that so?
Is there a way I can make Access to use the calculation method in Excel?

Thanks in advance.

 

[Jeff Boyce]

Airkon

I don't get that StDev in Excel (I get .0000863167). Is there a chance you
are using something other than the sample standard deviation function?
Excel offers 4 different "stdev" functions, Access offers two.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

For Excel, I just use the =StDev(A1:A10) and Access, a query to calculate.
Tested again with those values but still getting the same results.

 

[Jeff Boyce]

Airkon

"... a query to calculate"

We're not there. We don't know what formula you used to do that
calculation.

And there's still the discrepancy between what number your copy of Excel
generated with =StDev() and the number I got with my copy, using =StDev()...

Consider posting the SQL of your query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

This is my code for the query in SQL. For Excel, I dun see how we can get a
different result.... strange.

SELECT Cal_StDev.ReportID, StDev(Cal_StDev.R) AS SD
FROM Cal_StDev
GROUP BY Cal_StDev.ReportID;