Std Dev of a set of numbers

J

jhowk

I am trying to find the average and std dev for each of five different
manufacturing lines. The data is all in the same column. I'm thinking an if
statement is the way to go but can't quite get it to work. Any ideas?
 
K

KARL DEWEY

Why do you think you should use an IF statement? Post what you are trying.

Why not this simple query?

SELECT Avg([Change Requests].x) AS AvgOfx, StDev([Change Requests].x) AS
StDevOfx
FROM [Change Requests];
 
Top