马尔可夫预测法与Excel——利用Excel的“规划求解”工具解决马尔可夫预测的计算

Markov Pre-measurement and EXCEL——How to Compute by Plan Solution of Excel

马尔柯夫预测法在市场占有率、市场销售状况、期望利润预测中有着广泛的应用,但其计算过程比较复杂,手工计算难以完成。在EXCEL中,利用规划求解工具可以实现马尔柯夫预测法的全部计算,不仅操作简便,而且可以大大提高预测的效率和精度。

Markov pre-measurement has widespread application in economy management and market forecast, but the computation process quite is complex. The author solved this kind of question effectively by plan solution of EXCEL .