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 Tutorialcolumn!
The above is the detailed content of Excel data analysis methods. For more information, please follow other related articles on the PHP Chinese website!