...

E

In the excel the KApassenger worksheet shows data on the number of long-distance train passengers in Java from 2017 to 2019. Based on this information; 1. Using the ratio to moving average method, calculate the seasonal index for each quarter. 2. Interpret the seasonal index values for the first and fourth quarters. 3. Using the linear regression method, estimate the number of long-distance railway passengers in Java(Triwulan)train in the first quarter of 2020 based on seasonal index and trend models. 4. Using the exponential method, estimate the number of long-distance railway passengers in Java in the first quarter of 2020 based on seasonal index and trend models. A B D E 1 Year Triwulan (java train) total number of passengers 2 1 17106 3 2 17044 4 3 17992 5 4 18366 6 1 17440 7 2 19512 8 3 19725 9 4 20869 10 1 19346 11 2 21634 12 3 21802 13 21051 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 4 In the excel the KApassenger worksheet shows data on the number of long-distance train passengers in Java from 2017 to 2019. Based on this information; 1. Using the ratio to moving average method, calculate the seasonal index for each quarter. 2. Interpret the seasonal index values for the first and fourth quarters. 3. Using the linear regression method, estimate the number of long-distance railway passengers in Java(Triwulan)train in the first quarter of 2020 based on seasonal index and trend models. 4. Using the exponential method, estimate the number of long-distance railway passengers in Java in the first quarter of 2020 based on seasonal index and trend models. A B D E 1 Year Triwulan (java train) total number of passengers 2 1 17106 3 2 17044 4 3 17992 5 4 18366 6 1 17440 7 2 19512 8 3 19725 9 4 20869 10 1 19346 11 2 21634 12 3 21802 13 21051 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 4