I have a list of about 130 items and new things get added to the list every day. Of particular interest to me are items containing the indicator 'TR'. These are work items identifed by TR followed by a number (e.g. TR245, TR1281, etc.)
I need a solution to maintain a list of TRs on another tab. This way, I can run some lookups to see if a new TR is already on the list or not.
Hi All - i solved my first dilema which was to separate data contained on each cell. Each cell contained the following:
25.0 (11:25)
25.0 represents Total # of Visits and 11:25 represents Total Time spent on visits.
I used the a formula to separate this data into two cells with intention of being able to SUM this data later on.
So now i have 25.0 in one cell, and (11:25) in another cell. Great!
However...i am using a pivit to SUM the data and all i get returned is zeros. I need the pivot to recognize the values as they are meant to represent - Total # of Visits (25.0) as a number, and the Total Time as hours/minutes (11:25).
Now there are things that "I" can do to fix this, but the problem is that i am creating a 'template' of sorts for other users. So i don't want them copying/pasting etc. to get the pivot to work.
Anyone have any suggestions on how to accomplish this with "minimal" effort req'd from the users?
Thanks for taking the time to read!
Regards,
Sandi
Hi all,
i have problem with long text in Excel.The text in cell is trimmed although the cell height is enough to display the text.
http://carnivore.ic.cz/excel.JPG
Hi there,
I would like to have 3 small rows and have the text to fill those 3 rows. I can't merge them because I would like to have 3 different colors in the background.
Check at the attached file, see how the text is trimmed in the row 4 ?
I have added over the image (in red) what I want the text to look like. Is there a way to tell the row 4 to expand the text to the upper rows, like my red "Tuesday" example?
Thanks!! (By the way, I have Excel 2007)
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
I am having difficulty setting up a Excel sheet for the following problem.
An industrial Engineer at ABC Products wants to determine whether there are more units produced on PM shift then AM Shift.
Sample of 54 Am workesr with a mean number of units produced is 345 with a standard deviation of 21.
Sample of 60 PM workser with a mean number of units produced is 351 with a standard deviation of 28 units.
Significance level is .05
Trying to figure out if the PM shift is larger.
Hi Lords and Ladies!
I was wondering if there are any statistical tools in excel?
What I need is a comparison program to do the following:
Column A: abcdefgh
Column B: bcaghfrnreo
Column C: 80% match (roughly)
Is that possible to do in excel?
Regards,
Don Defy
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
