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 =
-
What do you think would be Whitmans approach to human capital?
-
Which of the following is not a recommended suggestion for running an effective job interview meeting? a. Show sincerity in your vocal tone. b. Try to make the candidate feel relaxed. c. Use open...
-
What is the critical test for any accounting system? Does this test rely on syntactic, semantic or pragmatic perspectives?
-
Rick and Stacy Stark, a married couple, are interested in purchasing their first boat. They have decided to borrow the boats purchase price of $100,000. The family is in the 28% federal income tax...
-
Does the process of globalization help or hinder wealth creation in developing countries? British petroleum' global activities for diplomatic/political to support your findings and conclusion...
-
Healthwise Medical Supplies Company is located at 2400 Second Street, City, ST 12345. The company is a general partnership that uses the calendar year and accrual basis for both book and tax...
-
Suppose that total GDP in a country at a given year is given by the following production function: Y = A(K) 1 3 (BL) 2 3 where B represents labour productivity and all other variables are the same as...
-
The following three ply glass fiber/ epoxy configuration [0/45/90], is subjected to a load (stress resultants) of Nx = Ny=1200 N/m. (each ply has fiber volume fraction of 0.6) Note that (Nxy=0 N/m...
-
In the figure below, m m1 = 11.0 kg and m = 3.9 kg. The coefficient of static friction between m and the horizontal surface is 0.60, and the coefficient of kinetic friction is 0.30. mq (a) If the...
-
Your real estate investment ($1250) tripled between 2014 and 2022. How long in total years (to the nearest 0.01 years) will your investment take to grow to 4x given that the annual rate r is...
-
In 2023, a person earned employment income of $80,000 They owned a 75% interest in a partnership that incurred a $50,000 business loss, and a 100% interest in a corporation that incurred a $20,000...
-
. . FastCars is debating whether its next car model should be a gas or electric car. Due to factory limitations, FastCars will only be able to introduce one new model in the next five years . Both...
-
11.A clerk embezzles customer payments on account and covers up the theft by making an adjustment to the accounts receivable ledger. Describe a specific internal control procedure that would prevent...
-
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.
-
Develop an expression for the damping constant of the rotational damper shown in Fig. 1.105 in terms of \(D, d, l, h, \omega\), and \(\mu\), where \(\omega\) denotes the constant angular velocity of...
-
Consider two nonlinear dampers with the same force-velocity relationship given by \(F=1000 v+400 v^{2}+20 v^{3}\) with \(F\) in newton and \(v\) in meters/second. Find the linearized damping constant...
-
If the linearized dampers of Problem 1.60 are connected in parallel, determine the resulting equivalent damping constant. Data From Problem 1.60:- Consider two nonlinear dampers with the same...
Study smarter with the SolutionInn App