利用Excel回归分析操作步骤.docVIP

数据分析——回归分析操作步骤 调出“数据分析”按钮 打开excel2007.。。这个不用说了的吧。。。 点击左上角office 图标 点击EXCEL选项 在左侧选择加载项 点击转到按钮 在跳出的加载宏窗口内，勾选分析工具库。如图所示 确定 在excel2007顶端选择“数据”按钮 最右侧会跳出数据分析按钮 好了 调出这个按钮就到此结束了。 使用数据分析工具 建立好相应的数据库，这里有一个最简单的，如图所示：数据库内容为A和B的数据，我们要做的是分析其相关性。 点选“数据分析”按钮 在跳出的窗口内选择“回归” 并点击确定 跳出如图示的窗口 给Y区域框选 给X区域框选 点击确定 在sheet4窗口内跳出了回归统计的数据了 其中这里。。具体哪个是 显著水平。。我忘记了。。。反正下次问黄老师吧。。童鞋们，到此over了。 leading cadres to everyday things busy as an excuse, urged not do or knock on the ring look, lack of work enthusiasm and forward-looking. The difficulties and problems of individual cadres indifferent masses as the buck passing, long, make some simple complex problems. Some cadres general talk about pay, do not take leading cadres to everyday things busy as an excuse, urged not do or knock on the ring look, lack of work enthusiasm and forward-looking. The difficulties and problems of individual cadres indifferent masses as the buck passing, long, make some simple complex problems. Some cadres general talk about pay, do not take leading cadres to everyday things busy as an excuse, urged not do or knock on the ring look, lack of work enthusiasm and forward-looking. The difficulties and problems of individual cadres indifferent masses as the buck passing, long, make some simple complex problems. Some cadres general talk about pay, do not take