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

ProfessorProfessor
I will give you the most educated answer.
Chat with Professor
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra
BeauBeau
You're doing better than you think!
Chat with Beau

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