+ Reply to Thread
Results 1 to 6 of 6

How to calculate monthly average

  1. #1
    Registered User
    Join Date
    07-15-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to calculate monthly average

    Top table is how I think the monthly average should be calculated. Bottom table is how it is currently been calculated at my work place. As you can see the overall grade is not the same at the end of the month, eventhough I am using the same exact numbers. Can anyone help me find the correct way?
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to calculate monthly average

    overall grade is not the same
    From where you are comparing .. I see both the overall all grades (which are in Y11 and Y17) are using different numbers and hence the average will be different. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    07-15-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to calculate monthly average

    But do you see on the top table I'm calculating the weekly average first and then at the end of the month I get the weekly average and with that generate the monthly average? And on the bottom table 2nd week's average is added to the first week's average, third week's average isadded to the 2nd and 1st week's average and so on? And at the end of the month that's causingthe overall grade to be different?

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to calculate monthly average

    Not sure.... are you calculating average of average?

    As you can see the overall grade is not the same at the end of the month, eventhough I am using the same exact number
    Best check would be to list down the numbers which are getting averaged in both the scenarios and then compare if both the list is same

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    07-15-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to calculate monthly average

    Yeah! does what I thought in the second table first week's average is already calculated and then second weeks' average is averaged again to the first weeks' average and I dont think this is the correct way to do it. Right?

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to calculate monthly average

    yes..

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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