6. a. Calculate and display the first 50 autocorrelations for the four data series in the table for this exercise, labeled A, B, C, and D; consider each of the four data series to be a quarterly time series. How many of the autocorrelations fall outside the 95 percent confidence interval (positive or negative)? b. Is there a pattern to those autocorrelation coefficients falling outside the 95 percent confidence interval? c. Calculate and display the first 50 partial autocorrelations for the 100 time-series observations. How many of the partial autocorrelation coefficients fall outside the 95 percent confidence interval? d. Is there a pattern to those partial autocorrelation coefficients falling outside the 95 percent confidence interval? e. Which frame in Figures 7.1 , 7.3, and 7.5 does this pattern of autocorrelation and partial autocorrelation coefficients most closely resemble? f. Estimate the appropriate model as determined from your inspections carried out in parts a through e, and forecast for four quarters into the future. Calculate the RMSE for each model. 60.00 50.00 40.00 30.00 20.00 10.00 0.00 Feb-1999 Oct-1999 Jun-2000 Feb-2001 Oct-2001 Jun-2002 Feb-2003 100.00 90.00 80.00 70.00 D Oct-2003 Jun-2004 Feb-2005 Oct-2005 Jun-2006 Feb-2007- Oct-2007 Jun-2008 Feb-2009 Oct-2009 Jun-2010 Feb-2011 Oct-2011 Jun-2012 Feb-2013 -Actual _ Statistical Forecast Forecast - Box Jenkins Selected Date Quarterly Statistical Forecast Annual Feb-2024 82.66 May-2024 83.34 Aug-2024 83.94 Nov-2024 84.47 334.40 Feb-2025 84.94 May-2025 85.35 Aug-2025 85.72 Nov-2025 86.04 342.04 Feb-2026 86.33 May-2026 86.58 Aug-2026 86.81 Nov-2026 87.01 346.72 Total 1,023.16 Avg 85.26 341.05 Max 87.01 346.72 Min 82.66 334.40 Oct-2013 Jun-2014 Feb-2015 Oct-2015 Jun-2016 Feb-2017 Fitted Values Series4 Oct-2017- Jun-2018 Feb-2019 Oct-2019 Jun-2020 Feb-2021 Oct-2021 Jun-2022 Feb-2023 Oct-2023 Jun-2024 Feb-2025 Oct-2025 Jun-2026 Summary Comments The forecast has an average error of The data has a standard deviation of The forecast exceeds the accuracy of a simple average by Audit Trail - Summary Analysis Audit Trail - Historical Versus Fitted Analysis 1.44% 23.05 99.98% Series:D Dates Original Data Fitted Data Error Series % Change Forecast % Change Cumulative Error Cumulative MAPE Feb-1999 0.93 0.93 0.00 0.00 0.00% May-1999 1.24 1.20 0.04 33.33% 29.56% 0.02 0.71% Aug-1999 2.12 1.55 0.58 71.05% 28.31% 0.20 3.48% Nov-1999 3.60 3.10 0.50 69.73% 100.75% 0.28 3.48% Feb-2000 4.59 5.01 -0.42 27.50% 61.49% 0.14 3.15% May-2000 5.75 5.26 0.49 25.27% 5.05% 0.20 2.86% Aug-2000 7.01 7.04 -0.03 21.91% 33.73% 0.16 2.46% Nov-2000 7.87 8.00 -0.13 12.27% 13.69% 0.13 2.18% Feb-2001 8.35 8.63 -0.28 6.10% 7.80% 0.08 1.98% May-2001 8.74 8.67 0.07 4.67% 0.48% 0.08 1.79% Aug-2001 9.29 9.15 0.14 6.29% 5.58% 0.08 1.64% Nov-2001 10.05 9.80 0.25 8.18% 7.05% 0.10 1.52% Feb-2002 10.62 10.81 -0.19 5.67% 10.28% 0.08 1.41% May-2002 11.74 11.02 0.72 10.55% 1.96% 0.12 1.34% Aug-2002 12.91 13.04 -0.13 9.97% 18.38% 0.11 1.26% Nov-2002 13.37 13.77 -0.40 3.56% 5.53% 0.07 1.19% Feb-2003 13.58 13.70 -0.12 1.57% -0.47% 0.06 1.12% May-2003 13.93 13.75 0.18 2.58% 0.36% 0.07 1.06% Aug-2003 15.00 14.31 0.69 7.68% 4.09% 0.10 1.02% Nov-2003 16.17 16.17 0.00 7.80% 13.01% 0.10 0.97% Feb-2004 16.67 17.11 -0.44 3.09% 5.78% 0.07 0.93% May-2004 17.41 16.99 0.42 4.44% -0.72% 0.09 0.89% Aug-2004 18.19 18.28 -0.09 4.48% 7.59% 0.08 0.86% Nov-2004 18.58 18.76 -0.18 2.14% 2.66% 0.07 0.82% Feb-2005 19.39 18.91 0.48 4.36% 0.77% 0.09 0.79% May-2005 20.74 20.30 0.44 6.96% 7.36% 0.10 0.76% Aug-2005 21.82 22.02 -0.20 5.21% 8.51% 0.09 0.74% Nov-2005 23.00 22.66 0.34 5.41% 2.91% 0.10 0.71% Feb-2006 24.00 24.22 -0.22 4.35% 6.86% 0.09 0.69% May-2006 24.87 24.73 0.14 3.63% 2.13% 0.09 0.67% Aug-2006 26.25 25.75 0.50 5.55% 4.13% 0.10 0.65% Nov-2006 27.62 27.61 0.01 5.22% 7.21% 0.10 0.63% Feb-2007 28.62 28.78 -0.16 3.62% 4.23% 0.09 0.61% May-2007 29.90 29.47 0.43 4.47% 2.39% 0.10 0.59% Audit Trail -- Out of Sample Table (Box JenkinsSelected) Date Feb-2023 May-2023 Aug-2023 Nov-2023 Avg Max Min StDev Var Median Audit Trail - Statistics Accuracy Measures Original Data Fitted Data MAD Cumulative MAD MAPE Cumulative MAPE Cumulative SSE 78.51 77.84 0.67 0.67 0.85% 0.85% 0.44 79.95 78.27 1.68 1.17 2.10% 1.48% 1.64 81.03 78.65 2.38 1.57 2.93% 1.96% 2.97 81.89 78.99 2.90 1.91 3.54% 2.36% 4.33 80.35 78.44 1.91 1.33 2.36% 1.66% 2.34 81.89 78.99 2.90 1.91 3.54% 2.36% 4.33 78.51 77.84 0.67 0.67 0.85% 0.85% 0.44 1.46 0.49 0.97 0.53 1.17% 0.65% 1.68 2.13 0.24 0.93 0.29 0.01% 0.00% 2.82 80.49 78.46 2.03 1.37 2.52% 1.72% 2.30 Value Forecast Statistics Mean Standard Deviation WMAPE R-Square Method Statistics Method Selected Model Selected 0.01% 99.98% Value Box Jenkins ARIMA(2,1,1) * (0,0,0) T-Test For Non Seasonal AR T-Test For Non Seasonal AR T-Test For Non Seasonal MA 1.90 1.55 -2.93 ForecastX Configuration Parameters Item Data range selected Time scale for data Periods to forecast Seasonal Length Replace Outliers Activated Replace Outliers Standard Deviations Replace Outliers Forecasting Technique Replace Missing Values Replace Missing Values (Lower Limit) Replace Missing Values (Upper Limit) Remove Leading Zeroes Value [C7P6.xlsx]Sheet1!$A$1:$D$101 Quarterly 12.00 No No Remove Trailing Zeroes Use Holdback Evaluation Holdback Evaluation Period Apply Tracking Signal Apply Tracking Signal (Under Forecast Percentage) Apply Tracking Signal (Over Forecast Percentage) Forecast Method Selected Report Details Run Date: 11/16/2023 2:28:58 PM Author: rherna42 Note: Yes No Yes 4.00 No Box Jenkins Value 41.38 23.05