STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 28CE
a.
To determine
To draw: The graph of the given time series data.
b.
To determine
To calculate: Three period moving average for the given time series data and MAD.
c.
To determine
To calculate: Six period moving average for the given time series data and MAD.
d.
To determine
To calculate: The forecast demand for period
e.
To determine
To state: The model to be chosen to make forecast.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In retail, a store manager uses time series models to understand shopping trends.
Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image.
Here is the data for Fiscal Year and Sales:
Fiscal Year
Sales
2010
$260,123.00
2011
$256,853.00
2012
$274,366.00
2013
$290,525.00
2014
$322,318.00
2015
$380,921.00
2016
$541,925.00
2017
$909,050.00
2018
$1,817,521.00
2019
$3,206,564.00
2020
$4,921,005.00
2021
$5,686,338.00
Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components?
The model can be additive or multiplicative. When do you use each?
Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe?
What predictions might you make about the store’s annual sales over the next few years?
Please answer asap I really need help
Use the data given in the three scenarios below to produce scatter plots, determine the type of model demonstrated in each example and then answer the questions based on the graph you created.
Chapter 18 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
Knowledge Booster
Similar questions
- The U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_forwardData table Month October November December Print ← Maureen Bly is the new manager of the materials storeroom for Parr Manufacturing. Maureen has been ask Maureen has purchase cost and quantity data for the past 9 months as follows: (Click the icon to view the data for the past 9 months.) Estimated monthly purchases for this part based on expected demand of the two products for the rest of the (Click the icon to view the expected demand for the rest of the year.) Purchase Quantity Expected 3,380 parts 3,780 3,070 Done Celeulator - X R Square er in Maureen's office is down, and Maureen has been asked to immediately pr ow method to estimate a cost equation. What equation does she get? $ 1,067 +($ 4 Quantity purchased X Variable 1 Regression Statistics uation from requirement 1, calculate the future expected purchase costs for ea High-Low Method Expected Cost 14,587 16,187 13,347 se Quantity Expected 3,380 parts 3,780 parts 3,070 parts X $ $ t Stat Data table Month January February March…arrow_forwardThe line graphs in Figure show the percentages of marriages ending in divorce based on the wife’s age at marriage.Here are two mathematical models that approximate the data displayed by the line graphs:In each model, the variable n is the number of years after marriage and the variable d is the percentage of marriages ending in divorce.a. Use the appropriate formula to determine the percentage of marriagesending in divorce after 10 years when the wife is over 25 at the time ofmarriage.b. Use the appropriate line graph in Figure to determine the percentageof marriages ending in divorce after 10 years when the wife is over 25 at the time of marriage.c. Does the value given by the mathematical model underestimate or overestimate the actual percentage of marriages ending in divorce after10 years as shown by the graph? By how much?arrow_forward
- Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. Note: See the formula sheet on the next page. P.S.: I can't attach the formula sheet in this because it has variuos symbols, such as Sigma, log, x value etc. I uploaded the formula sheet and the question as well in the chat box. Please let me know if you need any more information.arrow_forwardA time series plot showing the national murder rates per 100,000 people in the United States for the years 1990 to 2010 is shown below. Approximate the change in homicide rate from 2000 to 2010. National Homicide Rates, United States Homicide rate per 100,000 people 10 6 8 7 9 С & 1990 Select one: Oa. -0.4 O b. -0.7 C. -1 d. -1.2 1992 Clear my choice 1994 1996 1998 2000 2002 2004 2006 2008 Year 2010arrow_forwardThe creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. Click on the datafile logo to reference the data. The datafile logo. Month Downloads Month Downloads (previous year) (thousands) (current year) (thousands) February 33.0 January 31.0 March 34.0 February 32.0 April 34.0 March 33.0 May 31.0 April 34.0 June 32.0 May 33.0 July 33.0 June 32.0 August 35.0 July 35.0 September 36.0 August 33.0 October 37.0 September 33.0 November 34.0 October 31.0 December 35.0 a. Compute the mean, median, and mode for number of downloads in the previous year. Mean (to 3 decimals) thousand Median (to 2 decimal) thousand Mode (to 2 decimal) thousand b. Compute the mean, median, and mode for number of downloads in the current year. Mean (to 3 decimals) thousand Median (to 2…arrow_forward
- Bob is a photographer who sells prints on consignment. Each week during the summer, Bob checks the inventory so that he can replenish the prints that have been sold. The following data show the number of prints sold each week during the last eight weeks. Complete parts a through e below. Week 6 2 10 3 9 4 16 Sold 14 1 17 a) Forecast the demand for Week 9 using a two-period simple moving average. The forecasted demand for Week 9 using a two-period simple moving average is. (Type an integer or a decimal. Do not round.) b) Calculate the MAD for the forecast in part a. MAD = (Round to two decimal places as needed.) c) Forecast the demand for Week 9 using a three-period simple moving average. The forecasted demand for Week 9 using a three-period simple moving average is (Round to two decimal places as needed.) d) Calculate the MAD for the forecast in part c. MAD= 0 (Round to two decimal places as needed.) e) Which forecast should you choose? Choose the correct answer below. O A. Choose the…arrow_forwardthe values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?arrow_forwardWeekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute each forecast. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage