stdev CF Formula
 

How can I enter a standard Deviation formula in CF? I have tried several ways
and can't figure it out?
--

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

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

.

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

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

.

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

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

.