| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of the averages of two ranges
Can someone explain mathematically why the difference of the sum of the
average of row two and three (Range D2:D3) as shown in cell E3 is different than the average of each individual difference in range A4:C4 as shown in cell E4. It is not obvious to me. test 1 test 2 test 3 Average Diff 10 5 10 8,33 6 1 2 3 -64,00 % -40,00 % -80,00 % -80,00 % -66,67 % -- Regards Tommy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averages | Excel Discussion (Misc queries) | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| Averages formula for multiple ranges | Excel Worksheet Functions | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
