Calculating the Mode

Preview

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.

Implementation Method

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

Creating an Analysis Subject

Create an analysis subject and upload the sample data Calculating the Mode with all fields selected by default.

Editing Data

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.

Group	Amount (Group Records with Same Value)
Total	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".