- PLEASE PROVIDE CALCULATIONS

For both problems, use a significant level of 0.10 to compare the p-value in the regression output. #1. National Scan, Inc. sells (RFID) radio frequency inventory tags. Monthly sales for a nine month period were as follows: o You are required to provide a forecast value for month 10, 15 and 20 using the appropriate forecasting technique. What is the forecast value for period 10 and which forecasting methods should be used to forecast month 10? Explain why. You MUST provide ALL calculations, data and values in the Excel document to support your explanation. What is the forecast value for period 15 and which forecasting methods should be used to forecast month 15? Explain why. You MUST provide ALL calculations, data and values in the Excel document to support your explanation. What is the forecast value for period 20 and which forecasting methods should be used to forecast month 20? Explain why. You MUST provide ALL calculations, data and values in the Excel document to support your explanation. o O Month 1 2 3 4 5 6 7 Sales (000 units) 20 21 15 14 13 16 17 20 20 8 9