|
|
#1
02-16-2015, 08:10 AM
|
|||
|
|||
formula for cell's dispersion
Looking to calculate the absolute average deviation from the mean for a given cell. I have a formula that takes the absolute value difference between the reference cell's value and the average value of the range in which it falls. not sure if there's an actual excel function that performs this or is this my best way to go?
=ABS(A4-AVERAGE($A$4:$A$13)) 
|
| Tags |
| average, dispersion |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| A formula to Take what I need from a cell and add the rest | bremen22 | Excel | 2 | 11-21-2013 08:05 AM |
|
formula help with total in same cell
|
jterr | Excel | 14 | 02-25-2013 05:43 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
|
need to check whether cell contains formula
|
etodem | Excel | 2 | 10-23-2010 07:33 PM |
Windows 7 32bit 
Office 2003
Threaded Mode