1,940
edits
Changes
Jump to navigation
Jump to search
mLine 64:
Line 64: + +
TE year2sourcebook/year2 unit1 Topics of Study in the Unit (view source)
Revision as of 12:17, 9 May 2017
, 12:17, 9 May 2017→Conducting a research study - using spreadsheets to capture, process, analyse data - present analysed information in text and graphical formats
This can be analysed using the '[https://dwmallisk.blogspot.in/2015/01/using-libreoffice-calc-to-create-pivot.html Pivot Table]' advanced feature of the spreadsheet, to derive multi-variate tables. If the Pivot table seems too complex to use, simple formulae for 'sum', 'count' can be used in the sheet to calculate the sum of amount fields and count of amount or text fields in the data. You can also generate graphs and charts of the data using Calc.
This can be analysed using the '[https://dwmallisk.blogspot.in/2015/01/using-libreoffice-calc-to-create-pivot.html Pivot Table]' advanced feature of the spreadsheet, to derive multi-variate tables. If the Pivot table seems too complex to use, simple formulae for 'sum', 'count' can be used in the sheet to calculate the sum of amount fields and count of amount or text fields in the data. You can also generate graphs and charts of the data using Calc.
The data in the sheet can also be 'sorted' on any column in ascending of descending order, to allow a easy and quick view of the data as per the priority of analyses. For instance if the data has a column on 'age' and you want to see the younger respondents firsts, you could sort the data sheet based on age (ascending) to get this.
(images xxx-
(images xxx-