weighted average

  1. D

    Calculate weighted averages from a subset of data.

    Hi all, I have a subset example of my data below to help with this question. <tbody> A B C 1 Seam TK*RD ASH 2 A 2 5 3 A 1.8 6 4 A 2 5 5 B 3 10 </tbody> What I need to be able to do is calculate the weighted average 'ASH' value when the 'SEAM' column equals "A". To do this for...
  2. Z

    Weighted average ignoring zero values in pivot

    First timer posting here! I need to calculate average of material purchase prices, weighted by their mass, while ignoring zero values, in each factory separately. There are several different countries, factories and materials (and material & quality categories), but all the materials are...
  3. T

    Multi-Condition Weighted Average Formula

    Hello, I have a large data set and I am trying to calculate the weighted average price subject to two conditions. I know I can use SUMPRODUCT to accomplish this without the conditions, but is there anyway to make it work subject to conditions? I am hoping to be able to do this using a formula...
  4. Z

    Weighted Average Based on Multiple Criteria

    I need help writing a formula to do a weighted average base on multiple criteria. I have 4 main columns. Below is an small sample with dummy data. I really have about 500+ records. Marginal Revenue (bps) | Product Code | Trade Month | Loan Amt | .34 | C30 | 1511| 150,000 .36 | C30 | 1511|...
  5. J

    Values from a weighted average

    Hi all, I am new to the forum so hopefully this is posted in the correct place. I am trying to three derive values from a weighted average that I know. The below data starts in A1. I know the weighted average value of my data is 473.27, I need a formula to calculate the three missing values in...
  6. A

    What is the formula for a weighted average with cells possibly containing 0s

    Hello, Please assist i am trying to write a formula that will take that weight average of the of cells and not count any cells that have a "0" in them. my data set is; count average 8 6.832638889 12 5.388657407 10 6.961319444 2...
  7. C

    Weighted Average

    I am trying to calculate weighted averages where the weight is determined by volume. I want to calculate these weighted averages for various criteria such as Industry, year, etc...) Here is a sample of what my data looks like: <tbody> A B C 1 Volume Price Industry 2 4.5 $93.50 Cabinetry...
  8. A

    Weighted Average Formula Help

    I'm trying to write a formula to calculate the average investment size weighted by the total dollars we've invested and need to be able to separate out investments we've made through fund 1 and fund 2. I thought it would look something like this: =SUMPRODUCT(--(Cell Range ="Fund 1"),(Cell...
  9. R

    Weighted Average in Pivot Table

    Hi everyone, I have a question which I just can't figure out. I have a pivot table and want to create a weighted average from that data. I have researched and people suggest to do this by using a calculated field. However, my data is structured differently, I have one measure per column. This...
  10. D

    Sumproduct inside a pivot table help!!

    Hi - I am in desperate need of some pivot table help! I have a pivot table as shown below. The column titled "Value 1" is a calculated field that I added to my pivot table. The Column Called "Tier Weight" is the average of static values that are in my raw data sheet based on whether or not...
  11. R

    Calculating profit and loss and open positions by date

    Hi all, I have a tradesheet from my equity portfolio that looks something like the below (but much much longer). I have this in a table in an Access database at the moment. I have two queries that I was hoping someone could assist with: 1. I would like to be able to look at the open positions...
  12. K

    Calculating a weighted average with non-consecutive cells

    Hi there, (First time poster!) I'm working on a pretty large file. I want to calculate a weighted average on the left hand side of my excel spreadsheet. I have several tables (15 to be exact) and each table has 10ish columns. I want to calculate a weighted average using just 2 columns from...
  13. R

    Weighted Average

    I am running a price analysis on products that we have purchased last year and attempting to compare it to the market average each week. To identify the products we have assigned 4 letter product codes to each product (LAMD, LANR ect.). The information I want the weighted average for is in...
  14. M

    Small but hard Challenge

    Hey guys, I have been using excel for a long time now and I consider myself relatively good at it. However I have been having a headache trying to solve a kind of complex weighted average in a table like this: <tbody> Client name Broker Share Client&Share Quantity Avg Price (in Broker) Avg...
  15. D

    Extracting data from Polynomial regression equation

    Hi all, Apologies if this question seams disjointed but I am having trouble organising my thoughts. I've decided just to put what I can into words a hope someone can help. I have a cumulative data set as follows. I have graphed this data and created a 3rd order polynomial regression equation...
  16. E

    Weighted Average

    Can you please assist me in getting the weighted average of the following data? This is for a 9 day performance and I wanted to rank them accordingly with their performance. Thank you! <tbody> Evaluator Jameel Jameel Jameel Jameel Jameel Fahad Fahad Fahad Fahad Average Date...
  17. M

    Weighted average w/ multiple text criteria excel 2010

    hi i'm looking to get a weighted average from a table (in 'database format') for specific rows. i'm working on excel 2010. below might help to convey the idea of what i am trying to achieve, although the actual solution will probably differ considerably...
  18. L

    Weighted Averages for a Final Grade MS Excel 2007 Question

    I have a formula that is not working, wondering if anyone can help. Perhaps I am using the wrong function? Looking for nothing fancy, it is for an 11th grade homework assignment) Looking for a weighted average for a Final Quarter Grade =AVERAGE(G4*0.5)+(J4*0.1)+(M4*0.2)+(N4*0.2) G4=90 (out...
  19. M

    Weighted Average with conditions

    Hi Everyone , I'm trying to figure out the forumla to calculate the weighted average if Contract# from table 1 = Contract # from table 2 & Invoice Date from Table 1 = Date from Table 2. anyone can help?? <tbody> Table1 Cotract# Invoice Date Volume Price Con01 20-Mar-13 1000...
  20. S

    Weighted Probabilities with random numbers

    Hi guys, this has been killing me but does anyone know how to incorporate weighted probabilities with random numbers? For example: I need to have a random number between 1-9 and have these probabilities: <tbody> 1 5% 2 10% 3 0% 4 20% 5 30% 6 10% 7 10% 8 10% 9 5% </tbody> Any...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top