What is the trend equation based in the regression analysis? ( negative amounts should be indicated by minus sighn. Round your answer to 2 decimal places and other answer to 3 decimal places.) Annual U.S Grocery sales= _______ + ________ years. e. what is the predicted an

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
d-3. What is the trend equation based in the regression analysis? ( negative amounts should be indicated by minus sighn. Round your answer to 2 decimal places and other answer to 3 decimal places.) Annual U.S Grocery sales= _______ + ________ years. e. what is the predicted annual change of industry sales? ( round your answer to 3 decimal places) Predicted annual change of industry sales ________ million per year f. Using the trend model, forecast the next three years of grocery sales.( round to 2 decimal places) Year. Annual grocery sales 2018. _________millions 2019. _________ millions 2020. _________millions
Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars.
Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased
Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions.
Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following
table, respond to the following items.
Year
Sales
$511, 222
510,033
520, 750
2008
2009
2010
2011
547,476
563, 645
574,547
599, 603
613,159
625, 295
639, 161
2012
2013
2014
2015
2016
2017
Transcribed Image Text:Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items. Year Sales $511, 222 510,033 520, 750 2008 2009 2010 2011 547,476 563, 645 574,547 599, 603 613,159 625, 295 639, 161 2012 2013 2014 2015 2016 2017
d-1. Compute all possible forecasts using a trend forecasting model using sımple linear regression? (Round your answers to 2 decimal
places.)
Period
Sales
Predicted Sales
Absolute Error
2008
511,222
2009
510,033
2010
520,750
2011
547,476
2012
563,645
2013
574,547
2014
599,603
2015
613,159
2016
625,295
2017
639,161
d-2. What is the MAD? (Round your answer to 2 decimal places.)
MAD
Transcribed Image Text:d-1. Compute all possible forecasts using a trend forecasting model using sımple linear regression? (Round your answers to 2 decimal places.) Period Sales Predicted Sales Absolute Error 2008 511,222 2009 510,033 2010 520,750 2011 547,476 2012 563,645 2013 574,547 2014 599,603 2015 613,159 2016 625,295 2017 639,161 d-2. What is the MAD? (Round your answer to 2 decimal places.) MAD
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman