Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan Donahue
 
Posts: n/a
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Include statistics symbols in Excel, e.g. y-hat, bar x, etc.

While it is true that Excel does not have specialized statistical symbols built into its character set, there are ways to include them in your analysis. Here are a few options:
  1. Use Unicode characters: Many statistical symbols are included in the Unicode character set, which means they can be inserted into Excel cells like any other character. For example, the x-bar symbol can be inserted by typing "U+0304" after the x character (i.e. "x̄"). To insert a Unicode character, first make sure your font supports it, then go to the Insert tab, click on Symbol, and select More Symbols. From there, you can browse or search for the symbol you need.
  2. Use custom number formats: Excel allows you to create custom number formats that can include symbols, such as the x-bar or y-hat. To create a custom number format, select the cell or range of cells you want to format, then right-click and choose Format Cells. In the Format Cells dialog box, go to the Number tab and select Custom from the Category list. In the Type field, enter a format code that includes the desired symbol. For example, to format a cell with an x-bar symbol, you could use the code "0.00_);(0.00);x̄".
  3. Use conditional formatting: If you want to highlight certain values in your data based on statistical criteria, you can use Excel's conditional formatting feature. For example, you could set up a rule that highlights any values above or below a certain threshold with a symbol like an arrow or a star. To create a conditional formatting rule, select the cells you want to format, then go to the Home tab and click on Conditional Formatting. From there, you can choose from a variety of pre-defined rules or create your own.

While it would certainly be convenient if Excel included all the specialized statistical symbols in its character set, there are workarounds available that can help you achieve the same result.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel File in Use Notification Missing?? JoD317 Excel Discussion (Misc queries) 6 April 19th 05 02:33 PM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 02:08 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 01:02 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"