Re: Moving average
Rick James Wrote:
-------------------------------------------------------
> Please show me the Excel formula that gives you
> 62.062,5.
thank you...
YEARS MONTHS F1 F2 F3 F_SUM AVERAGE_12_MONTHS VAR
2013 09 16470.56 8159.76 16271.92 40902.24 62062.5
In excel the column is F_SUM
=MEDIA(F43:F54)
Rows between F43 and F54 the column is F_SUM:
YEARS MONTHS F1 F2 F3 F_SUM AVERAGE_12_MONTHS VAR
2012 10 75514.00438 35562.0016 63570.9984 174647. 167.159.3
2012 11 47608.00044 30661.00425 62245.0048 140514.01 167.159.39
2012 12 13527.2 10924.04032 26763.04036 51214.28 160.841.91
2013 01 15955.44 9888.8 18707.36 44551.6 152.505.38
2013 02 14813.76 9452.24 17036.08 41302.08 144.680.8
2013 03 13567.92 9950.64 18263.44 41782. 135.687.
2013 04 12965.6 8086 17543.6 38595.2 125.362.51
2013 05 12363.76 8034.64 16605.04 37003.44 113.103.72
2013 06 15822.88 8388.88 16211.92 40423.68 100.506.61
2013 07 21269.04 9082.4 16352.48 46703.92 87.119.27
2013 08 18727.44 10274.16 18108.96 47110.56 74.416.31
2013 09 16470.56 8159.76 16271.92 40902.24 62.062.5
Edited 1 time(s). Last edit at 11/04/2013 05:25AM by angel rivero.
Subject
Written By
Posted
November 02, 2013 04:15PM
November 03, 2013 04:18AM
November 03, 2013 10:36PM
Re: Moving average
November 04, 2013 04:53AM
November 04, 2013 10:52PM
November 05, 2013 02:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.