For the data in the Excel file do the following A Develop sp

For the data in the Excel file do the following:

A. Develop spreadsheet models for forecasting both male and female populations using single moving average and single exponential smoothing.

B. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant fir exponential smoothing.

·lu-... A. Mid A. = Copy - , Formatting- Table Styles 4 A 1 Ohio Prison Population Data Female Population Male Male Femal Female Total Total 4 Year Intake PopulaticIntake Populatic Intake Population 5 1972 4677 8846 236 275 4913 9121 6 1973 4635 8049 253 271 4888 8320 7 1974 5538 7449 367 268 5905 7717 8 19757014 348 7456 9326 6859 10985 493 436 7352 11421 8 1975 7014 8978 442 9 1976 6 10 1977 6317 12086 627 542 6944 12628 11 1978 5993 12269 558 577 6551 12846 12 1979 6849 12768 583 582 7432 13350 13 1980 7698 12762 63 598 8329 13360 14 1981 9046 12557 792 15 1982 9530 14071 919| 725|#### 14796 581 9838 13138 15 1982 953 Ohio Prison 149 PM 8581 8 1661 88:61 ZB61 BL61 123456789112345

(a) Using the excel , the output for the moving averages and exponential smoothing are,

For the data in the Excel file do the following: A. Develop spreadsheet models for forecasting both male and female populations using single moving average and

For the data in the Excel file do the following A Develop sp

Solution

Get Help Now

Submit a Take Down Notice