西藏自治区惠普打印机销售分析数据

分析惠普打印机在西藏自治区的销售情况，具体包括分类（激光、喷墨）、分型（普通、二合一、三合一和四合一）占比，筛选出各类、型的优势产品，帮助打印机销售企业制定、优化营销、仓储、物流和供应链方案。①整理数据，删除老旧分类型号； ②通过“数量”，计算“惠普打印机销售总量a”； ③筛选“商品名称”中带“激光”字段，通过“数量”，计算“惠普各激光打印机销售总量b”，惠普各激光打印机销售占比M=b÷a×100％； ④同理，计算c，N； ⑤比较M和N，较大的对应类别为优势产品； ⑥筛选“商品名称”中“惠普激光打印机”，通过“数量”，计算“惠普各普通打印机销售总量d”，惠普各普通打印机销售占比W=d÷a×100％； ⑦“商品名称”中无“二合一打印机”相关字段，故“惠普各二合一打印机销售总量e”为0，“惠普各二合一打印机销售占比X”为0％； ⑧筛选“商品名称”中带“三合一”字段，通过“数量”，计算“惠普各三合一销售总量f”，惠普各三合一打印机销售占比Y=f÷a×100％； ⑨同理，计算g，Z； ⑩比较X、Y和Z，最大的对应类别为优势产品。 说明：①普通打印机仅有打印功能，二合一增加复印功能，三合一增加扫描功能，四合一增加传真功能。 ②M、N、X、Y和Z，均精确到小数点后2位。

This dataset aims to analyze the sales status of HP printers in the Tibet Autonomous Region, specifically covering sales proportions by category (laser, inkjet) and by type (basic, 2-in-1, 3-in-1, 4-in-1), and screen out advantaged products for each category and type, so as to assist printer sales enterprises in formulating and optimizing marketing, warehousing, logistics and supply chain solutions.
1. Sort out the data and eliminate outdated categorized models.
2. Calculate the total sales volume of all HP printers (denoted as a) based on the "quantity" field.
3. Filter entries where the "product name" contains the keyword "laser", then calculate the total sales volume of HP laser printers (denoted as b) based on the "quantity" field, and the sales proportion of HP laser printers M = (b / a) × 100%.
4. Similarly, calculate the total sales volume of HP inkjet printers (denoted as c) and its sales proportion N.
5. Compare M and N, and the category corresponding to the larger value is the advantaged product.
6. Filter entries where the "product name" exactly matches "HP Laser Printer", then calculate the total sales volume of HP basic printers (denoted as d) based on the "quantity" field, and the sales proportion of HP basic printers W = (d / a) × 100%.
7. There are no entries related to "2-in-1 printers" in the "product name" field, so the total sales volume of HP 2-in-1 printers (denoted as e) is 0, and its sales proportion X is 0%.
8. Filter entries where the "product name" contains the keyword "3-in-1", then calculate the total sales volume of HP 3-in-1 printers (denoted as f) based on the "quantity" field, and the sales proportion of HP 3-in-1 printers Y = (f / a) × 100%.
9. Similarly, calculate the total sales volume of HP 4-in-1 printers (denoted as g) and its sales proportion Z.
10. Compare X, Y and Z, and the type corresponding to the maximum value is the advantaged product.

Additional Notes:
1. Basic printers only have printing functions; 2-in-1 printers add copying functions, 3-in-1 printers add scanning functions, and 4-in-1 printers add fax functions.
2. All values of M, N, X, Y and Z are rounded to 2 decimal places.

搜集汇总

数据集介绍

特点

该数据集记录了西藏自治区惠普打印机的销售情况，包含556条数据，按需更新。数据详细展示了不同类型惠普打印机的销售总量和占比，并筛选出优势产品，旨在帮助企业优化营销和供应链策略。