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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does 1 value affect the average?
If you take the total of those numbers (115) and express 100 as a
percentage of the total you get 87%, i.e. the number 100 is contributing 87% to the total, whereas the number 3, for example, is only 2.6%. So, the relative "worth" or weight of a number can be expressed as: =A1/SUM(A$1:A$100) formatted as a percentage and copied down. Hope this helps. Pete On Oct 26, 7:08 pm, Bruce wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does 1 value affect the average?
Now that I see it, it's simple. Thanks for getting me there.
"Pete_UK" wrote: If you take the total of those numbers (115) and express 100 as a percentage of the total you get 87%, i.e. the number 100 is contributing 87% to the total, whereas the number 3, for example, is only 2.6%. So, the relative "worth" or weight of a number can be expressed as: =A1/SUM(A$1:A$100) formatted as a percentage and copied down. Hope this helps. Pete On Oct 26, 7:08 pm, Bruce wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does 1 value affect the average?
You're welcome, Bruce - thanks for feeding back.
Pete On Oct 26, 8:12 pm, Bruce wrote: Now that I see it, it's simple. Thanks for getting me there. "Pete_UK" wrote: If you take the total of those numbers (115) and express 100 as a percentage of the total you get 87%, i.e. the number 100 is contributing 87% to the total, whereas the number 3, for example, is only 2.6%. So, the relative "worth" or weight of a number can be expressed as: =A1/SUM(A$1:A$100) formatted as a percentage and copied down. Hope this helps. Pete On Oct 26, 7:08 pm, Bruce wrote: 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?- Hide quoted text - - Show quoted text - |
Reply |
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 |