MySQL Forums
Forum List  »  Newbie

Re: Moving average
Posted by: angel rivero
Date: October 30, 2013 02:40AM

thank you for help.
this is new version of table `page1-1`.
I've update in column `F_SUM` with sum of colums values `F1`, `F2` and `F3`.

But I can not calculate the average dynamic... because in the column `AVERAGE_12_MONTHS` is a line feed, e.g.:
    [*]In the record number 12 I've the average of records 1,2,3,4,5,6,7,8,9,10,11 and 12
    [*]In the record number 13 I've the average of records 2,3,4,5,6,7,8,9,10,11,12 and 13
    [*]In the record number 14 I've the average of records 3,4,5,6,7,8,9,10,11,12,13 and 14
    [*].....
-- ----------------------------
-- Table structure for `page1-1`
-- ----------------------------
DROP TABLE IF EXISTS `page1-1`;
CREATE TABLE `page1-1` (
  `YEARS` int(11) DEFAULT NULL,
  `MONTHS` int(11) DEFAULT NULL,
  `F1` decimal(10,4) DEFAULT NULL,
  `F2` decimal(10,4) DEFAULT NULL,
  `F3` decimal(10,4) DEFAULT NULL,
  `F_SUM` varchar(255) DEFAULT NULL,
  `AVERAGE_12_MONTHS` varchar(255) DEFAULT NULL,
  `VAR` varchar(255) DEFAULT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of page1-1
-- ----------------------------
INSERT INTO `page1-1` VALUES ('2009', '5', '92626.4000', '32796.5600', '59924.6400', '185347.6000', '', '', '1');
INSERT INTO `page1-1` VALUES ('2009', '6', '95008.6400', '31933.6000', '56977.8400', '183920.0800', '', '', '2');
INSERT INTO `page1-1` VALUES ('2009', '7', '111853.1200', '33091.9200', '53262.4000', '198207.4400', '', '', '3');
INSERT INTO `page1-1` VALUES ('2009', '8', '108379.9200', '32500.4800', '60452.6400', '201333.0400', '', '', '4');
INSERT INTO `page1-1` VALUES ('2009', '9', '102605.4400', '34639.3600', '58108.4000', '195353.2000', '', '', '5');
INSERT INTO `page1-1` VALUES ('2009', '10', '83442.5600', '31952.4000', '52181.6000', '167576.5600', '', '', '6');
INSERT INTO `page1-1` VALUES ('2009', '11', '55527.8400', '24864.0000', '47962.8000', '128354.6400', '', '', '7');
INSERT INTO `page1-1` VALUES ('2009', '12', '45067.2800', '21627.2800', '50793.6000', '117488.1600', '', '', '8');
INSERT INTO `page1-1` VALUES ('2010', '1', '50108.6386', '32070.3592', '88992.3954', '171171.3932', '', '', '9');
INSERT INTO `page1-1` VALUES ('2010', '2', '45229.0026', '32119.9970', '57848.0026', '135197.0022', '', '', '10');
INSERT INTO `page1-1` VALUES ('2010', '3', '51329.9947', '34104.9989', '64472.8217', '149907.8153', '', '', '11');
INSERT INTO `page1-1` VALUES ('2010', '4', '47097.9986', '38268.0023', '77124.0064', '162490.0073', '', '', '12');
INSERT INTO `page1-1` VALUES ('2010', '5', '43667.0032', '31968.9999', '108472.0064', '184108.0095', '', '', '13');
INSERT INTO `page1-1` VALUES ('2010', '6', '55458.9969', '32521.0012', '103608.0000', '191587.9981', '', '', '14');
INSERT INTO `page1-1` VALUES ('2010', '7', '99716.0032', '33510.9958', '74126.9942', '207353.9932', '', '', '15');
INSERT INTO `page1-1` VALUES ('2010', '8', '101051.9955', '31377.0024', '67117.9971', '199546.9950', '', '', '16');
INSERT INTO `page1-1` VALUES ('2010', '9', '72834.0026', '35291.0002', '81023.0042', '189148.0070', '', '', '17');
INSERT INTO `page1-1` VALUES ('2010', '10', '42791.0036', '44317.0016', '87538.9998', '174647.0050', '', '', '18');
INSERT INTO `page1-1` VALUES ('2010', '11', '41505.9969', '32237.0001', '66770.9952', '140513.9922', '', '', '19');
INSERT INTO `page1-1` VALUES ('2010', '12', '38599.0050', '27211.9987', '61212.9974', '127024.0011', '', '', '20');
INSERT INTO `page1-1` VALUES ('2011', '1', '55458.9976', '28852.9989', '60279.0048', '144591.0013', '', '', '21');
INSERT INTO `page1-1` VALUES ('2011', '2', '46786.0049', '29952.0022', '58459.0003', '135197.0074', '', '', '22');
INSERT INTO `page1-1` VALUES ('2011', '3', '52550.0057', '32447.0006', '64910.7606', '149907.7669', '', '', '23');
INSERT INTO `page1-1` VALUES ('2011', '4', '39288.9992', '41818.0032', '81383.0011', '162490.0035', '', '', '24');
INSERT INTO `page1-1` VALUES ('2011', '5', '84902.9996', '32890.0020', '66315.9978', '184108.9994', '', '', '25');
INSERT INTO `page1-1` VALUES ('2011', '6', '94883.7325', '35711.4508', '60993.8301', '191589.0134', '', '', '26');
INSERT INTO `page1-1` VALUES ('2011', '7', '113265.9990', '38767.0016', '55319.9899', '207352.9905', '', '', '27');
INSERT INTO `page1-1` VALUES ('2011', '8', '122653.8295', '28179.2513', '48713.9252', '199547.0060', '', '', '28');
INSERT INTO `page1-1` VALUES ('2011', '9', '118939.0022', '25380.0064', '44827.9981', '189147.0067', '', '', '29');
INSERT INTO `page1-1` VALUES ('2011', '10', '72671.0032', '35154.0034', '66821.9968', '174647.0034', '', '', '30');
INSERT INTO `page1-1` VALUES ('2011', '11', '52688.0399', '29032.0638', '58792.8915', '140512.9952', '', '', '31');
INSERT INTO `page1-1` VALUES ('2011', '12', '50778.1824', '24184.4189', '52061.3935', '127023.9948', '', '', '32');
INSERT INTO `page1-1` VALUES ('2012', '1', '67452.0000', '27755.9989', '49381.9981', '144589.9970', '', '', '33');
INSERT INTO `page1-1` VALUES ('2012', '2', '65157.0003', '25064.9984', '44974.9978', '135196.9965', '', '', '34');
INSERT INTO `page1-1` VALUES ('2012', '3', '51895.9998', '35507.9970', '62303.6625', '149707.6593', '', '', '35');
INSERT INTO `page1-1` VALUES ('2012', '4', '59680.0026', '34401.9968', '68407.0042', '162489.0036', '', '', '36');
INSERT INTO `page1-1` VALUES ('2012', '5', '76293.0024', '36553.0013', '71262.9987', '184109.0024', '', '', '37');
INSERT INTO `page1-1` VALUES ('2012', '6', '91630.0031', '36862.0028', '63096.9939', '191588.9998', '', '', '38');
INSERT INTO `page1-1` VALUES ('2012', '7', '121355.0076', '35470.9997', '50525.9990', '207352.0063', '', '', '39');
INSERT INTO `page1-1` VALUES ('2012', '8', '104053.9946', '38849.0009', '56643.0022', '199545.9977', '', '', '40');
INSERT INTO `page1-1` VALUES ('2012', '9', '87243.9999', '38957.9976', '62945.9968', '189147.9943', '', '', '41');
INSERT INTO `page1-1` VALUES ('2012', '10', '75514.0044', '35562.0016', '63570.9984', '174647.0044', '', '', '42');
INSERT INTO `page1-1` VALUES ('2012', '11', '47608.0004', '30661.0043', '62245.0048', '140514.0095', '', '', '43');
INSERT INTO `page1-1` VALUES ('2012', '12', '13527.2000', '10924.0403', '26763.0404', '51214.2807', '', '', '44');
INSERT INTO `page1-1` VALUES ('2013', '1', '15955.4400', '9888.8000', '18707.3600', '44551.6000', '', '', '45');
INSERT INTO `page1-1` VALUES ('2013', '2', '14813.7600', '9452.2400', '17036.0800', '41302.0800', '', '', '46');
INSERT INTO `page1-1` VALUES ('2013', '3', '13567.9200', '9950.6400', '18263.4400', '41782.0000', '', '', '47');
INSERT INTO `page1-1` VALUES ('2013', '4', '12965.6000', '8086.0000', '17543.6000', '38595.2000', '', '', '48');
INSERT INTO `page1-1` VALUES ('2013', '5', '12363.7600', '8034.6400', '16605.0400', '37003.4400', '', '', '49');
INSERT INTO `page1-1` VALUES ('2013', '6', '15822.8800', '8388.8800', '16211.9200', '40423.6800', '', '', '50');
INSERT INTO `page1-1` VALUES ('2013', '7', '21269.0400', '9082.4000', '16352.4800', '46703.9200', '', '', '51');
INSERT INTO `page1-1` VALUES ('2013', '8', '18727.4400', '10274.1600', '18108.9600', '47110.5600', '', '', '52');
INSERT INTO `page1-1` VALUES ('2013', '9', '16470.5600', '8159.7600', '16271.9200', '40902.2400', '', '', '53');

Options: ReplyQuote


Subject
Written By
Posted
October 29, 2013 08:56AM
October 29, 2013 11:51AM
Re: Moving average
October 30, 2013 02:40AM
October 30, 2013 10:06AM
October 30, 2013 10:24AM
October 30, 2013 01:10PM
November 02, 2013 04:15PM
November 03, 2013 04:18AM
November 03, 2013 10:36PM
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.