Please use Data Analysis ToolPak in excel*

For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80,82,84,83,83,84,85,84,82,83,84, and 83 . This data is given in the tab Hawkins. (a) Construct a time series plot. What type of pattern exists in the data? (1/2 point) (b) Compare a four-month moving average (k=4) forecast with an exponential smoothing forecast for =0.3. Which provides the better forecasts using MSE as the measure of model accuracy? ( 2 points) (c) What is the forecast for next month? Use the best method from your comparison in part (b). (1/2 point)