lwhuang 發表於 16-7-1 21:39

標準差對應 Excel

AmIBroker StDev is Excel's STDEVP

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

so in AMiBroker
function ExcelStdev( array, N )
{
return StDev( array, N ) * sqrt( N / (N-1) );
}

function ExcelStdevP( array, N )
{
return StDev( array, N );
}

頁: [1]
查看完整版本: 標準差對應 Excel