Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about how to carry out Excel charts and data analysis. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

From the perspective of theoretical guidance, data analysis can be divided into statistics-based and data mining-based data analysis methods. Obviously, data analysis based on statistics is relatively easy to understand, while data mining has higher requirements for higher mathematics. I believe that students who have graduated for more than ten years are likely to forget A*X**2+B*X+C=0, and I am not even sure if a child can teach him math when he is in junior high school.

From the starting point of analysis, data analysis can be divided into business-driven and pure mathematics-driven data analysis, business-driven is based on the understanding of the business, some empirical color, in most cases is to verify their own ideas, or more convenient to identify business problems and performance Based on pure mathematical drivers, it is basically through some mining algorithms to find out the rules between numbers, and then translate this law into business, which is very feasible in theory, but there are few successful cases in practical work. In most cases, the two are combined, that is, the input and output of data are defined by slapping the head, while the mining algorithm is just to prove how smart their decisions are.

From the output of the analysis, data analysis can be presented in the form of charts, words, tables, business derivation processes or a series of advanced mathematical formulas. Obviously, charts are the most impressive, tables are the second, text effects are the worst, and finally, there are processes or formulas that no one can understand; the advantages of Excel are precisely tables and charts.

In terms of analysis tools, including the entry-level Excel, the recently popular R language, the professional statistical software tool SPSS, and the most powerful SAS, it is obvious that most people only know Excel, but Excel also has a lot of its own data analysis libraries, and the power of Excel's app store can not be underestimated, so it is hard to say whether it will be able to compete with professional statistical software data mining tools in the future. And one of the great advantages of Excel is its huge customer base.

From a chart point of view, Excel cannot compare with those professional BI tools, and from a statistical point of view, Excel cannot compare with those professional statistical software. But the function provided by Excel for us non-professionals is enough, through the perspective table to do some multi-dimensional analysis, through the app store to find some cool charts, through the plug-in to do some simple data analysis, through VBA and tireless debugging can also do some "professional" charts, this is also our goal.

Excel provides chart types including column chart, line chart, pie chart, bar chart, area chart, XY (scatter chart), stock price chart, surface chart, radar chart, combination, in fact, the most commonly used are column chart, line chart, pie chart, bar chart, combination chart; more commonly used are area chart, radar chart and XY (scatter chart); basically do not use stock price chart, surface chart.

The experts on the Internet have said enough about the choice of chart types, and it is suspected of cobbling words here, but it should be emphasized that whether the choice of chart types is wise or not is closely related to your understanding of business data and your analysis ideas. if you choose an inappropriate chart, it means that you are not ready for data analysis.

Finally, the basic types of the two charts and the selected Chinese and English versions are attached.

The above is the editor for you to share how to carry out Excel charts and data analysis, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.