histogram
Is there any reasonable documentation on how to use the INDEX and FREQUENCY functions for the purpose of creating a histogram? =INDEX(FREQUENCY(Data :: A, A), ROW()-1) is pretty cryptic.
HI Matt,
Apple has a basic Numbers User Guide here: Numbers User Guide for Mac - Apple Support
Other learning sources are found in Numbers itself.
Many of the templates included in the Template chooser can provide information and eexamples of how to accomplish tasks in Numbers.
The Function Browser, accessible by selecting a cell then typing =, to open the browser (and the Formula Editor at that cell).
The Function Browser lists all the functions supported in your version of Numbers, with syntax, a description, and at least one example for each.
The function list is alphabetical, but you can filter by category by clicking the category names in the pane, or search progressively by typing a few letters in the search box, then selecting the function from the shortened list fitting that series of letters.
You can place a function from the browser to the selected cell with a double click.The transfer includes syntax and suggestion lozenges for each element of the formula, Those lozenges are also supplied if you start a formula entry in the Formula Editor, then click on the function name when t appears in the 'short list' provided as you type the name.
Regarding the double colon: This is a separator between the Sheetname and the Tablename or between the Tablename and the cell address in a cell (or range) reference. A full cell reference address includes the address of the cell or range, preceded by the name of the table containing the cell or range, preceded by the name of the Sheet containing the table.
If the cell or range being referenced is on the same table as the formula containing the reference, only the cell or range address is needed:
SUM(A)
or
MAX(A5:C14)
If the cell or range being referenced is on a different table from that containing the formula making the reference, then:
if the table containing the referenced cell or range hasa a name distinct from any other table in the document, only then only the name of that table must precede the address of the cell or range:
SUM(Data::A)
or
MAX(Data::A5:C14)
If the name of the table containing the cell or range s also thr name of any other table in the document, both the name of the sheet containing the table and the name of the table (n that order) must precede the cell or range address:
SUM(Sheet 2::Table 1::A)
or
MAX(Sheet 2::Table 1::A5:C14)
If the full (Sheetname::Tablename::cell address) address string is entered, but not needed by Numbers, the unneeded parts will be automatically deleted.
Regards,
Barry