Excel实现马尔可夫法生产预测  

Excel Solution of Markov Model for Production Forecasting

作　　者：金晓龙[1] 

机构地区：[1]广东女子职业技术学院应用设计系,广州511450

出　　处：《电脑开发与应用》2012年第9期37-38,42,共3页Computer Development & Applications

摘　　要：马尔可夫法是使用马尔可夫链的基本原理和方法来预测事物的未来变化趋势,利用状态转移概率来预测某一事物发生的可能程度。使用Excel的工作表和自定义宏函数,采用马尔可夫法来对企业的盈利情况进行预测,并在Excel的VBA环境编程运行。The Markov method is used to predict future trends by the basic principles and methods of Markov chain. Possiblity that something may happen is predicted by using the state transition probability. This article describes how to solve the problem of Markov model for production forecasting by using Excel worksheet and custom macro functions, all is proved by programming and running in Excel VBA.

关 键 词：EXCEL 马尔可夫 VBA 预测 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]