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

EXCEL 5 - Assignment Exampleceipts is also done to identify whether the slip is clearer, whether thither are any anomalies left or any more cyclical patterns lasting more than one year. Finally, a review of the double smooth 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 sore receipt data, it is evident that there is both positive, negative and stationary gallerys at different months of the line graph. The initial months show a positive trend for the prime(prenominal) points before a negative trend begins. This trend doesnt 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. at that place are few anomalies observed thro ugh the projection period. The first anomaly is a spike in the 10th month of the projection period. some other 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 projection 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 give awaying 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 equ al proportions.The comparison between the de-seasonalized and