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

1、.管理統(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王玉才2

2、034443521王福全0034458022耿俊山2034465323高書臣0035525024甘樹才2035455025段玉茹0135375026張富榮2135303527董淑花0135375028劉國(guó)英2136302529王幸榮0136375030劉桂娟2136332231周麗榮0137450032高寶良2037525033張?jiān)缕?137477534劉廷祥1037466035陳金鳳0138450036郭世友2038525037王淑芬2138477538孫建平1038450039高榮英0138450040曹彥貴2038525041劉子榮2138434042陳俊杰1038458043裴麗艷01

3、39450044程相波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唐雅君1146

4、452567崔淑菊1147425068牛瑞英1147397069張淑媛1147426570董艷敏1147452571吳曉景1148468072王秀芹1148478073張春艷1148492074鄭英欣1148509075劉春梅1148462076陳靜1149433077張翠英1149452578董健穎1149564079劉金玲1149496080朱文革1150492081曹淑華11504480一、 繪制散點(diǎn)圖及箱形圖：二、 進(jìn)行相關(guān)分析：Correlations 年齡工資年齡Pearson Correlation1.435(*)Sig. (2-tailed).000N8181工資Pearson

5、 Correlation.435(*)1Sig. (2-tailed).000.N8181* Correlation is significant at the 0.01 level (2-tailed).Correlations 年齡工資Kendalls tau_b年齡Correlation Coefficient1.000.323(*)Sig. (2-tailed).000N8181工資Correlation Coefficient.323(*)1.000Sig. (2-tailed).000.N8181Spearmans rho年齡Correlation Coefficient1.000

6、.422(*)Sig. (2-tailed).000N8181工資Correlation Coefficient.422(*)1.000Sig. (2-tailed).000.N8181* Correlation is significant at the 0.01 level (2-tailed).三、進(jìn)行回歸分析：Model Summary(b)ModelRR SquareAdjusted R SquareStd. Error of the Estimate1.435(a).189.179782.083a Predictors: (Constant), 年齡b Dependent Vari

7、able: 工資ANOVA(b)Model Sum of SquaresdfMean SquareFSig.1Regression11268013.041111268013.04118.422.000(a)Residual48320664.09479611653.976 Total59588677.13680 a Predictors: (Constant), 年齡b Dependent Variable: 工資Coefficients(a)Model Unstandardized CoefficientsStandardized CoefficientstSig.BStd. ErrorBet

8、a1(Constant)1912.786555.021 3.446.001年齡60.25314.038.4354.292.000a Dependent Variable: 工資四、進(jìn)行方差分析（只考慮因子主效應(yīng)）： 第一種Tests of Between-Subjects EffectsDependent Variable: 工資 SourceType III Sum of SquaresdfMean SquareFSig.Corrected Model4415182.358(a)31471727.4532.054.113Intercept1296671423.33811296671423.3

9、381809.632.000性別305238.5491305238.549.426.516單位4131898.93422065949.4672.883.062Error55173494.77877716538.893 Total1533423433.00081 Corrected Total59588677.13680 a R Squared = .074 (Adjusted R Squared = .038)Parameter EstimatesDependent Variable: 工資 ParameterBStd. ErrortSig.95% Confidence IntervalLow

10、er BoundUpper BoundIntercept4637.182190.52324.339.0004257.8025016.562性別=0-125.737192.647-.653.516-509.346257.873性別=10(a).單位=0-602.345259.941-2.317.023-1119.953-84.738單位=1-384.963220.904-1.743.085-824.83954.912單位=20(a).a This parameter is set to zero because it is redundant.Tests of Between-Subjects

11、EffectsDependent Variable: 工資 SourceType III Sum of SquaresdfMean SquareFSig.Model1478249938.222(a)4369562484.556515.761.000性別305238.5491305238.549.426.516單位4131898.93422065949.4672.883.062Error55173494.77877716538.893 Total1533423433.00081 a R Squared = .964 (Adjusted R Squared = .962)Parameter EstimatesDependent Variable: 工資 ParameterBStd. ErrortSig.95% Confidence IntervalLower BoundUpper Bound性別=04511.445206.11821.888.0004101.0134921.878性別=14637.182190.52