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..