standardize formula

  • Thread starter Thread starter Gordon Meyer
  • Start date Start date
G

Gordon Meyer

I have the following formula:

=STANDARDIZE(D16,D$56,D$57)

when I click on the Function fx it shows the Formula Result as being for
example -0.5728

but in the cell it puts -0.2258

I am lost :-)

Can someone help.

Thanks.
 
Gordon,

The formula for standardizing should return:

=(D16-D$56)/D$57

That's the same as:

=STANDARDIZE(D16,D$56,D$57)

HTH,
Bernie
MS Excel MVP
 
Ok but when I click on the fx before the formula input window, a window
opens up showing me x , mean and standard deviation and in the bottom of
that little screen it shows formula result and this formula result is
different than what I got in the cell ?
 
I have the following formula:

=STANDARDIZE(D16,D$56,D$57)

when I click on the Function fx it shows the Formula Result as being for
example -0.5728

but in the cell it puts -0.2258
Click to expand...

If the value displayed as the cell formula's result is correct, getting
different values in the dialog is just a nuisance. What are the values in cells
D16, D56 and D57?
 
Back
Top