weighted average

Hi I would like get weighted average margin by category. I want to use the sales to weight the margins. Any help? thanking in advance <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Invoice Number Product Sales Margin 2 22 Pen 110 15% 3 28 Books 200 11% 4 26...

Hello everyone, I need to report weighted averages of athletes' performances based on when they played, who they played against, and their positions. Here is an example to clarify: Let's say I'm looking at Team A. I want to know how all of the players in Position X who have played against...

Hi, I need help to create a measure for Weighted % of Active employees by agency. My logic is : Weighted % of Active Employees = (Active Per Agency/Total Actives All Agency) * (Total Per Agency/Total All Agencies) Following is a sample of my pivot : I choose : I get: All I...

I am trying to find out how many shares of stock I can purchase based off the following: A) Total money available to spend on stocks is $100. B) I want to buy two stocks. C) Stock #1 price is $10. D) Stock #2 price is $20. The question is this... How many shares can I buy if I can only...

I'm working on a contact center quality score card that has yes, no, and na answers. each line item has a different weight with lines e12,and e13 if answered no should result in the entire form auto zero regardless of the other answers, if answered yes will be valued at 15 points each. The na...

Looking to calculate a weighted average if there is a rate in column B, and then to be able to filter on other columns and have the subtotal update with the correct weighted average rate. Below is a copy of the formula I have thus far, where column B lists the rates and column A lists the...

Would anyone know how to work out the weighted average P Year based on the Area field for any given Species in the table below where Land Use can be either High Forest or Windblow and Forecast can only be F? I can do this with sumproduct but am not sure how to have more than one allowable...

Hey guys, Spent about 5 hours or more trying to figure this out.. I don't see myself completing the formula without help. I need the weighted average for [(P) Storeys] where the following criteria are met: 1: [(C) Approved] = "Pending" 2: [(O) Approved] = "Pending" 3: [(O) Approved]...

<tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...

Hi Guys, First post, hope I'm doing this right! I have Table1 which contains the values I need to Average into a column in Table2. The selection of rows in Table1 for the Avg is based on multiple criteria matching every row of Table2. My problem is with solving the requirement for me to use...

Problem: We searched a total number of cases (total cases searched) and found errors in x number of cases (cases found). The average errors in those number of cases found is "average mistakes per case". These cases were searched using 3 different softwares: Non-CAC, CAC, and Legacy Scrubber...

Hello guys, I have been working on a file for quite sometime, and I finally hit the wall. I simply cannot find a workaround to the following question. I have an original table that i was able to summarize using index(match) so now the new table looks something like this <tbody> Product Prod...

In an excel sheet I have two rows of data. I want to search the first row for the closest value of what the user inputs into the box and then do a weighted average of five values in the column next to the column I searched. The values are all in the column to the right of the searched column and...

I'm currently using the following formula for a weighted average to great success: =SUMPRODUCT(--($V$3:$V$200=$Z5),G$3:G$200,$P$3:$P$200)/(SUMIF($V$3:$V$200,$Z5,$P$3:$P$200)) where the bold criteria is something I need to alter for another weighted average. My problem is that the set of...

<tbody> </tbody><colgroup><col></colgroup> Hello everyone, Thanks in advance for your help, thanks also for all the previous solutions I've found. I am using a SUMPRODUCT formula with conditions to determine weighted averages of analyses against volumes. My issue is that not all analyses...

Hi, I have a dataset with a variable versus depth (see below example). I want to calculate a weighted average of a calculated subset of these data, for example, the weighted average from 3.2 to, say, 8.7. I know how to calculate the weighted average of the full dataset, but not a subset, which...

I have a situation where I am trying to add different weighted averages of sales penetration. If they are weighted equally it is pretty easy. In my example below Bob has a goal of selling in 12% Apples and 60% of the Oranges. What I am trying to determine is what his goal penetration would be...

I am trying to value inventory and cost of materials used using the weighted average costing method. This is how it works in theory: When using the weighted average method, divide the cost of raw materials available by the number of units available, which yields the weighted-average cost per...

I need to update one of my spreadsheets to calculate a weighted average when 3 conditions are met. I have this formula which works but it only allows for 2 conditions...

A B <colgroup><col width="64" span="10" style="width:48pt"></colgroup><tbody> <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> 60,000 $5.15 20000 5.6 15,271 $5.25 30000 5.6 4,880 $5.25 18,500 $5.35...