A quick rule to remember: bars are averages while hats are estimates.īut actually typing any of these statistical symbols in Excel can be a bit tricky. Using a hat with any symbol – be it an x-hat or a p-hat – indicates an estimated value. If you want to learn more about how to crunch the numbers, here’s how to find X bar.

Once there, your x-bar symbol should appear. Pick “ Combining Overline” from the list of special characters. From the Subset drop-down menu, select Combining Diacritical Marks.ħ. In the Symbol dialog box, switch to the Symbols tab.Ħ. In the Symbols group, hit the “ Symbol” button.ĥ. Enter “x” into any empty cell – if you want to type a y-bar, enter “y” instead (you get the drill).Ĥ. Since this symbol is nowhere to be found on your keyboard, typing it involves a series of simple steps:ġ.

If you’re looking to master the art of working with statistical symbols, here’s how you can create them. While using statistical symbols might seem like a daunting task for newbies, in reality, you don’t even need to use functions or complex formulas to pull off the task.Īn x-bar and y-bar refer to the arithmetic means of x and y values.įor those looking for a quick solution, just copy and paste those symbols into your worksheet: How To Type X-bar (X̅), Y-bar (Y̅), R-bar (R̄), and Z-bar (Z̄) How To Type X-bar (X̅), Y-bar (Y̅), R-bar (R̄), and Z-bar (Z̄).

X double bar symbol microsoft word