Interval & Boxplot
The Interval and Box plot contains the following excel calculations:
| Value | Excel formula |
|---|---|
| Average | AVERAGE (serie) |
| SampleSize (#) | COUNT ( series) |
| StDev | STDEV.S (serie) |
| Confidence Ref | TINV( 0,05; Sample Size -1) |
| Margin of error | Confidence Ref * (StDev / SQRT( SampleSize) |
| 95% CI Lower Bound | Average – Margin of Error |
| 95% CI Upper bound | Average + Margin of Error |
| Median | MEDIAN (serie) |
| 1st Quartile | QUARTILE.EXC (serie; 1) |
| 3st Quartile | QUARTILE.EXC (serie ; 3) |
| Minimum | MIN (serie) |
| Maximum | MAX (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.
