For the data in the Excel file Gasoline Prices do the following: a. a. Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing. b. b.Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. c. c. Compare your results to the best moving average and exponential smoothing models found by CB Predictor. d. e. 3. f. For the data in the Excel file Ohio Prison Population do the following: g. a. Develop spreadsheet models for forecasting both male and female populations using single moving average and single exponential smoothing. h. b.Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. i. c. Compare your results to the best moving average and exponential smoothing models found by CB Predictor. J- k. 4. 1. For the data in the Excel file Gasoline Prices do the following: m. a Develop spreadsheet models for forecasting prices using single moving average and single exponential smoothing n. b.Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. c. Compare your results to the best moving average and exponential smoothing models found by CB Predictor. P- 5. Construct a line chart for the data in the Excel file Arizona Population. a. Suggest the best-fitting functional form for forecasting these data. b. Use CB Predictor to find the best forecasting model. 6. Construct a line chart for each of the variables in the data file Death Cause Statistics, and suggest the best forecasting technique. Then apply CB Predictor to find the best forecasting models for these variables