Hello all,
I have several variables and I want to calculate average, standard deviation and RSD.
I can calculate average using following expression,
I can calculate RSD using two variables: sd and avgflow
=Format(Format(sd,"0.0000")/Format(avgflow,"0.000")*100,"0.00")
2. But I can't calculate the SD for my list of variables ( f1 f11 f131 f f12 f13)
this expression gives error mesage
=Stdev(f1,f11,f131,f,f12,f13)
Please assist me.
Thank you in advance.
Kind regards,
Rustam
Hello Marty,
I have tried several ways to make aggregator, but unfortunately unsuccessful.
Below is the report I am trying to calculate SD and RSD. There is a list of values that are indtroduces manualy. Based on these values IR is making calculations for f1, f2, f3, f4, f5, f6 which are actualy my variables.
I will be very gratefull for your assistance.
Kind regards,
Rustam
Hello,
Well then you likely need to do the standard deviation calculation manually. You already have the average so use that in an expression like the one below for sample-based SD. In the example, I directly used parameters but the same can be done with variables.
Marty
=Sqrt((1/(6-1))*(Val(f1-MeanVal)^2+Val((f11-MeanVal))^2+Val((f131-MeanVal))^2+Val((f-MeanVal))^2+Val((f12-MeanVal))^2+Val((f13-MeanVal))^2))
Hello Marty,
Thank you very much!!!! You helped a lot. I was asking ChatGPT for several days, but all the answers did't work(
And what you have suggested works ideally!
Now OpenLab gives the same results that validated excel.
Thank you very much, you are the best! Have a good weekend.
Kind regards,
Rustam
