Explore BrainMass

Bell-curve: Model Labour Hours

Create a bell curve chart that shows the number of men needed per day for a 10,000 man hour job. The start date is 1/1/2008 and the end date is 6/1/2008. The job will run for a total of 21.71 weeks and there will be 108.57 work days. The estimated man hours is 10,000 and each worker will work an 8 hour shift 5 days out of the week. With this data can you help me create a bell curve that shows how many men would be needed each day to get the job done?

Solution Preview

Dear Student,

To create a sample bell curve for a problem, follow these steps:
1. Start Excel.
2. Enter the following column headings in a new worksheet:

A1:Original B1:Average C1:Bin D1:Random E1:Histogram G1:Histogram

3. Enter the following data in the same worksheet:

A2: 23 B2:
A3: 25 B3: STDEV
A4: 12 B4:
A5: 24
A6: 27
A7: 57
A8: 45
A9: 19

4. Enter the following formulas in the same worksheet:

B4: =STDEV(A2:A9)

These formulas will generate the average (mean) and standard deviation of the original data, respectively.

5. Enter the following formulas to generate the bin range for the histogram:

C2: =$B$2-3*$B4

This generates the lower limit of the bin range. This number represents three standard deviations less than the average.

C3: =C2+$B$4

This formula adds one standard deviation to the number calculated in the cell above.
6. Select Cell C3, grab the fill handle, and then fill the formula down from cell C3 to cell ...

Solution Summary

This tutorial provides guidelines on how to create a bell curve chart that shows the number of men needed per day to finish a 10,000 man hour job.