Excel data analysis methods

Some common analysis methods in the excel data analysis stage

Commonly used analysis methods

Situation analysis (Comparison)

Comparative analysis method

Complete values ​​and goals are worthy of comparison, comparison in the time dimension, comparison of various departments of the same company, and industry competitors For comparison, pay attention to the consistent calculation methods, consistent objects, and consistent indicator types

Comprehensive evaluation analysis method

The basic idea is to transform multiple indicators into one that can reflect comprehensive To analyze and evaluate the situation, such as the economic strength of different countries, regional social development levels, economic benefit evaluation of enterprises, etc., there are five main steps

#step1 Determine the comprehensive evaluation indicator system, that is, what indicators are included (Field) is the basis and basis for comprehensive evaluation step2 Collect data and standardize different measurement units (fields)

#step3 Determine the weight of each indicator in the indicator system to ensure scientific evaluation

#step4 Summarize the processed indicators to calculate the comprehensive evaluation index or comprehensive evaluation score

step5 Sort the parameter units according to the evaluation index or score, and use This is the conclusion

Cause analysis

Structural analysis method

Calculation formula of structural relative index (proportion)
Structural relative index (proportion) = (value of a certain part of the overall/overall total)*100%

DuPont analysis method

Use the relationship between the major ratios Internally linked, establish a comprehensive model of financial ratio analysis to comprehensively analyze and evaluate the company's financial status and operating performance. The conversion rate and churn rate in the website also reveal the popularity of various businesses on the website

Matrix correlation analysis method

The commonly used systematic comprehensive evaluation method, It mainly uses matrix form to express the relationship between the evaluation indicators and their importance of each alternative plan and the value evaluation amount of the specific indicators of the plan.

For more Excel-related technical articles, please visitExcel Learn in the Basic Tutorial column!

The above is the detailed content of Excel data analysis methods. For more information, please follow other related articles on the PHP Chinese website!