1、華東理工大學(xué)2016-2017學(xué)年第二學(xué)期多元統(tǒng)計學(xué)實驗報告實驗名稱實驗1數(shù)據(jù)整理與描述統(tǒng)計分析專業(yè)姓名學(xué)號組名/組號實驗時間實驗地點指導(dǎo)教師實驗?zāi)康?要求1、 掌握數(shù)據(jù)整 理的基本方法：觀察量排序(Sort Cases )、變量排序(Rank Cases)、計算新的變量(Compute Variables)、拆分?jǐn)?shù)據(jù)文件(Split Files)、分類匯總 (Aggregate)等。2、熟練應(yīng)用SPSS輸出描述統(tǒng)計量和繪制統(tǒng)計圖。實驗內(nèi)容1、對“employee data.sav ”進行數(shù)據(jù)整理，并分別給出三種工作類別(jobcat)的薪 水(salary)的描述統(tǒng)計量(均值、方差等)。2、

2、對第1章的習(xí)題4進行描述統(tǒng)計分析。實驗總結(jié)2. 變量值排序 (based on current salary : rsalary)1genderbdaleeducjobcalaslarysalbeginjobtirmepreuexpmiriLirrlyrqalary137日f現(xiàn)偵河01t.15.733t-10.20370Z7501 OX2郭I03/12/1338817J4302X039DfD2Q7/193Be1SIBDOJ9.79200d.rai4224f11 El 河121&15W0ZIIdDWOZi62004 OX5411I網(wǎng)仍弟1121既ISC04X0Bd如f121$1 耶 50HEI.

3、2DZI%1B31G.raj7191f即.為1河121&15碩H0.2TO的此il7 cmB1J4I0&湖弟1S1$16ESt rES41208M9325f11-1/193481HBflDZiHEI.2DZI7E7609.TCID24f現(xiàn)m誦121&1533353 JOS97場111 MJ11362IOWES 史丁8172319011 ax12367fD5/22/194212111B.99ZI11EI.2DZI72271111.raj13170fOV17/-1930121H7.103$1 叩 on8572013 3XUS3I碰H蝕231S17.1DQ罰口河810113 9X15229fDSQI

4、/IMD121$17.293$1DJD082350a15.X03. 計算新的變量(incremental salary=current salary - beginning salary)IgenderhdateeducjobCdlsalarysalbEginjofalimeI.mmarrty(salaryincresaivar左37日f09i2iri93301J157Jio.zro7027501.000K3ZIOO2E3Bl0312/193381$此.皿$031074昭02.000E7X X39Df02/27削珀81J1GnXCJ975092EiEii.arciEJffl.rci4224f1

5、1/1934121V1&.2TOvin.zro02004.000EOXiOO5411l03&仍9引121職310$0310能ISO0罰00GOOD 00B揶fC6ffifl9331211 zJ10.3006B16316.0056193.05r191f10Z3ri931121J16.3XJin.zro64260n7.000E0XIOOB1J4l0316,1931S1$1憲迎時如SB41200.OM300 009325f11934S1I16.BO110.3007B7BEig.arciEfiffi.KiID24fC0I27H933121S3.X097124111.0007950 on113G2lLU

6、e/193731$1民削$031072319011.am前 50 0012367fO5/22M942121116,95a110,300722711n.arci67.rci13170fCrm 771 日35121J17.1C0Jio.zro6572013.500EBOO 00U知l0241/19 疝81J17JL0$0310010113.500eaoooo15229f邸240121J 17.250J10n3ZC6235BDis.arciTosj.rci實驗報告正文：實驗1.1數(shù)據(jù)整理(一)對“employee data.sav 進行數(shù)據(jù)整理1.觀察量排序(based on current sal

7、ary)genderbdateeducjobcalsalarylalbeginjobtimepiwexpminorhy |137S0941 心M1r$10.100702750233SCH/12/193Se11圳；W7i43D3SOf01J16.2T0W.75D92004224f11碩1孫121$1310$10.10032005U11fO0Q1/1931121116.20aMRD6B16DD&freran 9L33121HE即S1Q.200851637191f121J185LOJ10.10084湖03114f03乙&1931S1職洶,-18B41209325fe1HS.BCtl*10.2007B

8、7BI10由fE物偵1215吧戲羽 JZOD9712411山的使7a1$怕碼$10.100723190123E7fD5.22/1942121116.95(72271113ITSf121Ji7.iroS1Q.2000572014253f21/1942s1J1781LOJ10.100810115229點21/19如121I 7項圳郁02湖F4.拆分?jǐn)?shù)據(jù)文件(based on gender)21D16BfDJZ23/19621G3tUBflZS117.29386190397.TC29B25.M21100f吸151瑚JOSH0JOO3羽72033X0 IX21272I161而皿I$18 皿|33110

9、jn ax弟 OX 0021324DfDE/15f1?611G3154.37E11B .79381S104i2.raj35B25.W214傾f15355.793&193即40419 OX35770 IX215挪I03/11/1213IS67SU削皿|73150J22X0沏 Hl IX21B371fW 時 9661G3冽125$1BJQDO7111a皿HM4525.0217192micmn押1211-12.733&L1印iZ7 an6900 IX21 e湖m碰明翊81121303fl 150to酒05? 5009750 IX219372mD8.Q2/1935151I21.3EBH5.79ZI70

10、372a52.SM5550.022022m現(xiàn)Ml啊121.7331-12.73397315i52 OX9X0 IX2216503施國81$21503印紋33410E6 0X7350 IX22232Dm11/1CV193B121i22fl9Zi7E福a7D.SM7KQ.O223135m咀伽121&15J0DDi=Gil74 XO7200 IX礎(chǔ)m國1|*1936-EC272178 5007350 ijfl結(jié)論： There are 215 female employees and 259 male employees.5. 分類匯總(break variable: gender ; functi

11、on: mean )|gendersalary_126031.9241441.70結(jié)論：The average current salary of female is 26031.92.The average current salary of male is 41441.78.（二）分別給出三種工作類別的薪水的描述統(tǒng)計量jobcal salary_1 a al ary_2 |7567.93279.6430333 8363377 ffl211-4 621B2-W73實驗2.2描述統(tǒng)計分析1）樣本均值矩陣StatisticsXLX2K-AX5K610ID10101010Mi55hg0000D0M

12、ean-.09120-.037EO-.2&4D-.4細(xì)口.63340.77970結(jié)論：總共分析六組變量，每組含有十個樣本。每股收益（X1）的均值為-0.0912；凈資產(chǎn)收益率（X2）的均值為-0.0378；總資產(chǎn)報酬率（X3）的均值為 -0.0294；銷售凈利率（X4）的均值為-0.4284；主營業(yè)務(wù)增長率（X5）的均值為0.6334；凈利潤增長率（X6）的均值為0.7797.2）協(xié)方差陣Reliability*：*foE this analysis *心蜘EELComriance Hit rix.5637,&90.07 02,LN63.0202.0092，頌Cl.1241 0B80L心旎3E

13、011491-.0543口3翊-30B03401-. 0538L2O7X5L798fi2. at isR of Cases =LDaU結(jié)論：矩陣共六行六列，顯示了每股收益（X1）、凈資產(chǎn)收益率（X2）、總資產(chǎn)報酬 率（X3）、銷售凈利率（X4）、主營業(yè)務(wù)增 長率（X5）和凈利潤增長率（X6）的協(xié)方阮liability Coefficients6 it engitwi alpha差。3）相關(guān)系數(shù)XIXEX3戲X5xsXi Pssrscn corrsttini.Q&44.E41-.3S&.湖Sl. IjIjJianan 105313N10IDIDUDID10X2 Rajscri CDrreJdtt

14、inw1,950*.T70-.326-.51Sg. (2-taled).000COD.170.135.190N10inID101010X3Fdfscn Correlation，猝51.5-.21-.394i. t.ill7i.000.ax.074.22&.260N10to10L01010X4Peats on Cnrreiation.541.470%1.CQ4.071Sl. IjIjJi 105.L7U.074949EH6N10IDIDL0ID10X5 Pejscri CorreJattin-.335-.335-.210241Sl. iSldl-ji313.L35.226翊CODN10ininin1010X6arsen Correlation-.3&?-.451-.394.071.9731*1:.r. i. t.ill7i.4B3.100.260.B46.conN101010101010correlation b significant at the o.ni1. T.ill7 1結(jié)論：矩陣共六行六列，顯示了每股收益（X1）、凈資產(chǎn)收