Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Applications of forecasting and regression techniques in business Case study Daily sales of industrial Vacuum cleaners over two months from September 2021 to October 2021
Applications of forecasting and regression techniques in business Case study Daily sales of industrial Vacuum cleaners over two months from September 2021 to October 2021 are presented in the Excel sheet "Sales Spring 2022" T- Using those forecasting methods to determine the sales for vacuum cleaners from 20/10/2021 to 01/11/2021 1- The moving average with 3 periods 2- The weighted moving average with 3 periods, determine the sales for vacuum cleaners, use 9,6,3 for the weights of the most recent, second most recent, and third most recent, respectively. 3- The exponential smoothing, assume the initial forecast for 19/10/2021 is 10,000, the smoothing constant selected is 0.2 4- Evaluate the accuracy of each of these methods 5- Which of the 3 methods provides a more accurate forecast. II- 1- Prepare a graph of the data, discuss any apparent trend and seasonal patterns 2- Use regression to develop a trend line that could be used to forecast daily sales for the next month 3- we want to test the significance of the regression model constructed earlier, by conducting the hypothesis test and Constructing the ANOVA table. Perform the test at the significance level a = 0.05 =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started