Running Average in Numbers

Discussion in 'iWork Forum' started by daker, Aug 6, 2011.

  1. daker
    Offline

    daker iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Hello. I was wondering if anybody knew how to create a running average in Numbers. I take data weekly, and each time I need to add a new column of cells. These newly added cells need to be used as part of my average function, but I don't want to go back to the equation cell and add the newly created cells. Can someone make this easier for me? Thanks!
  2. 88raymond
    Offline

    88raymond iPad Fan

    Joined:
    Jul 22, 2011
    Messages:
    285
    Thanks Received:
    5
    Trophy Points:
    0
    Ratings:
    +5 / 0
    the best i can offer is to set up one-time.. increase to 52 columns initially for the 52 weeks of the year, and then use the average function to cover the entire range. you don't need to worry as the function considers only non-blank cells.
    Last edited: Aug 6, 2011

Share This Page

Search tags for this page
average function in numbers app
,
average on mac numbers
,
calculating mean in mac numbers
,
getting average on apple ipads numbers
,
how do i make an average on numbers on mac
,
how to average numbers in numbers for ipad
,
how to average times in apple numbers
,
how to calculate average on apple ipad numbers
,
how to do averages on numbers app
,
how to find a moving average in mac numbers
,
how to find average in numbers app
,
how to get an average in mac numbers
,

iworks numbers create an average

,

mac numbers moving average

,
moving average in iwork
,
numbers app how to average numbers
,
numbers ipad app average
,
rolling average nubers mac
,

running average in numbers

,
running average of seria of numbers