{"title":"根据恩格尔定律在Excel中进行参数估计","authors":"S. Pivac, Mia Zoric, Ivo Eskinja","doi":"10.1504/IJIDSS.2010.033677","DOIUrl":null,"url":null,"abstract":"Engel's Laws have been frequently used in economic analysis. In this paper, the concrete relations in Croatian economy are studied according to basic postulates of Engel curve. The parameters of relevant model are estimated by respecting wages movement and luxury consumption. Beside standard method, parameters estimation has also been done by Monte Carlo simulation, which enables the basic assumptions to be fulfilled. By using such multi-objective approach, the obtained results have been presented, interpreted and comparatively analysed. All calculations are accomplished very simply in Excel. This user-friendly approach will help many users to easily solve similar complex statistical and mathematical calculations, which is useful and important for students of economic sciences in quantitative analysis.","PeriodicalId":311979,"journal":{"name":"Int. J. Intell. Def. Support Syst.","volume":"108 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2010-06-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Parameters estimation according to Engel's Law in Excel\",\"authors\":\"S. Pivac, Mia Zoric, Ivo Eskinja\",\"doi\":\"10.1504/IJIDSS.2010.033677\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Engel's Laws have been frequently used in economic analysis. In this paper, the concrete relations in Croatian economy are studied according to basic postulates of Engel curve. The parameters of relevant model are estimated by respecting wages movement and luxury consumption. Beside standard method, parameters estimation has also been done by Monte Carlo simulation, which enables the basic assumptions to be fulfilled. By using such multi-objective approach, the obtained results have been presented, interpreted and comparatively analysed. All calculations are accomplished very simply in Excel. This user-friendly approach will help many users to easily solve similar complex statistical and mathematical calculations, which is useful and important for students of economic sciences in quantitative analysis.\",\"PeriodicalId\":311979,\"journal\":{\"name\":\"Int. J. Intell. Def. Support Syst.\",\"volume\":\"108 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2010-06-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Int. J. Intell. Def. Support Syst.\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1504/IJIDSS.2010.033677\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Int. J. Intell. Def. Support Syst.","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1504/IJIDSS.2010.033677","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Parameters estimation according to Engel's Law in Excel
Engel's Laws have been frequently used in economic analysis. In this paper, the concrete relations in Croatian economy are studied according to basic postulates of Engel curve. The parameters of relevant model are estimated by respecting wages movement and luxury consumption. Beside standard method, parameters estimation has also been done by Monte Carlo simulation, which enables the basic assumptions to be fulfilled. By using such multi-objective approach, the obtained results have been presented, interpreted and comparatively analysed. All calculations are accomplished very simply in Excel. This user-friendly approach will help many users to easily solve similar complex statistical and mathematical calculations, which is useful and important for students of economic sciences in quantitative analysis.