+ Reply to Thread
Results 1 to 2 of 2

How to calculate average of percentage

  1. #1
    Forum Contributor
    Join Date
    09-15-2014
    Location
    london
    MS-Off Ver
    2013
    Posts
    111

    How to calculate average of percentage

    Employee 06/01/2017 06/02/2017 06/05/2017 06/06/2017 06/07/2017 06/08/2017 06/09/2017 06/12/2017 06/13/2017 06/14/2017 06/15/2017 06/16/2017 06/19/2017 06/20/2017 06/21/2017 06/22/2017 06/23/2017 06/26/2017 06/27/2017 06/28/2017 06/29/2017 06/30/2017 Average
    BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime
    Emp 1 51.85% 53.15% 80.56% 80.93% 87.22% 89.81% 82.41% 78.52% 86.30% 92.59% 91.85% 103.70% 95.74% 95.74% 92.87% 93.15% 102.04%
    Emp 2 100.93% 100% 106.11% 100.65% 99.28% 85.94% 87.67% 120.19% 106.57% 103.98% 107.78% 103.33% 101.02% 94.44% 93.80% 82.22% 112.04% 109.44% 102.69%
    Emp 3 72.69% 67.59% 107.41% 88.89% 64.07% 70.37% 55.74% 110.19% 81.48% 86.48% 32.22% 80.65% 83.06% 59.26% 63.89% 52.78% 93.52% 154.26% 69.44% 61.11% 66.67%
    Emp 4 40% 47.78% 64.89% 66.52% 99.44% 111.59% 87.04% 97.67% 51.39% 69.70% 106.85% 59.44% 73.28% 86.06% 60.59% 58.70% 82.80% 67.96% 71.50% 86.11% 96.30%
    Emp 5 92.26% 86.07% 87.07% 95.50% 111.19% 113.65% 106.57% 86.48% 89.50% 109.89% 101.59% 101.07% 82.26% 75.80% 129.89% 108.98% 116.76% 110.19%
    Emp 6 66.78% 80.07% 88.07% 104.17% 54.65% 66.48% 71.85% 107.70% 91.81% 71.46% 70.98% 80.24% 93.28% 114.11% 98.02% 72.26% 71.06% 109.26% 81.22%
    Emp 7 78.98% 132.78% 75% 46.11% 98.33% 99.44% 107.04% 89.26% 99.63% 63.89% 95.09% 111.67% 73.33% 94.63% 63.52% 73.70% 110.19% 157.31% 82.13% 80.37% 140.19%
    Emp 8 73.33% 67.96% 67.69% 50% 58.61% 69.81% 81.85% 62.96% 70.09% 80.56% 82.22% 54.91% 79.07% 48.43% 74.17% 72.50% 62.69%
    Emp 9 72.22% 83.80% 115.19% 78.89% 112.96% 80.56% 70% 96.85% 90.09% 87.96% 110.65% 131.30% 99.83% 105.19% 91.52%
    Emp 10 101.50% 91.44% 115.15% 113.96% 101.81% 108.57% 72.20% 103.65% 114.26% 72.37% 95.67% 98.93% 99.59% 101.44% 87.83% 67.15% 119.43% 103.46% 112.70% 116.78%
    Emp 11 54.06% 90.09% 66.78% 85.28% 88.78% 64.39% 50.41% 77.85% 58.44% 67.89% 99.91% 75.89% 101.80% 106.67% 78.83% 74.72% 112.09% 114.70% 73.09%
    Emp 12 61.11% 64.81% 125.65% 97.41% 84.63% 64.07% 82.28% 101.13% 105.56% 99.78% 98.81% 103.65% 103.76% 115.33% 106.48% 88.63% 88.59% 75.22% 103.33% 108.98% 100% 96.67%



    "How do I calculate average of %. I know I can just apply Avg formula which will give me the Avg % but that is arithmetically incorrect. Because we should not calculate Avg of %.
    And denominate (no of days worked will change from one person to another. As you can see few would have worked for entire month and few would have taken leaves in between"

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,315

    Re: How to calculate average of percentage

    To calculate an average of percentages, you have to know more than just the percentages. One way is to take the sum of the numerators and divide by the sum of the denominators. If your percentages are calculated, then you should be able to do this.

    Instead of pasting your date in as text, please attach your file so we can see where these numbers come from. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate average of every nth Cell in Excel when data is a percentage
    By lindystep in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2015, 05:54 PM
  2. Calculate average percentage for specific selected cells
    By me1992 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2013, 03:54 PM
  3. Replies: 13
    Last Post: 07-12-2012, 03:21 PM
  4. [SOLVED] calculate average in percentage coloumn with #DIV/! (ignore error
    By neelsels SA in forum Excel General
    Replies: 2
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] calculate monthly average percentage of change
    By vikgarden in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2005, 03:06 PM
  6. Need formula to calculate average monthly percentage of change...
    By vikgarden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2005, 02:06 PM
  7. How do I create a formula to calculate the average percentage rat
    By LD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2005, 03:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1