Hi SMath community,

I would like to calculate the variance() and StdDev() of the second column "V(3v3)" of the attached file with 50k datapoints. Unfortunately the calculation takes forever (aborted it after 30min).

The file is an export of a circuit simulation result (gaussian tolerance distribution in LTSpice). Originally it is in .txt-Format and it seems that I have to convert it in excel to .csv-Format before I can use is. I attached both, the original LTSpice export (.txt) and the converted one from Excel (.csv).

How can I handle this in sMath?

Archiv.zip (586kb) downloaded 8 time(s).

Thanks in advance,
Marc

Edited by user 04 April 2024 02:21:02(UTC)  | Reason: Not specified

Optimizations were all set to numeric - did not help. What helped was that I substituted the statistic function variance() and StdDev with the original/native formula for the variance and standard deviation.

This speeds it up to around 1s.

Don´t know what happens inside the functions of the statistic plugin but it is very slow.



Thanks

Confirmed, the bottleneck seems to be in the final ouput processing to return the result from the equation [f.e. 1/{n-1}*sum(((el(X,i)-mean)^2),i,1,n)) for StdDev]; no idea not sure what could be the cause...