+ Reply to Thread
Results 1 to 3 of 3

Computing the monthly mean value from daily data

  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    Milano
    MS-Off Ver
    Excel 2013
    Posts
    7

    Computing the monthly mean value from daily data

    As title suggests, I have to compute the mean of daily values on monthly basis.

    The problem consists on the fact that each month has different number of days. I have date data in column A, daily data in column B and I need for computing the arithmetic average for each month in column C.

    Can someone can help me?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Computing the monthly mean value from daily data

    How are you laying out column C? To show averages by month, you also need another column telling you what month the average is for. See sample attached. Hopefully you can modify this to suit your format.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-06-2014
    Location
    Milano
    MS-Off Ver
    Excel 2013
    Posts
    7

    Re: Computing the monthly mean value from daily data

    it has been help to me.
    Thanks!
    Can I also ask you for computing monthly standard deviation from daily data?

+ 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. Help with tidal data - computing daily max and min of sin curve
    By rlowgren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2014, 04:02 PM
  2. Sum daily data on Monthly
    By SDMA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2013, 07:32 AM
  3. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  4. Calculate daily targets given: month, monthly budget, daily indexes
    By Chuckyrp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 03:30 AM
  5. Replies: 1
    Last Post: 07-11-2008, 05:57 AM

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