Hi,
AS a part of my daily work I pick workitems from different team members from a consolidation sheet that will have their daily production.
As per my sampling I will have to take two workitems per employee every day. How can I do that by using Excel macros?
AS of now I'm using a macro which will pull every nth row from which Im getting the sampling as per the percentage I select, but going forward, I would be needing fixed number of rows from each employee
Example of how the consolidation sheet looks like:
Name
Date
Workitem #
Employee1
11/3/2009
W001234-04Nov09
Employee1
11/3/2009
W001544-04Nov09
Employee1
11/3/2009
W005234-04Nov09
Employee1
11/3/2009
W001624-04Nov09
Employee2
11/3/2009
W00134-04Nov09
Employee2
11/3/2009
W00544-04Nov09
Employee2
11/3/2009
W012234-04Nov09
Employee2
11/3/2009
W023624-04Nov09
Note: This lost goes on to 50 employees, and the count of Workitems worked will not be the same for all.
Any help on this is truly appreciated..!!
Many Thanks!
Swaroop
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
I need to sample 100 numbers out of a specified distribution (normal or
other). So basically I know the parameters, and I need Execl to sample 100
numbers. How do I do it?
Help With VBA in Excel ? Writing a function using probabilities ?
I need help writing a function in VB in excel that decides the winner of a game, the probabilities are input into an excel worksheet by the user. There are 2 players and 4 different probabilities for each player:
a = probability of first shot being allowed
b = probability of winning first shot
c = probability of second shot being allowed
d = probability of winning second shot
The game is played between 2 players, in each game one is chosen to be the server and the other the receiver. Service alternates game by game. A single game consists of a sequence of points played with the same player serving. A game is won when a player has (a) scored four or more points and (b) has two or more points more than his opponent
My function needs to take the server (chosen at random) and return the winner of a particular point, calculated according to the above probabilities.
I have NO idea where to start here, any help please?????
Hi I was just wondering you there is a way of doing an advanced sampling using the analysis tool pack.
I have 60 males, 30 females and I want to take a random sample of 30% of the males and 50% of the females.
Is this possible? Anyone have any ideas?
Thanks,
Charmed (as usual)
Hi,
I have no clue how to randomly select a random sample using excel , I looked at the youtube but the videos were too fast and I couldnt follow them.
Thanks
I had requested file earlier and Martin Wilson graciously helped me out with my problem. I have another issue in the same file.
In the attached excel file, I have raw data which needs to be randomly sampled.
1979-2008
Here in the excel I am computing averages. What I need to do is incorporate a formula if a cell is selected.
1: Treat the cell selected as T7. Move up 7 years and select cell as T1 and incorporate the following formula --> (T7/T1)^(1/7)-1 which will give me the compounded annual growth rate. Example: if the random cell selected is August 2000 (H23 in Excel Sheet1) then the formula will be such (H23/H17)^(1/7)-1 . this also means that the cells above 1985 cannot be randomly selected as the simulation will move up....
Additionally on Sheet 2, I want the data to move up and select seven 12 month periods i.e. if Random cell is May 2000(in excel sheet 2 - H23) then the seventh period should be June 1993 (in excel sheet 2 - I17). the simulation should average all the cells in between, rows and columns.
I have been trying and trying but can't seem to get it to work. Please help Thanks
Rahul
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.
