weighted average

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...

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...

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...

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|...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...