Please solve all

QUESTION 1 Complete the following table using the forecasting techniques of Moving Average and exponential Smoothing. Use 2 decimal places throughout. Use the smoothing factor alpha=0.1; pt M 4 pt MA Exp Sm (0.1) Period 13 3 pt MAD Forecast Errors 3 pt MSE 4 pt MSE 4 pt MAD Exp MAD Exp MSE QUESTION 2 of the three methods which forecast technique should be adopted? 4 pt Moving Average 3 pt Moving Average Exponential Smoothing It does not make a difference QUESTION 3 Why is this method the best of the three methods to be adopted? The MAD is highest and the forecast value is largest; The MAD is lowest and the forecast value is smallest; The MAD is lowest and the MSE is lowest; None of the above. QUESTION 4 Between the 3 pt Moving Average and the 4 pt Moving Average, which method is to be preferred and why? 3 pt MA since the MAD is lower than 4 pt MAD; 4pt MA since the MAD is higher than 3pt MA 4pt MA since the MAD is lower than the 3pt MA None of the above. QUESTION 5 Using the technique to find the optimal alpha, what is the value of the smoothing parameter which minimizes the MAD. Use 3 decimal places. Corporate Triple Bond Rates for 12 consecutive months are given as follows: 9.5, 9.3, 9.4, 9.6, 9.8, 9.7, 9.8, 10.5, 9.9, 9.7, 9.6, 9.6