QUESTION 1 Use the data about Lenovo computer chips to answer questions 1-5. Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: Month Price Per Chip Month Price Per Chip January $ 1.80 $1.80 February $1.67 $1.83 July August September October March $1.70 $1.70 April |$1.85 $1.65 May |$1.90 November $1.70 June $1.87 December $1.75 Create 2-month and 3-month moving average forecasts for the chip price data What is the MAD for the 2-month moving average? Enter your answer as a decimal to three places, example: 45.877 QUESTION 2 What is the MAD for the 3-month moving average? Enter your answer as a decimal to three example: 45.877 QUESTION 3 Which moving average forecast is better? O 2-month moving average forecast 3-month moving average forecast QUESTION 4 Compute the forecasts for each month using exponential smoothing with an initial forecast for January of $1.80. Use alpha = 0.1, then alpha=0.3, and finally alpha=0.5. Using MAD, which alpha is best? O alpha = 0.1 forecast O alpha = 0.3 forecast O alpha = 0.5 forecast QUESTION 5 Using your best exponential smoothing forecast, what is the forecast for chip price in January? Enter your answer as a decimal to two places with no dollar signs, example: 7.71