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?
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)
Hello
How do you write the following formula in VBA?
PHP Code:
=RADQ(A3^2+B3^2)
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,
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
