Problem 14.5 E Question Help ? oo venience store ecentiy started o oarry a new b
ID: 3374500 • Letter: P
Question
Problem 14.5 E Question Help ? oo venience store ecentiy started o oarry a new brand o soft drink. Management s merested n estmating uture sales volume to determine whether t snould oont nue to carry the new brand or recoce t w r another brand. The ollowing table pro e the number o oans sold per week use boon the trend proiection with regression and the exponenial smoot ng let ?-0.4 with an intal oreoast for week 1 of 659) methods to orecast demand or week 13. Compare these memod, by us ng the mean absolute de labon and mean absolute percent error perior ance cmena Does your analysis upgest that saes are trending and it so, by how much? Obcain the trend projscion with regreasion foracast. Tha toracast tor wesk 13Enter your reaponse rounded to she naaraat whoie number)Explanation / Answer
Using regression in Excel or in R, or in Minitab
We get
Y^=556.515+15.549*x
X=13
Y^=556.515+15.549*13=758.6
Hence 759