• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Typing statistical symbols like X-Bar (X̅) in Excel (Mac)


New Member
How do I type statistical symbols like X-Bar (X̅) in Excel. I also would like to type Y-Bar, d-bar, and p-hat. I am using Mac Excel 16.29.




Excel Ninja
Few ways to do it...

Type whatever the character you want in cell.
Go to Insert ribbon tool -> Symbols -> Symbol.
Set Font to Arial Unicode MS.
For Character code: for bar, use 0305, for hat use 0302.

Hit insert. It will combine whatever character you typed with the diacritical marks.

Use Insert -> Symbols -> Equation.
Enter your equation, using Accent to add Bar/Hat, while having character highlighted.
Note that this will be shape object and not in cell.

3. My preferred method in most cases.
Have list in UTF-8 text file. Copy and paste as needed.