I have no idea how to even bein this can someone help? Thanks For the prision da

Question

I have no idea how to even bein this can someone help? Thanks

For the prision data below develop a spreadsheet using single moving average and single expodential smoothing

Ohio Prison Population Data Male Male Female Female Total Total Year Intake Population Intake Population Intake Population 1972 4677 8846 236 275 4913 9121 1973 4635 8049 253 271 4888 8320 1974 5538 7449 367 268 5905 7717 1975 7014 8978 442 348 7456 9326 1976 6859 10985 493 436 7352 11421 1977 6317 12086 627 542 6944 12628 1978 5993 12269 558 577 6551 12846 1979 6849 12768 583 582 7432 13350 1980 7698 12762 631 598 8329 13360 1981 9046 12557 792 581 9838 13138 1982 9530 14071 919 725 10449 14796 1983 9293 16272 917 875 10210 17147 1984 8855 16795 780 971 9635 17766 1985 9132 17382 868 969 10000 18351 1986 9436 19416 1002 1123 10438 20539 1987 9871 20981 1071 1194 10942 22175 1988 11170 22659 1296 1284 12466 23943 1989 14673 24373 1833 1476 16506 25849 1990 15423 28346 1986 1954 17409 30300 1991 17450 29605 2196 1896 19646 31501 1992 18209 33189 2385 2257 20594 35446 1993 17460 35627 2374 2364 19834 37991 1994 16546 37715 2346 2538 19198 40253 1995 17395 39065 2520 2544 19915 41609 1996 16753 41595 2431 2743 19184 44338 1997 15589 43183 2011 2779 17600 45962 1998 16076 44997 2177 2811 18253 47808 1999 16122 45285 2203 2886 18325 48171 2000 17334 43813 2387 2806 19721 46619

Explanation / Answer

I'll use the total population data to make the exponential smoothing and Moving average.

I'll take 5-period moving average, this can be taken anything else as well. Also, I am taking the alpha value = 0.3 for the exponential smoothing part, but even for that, any other value may be taken.

Thus,

Hope this helps. Ask if you have any doubts.

Ohio Prison Population Data Exponential Male Male Female Female Total Total Forecast Moving Average Year Intake Population Intake Population Intake Population 1972 4677 8846 236 275 4913 9121 9121 1973 4635 8049 253 271 4888 8320 9121 1974 5538 7449 367 268 5905 7717 8881 1975 7014 8978 442 348 7456 9326 8532 1976 6859 10985 493 436 7352 11421 8770 9181 1977 6317 12086 627 542 6944 12628 9565 9882 1978 5993 12269 558 577 6551 12846 10484 10788 1979 6849 12768 583 582 7432 13350 11193 11914 1980 7698 12762 631 598 8329 13360 11840 12721 1981 9046 12557 792 581 9838 13138 12296 13064 1982 9530 14071 919 725 10449 14796 12549 13498 1983 9293 16272 917 875 10210 17147 13223 14358 1984 8855 16795 780 971 9635 17766 14400 15241 1985 9132 17382 868 969 10000 18351 15410 16240 1986 9436 19416 1002 1123 10438 20539 16292 17720 1987 9871 20981 1071 1194 10942 22175 17566 19196 1988 11170 22659 1296 1284 12466 23943 18949 20555 1989 14673 24373 1833 1476 16506 25849 20447 22171 1990 15423 28346 1986 1954 17409 30300 22068 24561 1991 17450 29605 2196 1896 19646 31501 24537 26754 1992 18209 33189 2385 2257 20594 35446 26626 29408 1993 17460 35627 2374 2364 19834 37991 29272 32217 1994 16546 37715 2346 2538 19198 40253 31888 35098 1995 17395 39065 2520 2544 19915 41609 34397 37360 1996 16753 41595 2431 2743 19184 44338 36561 39927 1997 15589 43183 2011 2779 17600 45962 38894 42031 1998 16076 44997 2177 2811 18253 47808 41014 43994 1999 16122 45285 2203 2886 18325 48171 43052 45578 2000 17334 43813 2387 2806 19721 46619 44588 46580

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.