用Excel求归方程.docVIP

首先，新建一个Office Excel，键入数据。 第二部，见图片操作 ①选中数据区域 ②选择标签上的插入 ③点击散点图 ④选择仅带数据标记的散点图 这时候，散点图就出现了 ①选中散点图 ②在标签上选择图表工具 ③在图表布局里选择布局三 ①双击出现的那条回归方程，会弹出对话框 ②选择趋势线选项标签 ③选择线性回归方程 ④在下面显示公式的地方打勾 然后带入数据，计算 lujianhua (South area ahead Office Director and to war victory)]. County Government operates 3 Civil Affairs, finance, education and Finance Committee, with espionage, sabotage, standing and political team. Soon, the tomb of the Wujiang District Committee of the Kuomintang relocated to the countryside village. Pre-war, strict tomb for seventh district, its regional range for this Taoyuan town a