Payment Analysis

<p>For this exercise, we use the Road Traffic Fine Management event log&nbsp;which is a real-life event log&nbsp;of an information system managing road traffic fines. The event log can be downloaded from https://data.4tu.nl/articles/_/12683249/1.</p><p>The&nbsp;initial&nbsp;setup of the workflow must&nbsp;contain&nbsp;the XES Reader node followed by the Event Log to Table node. The&nbsp;path to the event log can be set within the XES Reader node by selecting the folder where we uploaded the Road Traffic Fine Management log.&nbsp;&nbsp;</p><p>With this setup, we want to&nbsp;answer the following questions:&nbsp;</p><ol type="i"><li><p>How does&nbsp;the payment value change over time?&nbsp;</p></li><li><p>Does the initial fine amount influence whether the offender decides to file an appeal?</p></li></ol><p>To answer the first question, we start&nbsp;by binning the Payment attribute to create a new attribute called ‘Payment Category'.&nbsp;A dotted chart can then be used to visualize the trend in the payments over time.&nbsp;We refer to&nbsp;the dotted chart to&nbsp;identify&nbsp;two&nbsp;distinct time intervals where the most frequent payment category is clearly distinguishable.&nbsp;Next, we filter the data using&nbsp;the&nbsp;identified&nbsp;time intervals. For each time interval, we create a&nbsp;boxplot to find the median of the payments to get an understanding of how the payment value changes across the time&nbsp;intervals.&nbsp;&nbsp;</p><p>(Hint: As a preprocessing step, consider filtering the event log to only&nbsp;retain&nbsp;non-zero&nbsp;Payment events.)&nbsp;</p><p>To answer the second question,&nbsp;we first&nbsp;identify&nbsp;the cases&nbsp;which involve appealing by the offender&nbsp;as well as the cases with no appealing. Next, we compare the values of the fine issued&nbsp;in both cases&nbsp;using the mean value as well as boxplots.&nbsp;</p>