LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
josephWard6
 
Posts: n/a
Default how to use the Prob function in a list of averages to find the le

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtotaling and manipulating a list of data TJN Excel Worksheet Functions 0 April 27th 05 10:31 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
i need a function to find the highest value in a list Melani Excel Worksheet Functions 2 April 14th 05 07:00 PM
Function to list values of last 3 non-blank cells in a vertical bl ANJ Excel Worksheet Functions 1 April 14th 05 12:53 AM
Function that filters a list (Database) for criteria in a range a. FirstVette52 Excel Worksheet Functions 0 February 8th 05 04:37 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"