用Excel进行相关与回归
分析
定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析
实验六:用Excel进行相关与回归分析 实验目的:用Excel进行相关与回归分析
实验步骤:
例
题
快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题
:
要求对身高和体重作相关和回归分析。
方法
快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载
:用相关系数宏计算相关系数
第一步:单击工具菜单,选择数据分析选项,在数据分析选项中选择相关系数,弹出相关系数对话框
第二步:在输入区域中输入范围,分组方式选择逐列,选择标志位于第一行,在输出区域中输入范围,单击确定,得到结果。如图:
“1”为自相关系数。
soldiers in the war to win the confidence and courage, strength has grown. In March 1939, finally created the direct leadership of the party ranks--Jiangsu Taihu anti-Japanese volunteer army. By the Chinese Communist Party, song Ling Zhen Qian Kangmin (song Ling Monument Park • famous martyrs of the Revolution Money's eldest son) as Commander, Deputy Commander Ding Bingcheng. This is territory of Wujiang first established by the Chinese
用Excel进行回归分析
第一步:单击工具菜单,选择数据分析选项,出现数据分析对话框,在分析工具中选择回归,如图
第二步:单击确定按钮,弹出回归对话框。如图
as Commander, Deputy Commander Ding Bingcheng. This is territory of Wujiang first established by the ChineseCommunist Party, song Ling Zhen Qian Kangmin (song Ling Monument Park • famous martyrs of the Revolution Money's eldest son) Japanese volunteer army. By the Chinese -Jiangsu Taihu anti--ip of the party rankssoldiers in the war to win the confidence and courage, strength has grown. In March 1939, finally created the direct leadersh2
第三步,单击确定,得到回归分析结果。
在上面的输出结果中,第一部分为汇总统计,Multiple R指复相关系数,RSquare指判定系数,Adusted指调整的判定系数,标准误差指估计的标准误差,观测值指样本容量。第二部分为方差分析,df指自由度,ss指平方和,MS指均方,F指F统计量,Significance of
F指p值;第三部分包括:Intercept指截距,Coefficient指系数,t stat指t统计量。
练习:
要求:根据上表,进行回归分析。
tory of Wujiang first established by the Chinesement Park • famous martyrs of the Revolution Money's eldest son) as Commander, Deputy Commander Ding Bingcheng. This is terriJapanese volunteer army. By the Chinese Communist Party, song Ling Zhen Qian Kangmin (song Ling Monu-Jiangsu Taihu anti--rty ranksthe war to win the confidence and courage, strength has grown. In March 1939, finally created the direct leadership of the pa soldiers in3