Running Average in Numbers

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

  1. daker

    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

    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
,
calculating mean in mac numbers
,
how do i make an average on numbers on mac
,
how to calculate average on apple ipad numbers
,
how to find a moving average in mac numbers
,
how to find average on numbers app
,
iworks numbers create an average
,
mac numbers moving average
,

running average in numbers

,
running average of seria of numbers