数理统计 实验五 方差分析.docVIP

西北农林科技大学实验报告学院名称：理学院 专业年级： 姓 名： 学 号：课 程：数理统计学 报告日期： 实验五 方差分析 一实验目的运用SPSS软件对已给样本数据进行方差分析。二实验要求 某企业在制定某商品的广告策略时，对不同广告形式在不同地区的广告效果（销售额）进行评估。请以商品销售额为观测变量，以广告形式和地区为控制变量，通过单因素方差分析分别对广告形式、地区对销售额的影响进行分析。三实验内容分析广告形式对销售额的影响方法一1、打开数据，点击分析、比较均值，单因素。将x3和x1分别添加到因变量列表和因子中。2、点击两两比较，选LSD。3、点击选项，选描述性和方差同质性检验。4、点击确定，得到结果。结论：方差齐性检验表中，显著性p=0.5150.05，说明不同的广告形式与销售额是相关的，满足了方差分析的前提条件。 以结果中多重比较表做显著性分析，可以看出p1.3340，看出报纸对宣传品的显著性比报纸对广播的显著性大。方法二：1、打开数据，点击分析、一般线性模型、单变量。将X3和X1分别导入因变量和固定因子。2、点击单变量中的两两比较,将X1导入两两比较检验，勾选LSD。3、点击选项，将X1导入显示均值，勾选描述统计和方差齐性检验。4、得出结果。得到相同的结论。分析地区形式对销售额的影响1、打开实验数据，点击菜单中“分析”-“一般线性模型”-“单变量”，将“销售额”作为“因变量”，“地区”作为“固定因子”：2、点击“两两比较”，将x2放到右边“两两比较检验”中，勾选“LSD”：3、点击“继续”，在“选项”面板中，将“（OVERRALL)”放到右边“显示均值”中去，并且勾选“描述统计”和“方差齐性检验”：4、点击模型，选择设定（自定义），类型改为主效应，吧x1，x2加到模型中。5、点击“继续”，并且“确定”，得到结果：描述性统计量因变量: 销售额广告形式地区均值标准 偏差N报纸1.0071.50004.9497522.0066.000012.7279223.0079.50004.9497524.0071.50007.7781725.0070.50006.3639626.0074.00002.8284327.0073.00004.2426428.0083.50003.5355329.0062.5000.70711210.0091.00004.24264211.0055.00001.41421212.0078.000011.31371213.0085.50002.12132214.0071.00008.48528215.0071.50009.19239216.0079.5000.70711217.0062.0000.00000218.0072.50003.535532总计73.22229.7339236广播1.0061.500010.6066022.0064.500019.0918823.0089.500014.8492424.0086.50004.9497525.0075.50002.1213226.0064.50006.3639627.0050.500024.7487428.0077.00002.8284329.0069.00005.65685210.0085.000021.21320211.0057.00005.65685212.0070.50003.53553213.0073.50007.77817214.0064.50002.12132215.0074.000012.72792216.0078.50003.53553217.0065.000011.31371218.0069.50006.363962总计70.888912.9676036宣传品1.0046.50007.7781722.0052.500012.0208223.0073.500017.6776724.0075.5000.7071125.0066.000012.7279226.0057.50007.7781727.0042.500013.4350328.0065.00005.6568529.0051.500012.02082210.0065.00005.65685211.0042.00001.41421212.0058.500010.60660213.0062.50003.53553214.0055.00004.24264215.0052.50003.53553216.0048.00005.65685217.0045.0000.00000218.0059.00001.414212总计56.555611.6188136体验1.0060.50003.5355322.0074.500010.6066023.0081.50004.9497524.0083.50004.9497525.0078.500012.0208226.0069.500010.6066027.0069.00001.4142128.0068.00009.8994929.0047.500010.60660210.0070.00008.48528211.0055.000021.21320212.0072.00007.07107213.0046.50006.36396214.0066.00007.07107215.0070.00007.07107216.0071.00009.89949217.0043.50009.19239218.0072.500014.849242总计66.611113.4976836总计1.0060.000010.9805082.0064.375013.5006683.0081.000010.9805084.0079.25007.5545685.0072.62508.7331586.0066.37508.6344487.0058.750017.2936888.0073.37509.1016189.0057.625011.18593810.0077.750014.50862811.0052.250010.49830812.0069.750010.02497813.0067.000015.89250814.0064.12507.67998815.0067.000011.25040816.0069.250014.31034817.0053.875011.74050818.0068.37508.634448总计66.819413.52783144多个比较因变量: 销售额 LSD(I) 地区(J) 地区均值差值 (I-J)标准 误差Sig.95% 置信区间下限上限1.002.00-4.37504.73654.357-13.75075.00073.00-21.0000*4.73654.000-30.3757-11.62434.00-19.2500*4.73654.000-28.6257-9.87435.00-12.6250*4.73654.009-22.0007-3.24936.00-6.37504.73654.181-15.75073.00077.001.25004.73654.792-8.125710.62578.00-13.3750*4.73654.006-22.7507-3.99939.002.37504.73654.617-7.000711.750710.00-17.7500*4.73654.000-27.1257-8.374311.007.75004.73654.104-1.625717.125712.00-9.7500*4.73654.042-19.1257-.374313.00-7.00004.73654.142-16.37572.375714.00-4.12504.73654.386-13.50075.250715.00-7.00004.73654.142-16.37572.375716.00-9.25004.73654.053-18.6257.125717.006.12504.73654.198-3.250715.500718.00-8.37504.73654.080-17.75071.00072.001.004.37504.73654.357-5.000713.75073.00-16.6250*4.73654.001-26.0007-7.24934.00-14.8750*4.73654.002-24.2507-5.49935.00-8.25004.73654.084-17.62571.12576.00-2.00004.73654.674-11.37577.37577.005.62504.73654.237-3.750715.00078.00-9.00004.73654.060-18.3757.37579.006.75004.73654.157-2.625716.125710.00-13.3750*4.73654.006-22.7507-3.999311.0012.1250*4.73654.0122.749321.500712.00-5.37504.73654.259-14.75074.000713.00-2.62504.73654.580-12.00076.750714.00.25004.73654.958-9.12579.625715.00-2.62504.73654.580-12.00076.750716.00-4.87504.73654.305-14.25074.500717.0010.5000*4.73654.0281.124319.875718.00-4.00004.73654.400-13.37575.37573.001.0021.0000*4.73654.00011.624330.37572.0016.6250*4.73654.0017.249326.00074.001.75004.73654.712-7.625711.12575.008.37504.73654.080-1.000717.75076.0014.6250*4.73654.0025.249324.00077.0022.2500*4.73654.00012.874331.62578.007.62504.73654.110-1.750717.00079.0023.3750*4.73654.00013.999332.750710.003.25004.73654.494-6.125712.625711.0028.7500*4.73654.00019.374338.125712.0011.2500*4.73654.0191.874320.625713.0014.0000*4.73654.0044.624323.375714.0016.8750*4.73654.0017.499326.250715.0014.0000*4.73654.0044.624323.375716.0011.7500*4.73654.0142.374321.125717.0027.1250*4.73654.00017.749336.500718.0012.6250*4.73654.0093.249322.00074.001.0019.2500*4.73654.0009.874328.62572.0014.8750*4.73654.0025.499324.25073.00-1.75004.73654.712-11.12577.62575.006.62504.73654.164-2.750716.00076.0012.8750*4.73654.0083.499322.25077.0020.5000*4.73654.00011.124329.87578.005.87504.73654.217-3.500715.25079.0021.6250*4.73654.00012.249331.000710.001.50004.73654.752-7.875710.875711.0027.0000*4.73654.00017.624336.375712.009.5000*4.73654.047.124318.875713.0012.2500*4.73654.0112.874321.625714.0015.1250*4.73654.0025.749324.500715.0012.2500*4.73654.0112.874321.625716.0010.0000*4.73654.037.624319.375717.0025.3750*4.73654.00015.999334.750718.0010.8750*4.73654.0231.499320.25075.001.0012.6250*4.73654.0093.249322.00072.008.25004.73654.084-1.125717.62573.00-8.37504.73654.080-17.75071.00074.00-6.62504.73654.164-16.00072.75076.006.25004.73654.189-3.125715.62577.0013.8750*4.73654.0044.499323.25078.00-.75004.73654.874-10.12578.62579.0015.0000*4.73654.0025.624324.375710.00-5.12504.73654.281-14.50074.250711.0020.3750*4.73654.00010.999329.750712.002.87504.73654.545-6.500712.250713.005.62504.73654.237-3.750715.000714.008.50004.73654.075-.875717.875715.005.62504.73654.237-3.750715.000716.003.37504.73654.477-6.000712.750717.0018.7500*4.73654.0009.374328.125718.004.25004.73654.371-5.125713.62576.001.006.37504.73654.181-3.000715.75072.002.00004.73654.674-7.375711.37573.00-14.6250*4.73654.002-24.0007-5.24934.00-12.8750*4.73654.008-22.2507-3.49935.00-6.25004.73654.189-15.62573.12577.007.62504.73654.110-1.750717.00078.00-7.00004.73654.142-16.37572.37579.008.75004.73654.067-.625718.125710.00-11.3750*4.73654.018-20.7507-1.999311.0014.1250*4.73654.0034.749323.500712.00-3.37504.73654.477-12.75076.000713.00-.62504.73654.895-10.00078.750714.002.25004.73654.636-7.125711.625715.00-.62504.73654.895-10.00078.750716.00-2.87504.73654.545-12.25076.500717.0012.5000*4.73654.0093.124321.875718.00-2.00004.73654.674-11.37577.37577.001.00-1.25004.73654.792-10.62578.12572.00-5.62504.73654.237-15.00073.75073.00-22.2500*4.73654.000-31.6257-12.87434.00-20.5000*4.73654.000-29.8757-11.12435.00-13.8750*4.73654.004-23.2507-4.49936.00-7.62504.73654.110-17.00071.75078.00-14.6250*4.73654.002-24.0007-5.24939.001.12504.73654.813-8.250710.500710.00-19.0000*4.73654.000-28.3757-9.624311.006.50004.73654.172-2.875715.875712.00-11.0000*4.73654.022-20.3757-1.624313.00-8.25004.73654.084-17.62571.125714.00-5.37504.73654.259-14.75074.000715.00-8.25004.73654.084-17.62571.125716.00-10.5000*4.73654.028-19.8757-1.124317.004.87504.73654.305-4.500714.250718.00-9.6250*4.73654.044-19.0007-.24938.001.0013.3750*4.73654.0063.999322.75072.009.00004.73654.060-.375718.37573.00-7.62504.73654.110-17.00071.75074.00-5.87504.73654.217-15.25073.50075.00.75004.73654.874-8.625710.12576.007.00004.73654.142-2.375716.37577.0014.6250*4.73654.0025.249324.00079.0015.7500*4.73654.0016.374325.125710.00-4.37504.73654.357-13.75075.000711.0021.1250*4.73654.00011.749330.500712.003.62504.73654.446-5.750713.000713.006.37504.73654.181-3.000715.750714.009.25004.73654.053-.125718.625715.006.37504.73654.181-3.000715.750716.004.12504.73654.386-5.250713.500717.0019.5000*4.73654.00010.124328.875718.005.00004.73654.293-4.375714.37579.001.00-2.37504.73654.617-11.75077.00072.00-6.75004.73654.157-16.12572.62573.00-23.3750*4.73654.000-32.7507-13.99934.00-21.6250*4.73654.000-31.0007-12.24935.00-15.0000*4.73654.002-24.3757-5.62436.00-8.75004.73654.067-18.1257.62577.00-1.12504.73654.813-10.50078.25078.00-15.7500*4.73654.001-25.1257-6.374310.00-20.1250*4.73654.000-29.5007-10.749311.005.37504.73654.259-4.000714.750712.00-12.1250*4.73654.012-21.5007-2.749313.00-9.37504.73654.050-18.7507.000714.00-6.50004.73654.172-15.87572.875715.00-9.37504.73654.050-18.7507.000716.00-11.6250*4.73654.016-21.0007-2.249317.003.75004.73654.430-5.625713.125718.00-10.7500*4.73654.025-20.1257-1.374310.001.0017.7500*4.73654.0008.374327.12572.0013.3750*4.73654.0063.999322.75073.00-3.25004.73654.494-12.62576.12574.00-1.50004.73654.752-10.87577.87575.005.12504.73654.281-4.250714.50076.0011.3750*4.73654.0181.999320.75077.0019.0000*4.73654.0009.624328.37578.004.37504.73654.357-5.000713.75079.0020.1250*4.73654.00010.749329.500711.0025.5000*4.73654.00016.124334.875712.008.00004.73654.094-1.375717.375713.0010.7500*4.73654.0251.374320.125714.0013.6250*4.73654.0054.249323.000715.0010.7500*4.73654.0251.374320.125716.008.50004.73654.075-.875717.875717.0023.8750*4.73654.00014.499333.250718.009.37504.73654.050-.000718.750711.001.00-7.75004.73654.104-17.12571.62572.00-12.1250*4.73654.012-21.5007-2.74933.00-28.7500*4.73654.000-38.1257-19.37434.00-27.0000*4.73654.000-36.3757-17.62435.00-20.3750*4.73654.000-29.7507-10.99936.00-14.1250*4.73654.003-23.5007-4.74937.00-6.50004.73654.172-15.87572.87578.00-21.1250*4.73654.000-30.5007-11.74939.00-5.37504.73654.259-14.75074.000710.00-25.5000*4.73654.000-34.8757-16.124312.00-17.5000*4.73654.000-26.8757-8.124313.00-14.7500*4.73654.002-24.1257-5.374314.00-11.8750*4.73654.013-21.2507-2.499315.00-14.7500*4.73654.002-24.1257-5.374316.00-17.0000*4.73654.000-26.3757-7.624317.00-1.62504.73654.732-11.00077.750718.00-16.1250*4.73654.001-25.5007-6.749312.001.009.7500*4.73654.042.374319.12572.005.37504.73654.259-4.000714.75073.00-11.2500*4.73654.019-20.6257-1.87434.00-9.5000*4.73654.047-18.8757-.12435.00-2.87504.73654.545-12.25076.50076.003.37504.73654.477-6.000712.75077.0011.0000*4.73654.0221.624320.37578.00-3.62504.73654.446-13.00075.75079.0012.1250*4.73654.0122.749321.500710.00-8.00004.73654.094-17.37571.375711.0017.5000*4.73654.0008.124326.875713.002.75004.73654.563-6.625712.125714.005.62504.73654.237-3.750715.000715.002.75004.73654.563-6.625712.125716.00.50004.73654.916-8.87579.875717.0015.8750*4.73654.0016.499325.250718.001.37504.73654.772-8.000710.750713.001.007.00004.73654.142-2.375716.37572.002.62504.73654.580-6.750712.00073.00-14.0000*4.73654.004-23.3757-4.62434.00-12.2500*4.73654.011-21.6257-2.87435.00-5.62504.73654.237-15.00073.75076.00.62504.73654.895-8.750710.00077.008.25004.73654.084-1.125717.62578.00-6.37504.73654.181-15.75073.00079.009.37504.73654.050-.000718.750710.00-10.7500*4.73654.025-20.1257-1.374311.0014.7500*4.73654.0025.374324.125712.00-2.75004.73654.563-12.12576.625714.002.87504.73654.545-6.500712.250715.00.00004.736541.000-9.37579.375716.00-2.25004.73654.636-11.62577.125717.0013.1250*4.73654.0063.749322.500718.00-1.37504.73654.772-10.75078.000714.001.004.12504.73654.386-5.250713.50072.00-.25004.73654.958-9.62579.12573.00-16.8750*4.73654.001-26.2507-7.49934.00-15.1250*4.73654.002-24.5007-5.74935.00-8.50004.73654.075-17.8757.87576.00-2.25004.73654.636-11.62577.12577.005.37504.73654.259-4.000714.75078.00-9.25004.73654.053-18.6257.12579.006.50004.73654.172-2.875715.875710.00-13.6250*4.73654.005-23.0007-4.249311.0011.8750*4.73654.0132.499321.250712.00-5.62504.73654.237-15.00073.750713.00-2.87504.73654.545-12.25076.500715.00-2.87504.73654.545-12.25076.500716.00-5.12504.73654.281-14.50074.250717.0010.2500*4.73654.032.874319.625718.00-4.25004.73654.371-13.62575.125715.001.007.00004.73654.142-2.375716.37572.002.62504.73654.580-6.750712.00073.00-14.0000*4.73654.004-23.3757-4.62434.00-12.2500*4.73654.011-21.6257-2.87435.00-5.62504.73654.237-15.00073.75076.00.62504.73654.895-8.750710.00077.008.25004.73654.084-1.125717.62578.00-6.37504.73654.181-15.75073.00079.009.37504.73654.050-.000718.750710.00-10.7500*4.73654.025-20.1257-1.374311.0014.7500*4.73654.0025.374324.125712.00-2.75004.73654.563-12.12576.625713.00.00004.736541.000-9.37579.375714.002.87504.73654.545-6.500712.250716.00-2.25004.73654.636-11.62577.125717.0013.1250*4.73654.0063.749322.500718.00-1.37504.73654.772-10.75078.000716.001.009.25004.73654.053-.125718.62572.004.87504.73654.305-4.500714.25073.00-11.7500*4.73654.014-21.1257-2.37434.00-10.0000*4.73654.037-19.3757-.62435.00-3.37504.73654.477-12.75076.00076.002.87504.73654.545-6.500712.25077.0010.5000*4.73654.0281.124319.87578.00-4.12504.73654.386-13.50075.25079.0011.6250*4.73654.0162.249321.000710.00-8.50004.73654.075-17.8757.875711.0017.0000*4.73654.0007.624326.375712.00-.50004.73654.916-9.87578.875713.002.25004.73654.636-7.125711.625714.005.12504.73654.281-4.250714.500715.002.25004.73654.636-7.125711.625717.0015.3750*4.73654.0025.999324.750718.00.87504.73654.854-8.500710.250717.001.00-6.12504.73654.198-15.50073.25072.00-10.5000*4.73654.028-19.87