Hello friends, Hope all is well!
Please open the attachment here, and please help me calculate the weighted average in Column L.
The attachment:
Includes:
Staff name
Specialty
And 6 months of income generated by staff
Your kind help is appreciated always!
Thank you,
what should be the result and why (what is the weight)?
please add the expected result manualy in your excel file and color the related cells with the same color.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You want an average of columns E:J on each row? What would you be using to weight those values?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Hi there, you could use something simple as this =IFERROR(AVERAGE(E4:J4),"0")
the WEIGHT is the "Specialty".
That doesn't make sense.
Here's an example of a weighted average. 5 people have an average of $100 , and 2 people have an average of $25. Taken together, the 7 people have an average of (5*100+2*25)/(2+5) = $78.57 I have used the number of people to 'weight' the corresponding dollar amount for the two groups.
So, what numbers do you want in cells L4 through L7?
and what value has be counted with specialty?the WEIGHT is the "Specialty".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks