科研机构专利转化率分析数据
收藏资源简介:
科研机构专利转化分析数据包括国民经济行业分类号、专利申请数量、专利许可实施数量、专利转让数量、专利作价入股数量、专利转化率及专利转化率排名。通过计算分析不同国民经济行业中专利转化率,可以了解科研机构的专利成果在不同国民经济行业中的转化运用情况,有助于科研机构调整专利技术在不同行业中的推广策略,同时也可以为有关政府部门制定政策时提供数据支撑。1、数据收集:从知识产权管理系统中获取国民经济行业分类号、专利申请数量、专利许可实施数量、专利转让数量、专利作价入股数量数据。2、数据处理:通过对收集到的数据进行清洗整理,处理缺失数据和异常值,将数据转换为可分析的格式。3、数据分析:计算专利转化率,专利转化率=(专利许可实施数量+专利转让数量+专利作价入股数量)/专利申请数量*100%, 再通过RANK函数rank(number,ref,[order])对各国民经济行业的专利转化率进行排名,得出不同国民经济行业的专利转化情况,从而帮助科研机构调整专利技术在不同行业中的推广策略。
Patent transformation analysis data for research institutions includes National Economic Industry Classification Codes, number of patent applications, number of patent license implementations, number of patent transfers, number of patents contributed as capital for equity participation, patent conversion rates, and patent conversion rate rankings. By calculating and analyzing the patent conversion rates across different national economic industries, one can understand the transformation and application of patent achievements of research institutions in various sectors, which helps research institutions adjust their promotion strategies for patented technologies across different industries, and also provides data support for relevant government departments when formulating policies. 1. Data Collection: Obtain National Economic Industry Classification Codes, number of patent applications, number of patent license implementations, number of patent transfers, and number of patents contributed as capital for equity participation from the intellectual property management system. 2. Data Processing: Clean and organize the collected data, handle missing data and outliers, and convert the data into an analyzable format. 3. Data Analysis: Calculate the patent conversion rate using the formula: Patent Conversion Rate = (Number of Patent License Implementations + Number of Patent Transfers + Number of Patents Contributed as Capital for Equity Participation) / Number of Patent Applications * 100%. Then use the RANK function RANK(number, ref, [order]) to rank the patent conversion rates of each national economic industry, so as to obtain the patent transformation status of different national economic industries, thereby helping research institutions adjust their promotion strategies for patented technologies across various industries.




