多元统计学SPSS实验报告一

华东理工大学2016-2017学年第二学期《多元统计学》实验报告实验名称实验1数据整理与描述统计分析专业姓名学号组名/组号实验时间实验地点指导教师实验目的/要求1、掌握数据整理的基本方法：观察量排序(SortCases)、变量排序(RankCases)、计算新的变量(ComputeVariables)、拆分数据文件(SplitFiles)、分类汇总(Aggregate)等。2、熟练应用SPSS输出描述统计量和绘制统计图。实验内容1、对“employeedata.sav”进行数据整理，并分别给出三种工作类别(jobcat)的薪水(salary)的描述统计量(均值、方差等)。2、对第1章的习题4进行描述统计分析。实验总结实验报告正文：实验1.1数据整理(一)对"employeedata.sav"进行数据整理basedoncurrentsalary)1.，Igenderbdate|educ|jobcal|salary^albeginpreve^p|minnrityl1f皿廿欧S1r…$0310702750233SfOB/12/1930e11：I10.3CQ7U430390FU实功戏01V1E..2C0珥芒D安00日f121$16.310$0310820054.11f0BZ21/1931121J16.2Z0110.301180a6觇F121Fi氏aaiV10.2T0函1E017191f10^^1331121$16.910$0310&28S08仙f0B^M331S1$1民尚氾知8S41209325f1W4/1934e1JBffM*10.300767E0102AFD3/2功9S3121J1E..9C0珥030折1241113E2fa1J1B.9E0$0310723190123&7fQ5Z22/1942121J16.950110.3017227111317BF0V17/19130121Vl/.iroV10.2T05572n1J2£3fs1J17/1L0$03108101S229fOBZ21；194X1121I7项J10.2Z082350a2.3.—iJgenderbdateeducjobcatsalaryialbeginjobtimeprevespminorrlysalary137Blce⑵泅338$1做$02037027501LOO233Bf8伽汹B1J10.3Q0THU3D2.C0D390f0J16.3X安DD4COO4l11.CC/1934TJi(1£82X(108X08200JLOO5411l03^21/1931TJ(1682X(10s2XGSISO04LOOB何fC6O5/1933121I5S10.3DQE£163G.COD7191f10i23i193112J16.3XJ10.3X羽260D7COOB1J4l00^/19318i牌网E341208LOO9325f11itW1334B1S16.B0aJ10.3Q0767BD9.C0DIDrrai27i193312JIG.ra]sg.ra]sr?111.COD11至Nf0$1氏迎J10.2IX72319011COO12367iTJ$1缺如$gxo7227111LOO1317Bf01/17/193S1211：HS10.3DQ6513.50014253r02ES4W01J17/1IXJ10.3X01D门印。15229i0011,1940■■.(10.xoS2zse15LOO计算3开的变量(incrementalsalary=currentsalary-beginningsalary)ngender)bdstEeducjobcsl洞町由IbHginjnblimepn=^Hpminorityrsalaryincrg^sl旧r一137Bf03即933e1(15.7S0S10.20D7D27501.OM5550.012339fC6M驴93301V15.3X510.2007402.X05700IX390102&祁g寒8$1田320192□□4.X0645CIIX4224f12S16.3DQSIO^OD0200i.XOGHM.tM5411fB日W明1121J16.3X510.200E0iro04.XCEXO00Bd--:1场佰.9室12牌即$10.ICO6GIB?16.X06150IX7191f10.23M93112S16.HM510.20D6407.OMGMO]0144fC6例对01IS.75080—0a.xo890000g32S1lliOJ/19348$1&网$10.ICO767G□9.X060X00IDfCG.27M93312{16.95(]£9网97124.1n.rai7KQ.O]11或fW伽聃01J16.K0510.20072319011.™6破0012•玉丁1LSffi/194212$1&列$1%•命72271111.0X6750iX1317Bf01fl7fl93S12(17.1CC510.20D0572013.SMerai.a]14253f02!2l!l94201J17/1IX510.200010113.3XESXiX152291卜|,・T12$10.ICO82358□15.X07050IX变量值排序(basedoncurrentsalary:rsalary)4.拆分数据文件(basedongender)210150f153W5.075JlT.Zfd190切COD29E-25.00211801OSC^/196116•"11(18.0LO933204C6CM33LOO.OO21272fD1-CI7M9BJ1G1tsj.rccsis.rcc国11D411.COD3BZ0D.QD213抑f061孙51153J107fOSIai0412OTO35535.002U11港都9£51£3(19.9E03£0419^035770.00215挪fD&M1M9B21G3£56.750i二rc7315D宓COD2B75D.QD215：371f。何5门日说IB365B.125J18.X071110424WEI40125.002171921LO/I94y121E19.&E0(12.7£0S4iao1：27£O0&ZOO.OOII：：25BHl［）如9%争e1£21.工C(11.5508024D52.5QD975D.QD219372m防宴!门335■151K1.3T0J157f070372052皿555D.0D：Z2LI22。3/渤940TJ1973151raio.oo22165mD海泗印81£21.™(K5509341D茧COD735D.QD222■320m11fl0fl935J15.X0花335070^07050.0022313So&湖g羽•产11舶m0MCGEl7；fl0.0022426BHl附即938■:1£22.350(15.E£C802721710.500735D.QD结论：Thereare215femaleemployeesand259maleemployees.5.分类汇总(breakvariable:gender;function:mean)1gendersalary_1|26031.92m41441.78结论：Theaveragecurrentsalaryoffemaleis26031.92.Theaveragecurrentsalaryofmaleis41441.78.（二）分别给出三种工作类别的薪水的描述统计量jobcatealary_2127838.5475B7.992z30938.39ZRE23363977.30182U78实验2.2描述统计分析1）样本均值矩阵■jtJtlStlCGXIX:＞；6NV-zid101010101010Fi/issriga0Ua00Mssn-.osiaa-.CQ780-.02940-.43040.63310.77570结论：总共分析六组变量，每组含有十个样本。每股收益（X1）的均值为-0.0912；净资产收益率（X2）的均值为-0.0378；总资产报酬率（X3）的均值为-0.0294；销售净利率（X4）的均值为-0.4284；主营业务增长率（X5）的均值为0.6334；净利润增长率（X6）的均值为0.7797.2）协方差阵Reliability：+：：!：：+：：+：：+：：+：Method2(.covari：ancematrix.Jwillbeusedforthis:analysis：+：：+：：+：：+：*：+：□RELIABILITYANALYSISSCALE(ALPHA)Covar】anceMatrikKIX2X3X-4X5XI,5637X2.1590,0483X3.0702.0202.0092跑.4880.1241.06801.4432X5358114910543.03841.7986X6308014070538.12071.8498.K6X62.0116NofCases二10.0Fie1iabilityCoefficients6itemsAlpha二.4675St：andardizeditemalpha二,6141结论：矩阵共六行六列，显示了每股收益（X1）、净资产收益率（X2）、总资产报酬率（X3）、销售净利率（X4）、主营业务增长率（X5）和净利润增长率（X6）的协方差。3）相关系数CmielfitiDnsXLX2K3K4X5K6XIPaartonCar^aUon1.5A1-.35&-.209Bl|.(2-ldkL.COD.ODO.106.313.413N10IDIDIDIDIDX2Peahentorr目ati口n.95■1'1.470-.5D6-.4515u.i2IjLl.'.roo.000.136.1EI0NIDID10101010K3PearsonCcrrelailon.973.姑日村1.50B-.421-.394Bl|.(2-ldkL,COD,COD.074.226.260N10IDIDIDIDID润PaartonCar^aUon.541.47D.50B1,DM.□?!Sg.(2-taied].106.L7D.074§如MENIDID10101010K5PearsonCcrrelailon-.3Sb-.506-.421.02415u.i2IjLl'.313.136.226.9-48.000N10ID10101010X6PaartonCar^aUon-.339-.451崩EHEL1Sg.(2-taied].410.L9D.260冶IE.ODON101010ID5.CotTidati