AnsweredAssumed Answered

Simple standard deviation (Excel's STDEV.S)

Question asked by ultranix on Dec 9, 2013
Latest reply on Dec 10, 2013 by ultranix

Title

Simple standard deviation (Excel's STDEV.S)

Post

     Hey, I've encountered, that Filemaker's StDev function uses such formula:

     While Excel's STDEV.S (the function i try to implement) uses different formula: 

     I first tried to search this forum, came up with a thread , downloaded the latest version of example file and i need the result, which is achieved by sSTDv field (summary, option: Standard deviation of, field: Hours), i just use not the main table (BASE), but occurence of it (BASE_3Months), so i cannot have summary field on table occurence, just on the main table.

     How can i solve this?

      

Outcomes