Running Average in Numbers

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

  1. daker

    daker
    Expand Collapse
    iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    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
    Expand Collapse
    iPad Fan

    Joined:
    Jul 22, 2011
    Messages:
    285
    Thanks Received:
    5
    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.
     
    #2 88raymond, Aug 6, 2011
    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
,
iworks numbers create an average
,
mac numbers moving average
,
moving average in mac numbers
,

running average in numbers

,
running average of seria of numbers