The following data report total, monthly, U.S. grocery store sales in millions of dollars from January 2017 to December

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

The following data report total, monthly, U.S. grocery store sales in millions of dollars from January 2017 to December

Post by answerhappygod »

The Following Data Report Total Monthly U S Grocery Store Sales In Millions Of Dollars From January 2017 To December 1
The Following Data Report Total Monthly U S Grocery Store Sales In Millions Of Dollars From January 2017 To December 1 (54.7 KiB) Viewed 42 times
The following data report total, monthly, U.S. grocery store sales in millions of dollars from January 2017 to December 2018. (On the site https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the data for many retail sectors of the economy.) Year Month ($ Sales millions) $ 52,256 48,835 2017 Jan 2017 Feb 2017 Mar 53,811 2017 Apr 53,012 2017 May 54,979 2017 Jun 53,441 2017 Jul 54,359 2017 Aug 54,269 2017 Sep 53,365 2017 Oct 53,796 2017 Nov 54,691 2017 Dec 58,347 2018 Jan 54,336 2018 Feb 50,547 2018 Mar 56,955 2018 Apr 53,336 2018 May 57,535 2018 Jun 55,749 2018 Jul 56,372 2018 Aug 56,673 2018 Sep 54,568 2018 Oct 55,730 2018 Nov 56,307 2018 Dec 58,769
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Sales ($ Million) Trend Index Forecast Absolute Error 1 1 2 2 3 3 4 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Jan-2017 Feb-2017 Mar-2017 Apr-2017 May-2017 Jun-2017 Jul-2017 Aug-2017 Sep-2017 Oct-2017 Nov-2017 Dec-2017 Jan-2018 Feb-2018 Mar-2018 Apr-2018 May-2018 Jun-2018 Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018 52,256 48,835 53,811 53,012 54,979 53,441 54,359 54,269 53,365 53,796 54,691 58,347 54,336 50,547 56,955 53,336 57,535 55,749 56,372 56,673 54,568 55,730 56,307 58,769 MAD
e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 2 3₂ 4 5 6 7 00 8 9 10 11 12
f. Forecast sales for January, February, March, and April of 2019. (Round your answers to 3 decimal places.) Forecasted Slaes Period 25 Sales million Period 26 Sales million Period 27 Sales million Period 28 Sales million
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”