Microsoft Office Tutorials and References
In Depth Information
Using the Rank And Percentile tool
Note
If you select the Labels In First Row option but do not actually include the
cell containing the label in your input range, the first value in the input
range becomes the title. For example, if the input range in Figure 17-12 were
$D$2:$D$1001, the resulting label in column G would be 936 instead of Total.
In Figure 17-12, we analyzed a single column of data, but we could analyze the
Verbal, Math, and Total columns together. In that case, we would specify the input range
B1:D1001, and the tool would generate 12 columns of output, four for each input
column.
You can also have the output table placed on a new worksheet or workbook, which is
a good idea if you select multiple columns of input data that would result in a large
output table.
Correlating tables
The input and output tables shown at the bottom of Figure 17-12 share a common
column of data—the Total column—and the same number of rows. But because the
two tables are sorted differently, the rows don’t match. The easiest solution is to sort
the output table by the Point column; in this context, Point indicates the position of the
corresponding data point in the input range. Therefore, sorting the output table by the
Point column puts it in the same order as the input table:
If you want to add information from the output table to the existing input table, you
can delete the Point column (because the Point column simply indicates the row
number), the Total column (because the input table already has a Total column), and the
blank column in the output table, creating a single, correlated table.
Search JabSto ::




Custom Search