Data Processing with LibreOffice Calc

Session Details

Data is available widely nowadays and need to be processed well to generate useful information.
Numeric is one of data type which describe an object numerically but often we need Statistics methods to have some useful information such as minimum, maximum, average and variance of data.
In this talk, I would like to share about LibreOffice writer, data types, and Data Processing methods using Libreoffice calc including Descriptive Statistics. Besides implementing statistical methods using LibreOffice Calc, I would like to explain how the every single method work so the attendees understand the data besides able to practise the methods.
I would like to explain and implement techniques and methods as follows :

• Creating table of data

  • The result table contains data ready to be processed

• Explain and implement some methods in Descriptive Statistics using LibreOffice Calc, they are :

  • Min
  • Max
  • Average
  • Variance
  • Standard Deviation
  • Median
  • Modes
  • Quartile

• Explain and implement some data processing methods, they are :

  • if
  • count if
  • sumif
  • vlookup
  • hlookup

By using those methods, hopefully we get the insightful and information from data we have.