excel分析与应用的各章练习数据表.xls

《excel分析与应用的各章练习数据表.xls》由会员分享，可在线阅读，更多相关《excel分析与应用的各章练习数据表.xls（42页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、百百佳佳公公司司人人力力资资源源结结构构性别年龄来百佳前工作时间百佳工龄 教育程度年薪（元）139512438,450044128650,91202402429,35612521427,7500565258109,285141910448,44213362640,207037116442,3311511216687,48902301426,11803154641,95612708017,439047119449,63813555643,18412954014,371046415654,6131501017476,92703036438,556134101437,183142118450,712

2、1511015890,4730631620493,58802805436,90113241433,1000551116689,867145202451,259034212219,10603327439,22412301428,743040413654,965148615453,38812706018,01413655639,205058922488,76303111635,82912101217,784047516454,19913537436,9321521214893,27802933222,100142117449,9870601021485,471150813451,194133126

3、36,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

4、*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

5、,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,548249374

6、142,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,95

7、430,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*847

8、244651139,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,28326178315

9、8,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,

10、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,503254

11、1064038,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,4

12、5531,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,8

13、897622161331046,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,99

14、114,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,481

15、1,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,513926252173

16、3041,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,150

17、2521873146,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,262254200

18、6181,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,

19、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,7

20、069,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*8232442

21、414120,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*

22、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,044

23、2442694137,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,554712222282314

24、3,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,97055

25、72152972142,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,54333421331010

26、32,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,383

27、1,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,06020

28、23375142,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,217264

29、3504030,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,

30、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,

31、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,29556

32、62093894046,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,9

33、835382044028025,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,666780248415206

34、4,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,

35、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,705595204442515

36、3,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,09671

37、92064561032,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,07619746911

38、35,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,009259

39、4832137,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,032246496304

40、2,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

41、.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.458

42、8200510493607.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.1

43、00.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标准差34567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545

44、556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691

45、701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692

46、702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693

47、703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694

48、70471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500第2章1顾客满意度是市场调研中经常使用的指标。通常采用李克特五级量表请消费者对产品或服务进行评价时，即1表示非常不满意，2表示有些不满意，3表示没有意见，4表示有些满意，5表示非常满意。下面是某市场调研中的100个消费者的评分，试根据这些数据回答2443333144214124443433322234434344224242255224443244345223312某地快餐店经理想要改进其窗口服务的质量。他要求服

49、务员记录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的总体如下，从中随机抽取样本容量为515225615518

50、52374631468156161393654527190218247275304第6章 2某品牌的啤酒进行了一个小规模的满意度调查，让顾客对其某一产品进行满意度进行评价，最高分是10分。具体数据如下4698735789357467859768594785865企业为了满足客户要求，需要对某一产品的重量进行控制。现从一批产品中随机抽取25个进行检测，检测结果如下1001021041109898999796961001109910410398109108104989610210199第7章3按照生产标准规定，某一方便面的标准重量应该为200克，质检部门随机抽取14袋的重量如下2011981972