Generates descriptive statistics for data in the input range.
If this function is not available, you must install the Analysis ToolPak add-in.
Syntax
DESCR(inprng, outrng, grouped, labels, summary, ds_large, ds_small, confid)
DESCR?(inprng, outrng, grouped, labels, summary, ds_large, ds_small, confid)
Inprng is the input range.
Outrng is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.
Grouped is a text character that indicates whether the data in the input range is organized by row or column.
If grouped is "C" or omitted, then the data is organized by column.
If grouped is "R" then the data is organized by row.
Labels is a logical value that describes where the labels are located in the input range, as shown in the following table:
| Labels | Grouped | Labels are in |
| TRUE | "C" | First row of the input range. |
| TRUE | "R" | First column of the input range. |
| FALSE or omitted | (ignored) | No labels. All cells in the input range are data. |
Summary is a logical value. If TRUE, DESCR reports the summary statistics. If FALSE or omitted, no summary statistics are reported.
Ds_large is an integer k. If ds_large is present, DESCR reports the k-th largest data point. If ds_large is omitted, the value is not reported.
Ds_small is an integer k. If ds_small is present, DESCR reports the k-th smallest data point. If ds_small is omitted, the value is not reported.
Confid is the confidence level of the mean. If confid is given, DESCR reports the confidence interval for the input range. If confid is omitted, the confidence interval is 95%.
Return to index