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.
Related Articles
- How to Insert Tick Mark in Excel
- How to Insert Dollar Sign in Excel Formula
- How to Put Sign in Excel Without Formula
- How to Put Equal Sign in Excel without Formula
- How to Insert Rupee Symbol in Excel
<< Go Back to Mathematical Symbols in Excel | Insert Symbol in Excel | Excel Symbols | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!