中文版:请对我提供的Excel数据进行系统的数据分析,并将分析结果整理成一份适合管理层阅读的数据分析表格。

首先理解每个字段的业务含义,然后计算核心指标,包括总量、平均值、增长率、完成率、占比、最大值、最小值、中位数以及必要的同比和环比指标。

进一步分析数据中的趋势、异常值、结构变化和关键影响因素。

请建立以下结构:
1. 原始数据;
2. 数据清洗结果;
3. 核心指标汇总;
4. 分类统计;
5. 趋势分析;
6. 异常数据;
7. 数据透视分析;
8. 核心结论;
9. 建议采取的行动。

对于每个关键指标,请说明计算逻辑和Excel公式。不要只告诉我结果,还要解释这个结果意味着什么。

如果数据不足以支持某个结论,请明确说明,不要过度推断。

英文版:Analyze the Excel data I provide and turn the results into a structured analytical workbook suitable for management review.

First understand the business meaning of each field. Then calculate key metrics such as totals, averages, growth rates, completion rates, proportions, maximums, minimums, medians, year-over-year changes, and month-over-month changes where appropriate.

Identify trends, anomalies, structural changes, and the key factors affecting performance.

Build the workbook around:
1. Raw data;
2. Cleaned data;
3. KPI summary;
4. Category analysis;
5. Trend analysis;
6. Anomaly analysis;
7. Pivot-table analysis;
8. Key insights;
9. Recommended actions.

For every important metric, explain the calculation logic and provide the appropriate Excel formula. Do not only provide numbers; explain what the results mean from a business perspective.

If the available data is insufficient to support a conclusion, clearly state the limitation instead of making unsupported assumptions.

该提示词已在以下工具中验证有效:ChatGPT、Claude、Gemini、Copilot、WPS AI