EBK STATISTICAL TECHNIQUES IN BUSINESS
17th Edition
ISBN: 9781259924163
Author: Lind
Publisher: MCGRAW HILL BOOK COMPANY
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 14E
To determine
Determine the linear trend equation.
Forecast the seasonally adjusted sales for 2017.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use regression analysis to estimate a linear trend line for annual sales.
Create a 2-D line chart of Cash Sales for months 1-18.
Add a trend line with a forward forecast of 3 periods to the chart. Be sure to include the R-squared value on the chart.
Using =TREND(), complete the forecast table for months 19-21
1
$ 2,145,600
19
2
$ 2,175,200
20
3
$ 2,255,200
21
4
$ 2,505,600
5
$ 2,748,800
6
$ 2,358,000
7
$ 3,165,200
8
$ 3,253,600
9
$ 3,484,000
10
$ 3,731,200
11
$ 3,741,200
12
$ 3,558,800
13
$ 3,771,200
14
$ 3,787,600
15
$ 3,813,600
16
$ 3,822,800
17
$ 3,828,000
18
$ 3,897,200
Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020.
You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5.
Month
Sales ($)
April
17,000
May
18,000
June
19,500
July
22,000
August
21,000
September
23,000
Chapter 18 Solutions
EBK STATISTICAL TECHNIQUES IN BUSINESS
Ch. 18 - Prob. 1SRCh. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 3SRCh. 18 - Prob. 7E
Ch. 18 - Prob. 8ECh. 18 - Prob. 4SRCh. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 5SRCh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17CECh. 18 - Prob. 18CECh. 18 - Prob. 19CECh. 18 - Prob. 20CECh. 18 - Prob. 21CECh. 18 - Prob. 22CECh. 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. 34DACh. 18 - Prob. 35DACh. 18 - Prob. 36DACh. 18 - Prob. 37DACh. 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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardThe 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_forwardTable 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forward
- discuss the trend analysis of the oil palm pricingarrow_forwardDetermine the equation of the trend line for the data shown below on Canadian balance of payments for exports of wheat over a five-year period provided by Statistics Canada. Using the trend line equation, forecast the value for the year 2014. Calculate the slope, intercept and the forecast 1. using the formulas 2. using the functions Year Export-Balance of Payments (Unadjusted) -Wheat ($ millions) 2008 569.2 2009 480.8 2010 365.7 2011 471 2012 508.6 By formula By Function SLOPE INTERCEPT FORECAST Please provide calculation in excel with step by step process for me to follow . thank youarrow_forwardA scatterplot with no linear trend will have an r value of zero true or false?arrow_forward
- find the equation of the trend linearrow_forwardCompare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?arrow_forwardIf we assume the linear trend existed before 1950 and continues after 2000, the states median house values will be (or were) equal in what year?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY