Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Structural Foundations Of Monetary Policy

Authors: Michael D. Bordo, John H. Cochrane, Amit Seru

1st Edition

0817921346, 978-0817921347

More Books

Students also viewed these Finance questions