Interval & Boxplot

The Interval and Box plot contains the following excel calculations:

ValueExcel formula
AverageAVERAGE (serie)
SampleSize (#)COUNT ( series)
StDev STDEV.S (serie)
Confidence RefTINV( 0,05; Sample Size -1)
Margin of errorConfidence Ref * (StDev / SQRT( SampleSize)
95% CI Lower BoundAverage – Margin of Error
95% CI Upper boundAverage + Margin of Error
MedianMEDIAN (serie)
1st QuartileQUARTILE.EXC (serie; 1)
3st QuartileQUARTILE.EXC (serie ; 3)
MinimumMIN (serie)
MaximumMAX (serie)

TINV( probability, deg_freedom) The TINV function syntax has the following arguments:

Probability The probability associated with the two-tailed Student’s t-distribution.

Deg_freedom The number of degrees of freedom with which to characterize the distribution.

Biosisto - Quality in Control

Microbiological laboratories should be able to receive reliable analysis without much overhead. A microbiological analyst must be able to focus on the primary activities, for example analysis of the sample material. Quality control should support the analyst in a logical and simple manner. By using modern information technology, process control and quality assurance are designed smarter and more effective.

Biosisto b.v.
Martin Luther Kingweg 3
9403 PA Assen, The Netherlands