From a web page, I copied an "excel spreadsheet" and pasted it into a real Excel spreadsheet.<BR><BR>Name heading was in Column A, but John Doe, for example, would have his name in rows 1-4 that had been merged together to look like one cell.<BR><BR>Job Title heading was in Column B, but the job title was in row 3 of Col B.<BR><BR>City heading was in Column C, but the city name was in row 2 of Col C.<BR><BR>State heading was in Column D, but the state name was like Col A in that rows 1-4 were merged to look like one cell for the state name.<BR><BR>The goal is to get Name, Title, City, State all together on any one row.<BR><BR>I've tried merging, deleting, etc. but can't fiind the solution. Apparently somebody went to a lot of trouble to make sure that it could not be done, even though there is nothing illegal about it.<BR><BR>Help appreciated.<BR>JC
Hello,
I am new to trying to programming with excel. I am trying to gather some statistics on random numbers generated by a worksheet. Here is what I would like to do:
I would like to be able to use one sheet to call on another sheet to recalculate itself a specified number of times (up to 10,000) and after each recalculation to save one of the cells on the recalculating sheet.
In other words, In the 1st worksheet I would get 10,000 cells of the results of the 2nd worksheet calculation that I could then run some simple statistics on.
Is this possible? Is there a simple way to do this? I have very little experience!
Thanks for the help!
Adam
Hei guys..
I know you guys are the best out there so im back again this time
I have a scenario where by Column A is date incident opened and Colum B is date incident closed.
And Column C shows the days between them. I got this and its fine. However, how do i
make a table or in any how define it as if the number is 1 - 3 days then it should be A
1-3 days = A
4-6 days = B
7-8 days = C
9 days onwards = D
This is because i need to make a chart and graph of the turn around time and the best is to define into a character alphabet so the chart will show the statistics of how many A, B, C and D But how do i do that.
Hope you guys can help me out step by step..coz im Lost!..
Thanks
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?
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
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.
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,
I was hoping someone could help me with this particular statistics+excel problem that I cannot solve, or, at least need some confirmation that I am solving it correctly...
MY DILEMMA: Let's say I am asking people to choose their favorite letter(s) ranging from a-vvv (1-100). I ask 9 people to choose their favorites, but they can't choose more than 100 #'s (obviously since a-vvv represents 100 letters). Once I gather the information, the only way I know how to create the proper order is to AVERAGE the data by inputting zero into the fields/letters that were not chosen (since no one chose all 100 letters). My question is... HOW DO I PROPERLY ORDER THE "LETTERS" FROM MOST TO LEAST POPULAR BASED ON THE SUBMISSIONS??? I realize this is a statistics problem, but I'm hoping something efficient can be done in excel.
I've also attached the working excel file to use as a working document. Feel free to PM if you would like to attach an excel file.
Thanks in advance everyone!
-Ryan
