Question
Use the multiplicative decomposition model on these data. Use this model to forecast sales for each month of the next year. Discuss why the slope
Use the multiplicative decomposition model on these data. Use this model to forecast sales for each month of the next year. Discuss why the slope of the trend equation with this model is so different from that of the trend equation in Question 2. Based on these data, which model is better and why? Monthly Revenue (in $1,000s) Month 2008 2009 2010 January 438 444 450 February 420 425 438 March 414 423 434 April 318 331 338 May 306 318 331 June 240 245 254 July 240 255 264 August 216 223 231 September 198 210 224 October 225 233 243 November 270 278 289 December 315 322 335 I know the answer is Y=294.069 + 0.859X The question I want answers is the steps how to solve in "QM Excel?" Thank you
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