For your dataset do the following: 1. Produce a master table which is going to include all of your time-series data. You need to include columns for the following: quarter, profit ($), 4-point moving average (MA4) and centred moving average (CMA). Fill in the column for profit by transferring the data from your dataset onto the table. To accommodate the forecast, your table needs to range from March 01 to December 05 inclusive. Follow the same format as given in the lectures.

2. On graph paper produce a line graph of the profit, putting the quarter on the horizontal axis and the profit on the vertical axis. Start the vertical axis at an appropriate value (not necessarily zero). Label the axes appropriately and include a title for your graph. Ensure that you use a large enough sheet of graph paper so that the data can be read easily.

3. Describe the following components of your time-series:

a. Trend

b. Seasonal component

2. Store Item profit time- series data Quarter Profit Mar 01 10272 Jun 01 7392 Sep 01 7776 Dec 01 10080 Mar 02 10848 Jun 02 8352 8352 Dec 02 10848 Mar 03 11616 Jun 03 8832 9216 Dec 03 11040 Mar 04 12672 Jun 04 10176 10272 Dec 04 12480 Sep 02 Sep 03 Sep 04 Population Standard Deviation o = Ho: H = 5 1486 10820 Profit threshold ($) Confidence level (%) 8838.5 89.9 2. Store Item profit time- series data Quarter Profit Mar 01 10272 Jun 01 7392 Sep 01 7776 Dec 01 10080 Mar 02 10848 Jun 02 8352 8352 Dec 02 10848 Mar 03 11616 Jun 03 8832 9216 Dec 03 11040 Mar 04 12672 Jun 04 10176 10272 Dec 04 12480 Sep 02 Sep 03 Sep 04 Population Standard Deviation o = Ho: H = 5 1486 10820 Profit threshold ($) Confidence level (%) 8838.5 89.9