Results 1 to 8 of 8

Smooth data/moving average

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Smooth data/moving average

    Hello. I am having trouble smoothing or averaging data. Say I have data in A1 through A1000. I would like to make B1 the average of A1 - A5, B2 the average of A6-A10 and so on. Seems like it should be a simple series fill, but it won't work. Any suggestions? Thanks!
    Last edited by scottjn; 03-18-2010 at 08:58 PM.

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