BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//events.documentfoundation.org//libreoffice-conference-20
 26//speaker//NB9ESP
BEGIN:VEVENT
UID:pretalx-libreoffice-conference-2026-DVBSJC@events.documentfoundation.or
 g
DTSTART:20260910T170000Z
DTEND:20260910T173000Z
DESCRIPTION:Some time ago\, I worked with a dataset containing textual data
 . At that time\, I performed entropy calculations using Microsoft Excel. I
 n this study\, however\, I aim to explore the use of LibreOffice Calc for 
 data processing. Using the same dataset\, I conducted sentiment labeling\,
  topic relevance analysis\, and entropy calculations for each column. The 
 entropy calculation was performed to determine the weight value of each wo
 rd.\nThe first step was to identify the number of unique words appearing i
 n the dataset. After collecting all unique words\, the next step was to ca
 lculate the frequency of each word. Once the frequency values had been obt
 ained\, the subsequent step was to calculate the probability of occurrence
  for each word. An example of this process is presented below:\nUnique Wor
 d	Frequency	Probability\nTrain	2	2/4 = 0.50\nFire	1	1/4 = 0.25\nBekasi	1	1
 /4 = 0.25\n\nIn LibreOffice Calc\, the formula used to calculate the entro
 py contribution of a probability value is:\n=-(0.5*LN(0.5)/LN(2))\nThe res
 ult of this calculation is 0.5. This serves as an example of entropy calcu
 lation based on a probability value. In information theory\, entropy is us
 ed to measure the amount of uncertainty or information contained in a data
 set. The same calculation can be applied to other probability values\, and
  the resulting entropy contributions can then be summed to obtain the tota
 l entropy of the dataset.\nIn addition\, I calculated the probabilities of
  sentiment categories that had previously been grouped into three classes:
  positive\, negative\, and neutral. The first step was to determine the nu
 mber of instances belonging to each sentiment category. To perform this ca
 lculation in LibreOffice Calc\, I used the following formulas:\n=COUNTIF(A
 :A\,"positive")\n=COUNTIF(A:A\,"negative")\n=COUNTIF(A:A\,"neutral")\nThes
 e formulas count the occurrences of each sentiment label within the datase
 t. The resulting counts are then used to calculate the probability of each
  sentiment category by dividing the frequency of each category by the tota
 l number of records. The results are presented in the following table:\n\n
 A	                  B\nSentiment	Frequency\nPositive	        140\nNegative
 	35\nNeutral	        16\nTotal	        191\n\nAfter obtaining the counts f
 or the positive\, negative\, and neutral sentiment categories\, the next s
 tep was to calculate the probability of each sentiment. Before calculating
  these probabilities\, the total number of sentiment instances was determi
 ned by summing all sentiment categories. Subsequently\, the probability of
  each sentiment was calculated by dividing the frequency of a sentiment ca
 tegory by the total number of records.\nFor example\, the formula used in 
 LibreOffice Calc was:\n=B2/$B$5\nUsing this formula\, the probability of t
 he positive sentiment category was calculated as 0.73298. The same procedu
 re was applied to the negative and neutral sentiment categories. The compl
 ete results are presented in the following table:\nA	                     
             B	                  C\nSentiment Category	Frequency	Probabilit
 y\nPositive	                        140	                   0.73298\nNegati
 ve	                35	                   0.18325\nNeutral	                
         16	                   0.08377\nTotal	                        191\n
 \nLibreOffice Calc proved to be a valuable alternative for this study due 
 to its ease of use and user-friendly interface. The software was straightf
 orward to understand and provided a comfortable working environment for da
 ta processing and analysis. Based on this experience\, I would recommend t
 he use of LibreOffice Calc to other students and researchers who require a
 n accessible and effective tool for data analysis.
DTSTAMP:20260814T033522Z
LOCATION:Auditorium
SUMMARY:Entropy Calculation of Text Data Using LibreOffice Calc - Nawindah 
 Nawindah\, Sibro Abdurrahman
URL:https://events.documentfoundation.org/libreoffice-conference-2026/talk/
 DVBSJC/
END:VEVENT
END:VCALENDAR