The X Bar symbol is used in statistics frequently. Whenever working with Excel, you may face a situation where you will need to write X Bar. The focus of this article is to explain how to write X Bar in Excel.
How to Write X Bar in Excel: 3 Easy Ways
Here, I have taken the following dataset to explain this article. It contains some letters. You will need to write their bars. I will explain how you can write X Bar in Excel in 3 easy ways.
1. Use Symbol Command to Write X Bar in Excel
In this first method, I will explain how you can use the Symbol command to write X Bar in Excel.
Steps:Â
- Select the cells where you want to write the X Bar. Here, I selected the range C4:C8.
- Go to the Home tab from the Ribbon.
- Click on the drop-down option for Font.
- Next, select Arial as the Font.
- Select cell C4 and write X.
- Next, go to the Insert tab and select Symbol.
- The Symbol dialog box will appear.
- Select the drop-down option for Font and select Arial.
- Click on the drop-down option for Subset.
- After that, select Combining Diacritical Marks.
- Select Combining Overline and press Insert.
- Select Close in the dialog box.
- Now, you will see that you have written X Bar in Excel.
- Next, write the Y Bar in the same way.
- After that, select the cells where you want to write bars.
- Go to the Home tab and click on the drop-down option for Fill.
- Further, select Flash Fill.
- Click on the Flash Fill Options.
- Then, select Accept suggestions.
- Finally, you will get the desired output.
Read More: How to Insert Sign in Excel Formula
2. Employ the Equation Feature to Insert X Bar in Excel
You can also use the Equation feature in Excel to write the X Bar.
Steps:
- Go to the Insert tab and select Equation.
- Next, select Accent from the Equation tab.
- Select Bar from the drop-down menu.
- The equation box will appear.
- Write X or the letter you want.
- Next, double-click on the X Bar.
- Then, select Italic to remove the italic font from the X Bar.
- After that, click and drag the X Bar where you want it to be.
- Here, you can see that I have got my X Bar in Excel.
- In the end, write the other data in the same way.
Read More: How to Insert Symbol in Excel Header
3. Copy and Paste X Bar from Browser to Write in Excel
The easiest way to write X Bar in Excel is to copy it from a browser.
Steps:
- First, search for the X Bar symbol in your browser.
- Select the symbol and copy it by pressing Ctrl + C on your keyboard.
- After that, select the cell where you want the X Bar. Here, I selected cell C4.
- Then, paste the X Bar in the formula bar by pressing Ctrl + V on your keyboard.
- Next, press Enter and you will get the X Bar.
- Finally, write bars for other letters in the same way.
Read More: How to Insert Symbol in Excel FooterÂ
How to Write P Hat in Excel
In this section, I will show you how you can write P Hat in Excel. I will use the Symbol feature for this section.
Steps:
- Select the cells where you want to write the symbols.
- Then, go to the Home tab.
- Next, select Arial as the Font.
- Select the cell where you want to write P Hat.
- Then, write P in the selected cell.
- Next, go to the Insert tab.
- Next, select Symbol.
- The Symbol dialog box will appear.
- Select Arial as Font.
- Choose Combining Diacritical Marks as the Subset.
- Next, select Combining Circumflex Accent and press Insert.
- Then, select Close.
- After that, you will see that you have written P Hat in Excel.
- Lastly, write the other symbols by following the steps from Method 1.
Practice Section
Here, I have provided a practice sheet for you to practice how to write X Bar in Excel.
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
So, you have reached the end of my article. Here, I tried to cover how to write X Bar in Excel in 3 easy ways. I hope this article was helpful to you. For more articles visit our website. If you have any questions, feel free to let me know in the comment section below.
