Okay Jay,

What's asked of me is a bell curve of the following data set:

+ or - 10 std dev.
mean = 1604.278017
std dev= 454.2490865
330 records
Avg hourly $:
3,365.89
3,121.68
3,065.52
2,936.50
2,906.35
2,838.17
2,797.96
2,723.73
2,647.20
2,504.86
2,486.02
2,472.37
2,403.38
2,387.50
2,357.95
2,345.96
2,312.64
2,288.37
2,284.40
2,280.49
2,265.54
2,261.85
2,256.06
2,242.55
2,201.86
2,184.09
2,175.05
2,151.86
2,147.17
2,144.10
2,126.68
2,117.86
2,105.22
2,090.70
2,089.93
2,089.59
2,076.33
2,070.32
2,052.01
2,046.42
2,039.98
2,017.60
2,014.44
2,002.97
2,001.48
1,998.71
1,991.65
1,989.09
1,987.73
1,976.94
1,975.32
1,974.47
1,967.07
1,961.84
1,956.44
1,951.78
1,951.61
1,941.57
1,940.85
1,918.98
1,917.91
1,916.72
1,909.30
1,904.40
1,903.05
1,899.43
1,896.30
1,895.46
1,884.42
1,875.54
1,871.67
1,860.67
1,856.28
1,854.04
1,853.58
1,850.14
1,846.14
1,844.50
1,838.83
1,835.78
1,835.22
1,833.65
1,833.20
1,826.40
1,826.15
1,817.54
1,816.33
1,815.17
1,802.36
1,796.85
1,790.63
1,783.81
1,782.47
1,781.19
1,779.67
1,778.99
1,776.18
1,772.80
1,772.54
1,764.00
1,763.83
1,754.99
1,753.88
1,753.40
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,750.00
1,749.96
1,747.25
1,746.80
1,745.55
1,742.73
1,738.20
1,737.64
1,737.12
1,734.09
1,733.76
1,728.70
1,727.39
1,726.49
1,726.16
1,718.00
1,716.99
1,714.24
1,712.41
1,709.64
1,708.05
1,707.62
1,707.08
1,706.89
1,704.04
1,699.19
1,691.69
1,691.54
1,689.26
1,684.95
1,684.81
1,681.94
1,674.85
1,665.93
1,662.45
1,660.50
1,659.94
1,659.14
1,657.07
1,651.25
1,651.07
1,649.45
1,648.39
1,647.07
1,646.86
1,644.12
1,642.12
1,641.96
1,639.96
1,635.71
1,632.85
1,632.15
1,626.46
1,624.15
1,623.80
1,616.91
1,615.17
1,612.76
1,605.54
1,604.51
1,604.39
1,598.80
1,594.47
1,592.86
1,591.23
1,590.80
1,581.89
1,576.78
1,576.45
1,575.52
1,560.92
1,557.28
1,549.38
1,548.91
1,538.50
1,538.33
1,531.84
1,530.50
1,527.83
1,525.08
1,520.50
1,518.27
1,517.31
1,514.48
1,513.21
1,506.41
1,505.51
1,502.08
1,499.78
1,499.47
1,494.56
1,493.49
1,482.73
1,479.01
1,473.76
1,465.39
1,464.36
1,462.18
1,459.58
1,456.05
1,448.90
1,440.65
1,434.25
1,432.38
1,429.67
1,421.77
1,417.88
1,415.69
1,410.77
1,410.01
1,405.82
1,405.56
1,404.84
1,402.22
1,399.98
1,395.90
1,395.09
1,395.00
1,392.31
1,392.14
1,388.95
1,386.84
1,382.24
1,379.61
1,369.55
1,369.00
1,368.80
1,367.48
1,364.43
1,348.91
1,347.33
1,336.60
1,334.52
1,332.46
1,323.87
1,317.00
1,317.00
1,312.25
1,310.63
1,294.00
1,292.22
1,291.00
1,291.00
1,291.00
1,290.87
1,288.18
1,287.80
1,281.08
1,266.82
1,264.41
1,263.22
1,260.28
1,259.67
1,256.60
1,247.42
1,238.74
1,238.48
1,238.38
1,238.36
1,238.12
1,235.52
1,232.10
1,229.79
1,223.72
1,219.96
1,217.52
1,217.24
1,215.58
1,200.30
1,198.58
1,196.90
1,190.87
1,188.35
1,179.48
1,135.50
1,134.91
1,121.66
1,095.84
1,093.88
1,085.03
1,082.24
1,069.79
1,067.31
1,056.76
1,024.21
993.60
986.28
973.74
952.89
949.50
943.80
936.00
933.18
926.52
920.38
898.24
882.59
862.54
836.00
821.56
806.91
785.59
785.34
720.00
697.61
640.00
616.00
557.97
530.80
512.78
449.95
318.94
133.00
40.96



"jlclyde" wrote:

On Apr 17, 12:40 pm, pm wrote:
I am trying to create a standard deviation chart for our commission paid
employees and Hourly paid employees. Please see info below. Any
suggestions? Thanks.

Comm # of Est. monthly
Total paid checks avg.
40,085.00 6 13,361.67
32,147.94 6 10,715.98
17,775.42 4 8,887.71

Hourly # of Est. monthly
Total paid checks avg.
5,048.83 3 3,365.89
7,804.20 5 3,121.68
9,196.56 6 3,065.52

Are you talking about a control chart. + or - 3 standard deviation
from the average? Could you be more specific with what you want
accomplished. More data if you ahve it would also help.
Jay