+ Reply to Thread
Results 1 to 2 of 2

Avg numbers in specified interval from non-interval data

  1. #1
    Forum Contributor
    Join Date
    06-18-2012
    Location
    Denver, CO
    MS-Off Ver
    Excel 2013
    Posts
    118

    Avg numbers in specified interval from non-interval data

    Hello,

    I didn't really know how to explain this in the title, but hopefully I can do better here.

    I have a data set collected from a temp sensor. The data is simply a time range and temperature reading. Each new line is created as the sensor detects a change in temperature. There will be periods where the temperature is consistent for an hour, or it changes in a minute. ex:

    A B
    Min Temp
    1 72.4
    17 73.1
    31 73.4
    2 73.0
    5 72.8

    What I want to do is filter this data into 15 min intervals. So the weighted average temperature for the first 15 min would be ((1*72.4)+(14*73.1))/15 = 73.05

    If I create a column with the interval, what's the corresponding formula to give me the weighted avg?

    Interval
    15 73.05
    30 ?
    45
    60
    etc.

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Avg numbers in specified interval from non-interval data

    Hi,

    Have a look at this. Does it work for you?

    Hope it helps
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 04-23-2012, 10:06 AM
  2. Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 02:05 PM
  4. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  5. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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