Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 21st 07, 09:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 1
Default How to type X bar in 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   Report Post  
Old June 21st 07, 09:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 837
Default How to type X bar in 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

xbar is Alt-0214 in the Math Ext font from
http://www.columbia.edu/~em36/wpdos/wptoword.html

xbar is Alt-0120 in the MS Reference 1 font

Jerry

"Henrique" wrote:

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.

  #3   Report Post  
Old June 22nd 07, 02:16 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default How to type X bar in Excel

You can use the technique described here to add a bar:

http://www.contextures.com/xlfaqFun.html#bar

Henrique wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #4   Report Post  
Old August 16th 13, 04:28 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 1
Default

Quote:
Originally Posted by Henrique View Post
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.
Create x bar using inset/equation/accent, then select the x bar and copy and paste into a cell from within the cell. You will end up with something close, or you could just use the equation box.


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 will not let me type any characters....I can type in Word. deholly Excel Discussion (Misc queries) 1 March 17th 06 11:34 AM
Excel will not let me type any characters....I can type in Word. deholly Excel Discussion (Misc queries) 0 March 17th 06 11:20 AM
how to change all the words of one type(Gunsuh type)to another metumevlut Excel Discussion (Misc queries) 2 November 11th 05 04:29 PM
Adding new 'Type' to Format->Number->Time->Type Chip Pearson Excel Discussion (Misc queries) 5 September 26th 05 08:45 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 6th 05 12:25 AM


All times are GMT +1. The time now is 08:41 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017