I am taking a statistics class and am doing my homework in Excel. The

teacher want us to show our work and I am trying to locate the X bar symbol

(X with a line on top of it) or create it. In Word there is a formula

({eq(x,-)}. Is there something in Excel that works?

teacher want us to show our work and I am trying to locate the X bar symbol

(X with a line on top of it) or create it. In Word there is a formula

({eq(x,-)}. Is there something in Excel that works?

- How do you get an "X-bar" symbol in Excel?
- X Bar Symbol
- How do you get the X bar mathematical symbol?
- X-Bar in Statistical Process Control
- X Bar and R chart
- Include statistics symbols in Excel, e.g. y-hat, bar x, etc.
- Include statistics symbols in Excel, e.g. y-hat, bar x, etc.
- Stat symbols
- I need to be able to type using Statistical symbols.
- How to make a stacked bar chart using time?
- Formatting Cell Text
- Placing category values on X axis
- How to make a stacked bar chart using time?
- Data series and LegendEntries order reversed in clustered bar chart
- Calculating data inside Pivot Tables
- Excel SQC add-ins
- Coloring issue.....................................Simple but can't find the option!!!!!!!!!!
- Copy column range of "single word" cells with spaces to a single c
- Can't create dynamic charts
- Copy column range of "single word" cells with spaces to a single c
- Displaying mathematical characters
- Array formula + Indirect Reference
- Partly unable to insert rows and cols
- Creating file to pull out data and copy formulae in rows

Excel. Copying it from Word doesn't appear to work either. DOes anyone know

how to do this?

teacher want us to show our work and I am trying to locate the X bar symbol

(X with a line on top of it) or create it. In Word there is a formula

({eq(x,-)}. Is there something in Excel that works?

bar symbol. Does anyone know if there is one available?

TZ

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

"X-Bar"??

TIA - Bob

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

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

Am trying to enter Xbar (X with a line above), Rbar (as x bar) and Xbarbar (X with 2 lines above) etc.

Can't believe that I am the first to try to do this so what is the answer guys?

Please help.

I'm trying to compute the mean and standard deviation of the sampling distribution.

Mu = 89.34

Sigma = 7.74

n= 35

Thanks!

To make this work more easily I inserted a column with dummy labels (a

through f). The cell above a and to the left of Dr X is blank.

Dr X Dr Y Dr Z

a 2:03 3:00 1:00

b 0:20 2:00 0:30

c 0:40 1:00 0:30

d 2:45 1:00

e 0:15

f 2:10

Select the range and make a stacked bar chart, with the series in rows.

The doctors are linked by the series (series "a" has a value for each,

for example).

- Jon

-------

Jon Peltier, Microsoft Excel MVP

Peltier Technical Services

Tutorials and Custom Solutions

http://PeltierTech.com/

_______

Father Guido wrote:

> Hi,

>

> I have the following data to plot on a stacked bar chart, and

> displayed as time.

>

> Dr X Dr Y Dr Z

> 02:03 03:00 01:00

> 00:20 02:00 00:30

> 00:40 01:00 00:30

> 02:45 01:00

> 00:15

> 02:10

>

> 08:13 07:00 02:00

>

> This is time in hours and minutes.

>

> I need the result to look like this...

>

> Dr.X bar [02:03][00:20][00:40][02:45][00:15][02:10]

> Dr.Y bar [03:00][02:00][01:00][01:00]

> Dr.Z bar [01:00][00:30][00:30]

>

> where [02:03] represents a colour to represent 2 hrs & 3 mins etc.

>

> If I just select the Dr. X data I can get a stacked chart, but as soon

> as I add either Dr. Y or Dr. Z data the whole chart turns into one

> large bar, not three separate bars. I can of course create three bars

> if I just plot the totals, but I want the individual parts of the

> total (stacked bar) to show separately. What do I need to do to keep

> these three sets of data separate? I'm using Windows XP with Excel XP.

>

> Thanks in advance!!!

>

> Norm

I am using Excel 2007. I want to put into a cell the symbol for the mean of a set of x values ie x-bar or x with a line over it. One way is to go to Word and use the equation builder, then copy it into Excel. However that restricts me to the default equation font, and I would prefer to be able to use my own choice of font.

Is there a way to do this within Excel (perhaps by somehow combining two symbols, the x and a raised bar)? Alternatively can I do it within Word, without using the equation builder, and then copy it to Excel?

Thanks in advance.

Robert

On Office 07 (I believe) I am trying to make a few simple bar graphs. They consist of various economic indicators for various nations. Example:

Country|Score USA|10 Canada|8 France|7etc.

When I attempt to produce a bar graph of the data, the Country field is listed as the Y axis and the Score on the X (bars grounded on the left side of the screen pointing right). For my use it would make more sense to have them the other way (bars on the bottom of the screen pointing up).

The most apparent logical solution was the "switch rows/columns" function. However, this merely keeps the bars on the left and changes the appearance of the bars, as well as removing the bars for entries with a score of 0.

My second attempt was to place the data in rows rather than columns:

USA|Canada|France 7| 5| 7which still produced the same graph

As far as I can tell, from Microsoft help, searching this forum, and the broader internet, the problem is that I need to make the category variable (Country) on the horizontal axis, and do the opposite to the value variable. I have not been able to find a logical way to make that occur either online or through experimentation. How can I fix this

I have the following data to plot on a stacked bar chart, and

displayed as time.

Dr X Dr Y Dr Z

02:03 03:00 01:00

00:20 02:00 00:30

00:40 01:00 00:30

02:45 01:00

00:15

02:10

08:13 07:00 02:00

This is time in hours and minutes.

I need the result to look like this...

Dr.X bar [02:03][00:20][00:40][02:45][00:15][02:10]

Dr.Y bar [03:00][02:00][01:00][01:00]

Dr.Z bar [01:00][00:30][00:30]

where [02:03] represents a colour to represent 2 hrs & 3 mins etc.

If I just select the Dr. X data I can get a stacked chart, but as soon

as I add either Dr. Y or Dr. Z data the whole chart turns into one

large bar, not three separate bars. I can of course create three bars

if I just plot the totals, but I want the individual parts of the

total (stacked bar) to show separately. What do I need to do to keep

these three sets of data separate? I'm using Windows XP with Excel XP.

Thanks in advance!!!

Norm

I have a simple table with 2 data series (in rows):

item

X 10

Y 20

When inserted as a clustered bar chart, the "Y" bar is on top of the

"X" bar as it should. However the legend seems to behave differently.

When the legend is placed on the right/left, "Y" is listed on top of

"X" as it should. But when placed on the top/bottom, "X" shows on the

left and "Y" on the right. Since we read English from left to right,

wouldn't it make more sense that "Y" be on the left(read first)?

Say, regardless what makes more sense and the client requests "Y" be

listed on the left, is there a way to reverse the order of

LegendEntries but not the data series?

Thanks in advance,

WH

I am building an excel database with a lot of data that I will be updating daily. I need to generate charts from it as I update, so I am using pivot tables and charts. I also need the pivot table to organize the data properly.

The problem I am facing is that once the data is organized in the pivot table, I need to calculale the average of every 'n' items, i.e the average of the first 'n' items followed by the second 'n' items and so on and put it in a chart. I also need the calculate the range of the 'n' items. These are for X-Bar and R Statistics Charts.

So if anyone could help me with this, I would be really grateful. Thank you in advance.

I've seen a few Excel SQC add-ins around and was wondering if anyone could recommend any of them?

i'm trying to make this y-bar for each point blue. can't find the option and when i double click on my points, i can only modify the style and color of the x-bar.

thoughts?

Hi, is there a formula or script for copying a range of cells, that have

single word-text, to a single cell with spaces between each word? Thanks!

have: =A100&" "&A101&" " ... &A400&" "&A401&" "

but have many records / unwanted space lines.

(possible answer to excluding "." periods might be using FIND-REPLACE

afterwards.

maybe something like:

=IF(OR(A1=".",A1=".blank."),then skip,A1:A3000)&" ")

not code literate, so if can include instruction like (enter your range

here, do this/that; can / cannot use with other code.. thanks)

have code from somewhere, but do not know how to use, if someone can expand

a little, thanks!!

x = Sheets(1).Range("a" & Rows.Count).End(xlUp).Row

For Each c In Sheets(1).Range(Cells(5, 1), Cells(x, 1))

symbols = symbols & "+" & c

dynamic moving range chart. I am using the StatPlus add-in and can't get this

to work. I have been to probably 30 websites about dynamic charting and have

found nothing that applies to either of these charts. I think part of the

problem is that I have to create dynamic range names for the data. However,

when I try all the different methods of doing this that I've found I am

getting a #value error in the cell.

This is basically what I want in my chart( of course this is an example, you

wouldnt believe the amount of data in the actual sheet.)

I need an x-bar and a moving range chart that will allow me to update the

data AND add data and have the chart update automatically. Here is a sample

of my data

A B

1 Vendor Performance

2 1 36

3 2 33

4 3 45

5 4 39

6 5 38

7 6 40

8 7 46

9 8 34

10 9 32

This data changes constantly and I really need dynamic xbar and moving range

charts for this so I dont have to create a new chart every time the numbers

change or numbers are added. I have found several pages on creating dynamic

charts but they mostly apply to bar charts. I know that it's possible to

create these charts dynamically because I have seen them. Any ideas? Thanks

in advance for any help.

Hi, is there a formula or script for copying a range of cells, that have

single word-text, to a single cell with spaces between each word? Thanks!

have: =A100&" "&A101&" " ... &A400&" "&A401&" "

but have many records / unwanted space lines.

(possible answer to excluding "." periods might be using FIND-REPLACE

afterwards.

maybe something like:

=IF(OR(A1=".",A1=".blank."),then skip,A1:A3000)&" ")

not code literate, so if can include instruction like (enter your range

here, do this/that; can / cannot use with other code.. thanks)

have code from somewhere, but do not know how to use, if someone can expand

a little, thanks!!

x = Sheets(1).Range("a" & Rows.Count).End(xlUp).Row

For Each c In Sheets(1).Range(Cells(5, 1), Cells(x, 1))

symbols = symbols & "+" & c

other MS Office products?

TIA,

John

Procedure 1.

Array Formula setting.... for stock analysis.

The formula syntax is,

=QLink|Bars!'SYMBOL,PERIOD,#BARS,[DTOHLCV],{HEADERS},{HH:MM-HH:MM},{FILL}'

Example: =QLink|Bars!'IBM,15,1000,DTOHLCV,HEADERS,09:30-16:00'

I have copied the formula into multiple sheets (a separate sheet for each stock/symbol).

The SYMBOL field, of the formula, is the only field that changes on each sheet.

Instead of me typing in the different/new symbol manually on each sheet, is possible to reference the 'symbol' to a cell value (eg. $a$1 or if it is easier, to reference it to the sheet/tab name). I tried using the $A$1 format but it does not work ... i guess something to do with the apostrophe before the symbol text.

Another option, if it may be easier, can I group the sheets, select the cell that contains the array formula - and somehow 'find and replace' the 'symbol' text with a cell value (in this case the stock symbol in A1)

...............................

Procedure 2.

I have data for multiple stocks in multiple files/workbooks (because of size constraints of Excel).

I have another workbook that has an analysis template/sheet.

There are 2 data columns in the sheet - one each for a pair of symbols.

There are two empty cells in the template - one for each of the 2 stock/symbols.

When I type a symbol into one of the empty cell - I would like the template to fetch the data for that symbol, from the data workbooks, and paste/download it into the respective column for the stock.

My challenge here is: I think I can try the INDIRECT reference method.

What I do not know is, how to create the formula, such that, the template would search all the workbooks, and find the sheet for the particular symbol. By myself, I can manage creating a formula if there was only one workbook/file to create an INDIRECT reference.

Of course, I could manually type in the respective workbook/file each time, but obviously I am trying to bypass doing so.

.............................................

Thanks much for any feedback.

In a workbook I have a sheet which will not allow the last two options. CTRL+ does not give any reaction and the tool bar symbols for insertion are dimmed. It is possible to press 'Insert' where 'Rows' and 'Columns' are active, but 'Cells' (equivalent of CTRL+) is dimmed.

Only when clicking on the row designator at the utmost left and thus selecting the complete row does the tool bar become active and CTRL+ inserts a line.

I have tried this piece of VBA code found in an old thread with a similar problem, but it does not work in my case.

Sub ResetBars() Dim bars As CommandBars Set bars = Me.Application.CommandBars For i = 1 To bars.Count Dim bar As CommandBar Set bar = bars(i) bar.Reset Next i End SubAnyone has an explanation and a solution?

NSV

I am trying to create a sheet to pull out data from a MAIN DATA sheet in a file into another sheet (CALCULATION) based on selection in an INPUT sheet....

For this I need help on creating date validation and an Action Button containing a macro.

I have explained what exactly I want to do in the attached file.... (AM UNABLE TO ATTACH THE FILE)

I will appreciate any help that may be given.....

I had put out another request yesterday, but have not recd any reply.... It is extremely urgent and will be very obliged if anyopne can help me.... I am pasting it again for your reference and perusal......

I have been using excel for a long time. But when it comes to programming and VBAs, I would say I am a novice. I am clear about what I want to do, but don't know how to go about it. Let me know if any of the walk-ins or anyone you know who can help me....

The below link gives the realtime backfill data...

http://www.google.com/finance/getpri...=1266701290218

where

q= stock symbol on Google finance

x= exchange symbol

i= interval (here 60 means 60 sec (1 minute interval))

p= no of period(here 5d denotes 5 days of data)

f= parameters (day, close, open, high and low)

df= difference (cpct is may be in % change )

auto =1,

ts = time start… if you cut the last 4 digits…the rest gives the start day in seconds

you can choose your own set of value depending upon your need.

The following link gives the 1 min Realtime data for Nifty

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Using the above explanation we can build any formats (1min, 5min, 15min, 60 min) of real time data and can be use as a backfill

To get 1 min Data

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

To get 5 min Data

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 15 min Data

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 60 min Data

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost. (This sentence is the hyperlink to the site)

I am trying to create a sheet so that I have to key in the scrip name in cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.

I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60 min.

Then using VBA (which I want someone to design and help me) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV...

Finally the file should be designed in a way so that if I want real-time data for 50 - 100 stocks simultaneously, I should be able to get it.....

The most important aspect is getting the data in excel and have it updated on realtime basis….

Can this be managed????

Thanks & Regards,

Navin Agrawal

nbagrawal.2@gmail.com

No luck finding an answer? You could always try Google.