Excel回归分析解多元线性方程

Regression Solution a Multiple Linearity Equation by Excel

介绍了回归分析计算原理，LINEST（known_y’s，known_x’s，const，stats）语法。通过补加一组方程，Excel回归分析可解多元线性方程，列举了解多元线性方程实例。

The calculation theory was introduced for a regression. The function grammar of LINEST（known_y＇s, known_x＇s, const, stats） was explicated. Added a group of equation, the method with a regression solution a multiple linearity equation was introduced. An example of solution linearity equation was given.