【精品】管理统计作业

《【精品】管理统计作业》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、管理统计作业题目：对某公司81名员工工资进行分析，分析其任职部门、性别、年龄与工资间的关系。序号姓名单位性别年龄工资1陈子元002520002李应杰002727503刘恩利202822504马韧203027505马建军003131586艾丽013132007李荣华103131008陆玉刚003237509任立玲0131312510许志强1031367811卞玉杰0132400012董小凤0132400013韩帅臣1033325014T庆平1033334515于铁华1033354316崔永善10333

2、21317郑顺0034525018檀凤志2034450019李春华0034534320王玉才2034443521王福全0034458022耿俊山2034465323高书臣0035525024甘树才2035455025段玉茹0135375026张富荣2135303527荒淑花0135375028刘国英2136302529王幸荣0136375030刘桂娟2136332231周丽荣0137450032高宝良2037525033张月萍2137477534刘廷祥1037466035陈金风0138450036郭

3、世友2038525037王淑芬2138477538孙建平1038450039高荣英0138450040曹彦贵2038525041刘了荣2138434042陈俊杰1038458043裴丽艳0139450044程相波2039552045徐丽芹2139477546吴桂杰1039450047李恩復2139537548裴志军1039480049弭会兰2140537550吴东顺1040480051孙志霞2140537552刘作贵1040480053史秋芳2141537554刘占国1041490055韩双菊214

4、2525056王琳2142534057张月霞2143549058张锦绣1143337059王玉霞1144345060土意梅1144325061杜秀君1145298062孙玉霞1145286063毕风芝1145300064赵洪玲1146453065宋志梅1146423566唐雅君1146452567崔淑菊1147425068牛瑞英1147397069张淑媛1147426570董艳敏1147452571吴晓景1148468072王秀芹1148478073张春艳1148492074郑英欣114850907

5、5刘春梅1148462076陈静1149433077张翠英1149452578董健颖1149564079刘金玲1149496080朱文革1150492081曹淑华11504480绘制散点图及箱形图:60005000-□目口Bo□4000□□D□□目3000i□D□□□2000-1000—20304060005000-3000-2000-24单位506038二、进行相关分析:Correlations年龄工资年龄PearsonCorrelation1.435(**)Sg.(2-tailed)■.000N

6、8181工资PearsonCorrelation.435(**)1Sg.(2-tailed).000•N8181Correlationissignificantatthe0.01level(2-tailed).Correlations年龄工资KendalPstaub年龄CorrelationCoefficient1.000.323(**)Sig.(2-tailed)•.000N8181丁•资Correlation.323(**)1.000CoefficientSig.(2-tailed).000•N

7、8181Spearman'srho年龄Correlation1.000.422(**)CoefficientSig.(2-tailed)■.000N8181工资Correlation.422(**)1.000CoefficientSig.(2-tailed).000•N

8、818£

9、Correlationissignificantatthe0.01level(2-tailed).三、进行回归分析:ModelSummary(b)ModelRRSquareAdjustedRSquareStd.Brorof

10、theEstimate1.435(a).189.179782.083aPredictors:(Constant),年龄bDependentVariable:工资ANOVA(b)ModelSumofSquaresdfMeanSquareFSig.1Regression11268013.041111268013.04118.422.000(a)Ftesidual48320664.09479611653.976Total59588677.13680aPredictors:(