气动卷钉枪中国销售分析数据
收藏资源简介：
统计分析气动卷钉枪中国销售数据，通过对气动卷钉枪销售的各型号产品评价，为公司调整中国市场气动卷钉枪销售策略提供数据支持。1.数据采集：通过管理软件导出EXCEL表格销售数据。2.数据处理：(1)相同产品销售总额，是通过SUMIFS函数对相同型号产品销售额求和，例如本条产品型号为“CN65 TTI”，相同产品销售总额为数据统计范围内产品型号为“CN65 TTI”的销售额总和；(2)总销售额通过SUM函数将数据统计范围内销售额求和；(3)相同产品销售总额占总销售额的占比=相同产品销售总额/总销售额*100；(4)相同产品销售总额占总销售额的占比排名按相同产品销售总额占总销售额的占比从大到小进行排名；(5)累计占比为相同产品销售总额占总销售额的占比排名为的1至本条(包含本条)的相同产品销售总额占总销售额的占比之和，例如本条相同产品销售总额占总销售额的占比排名为2，即累计占比=排名为1的相同产品销售总额占总销售额的占比+排名为2的相同产品销售总额占总销售额的占比；(6)产品分类运用了ABC分类法，对如累计占比80以下的，则给予“A类产品”的评价，如累计占比80到90区间的，则给予“B类产品”的评价，如累计占比在90到100区间的，则给予“C类产品”的评价。
This dataset conducts statistical analysis on the sales data of pneumatic coil nailers in the Chinese market, and provides data support for the company to adjust its sales strategy of pneumatic coil nailers in the Chinese market by evaluating the sales performance of each product model. 1. Data Collection: Export sales data in Excel format via the management software. 2. Data Processing: (1) Total sales of the same product: Sum the sales amounts of products with identical models using the SUMIFS function. For example, if the product model is "CN65 TTI", the total sales of the same product refer to the total sales of all products with the model "CN65 TTI" within the statistical scope. (2) Total sales: Sum all sales amounts within the statistical scope using the SUM function. (3) Proportion of total sales of the same product: Calculated as (Total sales of the same product / Total sales) * 100. (4) Ranking of sales proportion: Sort the proportions of total sales of the same product in descending order and assign corresponding ranks. (5) Cumulative proportion: The sum of the proportions of total sales of the same product from rank 1 to the current rank (inclusive). For example, if the current rank is 2, the cumulative proportion = proportion of rank 1 + proportion of rank 2. (6) Product classification adopts the ABC classification method: Products with a cumulative proportion below 80% are classified as "Category A products", those with a cumulative proportion ranging from 80% to 90% are classified as "Category B products", and those with a cumulative proportion ranging from 90% to 100% are classified as "Category C products".
