Results 1 to 3 of 3

Thread: How to add statistics symbols in Excel like y-hat, bar x, etc.

  1. #1
    Join Date
    Oct 2011
    Posts
    89

    How to add statistics symbols in Excel like y-hat, bar x, etc.

    Excel is used extensively for statistical work, but does not support specialized statistical characters. For example, the sample mean is usually written as 'x' with a bar over it, or x-bar. The equation to approximate regression is referred to as y-hat, the letter y with a caret (^) on top. I believe inclusion of all of the specialized statistical symbols in the character set would add in the presentation of statistical analysis done in Excel.

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    Re: How to add statistics symbols in Excel like y-hat, bar x, etc.

    This is a font question/suggestion, not an Excel question/suggestion. As such, it more properly belongs in a newsgroup that deals with fonts, such as comp.fonts. With a font editor, you could create a font that has whatever characters that you wish. Googling similar previous previous requests indicates that x-bar is already available in at least 2 fonts:. They are Font MS Reference 1 and Math Ext and check that you might already have. Also a multiple character approach of underscore, followed by new line (alt+enter) then X that could be adapted to y-hat.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: How to add statistics symbols in Excel like y-hat, bar x, etc.

    I know this is Microsoft Word. You just need to click on Insert > Object and you click in the list of Microsoft equation. If you do not find entrust the installation CD of Microsoft Office in your CD player, and you can choose the option to install / uninstall and looking for Microsoft Equation (normally it is in Microsoft Office Tools) it is very easy to use and it gives you all the special symbols and notations (premiums, bars, dies, braces etc ...). Just check if there is any similar option.

Similar Threads

  1. Show/Hide group symbols via shortcut in Excel
    By Saddys in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 07:19 PM
  2. Does Excel consist Telephone, Fax and Email symbols
    By Holly Dayin in forum MS Office Support
    Replies: 5
    Last Post: 25-01-2012, 07:53 PM
  3. How to get special symbols for correct sign in Excel
    By Shaina Na in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 06:07 PM
  4. Why do we need the Website statistics?
    By Tarjan in forum Technology & Internet
    Replies: 3
    Last Post: 27-11-2009, 09:59 PM
  5. Solitaire statistics
    By Wiro in forum Video Games
    Replies: 3
    Last Post: 29-06-2009, 05:34 PM

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,714,056,652.86618 seconds with 17 queries