关 键 词：

Excel 统计分析 决策

资源描述：

于洪彦-Excel统计分析与决策（第2版）,Excel,统计分析,决策

内容简介：

百百佳佳公公司司人人力力资资源源结结构构性别年龄来百佳前工作时间百佳工龄 教育程度年薪（元）139512438,450044128650,91202402429,35612521427,7500565258109,285141910448,44213362640,207037116442,3311511216687,48902301426,11803154641,95612708017,439047119449,63813555643,18412954014,371046415654,6131501017476,92703036438,556134101437,183142118450,7121511015890,4730631620493,58802805436,90113241433,1000551116689,867145202451,259034212219,10603327439,22412301428,743040413654,965148615453,38812706018,01413655639,205058922488,76303111635,82912101217,784047516454,19913537436,9321521214893,27802933222,100142117449,9870601021485,471150813451,19413312636,10902605221,75003866639,455144712449,86102503430,32713785431,0080531313690,874046718457,96612001015,945家家庭庭财财务务状状况况调调查查数数据据家庭 家庭人口 住房产权第一人收入第二人收入家庭每月支出（元）水电支出（元）12158,20638,5031,58525226048,27329,1971,31421633037,58228,16438320741156,610*1,00224953037,73121,45474321764030,43426,00799120871147,969*84924381155,487*75224293159,947*1,498256106036,97031,838991222111153,113*1,163251123027,35020,969619209131148,064*1,434250142029,69220,617997190154125,853*948254163149,728*1,378272172049,88329,240902201184146,265*1,626256192149,809*834253204143,640*729259211157,395*1,473248221152,847*1,038245232159,486*933251244157,57752,088903255251163,825*1,346250263066,86857,974574202272148,37639,8941,407257284133,646*606264293165,24147,205699254303134,53121,536988264313018,84612,196746214323149,18135,0911,510264334165,27661,1401,091261342023,59720,798402211355028,85122,682696225363162,27631,2311,548249374142,63932,912919258382135,59223,0741,669245393149,77727,7731,049256403121,45113,309493259417137,80828,022722286423156,375*881261435167,79833,9451,424264441129,805*1,161253451035,289*457192465163,35452,6561,458277472030,69323,046977199482168,806*1,453251491166,770*1,658257501159,321*1,664247514149,95430,7581,062260522155,75237,4041,660253535043,43621,855699215545136,78021,609573279553064,48943,448748207562130,43323,9291,318244575020,23417,507572223582132,848*720254592016,25211,539669206603175,22571,9301,272260612138,83836,5131,084247623160,99344,2201,476257632031,05126,5201,033195641143,847*847244651139,862*1,472250662027,22217,215520201672027,65118,644501195683153,65050,6361,292259695042,16839,108490221704136,47233,8321,435260712166,346*1,914247724163,57254,0481,123249732150,23339,5391,293259743035,46628,368776212752177,89274,072875246764153,11748,3931,534254774156,31041,5581,283261783158,56343,5791,138272792133,105*976249804134,25928,4381,302251811126,910*1,028244825136,06528,020640278832156,33054,315989254842154,86341,3291,751245855148,304*752265863036,37332,341428207875060,94057,432888218883153,24939,7771,469254892159,06453,545943255903032,06127,840577202911127,377*815254922048,23230,7281,134199933162,28052,6541,278259943137,18427,5691,014265952164,154*1,088259962186,39843,9891,137241976141,335*959278984162,52255,855831265993041,49035,1585782051006145,39130,1211,0402751012139,367*1,2332451021175,865*1,0782391032036,58830,2786022021042048,72648,6946222031053175,208*1,5032541064038,74024,8065682081074026,21916,1655302111082132,806*7712421094146,66729,3341,2502551104165,11553,7551,3002591113040,39731,7255762141122065,60154,2789922011131043,657*8481911141137,523*1,8292501153173,73473,4811,7312641163158,58051,4886702611173155,80637,3841,6762571181131,400*1,0302461193148,45531,3316352701202140,85834,1141,0492471212159,73759,5101,5882541221024,478*9891961234036,39527,6506552151243142,84336,9651,5002611255021,55714,3226582171263037,18624,5776892041271034,806*6812071282135,47921,2719642551296030,58417,3725862231301152,448*1,1212481315139,09637,3361,2032631325024,12813,8897622161331046,342*5602011343023,30220,9876262231351139,578*9532391362149,13236,0072,1712501372156,83832,0218102521384161,95557,4451,4602531391171,211*1,5142531401028,837*5692021415034,35422,5437782281424024,44212,9405582051435022,25919,6836802231446148,91040,0631,0072681451025,713*8141911463122,99114,3871,2522571472184,82070,0961,4672451481027,721*7231981497039,60232,1988482371503031,10028,4891,0832101513158,45129,7531,4702571524020,27714,5025002151532133,96333,1689912431541145,869*1,3772461551162,071*1,3262551561030,557*6012111573030,48218,6845882081583190,48868,6191,5372621593161,17435,4811,6012611603128,378*6442561613139,84732,8021,5732531621037,154*6572011635042,84133,9618922131645156,07255,5931,2482711653033,44221,9207702011664128,82222,9369592571672133,018*8712491683130,225*1,1172601695142,17840,2111,2692781702028,34018,5336271981712143,02738,6001,2352511722176,54753,5139262521733041,27535,9201,1202061741159,708*1,0702551753068,11565,0991,1592051763025,75520,2678472091771033,699*7972081781036,384*6012021794025,81620,9035622091803030,41517,2137282071811034,150*6432051828031,48424,8506442331835168,10857,8951,5212751844026,78826,1011,0592031851168,299*1,2712461863136,015*1,1502521873146,56126,6311,9842551883152,434*1,0932711892037,65032,2305342011904134,30825,2479632541914153,57648,6661,1082571922146,249*1,1332541931133,940*1,0272471941137,924*6532481954026,16716,25955321219610033,45622,2674052261974020,18216,6536032181983165,69950,2021,0652631994159,01534,5491,2622542006181,36645,4431,8002672014031,19820,1154972132023140,38331,2701,0862562033024,57823,2691,2862072043030,00218,6323492122051142,058*8842542064025,83515,3627972092071018,276*4781962081022,380*7461942093148,893*6762542104060,95358,5731,1862052114029,32217,7876742122124136,170*1,1852532133170,69269,1151,0882522145136,74219,4781,3042622154039,25536,2349492072163043,73737,1967972062174041,40133,0597242052184023,77917,5677842072194053,16533,6441,7401992202034,75621,1018012052212049,47948,2036472012221072,949*1,5222002231039,987*5382042241034,204*8381972252038,97532,8673691922261139,991*7962462274018,7069,5496902142284052,96537,3707662142293065,31858,6281,6872192309132,63025,2911,3912872312056,64547,4727971972326140,27031,7738542762334033,53826,0836172152343137,599*1,0582552351159,579*1,1612542364032,27117,8478182112372141,427*1,3772492383037,23520,4887452062392131,519*1,2182452401173,980*8232442414120,51418,7326292662423181,612*1,7872542434165,717*1,2512632443150,155*1,0682542452135,502*8292532463140,87433,4461,2172602475038,42535,3763982242485130,04525,0549242712496131,64419,8938212662502034,05217,8055852002514147,33630,4371,0442612522138,00721,1448402592535021,40213,9647882222542139,353*4952472551064,179*1,4321992561167,184*7562422573043,16322,6229412082581051,372*8871912595023,76321,3609532262604020,98714,1893552142613049,81936,9119602112622158,303*1,2662562634071,13039,8261,2622162643137,375*9852552654021,70120,3317992062661027,700*7282032671032,420*1,0752032682165,74033,5831,0442442694137,55222,1038932602703158,18237,8351,5762482712134,66222,7987242452723038,63427,2135492072733127,085*9652682743160,590*1,1672642752198,88174,8251,2952492765146,47337,1341,4892612771154,374*8042522782164,63062,3211,5852492792139,320*1,2592542803031,46120,9498882072814038,38921,5547122222823143,179*9092572833031,72125,9405252102841028,835*7932052852165,85244,5959082462864149,156*8382582875157,77248,7231,0702692883045,45537,9977322172891146,890*57724429010048,33037,1356162302913050,72438,0926532012924148,586*6792582931029,289*8332062941036,838*6211922953139,080*1,1032592965021,38216,9705572152972142,39026,1731,0082472982148,12041,9521,3172462992135,343*5562393005175,04955,6571,3802723011132,316*7902603023046,28942,4217782083032035,88319,6928952033043137,90423,8901,6142673053154,90128,7681,3062663064032,64924,7421,1032123072116,971*8072413083134,431*8052583095030,53922,5433342133101032,697*6232023114184,886*1,1412603123029,38617,4308752053134024,10920,3143892113142136,49332,2211,4342483154155,50653,4121,1122643163139,62721,8319332643172028,91014,8554902033184124,493*1,1362683193141,96536,3351,2422563202069,61563,7101,0382053213141,069*1,4932593221022,091*6132083236140,81321,3831,0392663243140,742*1,4032583253021,69913,7044182123263024,43020,9876102143272149,744*1,7342543284019,31610,6807602123298152,86242,2941,0422793303083,85965,5821,1662093312146,02330,3931,5892453321026,351*6232013334150,38335,7496142663345136,63022,8711,2952683356139,773*8532723362038,89123,8081,0602023375142,32328,4278662793383143,89143,7451,7072573395171,65970,4361,1382673405035,24118,6775532213415017,88110,5095582173423035,31025,4056752033433025,16719,6735192103441024,859*5092013454038,99326,8669212083465130,38424,5821,4322643473156,96737,9011,0502683481153,283*9742483494144,43632,1621,2172643504030,52727,0557652093515195,58371,5991,2532623525024,06418,0957552183532028,95018,5424272053542033,17623,8977112013554037,29728,0101,8302123563133,65326,7041,0552663572033,72327,4806221923582045,57223,2139312023593046,67228,8771,0542153602137,09318,5611,2872483612036,58832,7287291993622143,93441,7311,8022523633028,06817,9276032063641175,737*1,5962493656137,10730,0471,3312713664162,63459,3521,3552563673163,94662,5231,3212513683035,94320,4945682143691124,992*5792423705148,64336,6511,4392643712027,16026,6197072013724149,699*1,5162503732147,65926,8271,0512573743039,77833,3368122123757031,09021,5866942313762142,70841,6017532533774031,23829,4028272163781160,240*9892523794037,11734,0715232063804043,83232,9967602003811035,105*9602013823045,60929,6029912093834141,91438,4781,2232703843151,20229,2891,6192673853022,39311,8025492133863049,44736,5628542083875183,36372,9301,7992673882025,99713,2955662093894046,65631,0446712103903156,85749,6961,5332473915149,94334,7318732673921172,515*1,0852503932053,24844,3984901923942135,57231,4339142493954132,42531,3481,1762533962046,27140,2829412083973185,62181,9791,8272603982125,07621,7581,0812523992038,69724,2777652034005032,79432,7044052164012026,10113,9835382044028025,65523,4644932344033044,15832,6167192254046124,11413,5779252654055024,50316,3214532184061148,914*1,1532494074023,69516,5585102114085130,372*7992794092024,30615,4675401994102135,07929,5429612574111025,886*8202054122045,62540,5838871994133139,34134,5207732704142132,43322,6667802484152064,57062,5909312024162155,665*1,0482524175031,65731,5965302134184185,37453,4171,1032554191176,800*1,2372584202138,68133,8539562514219026,38022,3826482324226171,20656,2681,0092764232169,86357,0191,7052454242037,43521,7249962014253042,41940,6541,1872064261043,482*7352004275148,43944,4341,1472624281045,038*9842014291033,087*6332114301145,993*1,6892484313145,22025,9149942574321029,407*8572034333134,93321,8441,7052564344149,20637,6149802594354161,764*1,0662504362164,98234,3701,7002614373020,84411,9488612164382053,60733,6208311944394038,48131,8924752104401156,151*1,1282524412031,11830,7055952044425153,338*7932744436025,24615,7079542224444132,70525,0291,1422524455179,69642,4978142734462024,32724,2506281944475184,09860,0491,2132674483023,65315,0524742164492158,305*1,1712474501047,570*9182004513020,43518,0135472154522184,675*1,0682494535042,60330,0729312204543035,04318,1899302074554018,78213,0967192064561032,125*5971964573138,15727,6437272644583029,10115,9675002064593137,86930,0599412624604026,10317,4359342154614155,26446,7781,4202654622029,71817,9551,2402064634134,884*7832514643033,46730,0321,2862144651018,119*1,4522114668146,10044,8478202864673148,369*1,2222594682045,27529,0551,0761974691135,430*1,0292594703042,24932,3876152084713184,82344,3881,1362544721160,069*1,4342494732128,534*7602554744130,43328,2045842604753153,18441,6241,0332544761049,358*5622054771141,628*1,7322534783146,389*1,7802584792185,051*1,3072464803046,70340,5021,0782054813033,26817,5876802084823176,43540,1361,0092594832137,45021,4646182484841047,244*6381964853057,52529,5141,0012134863133,91931,3717132594873150,64337,4651,4362614881026,610*9991974895152,65630,4227472664902149,25535,4911,2802534913031,14218,9694002184925139,18924,8341,0672754933046,37926,2534842154941142,313*8832484952146,82839,5961,0322464963042,75834,0671,1841974975166,39754,7169902744982143,59933,3641,6032534994125,713*8312665001139,187*948251城镇居民家庭人均可支配收入农村居民家庭人均纯收入年份绝对数 (元)指数 (1978=100) 绝对数 (元)指数 (1978=100)1978343.4100133.61001980477.6127191.31391985739.1160.4397.6268.919901510.2198.1686.3311.219911700.6212.4708.6317.419922026.6232.9784336.219932577.4255.1921.6346.919943496.2276.81221364.319954283290.31577.7383.619964838.9301.61926.1418.119975160.3311.92090.1437.319985425.1329.92162456.119995854360.62210.3473.520006280383.72253.4483.420016859.6416.32366.4503.720027702.8472.12475.6527.920038472.2514.62622.2550.620049421.6554.22936.4588200510493607.43254.9624.5200611759.5670.73587670.7x一般正态分布 标准正态分布均值0-6标准差1-5.9-5.8-5.7-5.6-5.5-5.4-5.3-5.2-5.1-5-4.9-4.8-4.7-4.6-4.5-4.4-4.3-4.2-4.1-4-3.9-3.8-3.7-3.6-3.5-3.4-3.3-3.2-3.1-3-2.9-2.8-2.7-2.6-2.5-2.4-2.3-2.2-2.1-2-1.9-1.8-1.7-1.6-1.5-1.4-1.3-1.2-1.1-1-0.9-0.8-0.7-0.6-0.5-0.4-0.3-0.2-0.100.10.20.30.40.50.60.70.80.911.11.21.31.41.51.61.71.81.922.12.22.32.42.52.62.72.82.933.13.23.33.43.53.63.73.83.944.14.24.34.44.54.64.74.84.955.15.25.35.45.55.65.75.85.96x（失业人数）二项分布 正态分布n5000p 0.31均值2标准差3456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500第2章1顾客满意度是市场调研中经常使用的指标。通常采用李克特五级量表请消费者对产品或服务进行评价时，即1表示非常不满意，2表示有些不满意，3表示没有意见，4表示有些满意，5表示非常满意。下面是某市场调研中的100个消费者的评分，试根据这些数据回答2443333144214124443433322234434344224242255224443244345223312某地快餐店经理想要改进其窗口服务的质量。他要求服务员记录20个顾客在窗口等待的时间如下，然后进行分析。他想知道如下问题：0.920.910.420.462.370.820.640.160.220.790.790.671.250.950.891.211.561.030.770.34第4章1某轿车品牌的一个4S店一天中可能销售的轿车数量及其概率如下销量0123456概率0.180.370.240.140.040.020.013一个超市某个品牌酸奶的12天的销量如下，假设酸奶销量服从正态分布920980110081010507709507207808401000970第5章1有一个N为20的总体如下，从中随机抽取样本容量为51522561551852374631468156161393654527190218247275304第6章 2某品牌的啤酒进行了一个小规模的满意度调查，让顾客对其某一产品进行满意度进行评价，最高分是10分。具体数据如下4698735789357467859768594785865企业为了满足客户要求，需要对某一产品的重量进行控制。现从一批产品中随机抽取25个进行检测，检测结果如下1001021041109898999796961001109910410398109108104989610210199第7章3按照生产标准规定，某一方便面的标准重量应该为200克，质检部门随机抽取14袋的重量如下201198197210199202206199202203199203200201第8章1比较两个城市的人均月收入水平，抽取两个城市的独立随机样本，数据如下A城市 B城市样本量3548人均月收入 30002500总体方差5003002企业的两个分厂生产同一产品。分别随机抽取两个分厂的22名和18名工人进行生产效率的比较，数据如下A厂150160153167159163143162143175168145167154160172164157165176166167B厂1601551651571601481541561561671721531471761771571731593对智商、年龄和性别比例等条件相同的两个班级进行教学方法效果的评价，每个班级20名学生，一个班级采用A教学法，另一班级采用B教学法。成绩如下A7073766978776765757669687172767774676869B7377767965676877787973757878656768697172第9 章1企业的管理人员需要适当的信息来完成他们的任务，根据某项研究可知，信息来源对于信息传播具有影响。下表为三组信息来源的信息传播程度，在显著水平为0.05的情况下检验信息来源对传播程度是否具有显著影响上级8546675355同事6675347666下属65743575772企业中重要的管理部门有财务，人力资源和营销。表中数据是这三类人员的职业操守的评价，高分表示职业操守好。试在显著水平为0.05的情况下检验三类人员的职业操守是否具有显著差异财务5544544576营销6543644867人力资源67656635683某品牌不同口味的方便面在五个地区销售，销售额（万元）资料如下表所示，试以0.05为显著水平检验该品牌方便面不同的口味和在不同的地区销售数量之间是否有显著差异口味地区红烧沙茶炸酱东北414534西北525144华中554846华南544445东南4438514一家邮购公司设计了一个实验以检验杂志广告大小以及广告方案对于收到订单的影响 。考察了三种广告方案和两种不同大小的广告，得到数据如下表所示。试以0.05为显著水平检验广告方案，广告大小或交互作用的显著影响广告大小小大方案A812128B22261430C10181814第10章1以下是10种饮料品牌的销售量（百万箱）和广告费用（百万元）：试计算广告费用1319260564029123856120销售数量1930138481154153653622052055018302下表是某企业人力资源部提供的工龄（年）和相应的年薪（万元）的数据，试计算工龄12821251026161年薪3.855.092.942.78 10.934.844.024.238.752.613飞机航班的飞行正点如何，是乘客经常投诉的对象之一，以下是搜集的样本资料航班正点率（%） 8176757673707169投诉率（%）0.580.850.680.740.930.721.221.254下表是关于汽车轮胎等级及其相应的承载能力数据，试计算轮胎等级7582858788919293105106承载能力853104711351201123513561389143320302034第11章1某营销经理认为每周的总收入是广告费用的函数，并想对周的总收入做出估计。下表是由10周的历史数据组织的样本，试计算月销售收入（万元）9690959295949494969092电视广告支出（万元）5242.533.52.534.52.53报纸广告支出（万元）221.52.53.32.34.22.522221.天天公司的营销人员认为该公司天天品牌饮水机销售数量受本品牌价格和竞争品牌价格的影响，因此希望建立考虑了本品牌价格和竞争品牌价格的饮水机销售量回归方程，下表是10个城市的抽样调查的价格资料，试计算：天天品牌价格120140190130155175125145180150竞争品牌价格10011090150210150250270300250销售量1021001207746932669658531.从上市公司数据库中随机抽取16家公司的数据如下表所示，试计算：价格收益比2223172618191323172619总边际利润（%） 24211127129.8139.712268.2销售增长率（%） 105.3179.4188.313225.6198.14某公司营销经理希望对公司销售人员工作年限的长短和电视销售数量之间的关系进行研究。下表是随机抽取14名销售人员近期电视销售数量（台）和每一名销售人员在公司的时间（月）。试根据这些数据计算工作月数411067610422128511140519销售量27529631737616215036730818923583第12章1某超市12周的销售额（万元如下表所示，试计算：周1234567891011销售额 17211923181620182220152某公司过去5年的各季度销售量（万台）如