Excel-Time Sequence Diagram (trend) Analysis

This article is excerpted from the author "website data analysis: data-driven website management, optimization and operation": item.jd.com112920.0.html time sequence diagram is a statistical tool that describes the trend and regularity of Flow Characteristic Values that change and fluctuate over a period of time, for example, the scope of the entire process, whether there is a period or time point with great fluctuations, etc. Through

This article is from the author "website data analysis: data-driven website management, optimization and operation": http://item.jd.com/11295690.html time sequence diagram is a statistical tool to describe the trend and law of flow characteristic value changes within a period of time, for example, the scope of the entire process, whether there is a period or time point with great fluctuations, etc. Through

From the author's website data analysis: data-driven website management, optimization and operation: http://item.jd.com/11295690.html

A time sequence diagram is a statistical tool that describes the trend and regularity of changes and fluctuations in the process characteristics within a period of time, for example, the scope of the entire process, whether there is a period or time point with great fluctuations, etc.

By analyzing the trend, you can also predict future data changes. Through the analysis of the fluctuation, we can find the deviation in the process and identify the deviation caused by the common or special reasons. If it is caused by a special reason, we should analyze the cause of the problem immediately, make improvements accordingly.

To draw a time sequence diagram, you must first determine the process feature values to be analyzed, and then collect enough sample data in chronological order, otherwise, it is difficult to reflect the fluctuating trend and regularity of the feature value if the data is too small. The time unit can be days, hours, or minutes. For the process of deviation, re-draw the time sequence diagram after improvement to check whether the deviation has vanished. Otherwise, continuous improvement is required.

In Excel, you can use line charts to draw time sequence diagrams. For example, Figure 9-58 shows the sales status of a product on the website for one month. Select the B1: B32 region and click the line chart in the "chart" module of the "insert" functional area ", select the "data-marked line chart" button in the two-dimensional line chart section to view the drawn time sequence diagram, as shown in 9-59.

Figure 9-58 sales data

Figure 9-59 time sequence diagram

You can add the category axis and data axis title to beautify the chart. For more information, see section 9.5.2. The final beautification result is 9-60.

Figure 9-60 time sequence diagram after beautification

By analyzing the time sequence diagram, we can find that the sales volume is high in the middle of the year, and the sales volume in other periods is between 1.5 and ~ Fluctuation between RMB 35 thousand, mainly concentrated in 2 ~ In the range of 30 thousand.