weighted average

Hi, I made a formula that works: =SUMPRODUCT(Answer!U2:U65535,Answer!AD2:AD65535)/SUM(Answer!AD2:AD65535) however, I need to update it for multiple conditions and I'm having some trouble with the specifics. Referencing sheet "Answer", I want to perform the same calculation as above but for the...

I need to calculate the standard deviation and weighted average of a large set of data. A sample of the data: Job Title Frequency Rate Proj Mgr 1 4 22.00 Proj Mgr 1 2 22.53 Proj Mgr 1 5 21.13 Proj Mgr 1...

Hello, I have figured out how to calculate the total weighted average in my data sheet with this formula: =SUMPRODUCT((DATA!AA285:AA20000)*(DATA!N285:N20000))/(SUM(DATA!N285:N20000)) Now I need to figure out, how I can calculate this with two criterias; 1) DATA!AH285:AH20000=Distrikter!C3 2)...

I have a powerpivot table with 2 years of data. I am trying to use a measure function in excel pivot tables to calculate a weighted average of revenue generated weighted by sales volume. Ultimately My data is split into 4 fields Sale Date Sales Method Sales Volume...

I have a spreadsheet with the following data (sample): What I am trying to do is the following: I want to calculate the average Conversion rate for each Unit per Month for the ABC Core Product Customers will only have one Core Product, either ABC or something else. If the customer does not...

I would like help in creating the formula that would weigh a third number: Each month, I collect the following data. I would like to be able to create a weighed conversion rate: ..........Showings......Contracts.........Listings......Conversion Rate...

Hello. I am trying to calculate a weighted average from 2 sets of data: 1 set is an array in a worksheet, and the 2nd set is a range of values that share a specific location across multiple worksheets. I was trying to use the following (example) formula to calculate the weighted average from...

I have a set of data that I ran Excel's embedded Subtotals function in the Data tab and used the Sum function in column "I" for each change in column "B". I am wanting to do a weighted average of column "L" based on column "I". I found this set of code in the forum that should take of this...

I have a need to calculate the weighted average spread based on whether the date in a column ("N") fits a given date criteria (and some other criteria). If text as opposed to a date is in the column, the result changes. I would like the option of having a date or text in that cell and have the...

I'm trying to come up with a weighted average formula for commodity futures curves. The end goal is to produce a confidence band for where future commodity prices will be. If I simply use a formula that rolls off each futures contract at expiry, the confidence band looks jagged on a graph...

I am trying to write a VBA routine to combine certain rows using Excel 2007. I have a table with columns PartNo, Type, Customer, Data, Qty, Price. Data is sorted by PartNo, Type, Customer. When multiple rows have the same PartNo, Type, Customer, I want to combine these rows into a single row...

Hi, I am in need of a simpler formula, I should clarify, a less clumsy formula. I have developed a weighted average emission factor for each pollutant and power setting using INDEX and MATCH. The weighting values are based on the number of tests on one sheet, and the corresponding emission...

I am trying to get a weighted average of each CPT in my Pivot Table for Excel 2007. Can anyone help me? Please keep you answers in simple terms (I am not as experienced). I'm also new to the website, so I apologize if this is posted incorrectly! Here is what my pivot table shows (The XXXX...

I currently have the following code to generate a random number between the constraints of B9 and B8 (dynamic): Randomize MyValue = Int((Range("B9") - Range("B8")) * Rnd + 0.5) + Range("B8") As it currently is calculated, each number in that range of B8:B9 (ex: 1-4) is weighted equally...

Needing to reduce the size of the formula below used to calculate the weighted average, I've tried using your suggestion of {=SUMPRODUCT(A1:A10*B1:B10)/SUM(B1:B10)}. However, using this formula gives me different value than the longer formula below...

I appreciate all I find in these forums and after searching for hours I don’t think I’ve found what I’m after completely this time but have found all the parts of the problem. (I’ll apologize in advance if I missed this answer.) So now, how to put it all together? <?xml:namespace prefix = o ns...

Hi everyone - huge thanks in advance to anyone that can offer some assistance with this problem. I have a 6x5 matrix with a series of data in it. It is as simple as this: Row 13: 0 1 2 3 4 Row 14: 0 1 2 3 4 and this is repeated over for 6 rows. The figures in each cell can increase or...

I am trying to get a weighted average from a pivot table and I am trying to use insert calculated field. Currently I am getting the pivot tables and copying those in a regular spreadsheet to do the weighted average calculations. Very time consuming!! 00000000000-000014 9,300 253,692...