1. Discuss the problems, if any, of explaining the Box-Jenkins method to John's banker and others on...
Question:
2. Given the autocorrelations in Figure 9-39 and the partial autocorrelations in Figure 9-40, what regular (nonseasonal) terms might John include in an ARIMA model for Mr. Tux sales? What seasonal terms might he include in the model?
Figure 9-39
Autocorrelations for Mr. Tux: Regular and Seasonally Differenced Series
Figure 9-40
Partial Autocorrelations for Mr. Tux: Regular and Seasonally Differenced Series
3. Using a program for ARIMA modeling, fit and check an ARIMA model for Mr. Tux sales. Generate forecasts for the next 12 months.
John Mosby has decided to try the Box-Jenkins method for forecasting his monthly sales data. He understands that this procedure is more complex than the simpler methods he has been trying. He also knows that more accurate forecasts are possible using this advanced method. Also, he has access to the Minitab computer program that can fit ARIMA models. And since he already has the data collected and stored in his computer, he decides to give it a try.
Transcribed Image Text:
Autocorrelation Function: Diffi Diff12Sales Autocurrelation for DarsDITs Lag ACF T L 0.434972 -3.96 16.28 2 0.119297 0.93 17.52 3 0.177448 1.36 20.29 4 -0.013968-0.10 20.31 5 0.223625 1.58 24.84 6 0.126474 0.92 26.30 7 -0.053425 0.38 26.57 8 0.0549570.39 26.85 9 -0.006380 0.05 26.85 10 0.032094 0.23 26.95 11 -0.006053 -0.04 26.96 Autocorrelation Function for Diff1Diff12Sales 04 80 12 0.037127 -0.27 27.09 13 0.024916 0.1827.16 14 0.025145 -0.18 27.22 15 -0.081508-0.58 27.91 16 0.028684 0.20 28.00 17 0.184183 1.31 31.62 18 -0.148161 1.03 34.01 19 0.059354 -0.41 34.39 20 Ο.165452 1.14 37.46 21 -0.044315 -0.30 37-6 -93 24O1 1420 Lag Partial Autocorrelation Function: DITIDIT12Sales Lag PACF 1 -0.434972-3.96 2 -0.380486 -3.47 3 -0.086077-0.78 4 0.013655 0.12 5 -0.232666 -2.12 Partial Autocorrelation Function for Diff1Diff125ales 6 -0.163070 1.49 7 -0.237648-2.17 8-0.061466 -0.56 9 -0.042868 -0.39 10 -0.010757-0.1O 0.4 -0.009411-0.09 12 -0.091044-0.83 13 0.021219 -0.19 14 -0.051663 0.47 15 -0.144650-1.32 16 -0.191300-1.74 17 0.089113 0.81 18 0.032755 0.30 -0.4 19 -0.142079 1.29 20 -0.075125-.68 21 -0.016020 -0.15 2460101214 20
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 65% (20 reviews)
1 BoxJenkins ARIMA models account for the autocorrelation in the observed series using possibly diff...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Statistics questions
-
Help-wanted advertising is used by businesses when they are caught short and need workers quickly, as might be expected to happen when business activity picks up after a downturn. Table 14.4.8 shows...
-
1. What is the appropriate Box-Jenkins model to use on the original data? 2. What are your forecasts for the first four weeks of January 1983? 3. How do these forecasts compare with actual sales? 4....
-
1. Write Dorothy a memo that explains the Box-Jenkins methodology. 2. Develop an ARIMA model using the Box-Jenkins methodology, and forecast the monthly number of new clients for the rest of 1993. 3....
-
Suppose that a 7% semi-annual coupon bond with a time to maturity of 8 years and a par value of $100 has a price of $106,4. This bond is first callable in 6 years at a redemption price of $104,8....
-
Draw LineweaverBurk plots for the behavior of an enzyme for which the following experimental data are available. (mM) 3.0 5.0 7.0 9.0 11.0 V No Inhibitor (mmol min-1) 4.58 6.40 7.72 8.72 9.50 V...
-
The following items, in alphabetical order, are available from the records of Walker Corporation as of December 31, 2010 and 2009: Required 1. Calculate the following as of December 31, 2010, and...
-
P3-5 Prepare a consolidated balance sheet one year after acquisition On January 1, 2016, Mignonne Corporation paid $2,850,000 in cash for a 100 percent interest in Petite Corporation when Petites...
-
The 2009 financial statements for the Griffin Company are as follows: Required Compute the following ratios for the Griffin Company for the year ending December 31, 2009: A. Profit margin ratio...
-
What is the total effect on the accounting definitional equation of collecting cash from a previously recorded credit sale? Assets Liabilities Shareholders' Equity A. B. increase $100 no effect...
-
Ryan Ross (111-11-1112), Oscar Omega (222-22-2223), Clark Carey (333-33-3334), and Kim Kardigan (444-44-4445) are equal active members in ROCK the Ages LLC. ROCK serves as agent and manager for...
-
1. Using Mary Beasley's data in Table 4-13, construct a time series plot, and compute the sample autocorrelations and sample partial autocorrelations for the total billable visits, Yt the differenced...
-
1. After this analysis was completed, the figure for sales in 1961 became available: $1,426. What is the model's forecast for 1961? If this year were added to the testing data set, what would the...
-
If an organization can borrow money or sell stock, it does not have a capital constraint. Is this statement true or false? Discuss the rationale for your answer. LO2
-
Fineas Co. use the Job Order Costing system to determine product costs. Before entering 2020, the company has created a production budget, with an estimated total manufacturing overhead of $...
-
Define what a market value is? What are three major principles of investing funds? How does the federal government control the money supply? An investor purchases a 10-year U.S. Treasury note and...
-
1. Suppose we have two alternative designs, each of which yields a different present value of the total lifetime cost: the first is $1604 and the second is $1595. Verify that the present value of the...
-
Sometimes when we are asked for a linear model, the information that we are given is data about a scenario. In these cases we have to use Excel to generate a trendline. There is a video in this...
-
1. Purpose Explain 3 points from the Introduction section as to why this study is important. How did this study build on the existing literature in this area? 2. Participants Outline at least 2...
-
Place these markets in the framework that follows. a. Indonesia b. Mozambique c. India d. Bangladesh e. Niger f. Brazil g. Turkey h. Spain i. Singapore j. Nigeria k. Algeria l. Zambia m.Peru n....
-
Refer to the information from Exercise 22-19. Use the information to determine the (1) Weighted average contribution margin , (2) Break-even point in units, and (3) Number of units of each product...
-
General Motors introduced the subcompact Geo with a name that appeals to a world market. Invent a brand name for a line of luxury sports cars that also would appeal to an international market....
-
The Cotton Mill is an upscale chain of womens clothing stores, located primarily in the southwest United States. Due to recent success, The Cotton Mills top management is planning to expand by...
-
The manufacturer of Cardio Glide exercise equipment wants to study the relationship between the number of months since the glide was purchased and the time, in hours, the equipment was used last...
-
City planners believe that larger cities are populated by older residents. To investigate the relationship, data on population and median age in 10 large cities were collected. a. Plot these data on...
-
20 On January 1, Year 1, X Company purchased equipment for $80,000. The company estimates that the equipment will have a useful life of 10 years and a residual value of $5,000. X Company depreciates...
-
Discuss why it is important for company managers to understand and use social capital knowledge to help build social ties among their skilled knowledge workers so they can build employee loyalty...
-
Kate lives in a house close to a local university, and she traditionally has rented a garage apartment in the back of her property to students for $750 per month. Kate wants to transfer the title to...
Study smarter with the SolutionInn App