Home / Statistical Tools / Analysis Tools / Barchart / Math Details
Math Details¶
Under review — candidate for removal
The Bar Chart is primarily a visualization tool; the only non-trivial formula is the sample standard deviation option. This page is flagged for review — it may be removed if judged too thin to warrant a Math Details page.
This page gives the formulas Quantum XL uses when a Bar Chart aggregates numeric data. Each bar's height is one of the aggregation functions below (chosen in Options).
Notation¶
| Term | Description |
|---|---|
| \(x_i, w_i\) | value in a category and its frequency weight (\(w_i = 1\) when no frequency column is used) |
| \(n\) | effective count in the category, \(n = \sum_i w_i\) |
| \(\bar{x}\) | weighted mean of the category |
Aggregation functions¶
| Function | Bar height |
|---|---|
| Sum | \(\sum_i w_i x_i\) |
| Count | \(n = \sum_i w_i\) |
| Mean | \(\bar{x} = \dfrac{\sum_i w_i x_i}{\sum_i w_i}\) |
| Minimum / Maximum | smallest / largest \(x_i\) in the category |
| Median | the \(0.5\) quantile (Hyndman–Fan Type 8) |
Sample standard deviation¶
The only non-elementary option:
\[ s = \sqrt{\frac{\sum_i w_i\,(x_i - \bar{x})^2}{n - 1}} \]
Uses the \(n-1\) (Bessel) denominator; returned as blank when \(n \le 1\).
See Also¶
References¶
- Snedecor, G. W., & Cochran, W. G. (1989). Statistical Methods (8th ed.). Ames, IA: Iowa State University Press.
- Montgomery, D. C. (2013). Introduction to Statistical Quality Control (7th ed.). Hoboken, NJ: John Wiley & Sons.