| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does 1 value affect the average?
I have a list of hundreds of numbers.
I have averaged the numbers, and the average is about 100. I want to see what impact each value has on the average. To be overly simple. If I had a list of 1, 2, 3, 4, 5, 100. The average is ~19. Without the 100, the average is 3. So the 100 has a greater impact on the average than do the other values. How do I express that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do business loans affect the p & l? | Excel Discussion (Misc queries) | |||
| VBA code to affect value of a named range | Excel Discussion (Misc queries) | |||
| conditional formats affect other cells | Excel Discussion (Misc queries) | |||
| Does how #s are listed affect IRR calc- same #s vertically vs. hor | Excel Worksheet Functions | |||
| Does font affect indent spacing? | Excel Worksheet Functions | |||
Threaded Mode
