Forecasting method, Marketing Management

Assignment Help:

Q :  Regress widget sales on time and add the (a) line, (b) linear equation and (c) R2 (variance explained) to the graph you created in Q3.  Please explain the meaning of each.   Also, please characterize the trend if one appears to exist in the data (be specific).

Q:  Take your understanding of seasonality from Q1 and use this understanding to employ a 3 month moving average to capture this seasonality effect.  Please describe your forecasting method in words (8) and then implement this forecasting method (forecast through period 33) in Excel (10) (use "Data" tab, column G).  Once you have completed implementing this method, assess its performance (RSFE, MAD, MSE, and MAPE using the appropriate columns I-AF). 

For example, suppose that you observe an 8 period season (see Figure 1).  You might develop a forecasting model for the NEXT SEASON that is based on observations from the PREVIOUS SEASON!  For a more specific example, (see Figure 1) a 3-period moving average forecast for period 13 might appropriately be based on an average of periods (4,5 & 6)!  To visualize this example, please see Figure 1.

 

Figure 1: Example of Seasonality (for example purposes only - - graph not based on actual exam data)

Q Consider both the forecasting method that you examined in Q5 in combination with the forecasting method that you examined in Q4.  Combine these two methods to create a new forecasting method.  Both describe this method in words (8) and implement this new forecasting method (forecast through period 33) in Excel (10) (use "Data" tab, column h). Once you have completed implementing this method, assess its performance (RSFE, MAD, MSE, MAPE using the appropriate columns I-AF) in comparison to the forecasts in Q2 and Q5 (1).  Why is this (or is this not) a better forecasting method (2)?


Related Discussions:- Forecasting method

What is direct marketing, What is Direct Marketing Growing utilisation ...

What is Direct Marketing Growing utilisation of direct marketing by organisations over recent years has been significant. It signals a shift in focus from mass to personalised

What is segment marketing, What is Segment Marketing? Segment Marketi...

What is Segment Marketing? Segment Marketing: A segment market comprises a large identifiable group in whole market. Company’s practice segment marketing recognizes which

Question, Discuss about the natural environment?

Discuss about the natural environment?

Last barrier to exchange in channels distribution, What is the working of f...

What is the working of final or last barrier to exchange in channels distribution? All problem are signifies the discrepancy of quantity and assortment within the exchange proc

What is structural realignment, What is Structural realignment Marketi...

What is Structural realignment Marketing communications agencies are attempting to adjust the way they can best serve interests of their clients. One of the results is structu

VALS model, I need help on making VALS model of Mobilink JAzz Octane. Plzzz...

I need help on making VALS model of Mobilink JAzz Octane. Plzzz help

Market or market segment , Michael Porter's Five Forces model is as applica...

Michael Porter's Five Forces model is as applicable today as when it was introduced. Select a market or market segment (jeans, cell phones, etc) and using Michael Porter's model, c

Marketing, Identify and briefly describe the four trends in the macro marke...

Identify and briefly describe the four trends in the macro market environment that will have or recently had an influence on the selected industry

Describe the marketing audit in detail, Question 1: Describe the market...

Question 1: Describe the marketing audit in detail. Characteristics of marketing audit Components of marketing audit Question 2: Explain consumer research p

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd