Weighted average issue
I have a weighted average question that I'm can't seem to calculate. Here's the calculation:
(25×3.5+25×4+20×2.5+10×4.5+10×3+10×4) / (25+25+20+10+10+10) = 3.525
How do I identify the weighted number of EACH data set from that equation (e.g., 3.5, 4, 2.5, etc.)?
I'm uploading these scores into my company's CMS, but it doesn't have the capability to calculate the weighted average. Without it, those data points will equal 3.58, not 3.525. So, I need to manually input each data point so that the final score comes to 3.525.
Thanks in advance!
Answer
- The questioner was satisfied with and accepted the answer, or
- The answer was evaluated as being 100% correct by the judge.
-
Hi Kav10! Thank you for your help with this. I was able to find the summation properly, using your formula above. But the real problem I'm facing is how to make the average of those weighted data points 3.525, not the sum. So, for instance, 3.5 should be remarkably close (say, 3.56), but likely not 3.5 exactly. Does that make sense? Thanks again! Eric
-
You mean you want to modify/adjust each data and then the average of those adjusted numbers be 3.525?
-
-
Yes, exactly.
-
I'm hoping there's a formula I can run to make that happen — I have 10 data sets to calculate (each with the same weighting, but different data points).
-
Clarification, each of the same weighting as above (e.g., 25%, 25%, 20%, 10%, 10%, 10%)
-
-
That is easy too.
-
I'll explain it here. Calculate the average of the weights. (25+25+20+10+10+10)/6 = 16.66. Calculate a score for each data point by dividing its weight (i.e. frequency) by the average frequency calculated above (i.e. 16.66). This will give you the adjusted score for each data point. For example, for the first data point (i.e. 3.5), this would be 5.25. And you calculate like that for the other data points. Now, average the new adjusted scores, and the average will be 3.525.
-
Thank you Kav10!!
-
-
Of course! Glad I was helpful. Thanks for the coffee.
- answered
- 976 views
- $10.00
Related Questions
- Bivariate Normality questions
- Hypothesis Testing, Probabilities
- Probability maximum value of samples from different distributions
- What plots should I use to describe the relationship between these 8 continuous variables?
- Choosing the right statistical tests and how to organize the data accourdingly (student research project)
- Probability of drawing a red ball, given that the first ball drawn was blue?
- Explain how the binomial probability equation is $\frac{n!}{x!(n-x)!}(p^x)(q^x)$
- Variance of Autoregressive models, AR(1)