D
Doug
How can I enter a standard Deviation formula in CF? I have tried several ways
and can't figure it out?
--
and can't figure it out?
--
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
p45cal
A bit short on detail here.Doug;557054 said:How can I enter a standard Deviation formula in CF? I have tried severa
ways
and can't figure it out?
--
How do you want to restrict entries?
Where does the info come from for the arguments that make up th
formula
D
Doug
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!
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 said:A bit short on detail here.Doug;557054 said:How can I enter a standard Deviation formula in CF? I have tried several
ways
and can't figure it out?
--
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/showthread.php?t=153650
Microsoft Office Help
.
P
p45cal
I beg your pardon - I read DV (Data validation) instead of CF!
I'm working on it, but xl2007 is significantly different from earlie
versions of Excel in this respect. Which version are you using?
I'm working on it, but xl2007 is significantly different from earlie
versions of Excel in this respect. Which version are you using?
D
Doug
I'm using 2007
--
--
p45cal said: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 said: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.
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=153650
Microsoft Office Help
.
P
p45cal
(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 coul
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 -Hom
-tab click on -Conditional formatting-, -Color Scales, More Rules-
Select the rule type: -Format only values that are above or belo
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 th
range having two CF rules
+-------------------------------------------------------------------
|Filename: 2009-11-13_151904.jpg
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=355
+-------------------------------------------------------------------
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 coul
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 -Hom
-tab click on -Conditional formatting-, -Color Scales, More Rules-
Select the rule type: -Format only values that are above or belo
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 th
range having two CF rules
+-------------------------------------------------------------------
|Filename: 2009-11-13_151904.jpg
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=355
+-------------------------------------------------------------------
D
Doug
--
Thank you!
Thank you!