Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
i need a function to find the highest value in a list | Excel Worksheet Functions | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions |