ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   X-Bar in Statistical Process Control (https://www.excelbanter.com/excel-discussion-misc-queries/162203-x-bar-statistical-process-control.html)

Bob Barnes

X-Bar in Statistical Process Control
 
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob

Bernard Liengme

X-Bar in Statistical Process Control
 
Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilŕ.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob




Bob Barnes

X-Bar in Statistical Process Control
 
Bernard - Thank you - Bob

"Bernard Liengme" wrote:

Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilĂ*.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob





Jerry W. Lewis

X-Bar in Statistical Process Control
 
There are also fonts that have x-bar in their basic (non-unicode) 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

"Bernard Liengme" wrote:

Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilĂ*.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob






All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com