statiscal symbol (the mean of a sample -- x with a bar on top).
How do I make the sample median symbol in excel?
Does "bar" and "hat" mean the same thing?
Videos
Perhaps more of a meta-statistics question than a statistics question, but I've been trying to understand the origins of the conventional symbols used in statistics and can't find any good sources. The two most common ways to distinguish a parameter from an estimator seem to be either using roughly equivalent Greek and Latin characters or hat. I've seen both 'π' and 'p' used to represent population proportions (though 'p' is definitely more common in introductory courses) and I've seen 'π' used often as a function in Bayesian statistics. Hat seems to be the preferred method of denoting an estimator for any new methods/unestablished/'non-canonical' statistics. Both 's' and 'σ' make a lot of sense, and 'μ' makes sense for population means, so where on earth did 'x̄' come from? Was 'm' already being used elsewhere? Did it come about before these conventions were established? I'm aware the 'X' is the goto for random variables and bar is generally used to denote means, but why? Why are there competing conventions, anyways?
I am trying to locate a statiscal symbol (the mean of a sample -- x with a bar on top). I have searched the symbols alternatives until my eyes are blurring. I can find most all the other symbols for statistics, but this one is "hiding" - I hope.
Look here:
- Insert tab
- Text group>Symbol icon
- On the Symbols tab, from the Font drop down select: MS Reference Sans Serif
- Near the bottom right side of the User form from the From drop down select: Unicode (Hex)
- In the Character code box enter: F7C2
There you go! 3 styles to choose from.
--
Biff
Microsoft Excel MVP
As there is the possibility of using any letter averaged, this symbol is created in XL using Insert - Object - Microsoft Equation 3.0 Personally, I use this whenever I need to create any math equation beyond a simple "2+3=5" scenario.