You may need to calculate the mode occurrence number of the consumption amount to evaluate the sales of a product. In the following figure, for example, users who spend $1,000 are the most, with a total of six consumption records. So 1,000 is the mode of the Amount column.
1. Calculate the number of records with the same amount. Group the sample data by Amount and calculate the distinct count result of the User column.
2. Sort the number of records in descending order to obtain the mode.
Sample data: Calculating the Mode.xlsx
Create an analysis subject and upload the sample data Calculating the Mode with all fields selected by default.
Group Summary
Click Group Summary, drag Amount (summary method: Group Records with Same Value) into Group, and drag User (summary method: Distinct Count) into Total to calculate the occurrence number of each value of Amount.
The following table introduces the settings of Group Summary.
User (Distinct Count)
Sorting
Sort the User column in descending order, and the amount corresponding to the highest number of records is the mode.
1. Click Sort, click Add Sorting Indicator, select User as the object to be sorted, and Descend as the sorting method. By doing so, the occurrence number of each amount is sorted in descending order.
2. Rename the analysis subject as Calculating the Mode and click Save and Update.
3. Close the analysis subject and click Update Data to view the result.
See section "Preview".
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy