An engineer wants to study the relationship between a specific machine setting and the amount of energy that the machine consumes, in order to determine an efficient operating setting. The engineer collects data on the machine setting and the energy consumption during the manufacturing process.

The engineer ranks the energy consumption measurements to determine which machine setting consumes the least amount of energy.

  1. Open the sample data, MachineSettings.MTW.
  2. Choose Data > Rank.
  3. In Rank data in, enter Energy Consumption.
  4. In Store ranks in, type Ranks.
  5. Click OK.

Results

The ranks are in column C3. A machine setting of 21.70 has the lowest energy consumption because the rank is 1.0.

C1 C2 C3
Energy Consumption Machine Setting Ranks
21.60 11.15 14.0
12.50 13.30 12.0
8.91 14.20 11.0
4.00 15.70 7.0
1.80 18.90 4.0
1.00 19.40 2.5
1.00 21.40 2.5
0.80 21.70 1.0
2.35 23.50 5.0
... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy