標準差對應 Excel

lwhuang

AmIBroker StDev is Excel's STDEVP

Excel StDev is StdevP multiplied by SQRT( N/(N-1) )

so in AMiBroker

1. function ExcelStdev( array, N )
   
2. {
   
3.   return StDev( array, N ) * sqrt( N / (N-1) );
   
4. }
   

複製代碼

1. function ExcelStdevP( array, N )
   
2. {
   
3.   return StDev( array, N );
   
4. }

複製代碼