Results 1 to 5 of 5

Thread: How to type X bar in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    24

    How to type X bar in Microsoft Excel

    How can I type the character x bar (for the statistical mean) into an excel spreadsheet? I can do it in a word document, but not in an excel sheet.

  2. #2
    Join Date
    Jun 2011
    Posts
    798

    Re: How to type X bar in Microsoft Excel

    You can either insert an equation object using the Equation Editor, or you can use a font that has xbar in its character set. Two such fonts are found on web.

  3. #3
    Join Date
    Jun 2011
    Posts
    635

    Re: How to type X bar in Microsoft Excel

    Run Microsoft office 2007 and then click on insert > symbols. Choose other symbols and then click on special characters. In subsets (top right) look for diacritical marks of associations. One of the marks is called:Combining overline. It should first write the desired letter (any) before you insert special characters. for the average mean (X double bar) look Combining double Overline" and do the same.

  4. #4
    Join Date
    Jul 2011
    Posts
    640

    Re: How to type X bar in Microsoft Excel

    There's always an alternative via paint. Go on google and then find a picture of x bar. Press printscreen from the keyboard and then paste the same on paint. You can modify the picture as per your need and copy the same in excel. Just by copy pasting you can now use the X bar in your excel.

  5. #5
    Join Date
    Jul 2011
    Posts
    634

    Re: How to type X bar in Microsoft Excel

    If you are facing a formula error when you try to type the X bar then you can do one thing. You can press .capital X to get the text. Remember to add a fullstop on the start of text which not count it as any functional. More ever there are ample of symbols available you can use in its place.

Similar Threads

  1. Replies: 6
    Last Post: 17-02-2012, 12:48 PM
  2. Replies: 2
    Last Post: 27-01-2012, 07:27 PM
  3. How to create type of Counter button on Microsoft Excel
    By aMADeO! in forum MS Office Support
    Replies: 4
    Last Post: 17-01-2012, 12:56 PM
  4. Opening file type .tsv with Excel
    By Damned 2 in forum Windows Software
    Replies: 5
    Last Post: 12-01-2012, 10:42 PM
  5. Replies: 4
    Last Post: 13-02-2011, 10:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,638,249,801.08447 seconds with 17 queries