SOLVED - stdev of a count

[#1]

Good evening,

I have a table which are recorded the numbers of requests, I created a line graph counting the records.

Putting the average was easy, but I am not aware calculate the standard deviation, the day had more and less records.


Any tips?


Hugs

Gledson

[#2]

I suspect you want to display a confident interval ?

You can add lines in your charts as new expressions :

To calculate the standard deviation , try this =Stdev( ALL aggr( COUNT( NumOco) , DataOco) )

In your chart, add new expression :

=AVG ( ALL aggr( COUNT( NumOco) , DataOco) ) + 1.96 * Stdev( ALL aggr( COUNT( NumOco) , DataOco) )

for the upper CL

JJ

[#3]

Thanks Jean-Jacques Jesua !

Works fine, thans a lot!!!

Hugs

Gledson