基于LINEST函数模型的市场营销预测与管理研究

On Marketing Forecast and Management Based on LINEST Function Model

市场营销处于一个竞争激烈、变幻莫测的宏观环境中,面临的形势错综复杂,为了更好地开展市场营销工作,制定正确决策进行深度营销与营销管理,确保企业竞争力,必须进行市场营销预测。在回归分析时,Excel可提供LINEST函数作为分析工具,纳入的自变量数目多,计算结果详尽。基于LINEST函数模型的市场营销预测与管理进行研究,以期更好地掌握市场动态变化,为企业目标市场的确定与营销管理提供依据。

ISince marketing nowadays in a fierce competitive and unpredictable macro environment facing a complicated situation, in order to better carry out the marketing work, make the correct decisions in -depth marketing and marketing management to ensure the competitiveness of the enterprises, the marketing forecast must be implemented , Excel can provide LINEST function in regression analysis with more than the number of independent variables ,detailed calculation results. Based on the marketing forecast and management of LINEST function models, the paper presents better understanding of the market dynamics and provides the enterprises a basis for the determination of the target market and marketing management.