Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 .The data , in the next six Tables, represent Historical Monthly Usage of 6 groups of materials by the AZX Company. Use minitab to

1.The data , in the next six Tables, represent Historical Monthly Usage of 6 groups of materials by the AZX Company. Use minitab to :

1.Plot the data and check for stationarity usingautocorrelation and Partial Autocorrelation.

2.Estimate an ARIMA models using theBox-Jenkins approach.

3. Do model checking using the ACF and PACF of residuals, residualsHistogram, Normality plot of Residuals ,Residuals vs Fits.

4.Forecast the monthly consumption for year 2007 using the model identified in 2.

Year

Month

1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006
Jan 0.00 13.38 64.84 31.61 55.03 46.00 73.96 4.76 125.88 119.86 92.06 46.99 27.20
Feb 0.00 13.23 43.90 25.12 26.25 118.37 96.05 186.89 62.25 53.59 46.32 36.72 86.72
Mar 0.00 38.40 47.92 75.21 80.85 80.28 56.48 67.48 111.29 94.70 85.99 36.54 303.44
Apr 51.14 49.04 39.56 52.44 42.79 46.52 49.26 56.64 77.78 103.23 92.42 39.69 224.46
May 51.85 6.60 18.34 39.91 0.00 0.00 0.00 81.08 88.20 69.86 153.91 105.56 280.63
Jun 29.43 7.74 25.65 40.40 0.00 0.00 108.24 69.06 155.33 90.26 158.04 102.34 148.16
Jul 41.18 15.82 37.95 66.65 0.00 139.03 83.24 105.06 144.62 117.23 178.18 92.79 105.71
Aug 50.06 31.11 29.84 59.48 0.00 87.96 36.32 60.84 99.47 89.82 154.49 77.20 94.13
Sep 49.10 40.68 54.35 44.95 36.26 26.91 26.71 113.22 175.08 85.80 164.28 22.33 81.24
Oct 4.15 50.23 47.65 33.71 97.64 52.57 65.64 74.67 119.19 72.42 62.79 65.90 212.85
Nov 51.99 63.42 24.50 59.62 89.99 163.36 52.97 71.16 109.69 139.78 83.42 74.43 74.23
Dec 42.00 49.33 35.15 57.66 132.71 113.17 80.36 49.15 112.29 65.59 61.47 83.01 112.56

TABLE 5.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probability, Random Variables, And Random Processes

Authors: Hwei P Hsu

3rd Edition

0071824774, 9780071824774

More Books

Students also viewed these Mathematics questions

Question

What does this look like?

Answered: 1 week ago