中国出口非洲国家入门级电动步行式仓储叉车产品订货量数据

通过中国工程机械工业协会工业车辆分会每月公布的基本数据，分析非洲各个国家对入门级电动步行式仓储叉车的需求，计算每个国家的全年订货总量、平均每月订货量、订货波动率和订货等级，为国内生产该产品并有意出口非洲市场的公司提供数据支撑，助力该类公司更好的进行非洲市场开拓，提升出口成功率。1.数据采集：通过中国工程机械工业协会工业车辆分会每月公布的基本数据进行采集。 2.数据处理：对基础数据进行分类和处理，计算出非洲各国入门级电动步行式仓储叉车产品全年订货总量，平均每月订货量，订货波动率，并对该国根据自己设定的标准赋予该国订货等级。 3.算法加工：根据公式φ=STDEV.S/AVERAGE计算，φ为订货波动率，STDEV.S该国1-12月每月订货量的标准偏差，STDEV.S= √[∑(Xn -AVERAGE)^2/11] ，Xn为每月订货量，AVERAGE为该国1-12月平均每月订货量，从而计算出订货波动率。当φ≤50%时，该国为订货强稳定型国家；当50%＜φ≤100%时，该国为订货一般稳定型国家；当φ＞100%时，该国为订货不稳定型国家。对年订货总量0-240台，241-480台，481-1200台，1201-2400台和2401台及以上的国家订货等级分别赋予E,D,C,B,A等。对于等级越高订货波动率越小说明该国对国内该类产品需求越旺盛，进行非洲市场开拓时成功率越高。

This dataset analyzes the demand for entry-level electric walk-behind warehouse forklifts across African countries using monthly publicly available basic data released by the Industrial Vehicle Branch of China Construction Machinery Industry Association. It calculates the annual total order volume, average monthly order volume, order volatility and order rating for each country, providing data support for domestic enterprises that produce this product and intend to export to the African market, to help such enterprises better expand their African market and improve export success rates.

1. Data Collection: Data is collected from the monthly published basic data of the Industrial Vehicle Branch of China Construction Machinery Industry Association.

2. Data Processing: Classify and process the basic data to calculate the annual total order volume, average monthly order volume and order volatility of entry-level electric walk-behind warehouse forklifts for each African country, and assign an order rating to each country based on a self-developed standard.

3. Algorithm Calculation: The order volatility φ is calculated using the formula φ = STDEV.S / AVERAGE, where STDEV.S is the sample standard deviation of the monthly order volumes from January to December of the target country, and STDEV.S = √[∑(Xn - AVERAGE)² / 11]. Here, Xn represents the monthly order volume, and AVERAGE represents the average monthly order volume of the country over January to December.
Countries are categorized into three stability types based on the value of φ: strong order stability type when φ ≤ 50%; general order stability type when 50% < φ ≤ 100%; and unstable order type when φ > 100%. For countries with annual total order volumes of 0–240 units, 241–480 units, 481–1200 units, 1201–2400 units and 2401 units and above, the corresponding order ratings are assigned as E, D, C, B and A respectively.
A higher order rating indicates a more vigorous demand for this product in the country and a higher success rate for expanding into the African market.

搜集汇总

背景与挑战

背景概述

该数据集记录了中国出口非洲国家入门级电动步行式仓储叉车产品的订货量数据，包含非洲各国的全年订货总量、平均每月订货量、订货波动率和订货等级等信息，旨在为国内企业开拓非洲市场提供数据支持。数据集每月更新，共709条记录，通过算法计算订货波动率和等级，帮助企业评估市场需求和稳定性。