Standard deviation in Google Sheets Query

by dzieciou   Last Updated October 15, 2018 12:03 PM

I have data of jobs (A), their executions (B) and duration (C) in my Google Sheet. I have already calculated the average duration of each job with Query language:

SELECT A, B, AVG(C) GROUP BY A, B

How do I calculate standard deviation?

I found the discussion suggesting usage of ARRAYFORMULA and calculating standard deviation from original math equations but I'm looking for a simpler solution.



Related Questions




Copying values between google sheets

Updated July 26, 2018 21:03 PM