answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar

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
Related questions

How do you calculate conductivity of a mixture?

To calculate the conductivity of a mixture, you can use the formula: conductivity = Σ(Ci * κi), where Ci is the concentration of each component in the mixture and κi is the conductivity of each component. Simply multiply the concentration of each component by its conductivity and sum up the products to get the overall conductivity of the mixture.


What are the advantages and disadvantages of using the average of averages mass to calculate the expected mass of 100 particles?

Well, honey, using the average of averages mass to calculate the expected mass of 100 particles can give you a quick estimate, but it's like putting a band-aid on a broken bone. It might save you time, but it's not the most accurate method. You're better off calculating the total mass of all 100 particles and then finding the average if you want to get it right.


When you are doing an experiment that will have multiple trials how do you handle averages chemistry?

To calculate the average for multiple trials in a chemistry experiment, add up the results of all the trials and then divide by the number of trials conducted. This will give you an overall average value that represents the combined results of all the trials. Averaging helps to minimize the impact of outliers and provides a more reliable estimate of the true value.


Is an average of a set of numbers the same as the average of the averages of the subsets of numbers?

No, it is not. Example: the average of (5 and 7) is 6, and the average of (50, 60 and 70) is 60, but if we add all five numbers we have 192, so the overall average is 192 divided by 5 = 38.4 and the reason for that is we have more and bigger numbers in the second set.


Which component of branding does moving forward in the overall standard bank brand represent?

which component of brading does ''moving forward'' in the overall standard bank brand represent?


Which component has the highest overall efficiency at a power plant?

generator


How do you calculate cumulative percentage of marks?

You calculate overall percentage of engineering marks by taking the number of engineering marks and dividing it by the percentage. When you do that, you will get your average percentage of engineering marks.


Is an average of averages accurate?

Mx = MM is the greek letter mu, by the way.Statistically speaking, an average of averages within a sample is said to very closely approximate the population average. However, where the sample size is under 30, there needs to be an adjustment for size. If the sample is over 30 (thus you are averaging over 30 averages), then this should reflect very closely the population average. It is not perfect but statistically it is incredibly close.However, it is important not to compare apples and oranges in general so while giving mu of mu, be sure to include the standard deviation and any notes you find relevant.Average of averagesYou're living dangerously.If the averages don't have equal weight, your average of averages will yield skewed results. Here's why.Let's say you're trying to calculate your overall average grade for all the tests you've taken in school, and let's say you are taking only math, English, and science. Let's say your average in math is 80, English is 85, and science is 90. The average of those averages is, of course, 85. But is that your true average?Not if you took ten math tests, five English tests, and only two science tests!! If all those tests have equal value, then your average is closer to 80, because the ten math tests dominate the true average. In other words, your true average is the WEIGHTED average of the three averages. To weight them properly, you must think of the math average as not one data point but ten data points, the English average as not one data point but five, and the science average as not one but two data points.Here's how the weighted average math looks:10 x 80 = 8005 x 85 = 4252 x 90 = 180__ ___17 1405Now, divide 1405 by 17. So, 1405/17 = 82.7. (The 17 is the sum of the weighting factors, which, as you can see, is equal to the total number of tests you took.)So, you can see that taking the average of averages may give erroneous results -- unless you find the weighted average.


How do you calculate the overall mean of the median?

it is grades


Salary under HRA it encompasses salary component only?

Yes. The HRA Component is also part of your overall salary package


How do you calculate credit in Anna university?

Calculating credit in Anna University is determined by entering the grades of assignment modules from each subject and the credit value of each subject. Clicking calculate will generate the overall Grade Point Average.


How do you calculate center of gravity for a taper shaft?

To calculate the center of gravity for a taper shaft, you would need to consider the varying cross-sectional area along the length of the shaft. You can use an integral approach to determine the centroid of each cross-sectional area and then calculate the weighted average of these centroids to determine the overall center of gravity of the taper shaft. Alternatively, you can simplify the taper shaft as a series of smaller sections with uniform cross-sections and calculate the center of gravity for each section, then determine the overall center of gravity using the weighted average of these section centroids.