+ Reply to Thread
Results 1 to 3 of 3

Require macro to reduce data by averaging

  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2007
    Posts
    2

    Require macro to reduce data by averaging

    Hello, I am unfamiliar with macros and have a problem that I think a macro may be able to solve.

    I have a worksheet with some columns of data:

    Time/P1/P2/P3/P4/P5

    This data was collected using LabView and a data acquistion system. The problem is the slowest speed that I could collect data was 16 samples per second. I collected about an hour of data each time I ran this test and simply have too much data to go through.

    I would like help in creating a macro that will allow me to average a number of rows (16 to 80 or something) and give me the calculated average values in 6 columns next to the 6 columns of raw data. I am simply trying to reduce the amount of data I have to work with and possibly reduce some instrument noise by averaging it out.

    If anyone has any idea how to do this (or maybe there's already some function in Excel that will let me do it quickly) let me know.

    Thanks,

    Dan
    Last edited by rylo; 08-24-2010 at 05:40 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Require macro to reduce data by averaging

    Hi

    See if this will do
    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    08-23-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Require macro to reduce data by averaging

    Hi,

    That works great!

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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