| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stdev CF Formula
How can I enter a standard Deviation formula in CF? I have tried several ways
and can't figure it out? -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
Doug;557054 Wrote: How can I enter a standard Deviation formula in CF? I have tried several ways and can't figure it out? -- A bit short on detail here. How do you want to restrict entries? Where does the info come from for the arguments that make up the formula? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
Sorry for the lack of detail. I am wanting to use the two color scale in CF
and under the minimum and maximum value enter a formula for the standard deviation of the data in that column. On the minimum side, I am wanting it to highlight data red when it exceeds -1 stdev, and on the maximum side highlight data green when it exceeds 1 stdev. This way I can see highlighted data for only values more than one stdev away from the mean. I may use the three color scale so to define what a center mean will be (usually 0). I just need to know what I should type into both the min and max to retrieve these results. -- Thank you! "p45cal" wrote: Doug;557054 Wrote: How can I enter a standard Deviation formula in CF? I have tried several ways and can't figure it out? -- A bit short on detail here. How do you want to restrict entries? Where does the info come from for the arguments that make up the formula? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
I beg your pardon - I read DV (Data validation) instead of CF! I'm working on it, but xl2007 is significantly different from earlier versions of Excel in this respect. Which version are you using? Doug;557601 Wrote: Sorry for the lack of detail. I am wanting to use the two color scale in CF and under the minimum and maximum value enter a formula for the standard deviation of the data in that column. On the minimum side, I am wanting it to highlight data red when it exceeds -1 stdev, and on the maximum side highlight data green when it exceeds 1 stdev. This way I can see highlighted data for only values more than one stdev away from the mean. I may use the three color scale so to define what a center mean will be (usually 0). I just need to know what I should type into both the min and max to retrieve these results. -- Thank you! "p45cal" wrote: Doug;557054 Wrote: How can I enter a standard Deviation formula in CF? I have tried several ways and can't figure it out? -- A bit short on detail here. How do you want to restrict entries? Where does the info come from for the arguments that make up the formula? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 'The Code Cage Forums - View Profile: p45cal' (http://www.thecodecage.com/forumz/member.php?userid=558) View this thread: 'stdev CF Formula - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=153650) 'Microsoft Office Help' (http://www.thecodecage.com) . -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
I'm using 2007
-- "p45cal" wrote: I beg your pardon - I read DV (Data validation) instead of CF! I'm working on it, but xl2007 is significantly different from earlier versions of Excel in this respect. Which version are you using? Doug;557601 Wrote: Sorry for the lack of detail. I am wanting to use the two color scale in CF and under the minimum and maximum value enter a formula for the standard deviation of the data in that column. On the minimum side, I am wanting it to highlight data red when it exceeds -1 stdev, and on the maximum side highlight data green when it exceeds 1 stdev. This way I can see highlighted data for only values more than one stdev away from the mean. I may use the three color scale so to define what a center mean will be (usually 0). I just need to know what I should type into both the min and max to retrieve these results. -- Thank you! "p45cal" wrote: Doug;557054 Wrote: How can I enter a standard Deviation formula in CF? I have tried several ways and can't figure it out? -- A bit short on detail here. How do you want to restrict entries? Where does the info come from for the arguments that make up the formula? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 'The Code Cage Forums - View Profile: p45cal' (http://www.thecodecage.com/forumz/member.php?userid=558) View this thread: 'stdev CF Formula - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=153650) 'Microsoft Office Help' (http://www.thecodecage.com) . -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
(Excel 2007 below) In 2003: Raw data in A1:A30: 355 If you cant see the picture, it's at http://tinyurl.com/y8vumd3 This picture shows the cf formulae in cell A1, but I think you could select the whole range and enter the same formulae and it should work. In xl2007 there is the built in facility to do exactly what you want - no formulae required. Select the entire raw data range, on the -Home -tab click on -Conditional formatting-, -Color Scales, More Rules-, Select the rule type: -Format only values that are above or below average-, in the -Format Values- dropdown choose -1 std dev above-, choose your formatting and OK. Repeat the exercise choosing -1 std dev below-. You end up with the range having two CF rules. +-------------------------------------------------------------------+ |Filename: 2009-11-13_151904.jpg | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=355| +-------------------------------------------------------------------+ -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stdev CF Formula
-- Thank you! "p45cal" wrote: (Excel 2007 below) In 2003: Raw data in A1:A30: 355 If you cant see the picture, it's at http://tinyurl.com/y8vumd3 This picture shows the cf formulae in cell A1, but I think you could select the whole range and enter the same formulae and it should work. In xl2007 there is the built in facility to do exactly what you want - no formulae required. Select the entire raw data range, on the -Home -tab click on -Conditional formatting-, -Color Scales, More Rules-, Select the rule type: -Format only values that are above or below average-, in the -Format Values- dropdown choose -1 std dev above-, choose your formatting and OK. Repeat the exercise choosing -1 std dev below-. You end up with the range having two CF rules. +-------------------------------------------------------------------+ |Filename: 2009-11-13_151904.jpg | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=355| +-------------------------------------------------------------------+ -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153650 Microsoft Office Help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display formula Excel uses for internal functions (STDEV...) | Excel Worksheet Functions | |||
| STDEV in a Formula for Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| How to write STDev formula in a macro | Excel Programming | |||
| Conditional STDEV formula | Excel Programming | |||
| STDEV | Excel Discussion (Misc queries) | |||
Linear Mode
