Data Processing with LibreOffice Calc

7 October 2023 - 13:45  WIB 

Parallel Class Session 2Room 1G114

Akhmad Sofwan

LibreOfficeEnglish*

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.

LOUCA23 Organizer & Sponsor

Thanks to all sponsor and contributor of LOUCA23.

Organizer

Platinum Sponsors

Silver Sponsors

Bronze Sponsors

Partners

Reach Us

Contact Organizer

Have questions or suggestions about LOUCA23, send your questions or ideas to the organizers.

Find Our Socials

Contact Form