# [ferret_users] Monthly average from 10 day mean Data

Hi Ferret users,

I want to calculate the monthly average of my data, which is having mean of 10 Days for each month. The time axis of my data is as follows.

sh axis taxis
name       axis              # pts   start                end
TAXIS     TIME               171 i   10-JAN-2010 00:00    30-SEP-2014 00:00
T0 = 15-JAN-1901 00:00:00
Axis span (to cell edges) = 1734

Listing of data at a particular point is as below

10-JAN-2010 00 /   1:  101.4
20-JAN-2010 00 /   2:  100.5
30-JAN-2010 00 /   3:   53.4
10-FEB-2010 00 /   4:   42.1
20-FEB-2010 00 /   5:   50.1
28-FEB-2010 00 /   6:   42.5
10-MAR-2010 00 /   7:   50.1
20-MAR-2010 00 /   8:   52.3
30-MAR-2010 00 /   9:   53.7
10-APR-2010 00 /  10:   54.5
20-APR-2010 00 /  11:   60.5
30-APR-2010 00 /  12:   55.7
10-MAY-2010 00 /  13:   53.0
20-MAY-2010 00 /  14:   77.6
30-MAY-2010 00 /  15:   55.0
10-JUN-2010 00 /  16:   75.1
20-JUN-2010 00 /  17:   75.5
30-JUN-2010 00 /  18:   76.1
10-JUL-2010 00 /  19:   77.1
20-JUL-2010 00 /  20:   77.9
30-JUL-2010 00 /  21:   77.6
10-AUG-2010 00 /  22:   76.3
20-AUG-2010 00 /  23:   75.7
30-AUG-2010 00 /  24:  101.1
10-SEP-2010 00 /  25:   81.1
20-SEP-2010 00 /  26:   85.9
30-SEP-2010 00 /  27:  101.0
10-OCT-2010 00 /  28:  104.4
20-OCT-2010 00 /  29:   45.7
30-OCT-2010 00 /  30:  125.4
10-NOV-2010 00 /  31:  123.2
20-NOV-2010 00 /  32:  107.3
30-NOV-2010 00 /  33:  116.7
10-DEC-2010 00 /  34:  129.0
20-DEC-2010 00 /  35:  126.0
30-DEC-2010 00 /  36:  114.5
10-JAN-2011 00 /  37:  125.7
20-JAN-2011 00 /  38:   98.4
30-JAN-2011 00 /  39:   51.1
10-FEB-2011 00 /  40:  100.5
20-FEB-2011 00 /  41:   87.0
28-FEB-2011 00 /  42:   76.0
10-MAR-2011 00 /  43:   33.6
20-MAR-2011 00 /  44:   71.3
30-MAR-2011 00 /  45:   77.5
10-APR-2011 00 /  46:   76.4
20-APR-2011 00 /  47:   54.7
30-APR-2011 00 /  48:   53.7
10-MAY-2011 00 /  49:   89.2
20-MAY-2011 00 /  50:   75.1
30-MAY-2011 00 /  51:   57.8
10-JUN-2011 00 /  52:   55.0
20-JUN-2011 00 /  53:   55.1
30-JUN-2011 00 /  54:   77.2
10-JUL-2011 00 /  55:   75.9
20-JUL-2011 00 /  56:   78.2
30-JUL-2011 00 /  57:   75.6
10-AUG-2011 00 /  58:   51.1
20-AUG-2011 00 /  59:   50.5
30-AUG-2011 00 /  60:   50.3
10-SEP-2011 00 /  61:   44.2
20-SEP-2011 00 /  62:   34.4
30-SEP-2011 00 /  63:   40.4
10-OCT-2011 00 /  64:   53.0
20-OCT-2011 00 /  65:   52.9
30-OCT-2011 00 /  66:   56.3
10-NOV-2011 00 /  67:   73.2
20-NOV-2011 00 /  68:   52.5
30-NOV-2011 00 /  69:   48.9
10-DEC-2011 00 /  70:   45.5
20-DEC-2011 00 /  71:   77.6
30-DEC-2011 00 /  72:  102.7
10-JAN-2012 00 /  73:   94.9
20-JAN-2012 00 /  74:  100.9
30-JAN-2012 00 /  75:   82.1
10-FEB-2012 00 /  76:   76.0
20-FEB-2012 00 /  77:   75.8
28-FEB-2012 00 /  78:   76.5
10-MAR-2012 00 /  79:   55.1
20-MAR-2012 00 /  80:   76.4
30-MAR-2012 00 /  81:   62.2
10-APR-2012 00 /  82:   52.0
20-APR-2012 00 /  83:   50.1
30-APR-2012 00 /  84:   51.0
10-MAY-2012 00 /  85:   75.4
20-MAY-2012 00 /  86:   76.1
30-MAY-2012 00 /  87:   76.9
10-JUN-2012 00 /  88:   83.1
20-JUN-2012 00 /  89:   79.7
30-JUN-2012 00 /  90:   79.8
10-JUL-2012 00 /  91:   63.7
20-JUL-2012 00 /  92:   76.0
30-JUL-2012 00 /  93:   79.8
10-AUG-2012 00 /  94:   77.2
20-AUG-2012 00 /  95:   64.6
30-AUG-2012 00 /  96:   58.8
10-SEP-2012 00 /  97:   55.4
20-SEP-2012 00 /  98:   46.3
30-SEP-2012 00 /  99:   51.1
10-OCT-2012 00 / 100:   76.6
20-OCT-2012 00 / 101:   77.9
30-OCT-2012 00 / 102:   78.2
10-NOV-2012 00 / 103:   78.1
20-NOV-2012 00 / 104:   78.3
30-NOV-2012 00 / 105:   78.1
10-DEC-2012 00 / 106:   74.2
20-DEC-2012 00 / 107:   73.1
30-DEC-2012 00 / 108:   74.2
10-JAN-2013 00 / 109:  115.6
20-JAN-2013 00 / 110:  101.2
30-JAN-2013 00 / 111:   77.7
10-FEB-2013 00 / 112:   81.7
20-FEB-2013 00 / 113:   78.5
28-FEB-2013 00 / 114:   75.9
10-MAR-2013 00 / 115:   70.9
20-MAR-2013 00 / 116:   33.6
30-MAR-2013 00 / 117:   39.4
10-APR-2013 00 / 118:   58.9
20-APR-2013 00 / 119:   50.4
30-APR-2013 00 / 120:   45.2
10-MAY-2013 00 / 121:   83.9
20-MAY-2013 00 / 122:  109.2
30-MAY-2013 00 / 123:   60.3
10-JUN-2013 00 / 124:   82.3
20-JUN-2013 00 / 125:  101.3
30-JUN-2013 00 / 126:   93.2
10-JUL-2013 00 / 127:   77.4
20-JUL-2013 00 / 128:   77.5
30-JUL-2013 00 / 129:   76.5
10-AUG-2013 00 / 130:   77.4
20-AUG-2013 00 / 131:   76.2
30-AUG-2013 00 / 132:   75.0
10-SEP-2013 00 / 133:   78.7
20-SEP-2013 00 / 134:   55.6
30-SEP-2013 00 / 135:   28.9
10-OCT-2013 00 / 136:   58.9
20-OCT-2013 00 / 137:   54.4
30-OCT-2013 00 / 138:   55.7
10-NOV-2013 00 / 139:   75.6
20-NOV-2013 00 / 140:   57.9
30-NOV-2013 00 / 141:   75.2
10-DEC-2013 00 / 142:   78.0
20-DEC-2013 00 / 143:   89.1
30-DEC-2013 00 / 144:   79.3
10-JAN-2014 00 / 145:   87.4
20-JAN-2014 00 / 146:   76.2
30-JAN-2014 00 / 147:   65.7
10-FEB-2014 00 / 148:   53.4
20-FEB-2014 00 / 149:   54.0
28-FEB-2014 00 / 150:   53.4
10-MAR-2014 00 / 151:   30.3
20-MAR-2014 00 / 152:   17.6
30-MAR-2014 00 / 153:   30.3
10-APR-2014 00 / 154:   19.5
20-APR-2014 00 / 155:   39.6
30-APR-2014 00 / 156:   19.5
10-MAY-2014 00 / 157:   48.0
20-MAY-2014 00 / 158:   53.4
30-MAY-2014 00 / 159:   48.0
10-JUN-2014 00 / 160:   60.0
20-JUN-2014 00 / 161:  102.1
30-JUN-2014 00 / 162:   60.0
10-JUL-2014 00 / 163:   85.9
20-JUL-2014 00 / 164:  102.8
30-JUL-2014 00 / 165:   85.9
10-AUG-2014 00 / 166:  101.3
20-AUG-2014 00 / 167:   85.2
30-AUG-2014 00 / 168:  101.3
10-SEP-2014 00 / 169:    5.6
20-SEP-2014 00 / 170:   25.7
30-SEP-2014 00 / 171:   50.6

I would be grateful, if anybody can help me regarding this problem..