Results 1 to 10 of 10

Finding an Average of every 25 rows.

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    5

    Finding an Average of every 25 rows.

    Hi there, ive been given a large data set for a uni project which is too large to be useful at the minute. It consists of about 30,000 rows of element abundances for every 0.2mm of a sediment core. A sample of the file is attatched.

    I would like to find the average of all the elements for every 5mm (so every 25 rows) of the sediment core with out having to go through every row individually finding an average. Ideally the average would be plotted against the medial depth of the values averaged i.e for the first 5mm the average would be plotted against 50.25cm.
    Sorry if ive not given enough info (if not just let me know). Any help would be very much appreciated.
    Attached Files Attached Files
    Last edited by rtb1991; 11-12-2012 at 04:46 PM.

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