SAS数据处理结课论文—城市居民消费价格指数

1、First compliance review of the application of the appraisal Committee, only through the compliance review of the application to take part in a detailed review. 8.1 application compliance review: does not meet one of the following conditions, procuratorial Agency to submit application through complia

2、nce reviews, be invalidated: (1) application of the formats, contents, meet the requirements of selected files, powers of Attorney, declarations by the legal representative and the tender agent application to meet the requirements; (2) licence and a bidding agent qualifications meet the requirements

3、; (3) the similar project tendering agency agent number and provide proof of material compliance; (4) the tendering Agency intends to put into this project the number of professionals to meet the requirements; (5) are intended to the agent of the project as a project manager has similar projects the

4、 number of and references to meet the requirements; (6) no fraud case. 8.2 application review in detail the Evaluation Committee through compliance reviews will be selected for detailed review of the application. 8.2.1 tender agent institutions similar project tender performance requirements (16 poi

5、nts) tender agent institutions similar project tender performance 16 points, by two part composition (1) agent similar project of cumulative bid amount scored calculation rules for: Agent water project bid amount (on January 1, 2007 has has bid notice for associate) cumulative each reached 100 milli

6、on Yuan have 2 points, water project cumulative bid amount scored up not over 6 points. In addition, completes a bid worth more than 500 million yuan in total 1 minute, but other items score accumulated winning amount up to a maximum of 6 points. (2) calculation rule for the number of agents similar

7、 projects: proxy bid amount (since January 1, 2007 winning notice shall prevail) bidding projects in more than 50 million Yuan by 2 points, but the Agency projects the number of scores up to 3 minutes. 8.2.2 to be agents of the construction project as a project manager in the same project performanc

8、e (10 points) Project Manager agent performance scores including agents of the bidding agencies of similar projects, as well as in other similar project tendering agency service agent during performance. Total 10 Project Manager agent performance, made up of two parts (1) acting like the accumulated

9、 winning amount calculation rule: agents for water conservancy project bid amount (since January 1, 2007 winning notice for example) cumulative average reached 100 million Yuan 3 but scored no more than 5 minutes. (2) calculation rule for the number of agents similar projects: proxy bid amount (sinc

10、e January 1, 2007 winning notice for example) in the more than 50 million Yuan water conservancy project period of 3 minutes, but scores the number of agents similar projects up to a maximum of 5 points. Project Manager demonstrated to provincial-level and higher peoples Government or the developmen

11、t and Reform Commission published the winning bidder on the designated media publicity shall prevail. 8.2.3 staff requirement (25 points) 1, to the construction project serving personnel, 4 years experience in tendering agent, 2 points per person, 2 years experience in tendering agent .Pig is not a

12、pig. With domestic international market and technology big environment of changes, as China traditional industry of pig production of job way and profit way are requirements related industry for resources integration, to quality security for premise, regulation based farming, and management cost and

13、 the production, and sales cost, go standardization, and scale, and intensive, and market road, fast upgrade whole industry chain of regulation capacity, market competition capacity and anti-risk capacity. First, industry analysis (a) the basic situation in China is a traditional hog production and

14、consumption country, 2008 46.15 million tons of pork, pig stock 462.64 million head by the end pig slaughter 609.6 million. National pig industrys annual production value at around 650 billion yuan, nearly 50% per cent of annual output value of animal husbandry. Sichuan province in 2008 produced 6.5

15、2 million tons of pork, with 694,000 tons of Chengdu city, live pig sell 10.46 million, first 15 Vice-provincial cities in the country. The whole nation advantage regional planning (2008-2015) there are 437 counties (cities), 55, Sichuan, Chengdu has 7 (including in pengzhou). International pig indu

16、stry mainly include the European Union, the United States, and Canada, and Brazil and other absolute scale of animal husbandry industry and technology developed countries. Market 1, the domestic market from Chinas meat consumption habits and economic analysis of the development situation, the emerge

17、nce of new trends in the market of domestic pork and its products. Docking is a pig production and sales more closely. The Yangtze River Delta, Pearl River Delta and the Bohai rim economic developed area industrial structure adjustment gathered pace, two or three industries to the Central and Wester

18、n bias. Second, the rigid domestic consumption growth. For a long period, pork is still the largest variety of meat consumption in China, the absolute consumption continues to grow. Especially in the vast rural market growth potential. Third, market for pork and higher product quality requirements.

19、Pollution-free pork safety and health has shown a very good market prospects. Four is the market changing. Currently, cold meat, more and more varieties of meat and pork meat products, which accounted for a large proportion of pork consumption, stores, chain stores, supermarkets and other marketing

20、methods is on the rise, and transport has been extended to more than 2000 km in RADIUS. Chengdu is an important River pig resource market, the citys commercial rate reaches above 60% of live pigs, pork and raw materials primary processing products in the domestic and international reputation is high

21、. Western hog trading center in Chengdu and provides disease-free areas of construction in order to further accelerate the development of swine industry realizes space and conditions. 2, the international markets at present, annual volume of trade in live pigs in the world year around 18 million, ab

22、out 6 million tons of pork trade. A large net exporter of pork is mainly the EU and North America,-importing countries mainly in Asia, Japan, and Korea, and Singapore, the Philippines, Hong Kong and other countries and regions, as well as Russia, about 3 million tonnes were imported. It is predicted

23、 that the world meat consumption increase of 80% in Asia in the future, our country has obvious geographical advantages, export potential. With the advancement of live pigs superiority industry belt construction, animal disease .SAS数据分析案例分析 城市居民消费价格指数班级：数学111姓名：徐丹丹学号：110008 城市居民消费价格指数(Urban Consumer

24、 Price Index)，是反映城市居民家庭所购买的生活消费品价格和服务项目价格变动趋势和程度的相对数。城市居民消费价格指数可以观察和分析消费品的零售价格和服务项目价格变动对职工货币工资的影响，作为研究职工生活和确定工资政策的依据， 是用来反映通货膨胀（紧缩）程度的指标。 2013年10月-2014年10月全国分地区居民消费价格指数主要经济指标地区2014年10月2014年9月2014年8月2014年7月2014年6月2014年5月2014年4月2014年3月2014年2月2014年1月2013年12月2013年11月2013年10月北京100.5101.1101.5101.8102.210

25、2.1101.5102.1101.8103.3102.7103.3103.4天津100.7101.0101.3101.3101.9102.4101.9102.9102.4103.4103.3103.9104.3石家庄101.7102.3102.8102.6103.0102.9101.2101.8101.0100.9101.0102.4103.3太原100.2101.7102.1102.5103.3103.3103.2104.0102.1102.4102.3104.1104.8呼和浩特100.8100.5101.2101.4101.5101.2100.5101.7101.7101.5103.11

26、03.8104.2沈阳102.1102.3103.2103.1103.0103.0101.9101.8100.7101.8101.7102.2102.0大连101.3101.0102.0102.1102.4103.1102.6102.3101.6101.9101.8102.7102.6长春102.1101.5102.0102.2102.5102.5102.3102.2102.2102.8102.1102.5102.9哈尔滨101.5101.2102.0101.9102.4103.7102.9102.6100.6102.2102.4103.7102.7上海102.4102.7102.6103.0

27、102.6102.9102.3102.5102.7103.0102.4102.4102.6南京102.4102.8102.7102.7102.3102.8101.8102.6103.2103.4103.8103.9103.9杭州101.0101.4102.3102.6102.5102.5102.2103.1102.5102.8102.9103.1103.1宁波101.0101.5102.4102.3102.2102.4102.1102.4102.0102.7102.9103.0103.4合肥101.7102.0102.2102.1102.2102.6101.9102.3102.3102.510

28、2.5103.1103.7福州100.8101.0101.9102.3101.9102.0101.2102.6101.4102.6102.8104.1104.6厦门100.5100.3101.4102.3102.9103.6103.2103.9102.5103.2102.9103.5104.2南昌101.5102.2102.1102.3103.7103.8103.0103.8103.4102.6103.1103.1103.1济南102.0102.4102.5102.8103.2102.5101.9102.5101.4101.1101.4101.8102.6青岛102.3102.8103.010

29、4.1103.9103.4102.6102.4100.9102.2102.3103.3103.3郑州102.1102.1102.4102.4102.4102.3101.6102.1101.3102.3102.5103.4103.4武汉101.9102.0101.6102.0101.7101.9101.6102.1102.2102.4102.0102.2102.5长沙101.9102.2102.8103.0102.9102.6101.9103.2103.8104.6104.2104.5104.5广州102.1102.0102.4102.9102.6102.5101.5102.8102.6102.

30、4101.9102.2102.4深圳101.2100.7101.2102.0102.5102.8102.1102.9103.0103.5103.2103.3103.5南宁100.4100.5101.3102.0101.9102.0102.5102.8101.9102.8103.3103.4103.5海口101.8102.2101.8102.6101.9101.8101.8102.9103.2103.5103.5104.0103.9重庆102.2101.6101.7101.9102.0101.8101.2101.8101.5101.9102.0102.5102.5成都101.0101.1101.

31、5101.7102.1101.3100.3101.2101.0101.7102.3103.4103.8贵阳101.8102.5103.0103.8104.0103.6102.5102.4100.9102.2102.2103.0103.0昆明104.0104.2103.7103.1102.8101.7101.3102.8102.6103.2102.9103.3103.5西安100.5100.8101.7101.9101.4101.8101.0102.3102.0102.9102.4102.8103.4兰州102.0102.0101.9101.8101.6101.9101.7102.4102.21

32、02.7102.5103.5103.8西宁103.6103.9103.3102.0102.0102.5102.1102.2102.5103.2101.6102.4102.7银川102.1102.7102.9102.1101.5101.0101.4102.3102.4102.7103.1103.3103.5乌鲁木齐101.6102.3103.2103.4103.5103.4102.8103.9102.8103.7103.0103.7103.9（数据来源于中国统计局）根据此表解决以下问题：1）用最长距离法对这35个城市进行谱系聚类,画出谱系图，并分类。2）对数据进行主成分分析，分析出贡献率最高的月

33、份，同时可以根据贡献率分析出13个月的居民消费水平的发展情况，然后根据主成分对城市进行排序。3）用SAS系统PROC UNIVARRIATE 过程计算每个月份的均值、方差、标准差、变异系数、偏度、峰度等数据特征 ，了解城市之间的差异。先根据此表中的数据对全国各分区做聚类分析：聚类分析是研究“物以类聚”的一种科学有效的方法，由实验测试得到的数据是原始数据，原始数据是没有进行分类的、无规律的、错综复杂的变量，要使得这些数据能够反映出一定的规律性或特殊的分类性，需要对数据或变量进行聚类分析，以使数据或变量呈现一定的分门别类的特征。 聚类分析的一般做法是：先确定聚类统计量，然后利用统计量对样品或者变量

34、进行聚类，对n个样品进行聚类的方法称为Q型聚类，常用的统计量称为“距离”；对m个变量进行聚类的方法称为R型聚类，常用个统计量称为“相似系数”。聚类的任务是把所有的实例分配到若干的簇，使得同一个簇的实例聚集在一个簇中心的周围，它们之间距离的比较近；而不同簇实例之间的距离比较远。对于由数值型属性刻画的实例来说，这个距离通常指欧氏距离。聚类分析程序：data shuju;run;proc print data=shuju;run;proc cluster data=shuju method=com nonorm outtree=y1;id diqu;run;proc tree data=y1 spa

35、ce=1 horizontal nclusters=3 out=z1;run;proc print data=z1;run;结果：（最长距离法）以下为数据的标准化：由PROC CLUCTER 过程,聚类过程如下分类结果如下：由聚类结果可知：35个大中型城市聚为了三类。第一类：青岛，贵阳，合肥，兰州，武汉，重庆，上海，广州，石家庄，济南，郑州，沈阳，银川，昆明，西宁。第二类：杭州，宁波，大连，长春，天津，深圳，南京，海口，南宁，太原，厦门，南昌，乌鲁木齐，长沙，哈尔滨。第三类：北京，西安，呼和浩特，成都，福州.再根据此表中的数据对全国各分区做主成分分析： 主成分分析（PrincipalCompo

36、nentAnalysis）是利用降维的思想，将多个变量转化为少数几个综合变量（即主成分），其中每个主成分都是原始变量的线性组合，各主成分之间互不相关，从而这些主成分能够反映始变量的绝大部分信息，且所含的信息互不重叠。主成分分析法代数模型：假设用p个变量来描述研究对象，分别用X1，X2Xp来表示，这p个变量构成的p维随机向量为X=(X1，X2Xp)t。设随机向量X的均值为，协方差矩阵为。对X进行线性变化，考虑原始变量的线性组合：Z1=11X1+12X2+1pXp2=21X1+22X2+2pXpZp=p1X1+p2X2+ppXp主成分是不相关的线性组合Z1，Z2Zp，并且Z1是X1，X2Xp的线性

37、组合中方差最大者，Z2是与Z1不相关的线性组合中方差最大者，Zp是与Z1，Z2Zp-1都不相关的线性组合中方差最大者。主成分分析程序：data a;set work.Shuju;run;proc princomp n=13 cov out=out1;var F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F14;run;proc sort data=out1 out=a1;by prin1;run;proc print data=a1(keep=diqu F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F14 prin1 prin

38、2 );run;结果：由proc princomp的指数之间的相关系数矩阵如图所示（Covariance Matrix）相关矩阵特征值及累计贡献率(Eigenvalues of the Covariance Matrix)由特征值结果可以看出，前3个特征值累计贡献率已达到80.75%。说明前 3个主成分基本包括了全部指标，且前 3个主成分的每个主成分方差贡献率分别为33.25%，28.28%，19.22%。则取前3个特征值，并计算相应的特征矢量。特征矢量的结果如图：由结果可得主成份的表达式，如下：Y1=0.453271F2+0.499109F3+0.372986F4+0.278237F5+0.

39、239497F6+0.149365F7+0.062302F8-0.069859F9-0.106172F10-0.138179F11-0.252940F12-0.253917F13-0.285747F14Y2=0.069654F2+0.185746F3+0.148064F4+0.190808F5+0.206218F6+0.232561F7+0.295616F8+0.384813F9+0.421266F10+0.429614F11+0.319339F12+0.248109F13+0.211348F14Y3=0.363645F2+0.313615F3+0.085343F4-0.126516F5-0.

40、361828F6-0.489873F7-0.403442F8-0.188231F9+0.285873F10+0.223939F11+0.189069F12+0.061973F13+0.074619F14在第一主成分的表达式中，F9-F14项上有负的作用。F2,F3的指数相比较大，故起到相对重要的作用。在第二主成分的表达式中，各项系数均为正数，但是，F10,F11的作用相对较大。按照第一主成分进行排序，结果如下：在第三主成分的表达式中，F5-F9项上有负的作用。按照第一主成分进行排序，排序图如下：然后了解一下每个月份的数据的描述性统计分析：描述性统计分析要对调查总体所有变量的有关数据做统计性描述

41、，主要包括数据的频数分析，数据的集中趋势分析，数据的离散程度分析，数据的分布，以及一些基本的统计图形。数据的数字特征程序：proc univariate data=work.Shuju plot normal;var F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F14;id diqu;run;结果：注释：（N：输入的观测值个数， Mean：变量的平均数，sum observations： 变量所有值的和，Variance： 变量的方差，Std Deviation ：变量的标准差，Skewness： 偏斜度，Kurtosis： 峭度，USS：每一变量原始数据的

42、平方和，CSS：每一变量的离均差平方和，CV：变异系数，Std Error Mean： 每一变量的标准误差。）以下图片显示的是F2（2014年10月）的35个大中型城市的基本数据特征：以下是所画的数据图形，包括茎叶图，盒形图，以及正态概率图。以下图片现实的是F3（2014年9月）的35个大中型城市的基本数据特征：以下是所画的数据图形，包括茎叶图，盒形图，以及正态概率图。以下图片现实的是F4（2014年8月）的35个大中型城市的基本数据特征：以下是所画的数据图形，包括茎叶图，盒形图，以及正态概率图。（其余月份的类似，不再一一列述）结论与建议：在和平稳定的国际和国内形势下，我国近几年来国民经济持续

43、平稳的快速增长。与此同时，在上面的数据中我们可以看出近期居民消费价格水平呈上升趋势，不同地区的上升空间也各相同，这与地区的地理位置以及经济发展水平相关。但是，有些地区的消费价格的一路飙升使得相当部分的居民感觉生活压力明显增加。所以，在一些发展不太快的城市，我们应该采取一些措施来有效的减轻居民负担。比如：有物价部门带头组织听证会，强化价格检测分析，通过价格管制实现社会福利最大化，打断垄断思想等。以民为本使我国继续稳定发展的前提，在注重民生的基础上，我国经济水平会更上一层楼。4.1 application of the Chinese language application for proxy

44、bidding agency application system. 4.2 bidding agent applications should be submitted by the Agency included in the 5th chapter of the content, and than select file asked to provide appropriate documentation. 4.3 proxy application shall affix its official seal coding and page by page in the specifie

45、d location. Agent a copy of the application shall have to number the pages and signed original copy (copy) (including supporting documents), and copy should be exactly the same. 4.4 application there shall be no loose pages. 4.5 agent application should be complete with indelible ink (powdered) prin

46、ts, the agent shall not alter any page of the application. 4.6 bidding agencies offer should be based on the interim measures for the management of tendering agents service charges (meter prices 20021980) rules of the Nineth, tender agent service charges using the difference progressive billing rate

47、. Charges in accordance with the tendering agents service charges and, in conjunction with the provisions of the specific circumstances of the project shall not be floating up and down-floating range must not exceed 20%, otherwise the application cannot pass compliance checks, be invalidated. Due to

48、 bidding agency selection and principal-agent contracts signed during charging base bid amount has not yet been produced, it can only be according to the rates of price, bid and the bid amount determines after the end, controlled response rates calculated shall pay tender fee (tender agency fee accounts for the actual bidding agent item for fares). Than the selected person tendering agents service charge control the upper and lower limits, Cap for the State Development Planning Commission of the interim measures for the management of tenderin