View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 -