Is this what you want?

B2=Average=26.27, C2 =stdev=1.729 on your data

The standardize function is STANDARIZE(x,Average,Standard deviation)
x=29.27 results in 1.7325649

Use this formula to find the x using goal seek. (Tools, Goal seek)

Enter 30 in say g1, In g2 type =standardize(g1,29.27,1.7325649)

In gaol seek Set cell = the formula (g2) in the change cell type 1.745 the
by changing cell is g1 Repeat and set change to -.745

These result in values of 28.86784223 and 24.98572503

Regards
Peter Atherton


"josephWard6" wrote:

Hi ,
How to use the Prod Function in a list of averages to find the lease common
value !
here is an example.

AVRG
26.27
-------------------
29.27
25.61
26.17
25
25.32
--------------
3 | These are a list of Over and Under values of the above
-0.66
-0.1
-1.27
-0.95
--------------
3 | These are a list of compile Positive and Negitive values
also average

| trying to locate which one is within range of the
average,one group
-0.745
| is always known ,in this case it's (25) of the above
values,which now leave (4) items to be measure by an average, maybe if I
could find the Standard Error in the Averaging,it would help in locating(plus
or munis) and the amount !

Thanks in advance


Joseph..