answersLogoWhite

0

I recommend you do not try to average a set of components, because your result may be not be accurate. The best way to find an overall average is to average the entire data set.

EXAMPLE: You have three columns of ten numbers each with an average listed at the bottom of each, say A11, B11, and C11. There are two ways you can solve this:

  1. Combine all the averages and divide by 3. [=SUM(A11:C11)/3] - But, the result may not reflect the average of the entire data set.
  2. Calbulate the average for all 30 numbers in the data set. [=SUM(A1:C10)/30] - This would give a much more accurate representation of the entire data set.
User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
JudyJudy
Simplicity is my specialty.
Chat with Judy

Add your answer:

Earn +20 pts
Q: How do you calculate an overall average from a set of component averages?
Write your answer...
Submit
Still have questions?
magnify glass
imp