统计分析与SPSS的应用考试

1/20《统计分析软件》试(题)卷班级姓名题号题号一二三四五六总成绩说明：1.本试卷分析结果写在每个题目下面(即所留空白处)；SPSS.sav”与“学生成绩二.sav”合2/20(2)对所建立的数据文件“成绩.sav”进行以下处理：2)计算每个学生的总成绩、并按照总成绩的大小进行排序3)把数学成绩分成优、良、中三个等级，规则为优(X≥85)，良(75≤XNMinimumMaximum477.0085.0041667.0090.00ValidNlistwise)ValidNlistwise)eviation男女3/204/20自己满意的品牌，调查结(2)试利用多选项分析，利用频数分析来分析消费者对不同品牌电脑的满意5/206/20(7)(7)7/20(1)(2)8/20(3)差异，设计了一项实验。从尚无推销经验的应聘人员中随机挑选一部分，并随机地将他们分为五个组，每组用一种推销方法培训。一段时期后得到他们在一个月内的9/2022.420.720.8第五组25.226.226.929.30.429.728.3DsGroupsuares627Sig.F410/20(J)推销ence 3.30000*4.02857*ErroreInterval-6.5736-2.5451 -.2165-9.9879 .0264 .75493.0835-6.6879-.02644.00226.3308-3.44066.57367.30229.6308-.140611/20differenceissignificantatthelevel9*92(1)按照性别建立推销员频率分布表及销售额的直方图；(2)利用交叉列联表分析不同性别推销人员参与销售方式状况；(3)利用参数检验来分析不同性别推销人员的销售额是否有显著性差异？0000男女男rcent15.3cent12/2016.8015.35.310.517.3015.35.315.817.5015.35.321.118.2015.35.326.320.0015.35.331.620.1015.35.336.820.2015.35.342.120.8015.35.347.421.2015.35.352.622.5015.35.357.922.6015.35.363.223.9015.35.368.425.2015.35.373.726.9015.35.378.928.3015.35.384.229.3015.35.389.529.9015.35.394.730.2015.35.3100.0Total19100.0100.0女Valid16.5016.36.36.317.7016.36.312.517.9016.36.318.818.4016.36.325.019.1016.36.331.320.7016.36.337.520.9016.36.343.821.3016.36.350.022.0016.36.356.322.4016.36.362.524.9016.36.368.826.2016.36.375.026.80212.512.587.529.7016.36.393.813/20l1ProcessingSummary14/20ValidMissingTotalNPercentNPercentNPercent推销方式*性别35100.0%0.0%35100.0%推销方式*性别Crosstabulation推销方式第一组ount%within推销方式%within性别otalesidualount%within推销方式%within性别otalesidualount%within推销方式%within性别otalesidualount%within推销方式%within性别otal男457.1%21.1%457.1%21.1%457.1%21.1%32.9%%女32.9%6%-.132.9%6%-.132.9%6%-.1457.1%.0%7.0%.0%7.0%.0%7.0%.0%7.0%.0%tdResidual第五组Countount%within推销方式%within性别otalesidual%within推销方式%within性别otal.8457.1%21.1%3%3%32.9%6%45.7%45.7%7.0%.0%lareTestsAsymp.Sig.df(2-sided)hiSquareLikelihoodRatioLinear-by-LinearAssociationNofValidCasesnTheminimum4.9774.9771.81315/2016/20(1)绘制城镇居民人均可支配收入与人均消费性支出的相关图(散点图)；(3)如果有相关关系，建立一元线性回归模型，解释输出结果。人均消费性人均可支配人均消费性人均可支配地区地区支出(Y)收入(X)支出(Y)收入(X)17/20118/20tailedonsNnSig.(2-tailed)N(Y)人均消费性支出(Y)相关系数的原假设，认为总体不是零相关。esDependentVariable:人均消费性支出(Y)EquationREquationRSquareFdf1df2Sig.Constantb1b2Quadratic.983287.780210.0001015.083.5539.499E-6Cubic.983287.780210.0001015.083.5539.499E-6Compound.976452.084