FrequencyTable - Maple Help

Statistics

 FrequencyTable
 compute the frequency table for a data sample

 Calling Sequence FrequencyTable(A, options)

Parameters

 A - options - (optional) equation(s) of the form option=value where option is one of bins, headers, ignore, summarize, tableweights, or weights; specify options for the FrequencyTable function

Options

 The options argument can contain one or more of the options shown below. Some of these options are described in more detail in the Statistics[DescriptiveStatistics] help page.
 • bins : posint; If this option is set, every data range will be subdivided into the given number of equal subintervals. Note that each subinterval except for the last one is considered closed from the left and open from the right; the last subinterval in each range includes both endpoints. The default value of bins is 10 if only one range is given and 1 if multiple ranges are given.
 • headers : truefalse; If this option is set to true, the returned array contains the header information for each of the columns. The default is false.
 • ignore : truefalse; This option controls how missing data is handled by the FrequencyTable command. Missing items are represented by undefined or Float(undefined). So, if ignore=false and A contains missing data, most of the statistics command will yield undefined. If ignore=true all missing items in A will be ignored. The default value is false.
 • summarize : false or embed; Display an embedded summary table. The default is false.
 • tableweights : list(integer); Relative weights for the Table's columns' widths. By default all columns have equal weight.
 • weights : Vector of data weights. The number of elements in the weights array must be equal to the number of elements in the original data sample. By default all elements in A are assigned weight $1$.

Description

 • The FrequencyTable command computes the frequency table for the data set A. This is done by subdividing all data from A into the specified number of ranges of equal size and computing the number of observations falling in each range. The ranges are considered closed from the left and open from the right, the rightmost range is also closed from the right. The FrequencyTable command returns a 5-column Array. The first column contains the ranges. The remaining four columns contain the absolute frequency, the percentage, the cumulative frequency and the cumulative percentage of the data.
 • The first parameter A is the data set - such as a Vector.

Computation

 • All computations involving data are performed in floating-point; therefore, all data provided must have type realcons and all returned solutions are floating-point, even if the problem is specified with exact values.
 • For more information about computation in the Statistics package, see the Statistics[Computation] help page.

Examples

 > $\mathrm{with}\left(\mathrm{Statistics}\right):$
 > $A≔\mathrm{Array}\left(\left[\mathrm{seq}\left(\mathrm{nextprime}\left(i\right),i=100..700\right)\right]\right)$
 ${{\mathrm{_rtable}}}_{{36893628249145659508}}$ (1)
 > $\mathrm{FrequencyTable}\left(A\right)$
 $\left[\begin{array}{ccccc}101.0..161.0& 57.& 9.484193012& 57.& 9.484193012\\ 161.0..221.0& 54.& 8.985024958& 111.& 18.46921797\\ 221.0..281.0& 66.& 10.98169717& 177.& 29.45091514\\ 281.0..341.0& 60.& 9.983361065& 237.& 39.43427621\\ 341.0..401.0& 60.& 9.983361065& 297.& 49.41763727\\ 401.0..461.0& 60.& 9.983361065& 357.& 59.40099834\\ 461.0..521.0& 52.& 8.652246256& 409.& 68.05324459\\ 521.0..581.0& 68.& 11.31447587& 477.& 79.36772047\\ 581.0..641.0& 54.& 8.985024958& 531.& 88.35274542\\ 641.0..701.0& 70.& 11.64725458& 601.& 100.\end{array}\right]$ (2)

Try fewer bins.

 > $\mathrm{FrequencyTable}\left(A,\mathrm{bins}=3,\mathrm{headers}\right)$
 $\left[\begin{array}{ccccc}\mathrm{Range}& \mathrm{Absolute Frequency}& \mathrm{Percentage}& \mathrm{Cumulative Frequency}& \mathrm{Cumulative Percentage}\\ 101.0..301.0& 193.& 32.11314476& 193.& 32.11314476\\ 301.0..501.0& 206.& 34.27620632& 399.& 66.38935108\\ 501.0..701.0& 202.& 33.61064892& 601.& 100.\end{array}\right]$ (3)

Consider a data set with missing values.

 > $B≔\mathrm{Array}\left(\left[\mathrm{seq}\left(i,i=100..300\right),\mathrm{seq}\left(\mathrm{undefined},i=1..100\right)\right]\right)$
 ${{\mathrm{_rtable}}}_{{36893628249048077604}}$ (4)
 > $\mathrm{FrequencyTable}\left(B,\mathrm{bins}=3\right)$
 $\left[\begin{array}{ccccc}100.0..\mathrm{HFloat}{}\left(\mathrm{undefined}\right)& 0.& 0.& 0.& 0.\\ \mathrm{HFloat}{}\left(\mathrm{undefined}\right)..\mathrm{HFloat}{}\left(\mathrm{undefined}\right)& 0.& 0.& 0.& 0.\\ \mathrm{HFloat}{}\left(\mathrm{undefined}\right)..\mathrm{HFloat}{}\left(\mathrm{undefined}\right)& 0.& 0.& 0.& 0.\end{array}\right]$ (5)
 > $\mathrm{FrequencyTable}\left(B,\mathrm{ignore}=\mathrm{true}\right)$
 $\left[\begin{array}{ccccc}100.0..120.0& 20.& 9.950248756& 20.& 9.950248756\\ 120.0..140.0& 20.& 9.950248756& 40.& 19.90049751\\ 140.0..160.0& 20.& 9.950248756& 60.& 29.85074627\\ 160.0..180.0& 20.& 9.950248756& 80.& 39.80099502\\ 180.0..200.0& 20.& 9.950248756& 100.& 49.75124378\\ 200.0..220.0& 20.& 9.950248756& 120.& 59.70149254\\ 220.0..240.0& 20.& 9.950248756& 140.& 69.65174129\\ 240.0..260.0& 20.& 9.950248756& 160.& 79.60199005\\ 260.0..280.0& 20.& 9.950248756& 180.& 89.55223881\\ 280.0..300.0& 21.& 10.44776119& 201.& 100.\end{array}\right]$ (6)

Try weighted data.

 > $C≔\mathrm{Array}\left(\left[\mathrm{seq}\left(i,i=20..30\right)\right]\right)$
 $\left[\begin{array}{rrrrrrrrrrr}20& 21& 22& 23& 24& 25& 26& 27& 28& 29& 30\end{array}\right]$ (7)
 > $W≔\mathrm{Array}\left(\left[10,20,30,40,50,60,70,80,90,100,110\right]\right)$
 $\left[\begin{array}{rrrrrrrrrrr}10& 20& 30& 40& 50& 60& 70& 80& 90& 100& 110\end{array}\right]$ (8)

The summarize option makes it possible to display an embedded table containing the results. Note that the embedded table is only for display and that the returned value of the FrequencyTable command is unchanged.

 > $\mathrm{FrequencyTable}\left(C,\mathrm{weights}=W,\mathrm{headers},\mathrm{summarize}=\mathrm{embed}\right):$

 $\mathrm{Range}$ $\mathrm{Absolute Frequency}$ $\mathrm{Percentage}$ $\mathrm{Cumulative Frequency}$ $\mathrm{Cumulative Percentage}$ $20...21.$ $10.$ $1.51515151515151514$ $10.$ $1.51515151515151514$ $21...22.$ $20.$ $3.03030303030303028$ $30.$ $4.54545454545454586$ $22...23.$ $30.$ $4.54545454545454586$ $60.$ $9.09090909090909172$ $23...24.$ $40.$ $6.06060606060606055$ $100.$ $15.1515151515151523$ $24...25.$ $50.$ $7.57575757575757613$ $150.$ $22.7272727272727266$ $25...26.$ $60.$ $9.09090909090909172$ $210.$ $31.8181818181818166$ $26...27.$ $70.$ $10.6060606060606055$ $280.$ $42.4242424242424221$ $27...28.$ $80.$ $12.1212121212121211$ $360.$ $54.5454545454545396$ $28...29.$ $90.$ $13.6363636363636349$ $450.$ $68.1818181818181728$ $29...30.$ $210.$ $31.8181818181818166$ $660.$ $100.$

 > $\mathrm{FrequencyTable}\left(C,\mathrm{weights}=W\right)$
 $\left[\begin{array}{ccccc}20.0..21.0& 10.0& 1.5151515151515151& 10.0& 1.5151515151515151\\ 21.0..22.0& 20.0& 3.0303030303030303& 30.0& 4.545454545454546\\ 22.0..23.0& 30.0& 4.545454545454546& 60.0& 9.090909090909092\\ 23.0..24.0& 40.0& 6.0606060606060606& 100.0& 15.151515151515152\\ 24.0..25.0& 50.0& 7.575757575757576& 150.0& 22.727272727272727\\ 25.0..26.0& 60.0& 9.090909090909092& 210.0& 31.818181818181817\\ 26.0..27.0& 70.0& 10.606060606060606& 280.0& 42.42424242424242\\ 27.0..28.0& 80.0& 12.121212121212121& 360.0& 54.54545454545454\\ 28.0..29.0& 90.0& 13.636363636363635& 450.0& 68.18181818181817\\ 29.0..30.0& 210.0& 31.818181818181817& 660.0& 100.0\end{array}\right]$ (9)

The tableweights option controls the width of columns in an embedded table.

 > $\mathrm{interface}\left(\mathrm{displayprecision}=4\right):$
 > $\mathrm{FrequencyTable}\left(C,\mathrm{weights}=W,\mathrm{headers},\mathrm{summarize}=\mathrm{embed},\mathrm{tableweights}=\left[4,2,2,2,2\right]\right):$

 $\mathrm{Range}$ $\mathrm{Absolute Frequency}$ $\mathrm{Percentage}$ $\mathrm{Cumulative Frequency}$ $\mathrm{Cumulative Percentage}$ $20.0000..21.0000$ $10.0000$ $1.5152$ $10.0000$ $1.5152$ $21.0000..22.0000$ $20.0000$ $3.0303$ $30.0000$ $4.5455$ $22.0000..23.0000$ $30.0000$ $4.5455$ $60.0000$ $9.0909$ $23.0000..24.0000$ $40.0000$ $6.0606$ $100.0000$ $15.1515$ $24.0000..25.0000$ $50.0000$ $7.5758$ $150.0000$ $22.7273$ $25.0000..26.0000$ $60.0000$ $9.0909$ $210.0000$ $31.8182$ $26.0000..27.0000$ $70.0000$ $10.6061$ $280.0000$ $42.4242$ $27.0000..28.0000$ $80.0000$ $12.1212$ $360.0000$ $54.5455$ $28.0000..29.0000$ $90.0000$ $13.6364$ $450.0000$ $68.1818$ $29.0000..30.0000$ $210.0000$ $31.8182$ $660.0000$ $100.0000$

References

 Stuart, Alan, and Ord, Keith. Kendall's Advanced Theory of Statistics. 6th ed. London: Edward Arnold, 1998. Vol. 1: Distribution Theory.

Compatibility

 • The headers option was introduced in Maple 2015.
 • For more information on Maple 2015 changes, see Updates in Maple 2015.
 • The summarize option was introduced in Maple 2016.
 • For more information on Maple 2016 changes, see Updates in Maple 2016.
 • The Statistics[FrequencyTable] command was updated in Maple 2019.
 • The tableweights option was introduced in Maple 2019.
 • For more information on Maple 2019 changes, see Updates in Maple 2019.