Statistical analysis is divided into two major blocks, the first is to enter the information, the second is to analyze the information based on the information
One, the statistical information, especially at the end of the statistics is very important to summarize the financial information on the one hand, according to the information for the checking of accounts, checking the accounts; On the other hand, in order to analyze business operations (there are perverted small companies will take this information on the performance of employees to examine)
Two, data analysis, through the statistical information, business analysis, through the current month and the past month data comparison, you can clearly know the operating curve, these data on the boss's decision-making has a very significant data support function.
Generally do logistics statistical analysis of the software is Excel (do academic professional with spss) (some professional software, the cost is too high, the general company will not buy), to be able to skillfully use the analysis of the summary of some of the functions or formulas, such as filtering, classification summary, sum, avg, vlookup and other analytical functions of some of the applications. And can be summarized according to the results of the data to produce a simple bar chart or curve.
Which pivot table is very commonly used (open Excel - data - pivot table), I hope these can help LZ!