Create a graph of widget sales, Marketing Management

Q1 Create a graph of widget sales on the tab "Q1-Graph" and characterize the time series.  That is, does the time series appear to include the effects of (1) cyclicality, (1) seasonality, (1) trend, (1) irregular variation and, or (1) noise?  Please characterize each effect as appropriate.

Q2 Prepare the following forecasting methods using the template provided on "Data" tab and assess how well each method is performing (RSFE, MAD, MSE, and MAPE using the appropriate columns from I-AF) and indicate which method is performing the best and why:

A. 3-month moving average (use "Data" tab, column C)

B. 6-month moving average (use "Data" tab, column D)

C. 3-month weighted moving average (.65, .2, .15) (use "Data" tab, column E)

D. Single exponential smoothing (α=.3), enter smoothing constant into cell F2 and use this cell in the calculations for SES (Use "Data" tab, column F)

Q3:  Create a graph of widget Sales on tab "Q3-Graph" and then add to the graph the forecasts that you calculated in Q2.

Posted Date: 2/25/2013 6:03:22 AM | Location : United States







Related Discussions:- Create a graph of widget sales, Assignment Help, Ask Question on Create a graph of widget sales, Get Answer, Expert's Help, Create a graph of widget sales Discussions

Write discussion on Create a graph of widget sales
Your posts are moderated
Related Questions

List out the secondary sources of information while pursuing market research.

1. Isaac goes to an amusement park where tickets for the rides cost $25 per sheet and tickets for the shows cost $10 each. a. Write an expression that describes the amount of money

Question 1: (a) ‘Knowledge is more than just an accumulation of bits of information.' Explain this statement in the light of the knowledge pyramid and the different types of

Question: (a) Creating and managing teams in the workplace can lead to effective outcomes, but the success and longevity of teams in organizations will depend on how thoroughly


"The perimeter of a rectangle is 32 feet. The length is three times as long as the width. Find the length of the diagonal."

have to do case study for Pepcid AC Racing to OTC-- anyone have idea what are the weaknesses in this case?? Also, can you think think of any alternative solution besides either to

Problem (a) Why it is difficult to perform IP trace-back. (b) (i) Explain the packet marking approach to IP trace-back. (ii) What is the basic problem with this approach

Problem : a) A Mauritian consumer goods firm is deciding whether to enter the United States market or the Asian market. Show why it should take into account different marketing