How does 1 value affect the average?

[Bruce]

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?

 

[Pete_UK]

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

 

[Bruce]

Now that I see it, it's simple. Thanks for getting me there.

 

[Pete_UK]

You're welcome, Bruce - thanks for feeding back.

Pete