管理統(tǒng)計(jì)作業(yè)

PAGEPAGE1管理統(tǒng)計(jì)作業(yè)題目：對(duì)某公司81名員工工資進(jìn)行分析，分析其任職部門、性別、年齡與工資間的關(guān)系。序號(hào)姓名單位性別年齡工資1陳子元002520002李應(yīng)杰002727503劉恩利202822504馬韌203027505馬建軍003131586艾麗013132007李榮華103131008陸玉剛003237509任立玲0131312510許志強(qiáng)1031367811卞玉杰0132400012董小鳳0132400013韓帥臣1033325014王慶平1033334515于鐵華1033354316崔永善1033321317鄭順0034525018檀鳳志2034450019李春華0034534320王玉才2034443521王福全0034458022耿俊山2034465323高書(shū)臣0035525024甘樹(shù)才2035455025段玉茹0135375026張富榮2135303527董淑花0135375028劉國(guó)英2136302529王幸榮0136375030劉桂娟2136332231周麗榮0137450032高寶良2037525033張?jiān)缕?137477534劉廷祥1037466035陳金鳳0138450036郭世友2038525037王淑芬2138477538孫建平1038450039高榮英0138450040曹彥貴2038525041劉子榮2138434042陳俊杰1038458043裴麗艷0139450044程相波2039552045徐麗芹2139477546吳桂杰1039450047李恩霞2139537548裴志軍1039480049弭會(huì)蘭2140537550吳東順1040480051孫志霞2140537552劉作貴1040480053史秋芳2141537554劉占國(guó)1041490055韓雙菊2142525056王琳2142534057張?jiān)孪?143549058張錦繡1143337059王玉霞1144345060王慧梅1144325061杜秀君1145298062孫玉霞1145286063畢鳳芝1145300064趙洪玲1146453065宋志梅1146423566唐雅君1146452567崔淑菊1147425068牛瑞英1147397069張淑媛1147426570董艷敏1147452571吳曉景1148468072王秀芹1148478073張春艷1148492074鄭英欣1148509075劉春梅1148462076陳靜1149433077張翠英1149452578董健穎1149564079劉金玲1149496080朱文革1150492081曹淑華11504480繪制散點(diǎn)圖及箱形圖：進(jìn)行相關(guān)分析： Correlations年齡工資年齡PearsonCorrelation1。435（*＊）Sig。(2—tailed).。000N8181工資PearsonCorrelation.435(*＊)1Sig。（2—tailed)。000.N8181＊＊Correlationissignificantatthe0。01level(2—tailed）。 Correlations年齡工資Kendall'stau_b年齡CorrelationCoefficient1.000.323(*＊)Sig.（2—tailed）..000N8181工資CorrelationCoefficient.323（＊*）1。000Sig。（2-tailed)。000.N8181Spearman’srho年齡CorrelationCoefficient1.000。422(＊*）Sig.（2—tailed).。000N8181工資CorrelationCoefficient。422(＊＊）1.000Sig.(2—tailed)。000.N8181*＊Correlationissignificantatthe0.01level(2—tailed).三、進(jìn)行回歸分析： ModelSummary(b)ModelRRSquareAdjustedRSquareStd。ErroroftheEstimate1。435（a）.189.179782。083aPredictors:（Constant）,年齡bDependentVariable：工資 ANOVA(b)ModelSumofSquaresdfMeanSquareFSig。1Regression11268013.041111268013.04118.422。000（a)Residual48320664.09479611653.976Total59588677。13680aPredictors:（Constant）,年齡bDependentVariable:工資 Coefficients（a）ModelUnstandardizedCoefficientsStandardizedCoefficientstSig。BStd.ErrorBeta1（Constant)1912.786555.0213.446.001年齡60。25314。038.4354.292.000aDependentVariable：工資四、進(jìn)行方差分析（只考慮因子主效應(yīng)）：第一種 TestsofBetween—SubjectsEffectsDependentVariable:工資SourceTypeIIISumofSquaresdfMeanSquareFSig.CorrectedModel4415182。358（a）31471727.4532.054.113Intercept1296671423。33811296671423。3381809。632.000性別305238。5491305238。549。426。516單位4131898.93422065949.4672.883。062Error55173494.77877716538。893Total1533423433.00081CorrectedTotal59588677。13680aRSquared=。074(AdjustedRSquared=.038） ParameterEstimatesDependentVariable:工資ParameterBStd。ErrortSig。95％ConfidenceIntervalLowerBoundUpperBoundIntercept4637.182190。52324.339。0004257.8025016.562［性別=0］—125。737192。647—.653.516—509.346257。873[性別=1]0（a）..。。。[單位=0］-602。345259。941—2.317.023-1119.953—84.738[單位=1］-384。963220。904-1.743。085-824.83954.912[單位=2]0(a)。。。。.aThisparameterissettozerobecauseitisredundant。 TestsofBetween—SubjectsEffectsDependentVariable:工資SourceTypeIIISumofSquaresdfMeanSquareFSig.Model1478249938。222（a)4369562484。556515.761。000性別305238。5491305238。549。426。516單位4131898.93422065949.4672.883.062Error55173494。77877716538。893Total1533423433。00081aRSquared=.964(AdjustedRSquared=。962) ParameterEstimatesDependentVariable：工資ParameterBStd.ErrortSig。95%ConfidenceIntervalLowerBoundUpperBound[性別=0]4511。445206.11821。888.0004101.0134921。878［性別=1］4637.182190。52324