How does Excel perform frequency distribution statistics
Tools/raw Materials
Raw statistical data
Excel
Method/Step
We use statistical access to a website resources of the first-line city visits as an example to illustrate.
First, the basic data source is placed, which is generally obtained directly from the original data. The IP address is masked in the figure.
Second, because the original data will be statistical sample data to be cleaned, thus to the data source we want to statistics. It should be noted here that Internet data often has unformatted unordered data. This time, pay more attention to the data cleaning operation. In this case, the source of access (overseas/Hefei) for non-tier cities is filtered through Excel's own filtering capabilities. In this regard, in the research industry, according to the different statistical rules, Chengdu will generally be listed as a first-tier city.
Third, put the city list in the corresponding statistical results cell, as the final output. Note here that you must select the Select No Duplicate records check box.