统计学作业1115080206.docx

1、统计学作业1115080206SPSS上机实验案例分析姓名：袁旭阳专业班级：物管2班学号：1115080206练习一：下表为10个人对两个不同的问题作出的回答（回答为“Yes”或“No”）后得到的数据，利用SPSS为该数据创建频数分布表。sample1sample2genderNoYes女YesNo女NoYes女NoNo女NoNo女YesYes男YesYes男YesYes男NoYes男NoYes男答案：FREQUENCIES VARIABLES=sample1 sample2 /ORDER=ANALYSIS.频率数据集0统计量sample1sample2N有效4949缺失00频率表sample

2、1频率百分比有效百分比累积百分比有效 3979.679.679.6No612.212.291.8Yes48.28.2100.0合计49100.0100.0sample2频率百分比有效百分比累积百分比有效 3979.679.679.6No36.16.185.7Yes714.314.3100.0合计49100.0100.0SAVE OUTFILE=C:Documents and SettingsAdministrator桌面输出1.sav /COMPRESSED.练习二: 某百货公司连续40天的商品销售额（单位：万元）如下：41 25 29 47 38 34 30 38 43 40 46 36 4

3、5 37 37 36 45 43 33 44 35 28 46 34 30 37 44 26 38 44 42 36 37 37 49 39 42 32 36 35 根据上面的数据进行适当分组，编制频数分布表。FREQUENCIES VARIABLES=sale /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN MODE SUM SKEWNESS SESKEW KURTOSIS SEKURT /ORDER=ANALYSIS.频率数据集0 统计量saleN有效40缺失0均值37.8500均值的标准误.9422

4、8中值37.0000众数37.00标准差5.95948方差35.515偏度-.227偏度的标准误.374峰度-.509峰度的标准误.733全距24.00极小值25.00极大值49.00和1514.00sale频率百分比有效百分比累积百分比有效25.0012.52.52.526.0012.52.55.028.0012.52.57.529.0012.52.510.030.0025.05.015.032.0012.52.517.533.0012.52.520.034.0025.05.025.035.0025.05.030.036.00410.010.040.037.00512.512.552.538

5、.0037.57.560.039.0012.52.562.540.0012.52.565.041.0012.52.567.542.0025.05.072.543.0025.05.077.544.0037.57.585.045.0025.05.090.046.0025.05.095.047.0012.52.597.549.0012.52.5100.0合计40100.0100.0FREQUENCIES VARIABLES=sale 组数 /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN MODE SUM SKE

6、WNESS SESKEW KURTOSIS SEKURT /ORDER=ANALYSIS.频率数据集0 统计量sale组数N有效4040缺失00均值37.85002.13均值的标准误.94228.114中值37.00002.00众数37.002标准差5.95948.723方差35.515.522偏度-.227-.194偏度的标准误.374.374峰度-.509-1.006峰度的标准误.733.733全距24.002极小值25.001极大值49.003和1514.0085频率表sale频率百分比有效百分比累积百分比有效25.0012.52.52.526.0012.52.55.028.0012.5

7、2.57.529.0012.52.510.030.0025.05.015.032.0012.52.517.533.0012.52.520.034.0025.05.025.035.0025.05.030.036.00410.010.040.037.00512.512.552.538.0037.57.560.039.0012.52.562.540.0012.52.565.041.0012.52.567.542.0025.05.072.543.0025.05.077.544.0037.57.585.045.0025.05.090.046.0025.05.095.047.0012.52.597.549

8、.0012.52.5100.0合计40100.0100.0组数频率百分比有效百分比累积百分比有效25-33820.020.020.034-411947.547.567.542-501332.532.5100.0合计40100.0100.0练习三：某行业管理局所属40个企业1999年的产品销售收入数据（单位：万元）如下：152 124 129 116 100 103 92 95 127 104 105 119 114 115 87 103 118 142 135 125 117 108 105 110 107 137 120 136 117 108 97 88 123 115 119 138 1

9、12 146 113 126 （1） 根据上面的数据进行适当分组，编制频数分布表，并计算出累计频数和累计频率；（2） 按规定，销售收入在125万元以上为先进企业，115万元-125万元为良好企业，105万元-115万元为一般企业，105万元以下为落后企业，按先进企业、良好企业、一般企业、落后企业进行分组。频率数据集0 统计量sale组数N有效4040缺失00均值116.17502.3000均值的标准误2.45991.12506中值115.50002.0000众数103.00a2.00标准差15.55781.79097方差242.046.626偏度.258.380偏度的标准误.374.374峰度

10、-.247-.025峰度的标准误.733.733全距65.003.00极小值87.001.00极大值152.004.00和4647.0092.00a. 存在多个众数。显示最小值频率sale频率百分比有效百分比累积百分比有效87.0012.52.52.588.0012.52.55.092.0012.52.57.595.0012.52.510.097.0012.52.512.5100.0012.52.515.0103.0025.05.020.0104.0012.52.522.5105.0025.05.027.5107.0012.52.530.0108.0025.05.035.0110.0012.5

11、2.537.5112.0012.52.540.0113.0012.52.542.5114.0012.52.545.0115.0025.05.050.0116.0012.52.552.5117.0025.05.057.5118.0012.52.560.0119.0025.05.065.0120.0012.52.567.5123.0012.52.570.0124.0012.52.572.5125.0012.52.575.0126.0012.52.577.5127.0012.52.580.0129.0012.52.582.5135.0012.52.585.0136.0012.52.587.5137.

12、0012.52.590.0138.0012.52.592.5142.0012.52.595.0146.0012.52.597.5152.0012.52.5100.0合计40100.0100.0组数频率百分比有效百分比累积百分比有效80-100512.512.512.5100-1202152.552.565.0120-1401127.527.592.5110-12037.57.5100.0合计40100.0100.0描述数据集0 描述统计量N极小值极大值均值标准差销售额4087.00152.00116.175015.55781先进企业101.001.001.0000.00000良好企业122.0

13、02.002.0000.00000一般企业113.003.003.0000.00000落后企业94.004.004.0000.00000有效的 N （列表状态）0FREQUENCIES VARIABLES=销售额 先进企业 良好企业 一般企业 落后企业 /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN MODE SUM /ORDER=ANALYSIS数据集0 频率表IF ( 销售额 125) 企业类型=先进企业.EXECUTE.IF ( 销售额 = 115 & 销售额 = 125) 企业类型=良好企业.EX

14、ECUTE.IF ( 销售额 = 105 & 销售额 = 115) 企业类型=一般企业.EXECUTE.IF (销售额 105) 企业类型=落后企业.EXECUTE.FREQUENCIES VARIABLES=销售额 企业类型 /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN MODE SUM /ORDER=ANALYSIS.频率数据集0 统计量销售额企业类型N有效4040缺失00均值116.1750均值的标准误2.45991中值115.5000众数103.00a标准差15.55781方差242.046全距

15、65.00极小值87.00极大值152.00和4647.00a. 存在多个众数。显示最小值频率表销售额频率百分比有效百分比累积百分比有效87.0012.52.52.588.0012.52.55.092.0012.52.57.595.0012.52.510.097.0012.52.512.5100.0012.52.515.0103.0025.05.020.0104.0012.52.522.5105.0025.05.027.5107.0012.52.530.0108.0025.05.035.0110.0012.52.537.5112.0012.52.540.0113.0012.52.542.511

16、4.0012.52.545.0115.0025.05.050.0116.0012.52.552.5117.0025.05.057.5118.0012.52.560.0119.0025.05.065.0120.0012.52.567.5123.0012.52.570.0124.0012.52.572.5125.0012.52.575.0126.0012.52.577.5127.0012.52.580.0129.0012.52.582.5135.0012.52.585.0136.0012.52.587.5137.0012.52.590.0138.0012.52.592.5142.0012.52.5

17、95.0146.0012.52.597.5152.0012.52.5100.0合计40100.0100.0企业类型频率百分比有效百分比累积百分比有效良好企业1025.025.025.0落后企业922.522.547.5先进企业1025.025.072.5一般企业1127.527.5100.0合计40100.0100.0FREQUENCIES VARIABLES=分组 销售后入 企业等级 /STATISTICS=SUM /BARCHART FREQ /ORDER=ANALYSIS.IF (销售后入 105) 企业等级=企业等级.EXECUTE.FREQUENCIES VARIABLES=分组 销

18、售后入 企业等级 /STATISTICS=MEDIAN MODE SUM /BARCHART FREQ /ORDER=ANALYSIS.练习四：某班的统计学成绩如下表所示：姓名平时成绩期末测试成绩李娟8057袁晓惠8072邓盼8989蒋君9088刘俊莉8787王媛媛9091周波8076赵佳8070雷晓荣9590刘洁9797欧阳敏8383向华8686张江南8181曾嘉8787朱赟8686高茜8893田婷8069颜晓8064彭林8074林丹萍8067（1）请按下面注明的两个条件计算出该班每位同学的总评成绩。条件1:总评成绩的构成：总评成绩=0.2*平时成绩+0.8*期末成绩（即总评成绩中，平时成绩

19、占20%，期末成绩占80%）条件2：总评成绩请保留为整数（2）请按100-90分，89-80分，79-70分，69-60分，59分及以下，将该班全体同学按照期末成绩进行分组得出各组人数。答案：COMPUTE 总评成绩=0.2 * 平时成绩 + 0.8 * 期末测试成绩.EXECUTE.DESCRIPTIVES VARIABLES=总评成绩 /STATISTICS=MEAN STDDEV MIN MAX.频率数据集0 统计量总评成绩分组N有效2020缺失2020均值81.272.30均值的标准误2.174.206中值84.502.00众数86a2标准差9.723.923方差94.536.853全

20、距353极小值621极大值974和162546a. 存在多个众数。显示最小值频率表总评成绩频率百分比有效百分比累积百分比有效6212.55.05.06712.55.010.07012.55.015.07112.55.020.07212.55.025.07412.55.030.07512.55.035.07712.55.040.08112.55.045.08312.55.050.08625.010.060.08725.010.070.08812.55.075.08912.55.080.09112.55.085.09112.55.090.09212.55.095.09712.55.0100.0合计

21、2050.0100.0缺失系统2050.0合计40100.0分组频率百分比有效百分比累积百分比有效1410.020.020.02820.040.060.03615.030.090.0425.010.0100.0合计2050.0100.0缺失系统2050.0合计40100.0IF (总评成绩 = 100 & 总评成绩 = 90) 分组=优秀.EXECUTE.IF (总评成绩 = 89 & 总评成绩 = 80) 分组=良好.EXECUTE.IF (总评成绩 = 79 & 总评成绩 = 70) 分组=一般.EXECUTE.IF (总评成绩 = 69 & 总评成绩 = 60) 分组=及格.EXECUTE.FREQUENCIES VARIABLES=总评成绩 分组 /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN MODE SUM /ORDER=ANALYSIS.频率数据集0 统计量总评成绩分组N有效2040缺失200均值81.27均值的标准误2.174中值84.50众数86a标准差9.723方差94.536全距35极小值62极大值97和1625a. 存在多个众数。显示最小值频率表总评成