用EXCEL做性回归的方法.docVIP

用Excel做线性回归的方法 以下列数据为例说明： 1.首先在excel中输入数据，如下 2.选中数据区域?点击??选择XY散点图然后点击下一步?4.继续点击下一步可以输入对应的标题?，X轴Y轴值?继续点击下一步，出现点击完成出现生成的曲线然后用鼠标指着点，右击，选择添加趋势线选中线性然后确定出现用鼠标指着直线，然后右击，点击趋势线格式点击选项选中显示公式?，显示R平方值这样就好了 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