EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 words

EXCEL 5 - Assignment Example ceipts is also done to identify whether the trend is clearer, whether there are any anomalies left or any more cyclical patterns lasting more than one year. Finally, a review of the double smoothed results to determine whether the values from the projected position are reasonable. We can also determine the impact of the recent values on the projection and whether it skews the projection. From observing the raw receipt data, it is evident that there is both positive, negative and stationary trends at different months of the line graph. The initial months show a positive trend for the first points before a negative trend begins. This trend doesn’t last long before another stationary then positive trends are observed. Essentially, there is no definite trend with the raw receipts as it emerges as a zigzag trend of positive, negative and stationary trends. Generally, a positive trend is observed. There are few anomalies observed through the projection period. The first anomaly is a spike in the 10th month of the projection period. Another spike though not too significant is evident at the 22nd month. A significant anomaly is evident at the 46th month where the highest spike in the entire projection period is observed. Other minor spikes are shown at the 36th and 40th month of the projection period respectively. There is no significant dips (decreases) in the proje ction period although minor decreases in the 9th, 21st, 30th, 33rd and 45th can be observed from the graph. Particular patterns can be observed in the dips (decrease) and spikes (increase) in the projection period. The spikes (increase) seem to occur after twelve months exhibiting an annual pattern over the projection period. The dips (decrease) however, do not exhibit a particular pattern as some occur after 2 months. It is also important to note that after every dip (decreases) there is a spike (increases) in the following month but not of equal proportions. The comparison between the de-seasonalized and