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 2SR
a.
To determine
To draw: The graph of the given time series data.
b.
To determine
To describe: The given time series data.
c.
To determine
To explain: The reason that forecasting with forecasting with simple exponential smoothing is appropriate for the given time series.
d.
To determine
To calculate: The simple exponential smoothing forecast model with a smoothing constant of
e.
To determine
To calculate: The forecast using simple exponential smoothing forecast model with a smoothing constant of
f.
To determine
To calculate: The simple exponential smoothing forecast model with a smoothing constant of
g.
To determine
To explain: The better of simple exponential smoothing forecast model with a smoothing constant of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
No need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.
Cynthia’s Design Studios had sales in the last four months of $12,700, $14,500, $19,100, and $15,800. Sales are related to how many designers Cynthia has on duty. The sales forecast helps her decide on the proper staffing levels.
What is the forecast for the fifth month using a two-period moving average?
What is the forecast for the fifth month using = 0.8 in an exponential smoothing model with A4 = $15,800 and F4 = $17,913 to get things started.
The accompanying data represent health care expenditures per capita (per person) as a percentage of the U.S. gross domestic product (GDP) from 2007 to 2013. Gross domestic product is the total value of all goods and services created during the course
of the year Complete parts (a) through (c) below.
Click the icon to view the data table.
(a) Construct a time-series plot that a politician would create to support the position that health care expenditures are increasing and must be slowed. Choose the correct graph below
OD.
O C.
OB
OA
A
Q
A
Q
Q
25,000+
11,000
Q
Q
3
2
G
HIER
11200
2H
7,000++
C
2013
of
+
2013
2007
2007
Year
Year
Year
(b) Construct a time-series plot that the health care industry would create to refute the opinion of the politician. Choose the correct graph below.
OB.
O C.
O A.
A
Q
A
Q
11,000
Q
(C)
7,000+
201
20
7.000+++++++*
2007
2007
2013
2013
Year
Year
(c) Explain how different measures may be used to support two completely different positions. Choose the correct answer…
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 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_forwardDVD Player sales The table shows the number of DVD play-ers sold in a small electronics store in the years 2003-2013. What was the average rate of change of sales between 2003 and 2013? Whatwas the average rate of change of sales between 2003 and 2004? What was the average rate of change of sales between 2004 and 2005? Between which two successive years did DVD player sales increase most quickly?arrow_forward
- Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?arrow_forwardStock Market The week of September 15, 2008 was one of the most volatile weeks ever for the US stock market. The closing numbers of the Dow Jones Industrial Average each day were: What was the overall change for the week? Was it positive or negative?arrow_forwardEloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yesarrow_forward
- Please do it in Excell..arrow_forwardUnited Dairies, Inc., supplies milk to several independent grocers throughout DadeC ounty, Florida. Managers at United Dairies want to develop a forecast of the number ofhalf gallons of milk sold per week. Sales data for the past 12 weeks are: a. Construct a time series plot. What type of pattern exists in the data?b. Use exponential smoothing with a 5 0.4 to develop a forecast of demand for week 13.What is the resulting MSE?arrow_forwardCryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)arrow_forward
- An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points) Quarter Percent change in income Percent Change in appliance sold Quarter Percent change in income Percent change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 (a) What forecasting model should be used for this data. Why?(5(b) Develop the forecasting model that you have proposed in (a).(c) Compute the relationship for these data. In your opinion, is the relationship between independentvariable…arrow_forwardHi, Could you please help me. I can't get on the X-axis the correct years to show up in minitab. Thank you!arrow_forwardSuppose that you are a researcher and wish to construct a linear mathematical (statistical) model that relates the number of years and the corresponding exports (million U.S.$) of a country. The constructed model may use to forecasts the future values. You have obtained the relevant data for the during of 1990 to 1995 and you have listed the data in Table 5. Table 5. Shows the list of the amount that have earned on exports Year No. 1 2 3 4 5 6 Exports 4954 6131 6904 6813 6803 8137 (a) Construct a suitable graph that explains the relationship between the number of years and the corresponding exports. (b) Construct a mathematical (Statistical) model by using least square method between number of years and the corresponding sales. (c) Interpret the slope of the estimated linear model (d) Forecast the value of exports by using the estimated linear model for the year of 2000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice UniversityCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning