This question was posted on Chegg but has not been answered yet

10,03.3 10,JU. 10 Juru A..-A . , 14 III Chapter 7, Problem 9E 0 5 Bookmarks Show all steps: ON YK * # # # 24 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Dec-93 Jan-94 Feb-94 Mar-94 Apr-94 May-94 Jun-94 Jul-94 Aug-94 Sep-94 Oct-94 Nov-94 Dec-94 Jan-95 Feb-95 Mar-95 Apr-95 May-95 Jun-95 Jul-95 Aug-95 Sep-95 Oct-95 Nov-95 Dec-95 Jan-96 17,155.07 18,404.18 17,884.69 16,754.90 15,277.75 15,040.02 17,836.91 19,349.14 17,734.60 16,015.75 15,382.20 15,941.85 16,833.42 17,056.81 17,695.12 16,351.09 15,495.87 15,291.26 17,252.93 19,154.12 19,166.08 16,178.87 15,619.46 16,434.09 17,627.00 17,932.43 17,669.17 17,389.77 17,056.34 17,036.37 16,833.40 15,739.52 16,059.23 17,779.28 19,460.53 19,705.33 17,751.83 16,035.26 16,490.67 17,349.93 18,014.58 17,472.08 Dec-01 Jan-02 Feb-02 Mar-02 Apr-02 May-02 Jun-02 Jul-02 Aug-02 Sep-02 Oct-02 Nov-02 Dec-02 Jan-03 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 Feb-99 Feb-03 Mar-99 17,188.13 Mar-03 Apr-03 May-03 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 May Jun-00 Jul-00 15,811.44 15,913.57 19,271.75 21,652.70 19,652.57 18,180.01 16,478.46 16,739.43 17,742.58 18,485.60 17,955.94 16,834.31 16,218.50 16,656.62 18,980.76 18,745.26 19.480.04 18,018.60 16,607.91 17,231.95 18,737.37 Feb-96 www 17,267.98 17,808.09 17,404.08 16,809.13 16,561.17 16,168.09 18,691.46 21,372.06 21,300.47 18,505.90 17,157.60 17,201.31 18,362.16 19,065.90 18,741.54 17,400.20 16,358.73 15,929.05 17,999.87 20,717.03 20,730.96 18,038.57 16,531.88 16,758.73 18,137.06 19,333.36 18,313.19 17,351.52 16,384.22 17,001.84 18,798.57 20,040.84 20,222.35 18,643.92 16,775.23 17,308.72 18,617.75 16,816.22 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Mar-96 Apr-96 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 15,702.85 15,478.36 17,209.71 17,770.67 18,314.77 16,906.53 15,745.02 16,486.24 16,880.53 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 a. Plot the series and explain what can be learned from this plot. b. Calculate the first 24 autocorrelations for the series, and explain what characteristics of the data are shown in the ACF and PACF. c. Suggest and estimate an optimal ARIMA model. d. Estimate the ARIMA model that you believe to be a good candidate for forecasting electricity usage. Test the Ljung-Box statistic and report your findings. Finally, plot the first 24 autocorrelations of the residuals to your best model. 10,03.3 10,JU. 10 Juru A..-A . , 14 III Chapter 7, Problem 9E 0 5 Bookmarks Show all steps: ON YK * # # # 24 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Dec-93 Jan-94 Feb-94 Mar-94 Apr-94 May-94 Jun-94 Jul-94 Aug-94 Sep-94 Oct-94 Nov-94 Dec-94 Jan-95 Feb-95 Mar-95 Apr-95 May-95 Jun-95 Jul-95 Aug-95 Sep-95 Oct-95 Nov-95 Dec-95 Jan-96 17,155.07 18,404.18 17,884.69 16,754.90 15,277.75 15,040.02 17,836.91 19,349.14 17,734.60 16,015.75 15,382.20 15,941.85 16,833.42 17,056.81 17,695.12 16,351.09 15,495.87 15,291.26 17,252.93 19,154.12 19,166.08 16,178.87 15,619.46 16,434.09 17,627.00 17,932.43 17,669.17 17,389.77 17,056.34 17,036.37 16,833.40 15,739.52 16,059.23 17,779.28 19,460.53 19,705.33 17,751.83 16,035.26 16,490.67 17,349.93 18,014.58 17,472.08 Dec-01 Jan-02 Feb-02 Mar-02 Apr-02 May-02 Jun-02 Jul-02 Aug-02 Sep-02 Oct-02 Nov-02 Dec-02 Jan-03 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 Feb-99 Feb-03 Mar-99 17,188.13 Mar-03 Apr-03 May-03 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 May Jun-00 Jul-00 15,811.44 15,913.57 19,271.75 21,652.70 19,652.57 18,180.01 16,478.46 16,739.43 17,742.58 18,485.60 17,955.94 16,834.31 16,218.50 16,656.62 18,980.76 18,745.26 19.480.04 18,018.60 16,607.91 17,231.95 18,737.37 Feb-96 www 17,267.98 17,808.09 17,404.08 16,809.13 16,561.17 16,168.09 18,691.46 21,372.06 21,300.47 18,505.90 17,157.60 17,201.31 18,362.16 19,065.90 18,741.54 17,400.20 16,358.73 15,929.05 17,999.87 20,717.03 20,730.96 18,038.57 16,531.88 16,758.73 18,137.06 19,333.36 18,313.19 17,351.52 16,384.22 17,001.84 18,798.57 20,040.84 20,222.35 18,643.92 16,775.23 17,308.72 18,617.75 16,816.22 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Mar-96 Apr-96 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 15,702.85 15,478.36 17,209.71 17,770.67 18,314.77 16,906.53 15,745.02 16,486.24 16,880.53 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 a. Plot the series and explain what can be learned from this plot. b. Calculate the first 24 autocorrelations for the series, and explain what characteristics of the data are shown in the ACF and PACF. c. Suggest and estimate an optimal ARIMA model. d. Estimate the ARIMA model that you believe to be a good candidate for forecasting electricity usage. Test the Ljung-Box statistic and report your findings. Finally, plot the first 24 autocorrelations of the residuals to your best model