v统计技术应用课件第四章例题计算记录.xls

例4-1粮食产量（万吨）比重（%）夏粮1231022.53早稻31325.73秋粮3919971.74合计54641100.00例4-2指标绝对数货物进出口总额29728货物出口额157791.13其中：一般贸易7207加工贸易74030.97其中：机电产品9334高新技术产品49241.90其中：国有企业2344外商投资企业8623其他企业48133.68货物进口额139482.05其中：一般贸易7680加工贸易41741.84其中：机电产品6603高新技术产品41271.60其中：国有企业3876外商投资企业73801.90其他企业26930.69进出口差额（出口减进口）1831例4-3高收入国家High Income7 79 90 04 48 81 16 64 4中等收入国家Middle Income2 22 27 72 23 30 05 55 53.482.67例例4-4年份200020032004200520062007港口集装箱吞吐量41006190747367258481103821.511.821.642.072.53例4-50.406504例例4-6110%例例4-7104%例例4-8112.38%例例4-985.11%14.89%例例4-10103.67%例例4-1197.87%2.13%2008115062.81例例4-12112115和583116118116.6122平均数116.6例例4-13日产量（件）工人数（人）每组工人产量（件）11288968961151011501150116131508150811812141614161227854854合计505824582450116.48例例4-14日产量（件）工人数（人）每组工人产量（件）绝对数相对数11280.1617.92115100.223116130.2630.16118120.2428.3212270.1417.08合计501116.480.1617.920.2230.2630.160.2428.320.1417.081116.48例例4-15xfxfxfffxff按月工资额分组（元）工人数组中值各组工资额（人）（元）（元）100015001812502250015002000201750350002000250012225027000合计5084500250012502250035001750350004500225027000845001690例例4-162.70.370370372.60.3846153852.30.4347826092.521.1897683642.521499219例例4-172.712.622.332.46fxxf例例4-1898%98%97%97%92%92%0.8746几何平均数0.95630.956312310.000.233132.000.0639199.000.7254641.001.00例例4-19本利率年数本利率的 次幂1.075611.07561.073221.15181.069831.22441.516770601加权几何平均数1.071903.48GxxffG2.67100.00例例4-20码数384143394041424339414042384140414142414341例4-21按年人均纯收入分组（元）农户数（户）1000以下181000150020150020009020002500126250030001663000300035003500185185350040001534000450013545005000885000以上19合计10003000L35005001932按下限公式计算3186.27451按上限公式计算3186.27451Ud120M0M例4-22112115116118122116例例4-23按年人均纯收入分组（元）农户数（户）向上累计向下累计1000以下18181000100015002038982150020009012896220002500126254872250030001664207463000300035003500185185605580580350040001537583954000450013589324245005000889811075000以上19100019合计100030004203500185395500下限公式3216.216216上限公式3216.216216mfdeMU1mSeML1mSeM410061907473672584811.511.821.642.0785.11%97.87%112.38%14.891128115101161311812122750583116.61812502250020175035000122250270005008450016901.18976841.9824660630.39658950.6608220210.661.1897683642.4439492.52149920.8745521.07561.07561.0732 1.15175821.0698 1.22435621.516771182090126166185153135881910003186.27453186.275按年人均纯收入分组（元）农户数（户）向上累计向下累计181000203810009012898012625489016642076418560559815375841313589326088981125191000373216.216211211511611812212611764261042020410303901003601802606080202042670018080100eM10382115062.532.81103.67%1.04002.20.1617.928960.22311500.2630.1615080.2428.3214160.1417.08854116.485824116.48#REF!7.62.5333332.4590162.4550430.9563020.9563021.0718981932283.78383216.216例4-246531.519.4例例4-25第一组第二组日加工量（件）离差离差绝对值日加工量（件）离差离差绝对值113-44111-66115-22113-44116-111170011811119221236612588合计14合计20117117-44-660-22-440-11000112206688014202.846例例4-26按年人均纯收入分组（元）组中值农户数（户）收入总额离差离差绝对值离差绝对值乘以次数1000以下7501813500-2452.52452.5441451000150012502025000-1952.51952.53905015002000175090157500-1452.51452.5130725200025002250126283500-952.5952.5120015250030002750166456500-452.5452.57511530003500325018560125047.547.58787.51x11xx 11xx 2x22xx 22xx xfxfxx xx fxx 350040003750153573750547.5547.583767.54000450042501355737501047.51047.5141412.5450050004750884180001547.51547.51361805000以上525019997502047.52047.538902.5合计1000320250081810013500-2452.52452.54414525000-1952.51952.539050157500-1452.51452.5130725283500-952.5952.5120015456500-452.5452.57511560125047.547.58787.5573750547.5547.583767.55737501047.51047.5 141412.54180001547.51547.5136180997502047.52047.538902.581810032025003202.5818.100000例例4-27第一组第二组日加工量（件）离差离差平方日加工量（件）离差113-416111-6115-24113-4116-1111701181111921236361258合计58合计117-41600-2400-11003.8078871100636003.405877584.89897948611.63.41例例4-28按年人均纯收入分组（元）组中值农户数（户）收入总额离差离差绝对值1000以下7501813500-2452.56014756.251000150012502025000-1952.53812256.2515002000175090157500-1452.52109756.25200025002250126283500-952.5907256.25250030002750166456500-452.5204756.2530003500325018560125047.52256.25350040003750153573750547.5299756.254000450042501355737501047.51097256.25450050004750884180001547.52394756.255000以上525019997502047.54192256.25合计100032025003202.5加权标准差 1003.73988xfxfxx x2)(xx 1x11xx 211)(xx 2x22xx 例例4-299.00%9.26%例例4-3069.29%30.71%0.461291离差平方36160464120117-636-4160024864120244.898979离差绝对值乘以次数108265612.576245125189878062.5114314287.533989537.5417406.2545862706.25148129593.821073855079652868.751007493750fxx2)(222)(xx 第二组