+ Reply to Thread
Results 1 to 5 of 5

How to calculate weighted average

  1. 04-19-2017, 10:08 AM #1
    Raehan
    Raehan is offline
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    How to calculate weighted average

    Hi everyone,

    Can someone please help me understanding how the weighted average and industry split were calculated in the attached? I have been trying Sumproduct formula but maybe I am not doing it right.

    Thanks,
    Rae
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-19-2017, 10:41 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How to calculate weighted average

    assuming your percentages are in B2:B4 and employees No. in D2:D4 use
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    industry split is probably just
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 04-19-2017, 11:07 AM #3
    Raehan
    Raehan is offline
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Re: How to calculate weighted average

    Hi Kaper, thank you for looking into this. The 25% of weighted average works out well based on your formula but not 76% and industry split is also not working. When you say E1/E5, you mean 25%/76%? Sorry I have attached the Excel file this time.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-19-2017, 11:23 AM #4
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How to calculate weighted average

    Sorry to say so, but I see no point why E5 shall be 76% not 67%
    Reply With QuoteRegister To Reply
  5. 04-19-2017, 11:45 AM #5
    Raehan
    Raehan is offline
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Re: How to calculate weighted average

    That would be non-weighted average.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate weighted average based on a date
    By danallamas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2016, 10:59 PM
  2. How to calculate the weighted average of duration or time
    By BlueCollarCritic in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2016, 04:58 PM
  3. [SOLVED] Using Sumproduct to calculate weighted average
    By Excel15 in forum Excel General
    Replies: 3
    Last Post: 03-11-2015, 10:33 AM
  4. [SOLVED] Help with IF and SUMPRODUCT to calculate weighted average??
    By consulttk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 03:56 PM
  5. How can I calculate a weighted average in a Pivot Table?
    By petevang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2012, 12:56 PM
  6. Calculate weighted average with missing values
    By Deiseman in forum Excel General
    Replies: 9
    Last Post: 06-08-2010, 10:03 AM
  7. Weighted Average with NA...can't calculate
    By salmanjan in forum Excel General
    Replies: 5
    Last Post: 04-18-2008, 08:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1