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 13E
a.
To determine
To draw: The graph of the provided time series data and draw the observations.
b.
To determine
To describe: The time series pattern.
c.
To determine
To explain: The reason that forecasting with a trend model is appropriate for the given time series.
d.
To determine
To calculate: A trend forecasting model using simple linear regression and the MAD.
e.
To determine
To state: The predicted annual change of industry sales.
f.
To determine
To calculate: The sales for the next three periods.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The accompanying table gives the stock market indices for a certain company on the stock market. Use simple linear regression to forecast the data. What would be
the forecasts for the next three days?
Click the icon to view the stock market indices for the company on the stock market.
Select the graph that shows the correct trendline forecast for the given data.
O Click here to view the graph d.
O
Click here to view the graph b.
•
Click here to view the graph a.
O
Click here to view the graph c
What would be the forecast for the next three days?
(Round to two decimal places as needed.)
Index
Date
10/2/2010
10/3/2010
10/4/2010
B
F
G
A
H
Date
Index
9/3/2010
10448.19
9/7/2010
10340.44
9/8/2010 10386.08
9/9/2010 10414.94
9/10/2010 10461.14
9/13/2010 10545.98
9/14/2010 10527.68
9/15/2010 10574.14
0 9/16/2010
10596.74
1 9/17/2010
10606.46
2 9/20/2010 10752.05
3 9/21/2010 10759.95
4 9/22/2010 10738.52
5 9/23/2010 10661.03
16 9/24/2010 10859.59
17 9/27/2010 10810.12
18 9/28/2010 10856.59
19…
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.
Please do it in Excell..
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_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
- Using your graphing calculator, make a scatter plot of the data from the table. Then graph your model from Question 2 along with the data. How well does your model fit the data? What could you do to try to improve your model?arrow_forwardLife Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardSales Barnes & Noble had annual sales of $6.8 billion in 2013 and $6.1 billion in 2015. Use the Midpoint Formula to estimate the sales in 2014. Assume that the annual sales followed a linear pattern.arrow_forward
- DVD 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_forwardWhat is regression analysis? Describe the process of performing regression analysis on a graphing utility.arrow_forwardDemand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00arrow_forward
- Does Table 1 represent a linear function? If so, finda linear equation that models the data.arrow_forwardPlease help me understand this problem show me how to do the work in excel. Question/ Use the data that i pasted below to answer this question. United Dairies, Inc., supplies milkto several independent grocers throughout Dade County, Florida. Managers at UnitedDairies want to develop a forecast of the number of half gallons of milk sold per week.a. Construct a time series plot. What type of pattern exists in the data?b. Use exponential smoothing with α = 0.4 to develop a forecast of demand for week13. What is the resulting MSE?c. Use a moving average with k = 4 to develop a forecast of demand for week 13.What is the resulting MSE?d. Using the above forecasting techniques, what is the forecasts for the next timeperiod? Week Sales 1 2750 2 3100 3 3250 4 2800 5 2900 6 3050 7 3300 8 3100 9 2950 10 3000 11 3200 12 3150arrow_forwardPerdisco Limited has shared their annual sales revenue over the last 6 financial years from 2010 to 2015. Year Sales ($ 000) 2010 4500 2011 5100 2012 4900 2013 5400 2014 5670 2015 6000 Using linear trend equation forecast the sales revenue of Perdisco Limited for 2016. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: 2013 (0.1), 2014 (0.3) and 2015(0.6). Please answer this question. this is not graded question. this is from book which is provided by my teacher for understanding concepts. Please solve this as i have finding difficulty in solving.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning