Return to site

In numbers for mac create subtotals for each group of identical entries in a column

broken image
broken image

Even simple operations with a spreadsheet require some understanding of what constitutes ‘good’ data.Īs an example, let’s ‘deconstruct’ some information:

broken image

Processing data in some way provides context and hence meaning - when it may be referred to as ‘information’. As well as performing calculations, we can manipulate and interrogate data in other ways, such as sorting and filtering.Ī quick web search will render several definitions of ‘data’, the common theme being that they are values without context. Although originally designed for numeric data, spreadsheets are a powerful tool for working with broader sets of data that include text values.