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.
Download Practice Workbook
You can download the practice workbook from here.
3 Easy Ways to Write X Bar in Excel
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. Let’s explore the steps.
Steps:
- Firstly, select the cells where you want to write the X Bar. Here, I selected the cell range C4:C8.
- Secondly, go to the Home tab from the Ribbon.
- Thirdly, click on the drop-down option for Font.
- Next, select Arial as Font.
- Then, select the cell where you want to write the X Bar. Here, I selected Cell C4.
- Next, in Cell C4 write X.
- Afterward, go to the Insert tab.
- Further, select Symbol.
- Consequently, the Symbol dialog box will appear.
- Select the drop-down option for Font.
- Then, select Arial.
- Next, click on the drop-down option for Subset.
- After that, select Combining Diacritical Marks.
- Then, select Combining Overline.
- Next, select Insert.
- Afterward, 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.
- Then, go to the Home tab.
- Next, click on the drop-down option for Fill.
- Further, select Flash Fill.
- Afterward, click on the Flash Fill Options.
- Then, select Accept suggestions.
- Finally, you can see that, I have got my desired output.
Read More: How to Overline Text in Excel (4 Easy Ways)
2. Employ Equation Feature to Insert X Bar in Excel
You can also use the Equation feature in Excel to write X Bar. Let me show you how you can do that.
Steps:
- In the beginning, go to the Insert tab.
- Then, select Equation.
- Next, select Accent from the Equation tab.
- Then, a drop-down menu will appear.
- Select Bar.
- Consequently, an 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 WordArt in Excel (2 Simple Methods)
Similar Readings
- How to Insert Clipart in Excel (4 Easy Ways)
- Create Double Entry Bookkeeping in Excel
- How to Drill Down in Excel Without Pivot Table (With Easy Steps)
- Calculate Bootstrapping Spot Rates in Excel (2 Examples)
- How to Edit Document Properties in Excel (with Detailed Steps)
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. Let’s see the steps.
Steps:
- First, search for “X bar symbol” in your browser.
- Next, select the symbol and then 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 Create a Word Cloud in Excel (2 Easy Ways)
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. Let’s see the steps.
Steps:
- To begin with, select the cells where you want to write the symbols.
- Then, go to the Home tab.
- Next, select Arial as Font.
- After that, select the cell where you want to write P Hat.
- Then, write P in the selected cell.
- Next, go to the Insert Tab.
- Subsequently, select Symbol.
- Now, the Symbol dialog box will appear.
- Select Arial as Font.
- Then, select Combining Diacritical Marks as Subset.
- Next, select Combining Circumflex Accent.
- Afterward, 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.
Read More: How to Do Descriptive Statistics in Excel (2 Suitable Methods)
Practice Section
Here, I have provided a practice sheet for you to practice how to write X Bar in Excel.
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 ExcelDemy. If you have any questions, feel free to let me know in the comment section below.
Related Articles
- How to Show Menu Bar in Excel (2 Common Cases)
- Use of Task Pane in Excel (Detailed Analysis)
- How to Change 1000 Separator to 100 Separator in Excel
- Show Full Cell Contents on Hover in Excel (5 Quick Ways)
- How to Check If Value Is Between 10 and 20 in Excel
- Mark Workbook as Final in Excel (with Easy Steps)
- How to Move Data from Row to Column in Excel (4 Easy Ways)