need help with a standard deviation chart.

  • Thread starter Thread starter pm
  • Start date Start date
P

pm

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top