Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

lab 5 contains several months or can volume data tor a help desk. In addition to the date and the call volume, the data set

image text in transcribed
lab 5 contains several months or can volume data tor a help desk. In addition to the date and the call volume, the data set has been coded with the weekday. (Note: review formulas to see how the day of week was calculated from the date) A binary indicator has also been created to mark holidays; days when the company was closed for business but the call center was still open. Do the following: - Use Data Mining or R to generate a Double Exponential Smoothing forecast with optimized parameters. Forecast for 10 days 0 Paste the Actual vs Forecast plot for the training data into the template 0 Paste the Forecast into your template - Repeat the process for a multiplicative Holt-Winter model forecast with optimized parameters. Make sure to indicate the 5 period seasonality - Convert the Day of Week Name data into Dummy Variables - Perform a linear regression analysis using the day (obs#), day of week binaries (exclude Friday as the base case), and holiday binary indicators as X variables. 0 Paste the Regression Model output (coefficients and ANOVA) into your template. - Create a forecast for the next 10 days and paste it into your template. (Score the data on Tab 3a. If using R use the data on TabBaR) - Comment on which forecast you think would be the most accurate

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

Step: 3

blur-text-image

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

Strategic management concepts

Authors: Fred david

13th Edition

9780136120988, 136120997, 136120989, 978-0136120995

More Books

Students also viewed these General Management questions