It is Confusing because in his Query the parameter 1 does not mean that Number of samples.if you put 100 inplace of 1 still it gives the same null. as per his explanation it is not a divide by zero error

The usage of the Function is wrong in the Query.

see if we can use some thing like below it gives 0

SELECT STDEV(1) from sys.objects