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. Open the Rank dialog box.
    • Mac: Data > Rank
    • PC: DATA > Rank
  3. In Rank the data in, enter Energy Consumption.
  4. Click OK.

Results

The ranks are in a column of the worksheet. A machine setting of 21.70 has the lowest energy consumption.

C1 C2 C3
Energy Consumption Machine Setting Ranks of Energy Consumption
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