Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with a standard deviation chart.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with a standard deviation chart.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with a standard deviation chart.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart normal distribution/standard deviation | Excel Worksheet Functions | |||
standard deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) |