Time Series Analysis Predicting Future Hiking Shoe Demand - Download the Hiking Shoe Demand Time Series dataset in Excel which has hiking shoe sales over 48 months from January 2021 to December 2024. (Hint: It may be helpful to complete Lab 8-6 before completing this problem). Required: Answer the following questions based on the information provided. Note: Round your answers to 2 decimal places. Question 2. What is the expected hiking shoe demand in December 2026? 3. What is the upper limit (upper confidence bound) in November 2025? 4. What is the lower limit (lower confidence bound) in November 2025? Answer 144.41

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter8: Time Series Analysis And_forecasting
Section: Chapter Questions
Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...
icon
Related questions
Question

Answer 1 and 2 please!!! here is the data you needf: 

Month Monthly Product Demand
2021-01-01 100.32
2021-02-01 102.57
2021-03-01 103.32
2021-04-01 104.45
2021-05-01 108.78
2021-06-01 110.10
2021-07-01 112.99
2021-08-01 113.27
2021-09-01 108.22
2021-10-01 107.20
2021-11-01 114.90
2021-12-01 117.88
2022-01-01 104.92
2022-02-01 112.06
2022-03-01 112.56
2022-04-01 109.18
2022-05-01 111.41
2022-06-01 112.62
2022-07-01 122.41
2022-08-01 124.90
2022-09-01 111.65
2022-10-01 115.37
2022-11-01 120.23
2022-12-01 120.64
2023-01-01 106.34
2023-02-01 115.43
2023-03-01 119.18
2023-04-01 110.58
2023-05-01 112.89
2023-06-01 117.91
2023-07-01 123.61
2023-08-01 128.75
2023-09-01 117.18
2023-10-01 124.42
2023-11-01 128.22
2023-12-01 121.14
2024-01-01 108.70
2024-02-01 120.23
2024-03-01 130.26
2024-04-01 115.35
2024-05-01 116.74
2024-06-01 128.81
2024-07-01 130.88
2024-08-01 132.19
2024-09-01 129.45
2024-10-01 129.72
2024-11-01 137.30
2024-12-01 131.99
Time Series Analysis Predicting Future Hiking Shoe Demand - Download the Hiking Shoe Demand Time Series dataset in Excel which
has hiking shoe sales over 48 months from January 2021 to December 2024. (Hint: It may be helpful to complete Lab 8-6 before
completing this problem).
Required:
Answer the following questions based on the information provided.
Note: Round your answers to 2 decimal places.
Question
2. What is the expected hiking shoe demand in December 2026?
3. What is the upper limit (upper confidence bound) in November 2025?
4. What is the lower limit (lower confidence bound) in November 2025?
Answer
144.41
Transcribed Image Text:Time Series Analysis Predicting Future Hiking Shoe Demand - Download the Hiking Shoe Demand Time Series dataset in Excel which has hiking shoe sales over 48 months from January 2021 to December 2024. (Hint: It may be helpful to complete Lab 8-6 before completing this problem). Required: Answer the following questions based on the information provided. Note: Round your answers to 2 decimal places. Question 2. What is the expected hiking shoe demand in December 2026? 3. What is the upper limit (upper confidence bound) in November 2025? 4. What is the lower limit (lower confidence bound) in November 2025? Answer 144.41
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning