For the data in the Excel file Ohio Prison Population do the following: a. Develop spreadsheet models
Fantastic news! We've Found the answer you've been seeking!
Question:
For the data in the Excel file Ohio Prison Population 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 for exponential smoothing.
Transcribed Image Text:
A в D E F G H Ohio Plison Population Data 2 Male Male Female Female Total Total 4 Year Intake Population Intake Population Intake Population 1972 4677 8846 236 275 4913 9121 6 1973 4635 8049 253 271 4888 8320 7 1974 5538 7449 8978 367 268 5905 7717 8 1975 7014 442 348 7456 9326 1976 6859 10985 493 436 7352 11421 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 631 598 8329 13360 14 1981 9046 12557 792 581 9838 13138 15 1982 9530 14071 919 725 10449 14796 16 1983 9293 16272 917 875 10210 17147 17 1984 8855 16795 780 971 9635 17766 18 1985 9132 17382 868 969 10000 18351 19 1986 9436 19416 1002 1123 10438 20539 20 1987 9871 20981 1071 1194 10942 22175 21 1988 23943 11170 14673 22659 1296 1284 12466 22 1989 24373 1833 1476 16506 25849 23 1990 15423 28346 1986 1954 17409 30300 24 1991 17450 29605 2196 1896 19646 31501 25 1992 18209 33189 2385 2257 20594 35446 26 1993 17460 35627 2374 2364 19834 37991 27 1994 16546 37715 2346 2538 19198 40253 28 39065 41595 1995 17395 2520 2544 19915 41609 29 1996 16753 2431 2743 19184 44338 30 1997 15589 43183 2011 2779 17600 45962 31 1998 16076 44997 2177 2811 18253 47808 32 1999 16122 45285 2203 2886 18325 48171 33 2000 17334 43813 2387 2806 19721 46619 34 35 A change in policy in 1994 no longer counts inmates AWL to court as prison population A в D E F G H Ohio Plison Population Data 2 Male Male Female Female Total Total 4 Year Intake Population Intake Population Intake Population 1972 4677 8846 236 275 4913 9121 6 1973 4635 8049 253 271 4888 8320 7 1974 5538 7449 8978 367 268 5905 7717 8 1975 7014 442 348 7456 9326 1976 6859 10985 493 436 7352 11421 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 631 598 8329 13360 14 1981 9046 12557 792 581 9838 13138 15 1982 9530 14071 919 725 10449 14796 16 1983 9293 16272 917 875 10210 17147 17 1984 8855 16795 780 971 9635 17766 18 1985 9132 17382 868 969 10000 18351 19 1986 9436 19416 1002 1123 10438 20539 20 1987 9871 20981 1071 1194 10942 22175 21 1988 23943 11170 14673 22659 1296 1284 12466 22 1989 24373 1833 1476 16506 25849 23 1990 15423 28346 1986 1954 17409 30300 24 1991 17450 29605 2196 1896 19646 31501 25 1992 18209 33189 2385 2257 20594 35446 26 1993 17460 35627 2374 2364 19834 37991 27 1994 16546 37715 2346 2538 19198 40253 28 39065 41595 1995 17395 2520 2544 19915 41609 29 1996 16753 2431 2743 19184 44338 30 1997 15589 43183 2011 2779 17600 45962 31 1998 16076 44997 2177 2811 18253 47808 32 1999 16122 45285 2203 2886 18325 48171 33 2000 17334 43813 2387 2806 19721 46619 34 35 A change in policy in 1994 no longer counts inmates AWL to court as prison population
Expert Answer:
Answer rating: 100% (QA)
Answers to both parts are in the Excel sheet The Excel s... View the full answer
Related Book For
Statistics Data Analysis and Decision Modeling
ISBN: 978-0132744287
5th edition
Authors: James R. Evans
Posted Date:
Students also viewed these business communication questions
-
Use the data in the Excel file Baseball Attendance to do the following a Develop spreadsheet models for forecasting attendance using single moving average (use MA with k-2,3,4,5) Calculate the...
-
For the data in the Excel file New Account Processing, perform chisquare tests for independence to determine if certification is independent of gender, and if certification is independent of having...
-
The data in the Excel file Real Estate Sales represent the annual sales of 100 branch offices of a national real estate company. Use the Crystal Ball distribution fitting procedure to find the...
-
Solve the equation symbolically. Then solve the related inequality. - - x] S | - H =
-
Suppose that X1, X2, . . . ,X5 are five random variables for which the joint p.d.f. can be factored in the following form for all points (X1, X2, . . . , X5) R5: f (x1, x2, . . . , x5) = g(x1,...
-
The Barden Corporation's comparative balance sheets for 2017 and 2016 are presented below. Barden Corporation Balance Sheets The income statement of Barden Corporation for the year ended December 31,...
-
Determine the fundamental frequency of a uniform fixed-fixed beam carrying a mass \(M\) at the middle by applying Rayleigh's method. Use the static deflection curve for \(W(x)\).
-
The accounts receivable clerk for Quigley Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: The following accounts were...
-
This will continue to focus on the community you have identified in Unit I, which is either the community you live or work in. It is not a fictional community and should not differ from the one...
-
Finnegan and Healey form a partnership, contributing $35,000 and $105,000, respectively. Determine their shares of net income or net loss for each of the following independent situations: a. Net loss...
-
How can a business ensure that their trademarks are not being infringed globally?
-
Rachel Janet is preparing the 2024 budget for one of BestKayak's roto-moulded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit...
-
Explain how you would design a distributed system that ensures high availability and fault tolerance, and what strategies would you employ to manage state across multiple nodes?
-
You have come a long way since starting this project, and you should be very proud to be to this point. However, you still have a few more things to do. For this week's discussion, the leadership...
-
Golden Gate Corporation (GGC) was formed in 2016 by two shareholders, Malcolm Jones and Linda Ramirez. Both Malcolm and Linda are U.S. residents. Malcolm contributed $500,000 cash in exchange for 250...
-
ABC Limited closes its books and prepares financial statements at the end of each month. The company incurred the below transaction during June 2023. Date Transaction 6 issued sales invoice no. 721...
-
Michael has decided to invest his money in a bakery shop in Kitsilano. He invested $400,000 and he expects to earn 6% per annum, compounded semi-annually, for 2 years. He will receive no cash flows...
-
Using the information presented in Problem 13.4B, prepare a partial statement of cash flows for the current year, showing the computation of net cash flows from operating activities using the...
-
A survey of 100 MBA students found that 75 owned mutual funds, 35 owned stocks, and 15 owned both. a. What is the probability that a student owns a stock? What is the probability that a student owns...
-
Refer back to the college admission director scenario (Problem 20 in Chapter 9). Develop a spreadsheet model and apply Crystal Ball tools to make a recommendation on how many scholarships to offer.
-
Summarize the modeling and analysis tools available in Crystal Ball and what information they provide.
-
A low Altman Z-score is most indicative of a: A. financially healthy company. B. company likely to enter bankruptcy. C. company likely to be misclassified as financially unhealthy.
-
The arbitrage pricing theory is a model in which: A. the market return explains a stock's expected return. B. several factors may explain a stock's expected return. C. one and only one factor...
-
Which of the following statement is not true: A. A company's beta does not change over time. B. The fundamental beta allows for potential of beta to change over time. C. An historical beta is...
Study smarter with the SolutionInn App