+ Reply to Thread
Results 1 to 2 of 2

Include statistics symbols in Excel, e.g. y-hat, bar x, etc.

Hybrid View

  1. #1
    Dan Donahue
    Guest

    Include statistics symbols in Excel, e.g. 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.

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...lic.excel.misc

  2. #2
    Jerry W. Lewis
    Guest

    Re: Include statistics symbols in Excel, e.g. 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 whaterver
    characters that you wish.

    Googling similar previous previous requests indicates that x-bar is
    already available in at least 2 fonts:
    Font MS Reference 1
    Math Ext
    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,

    Jerry

    Dan Donahue wrote:

    > 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.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1