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

Show the advertising effects on employment, Q. Show the advertising effects...

Q. Show the advertising effects on Employment? Effect on Employment: - Advertising has created together direct and indirect employment to various persons in the society. Thes

Advantage of the direct marketing, Advantage of the direct marketing: ...

Advantage of the direct marketing: 1.       Focued approach: it is possible to identify a very specifc target using direct marketing techniques. This makes it a very useful

Discuss the significance of a customer retention strategy, Question 1: ...

Question 1: "Relationship Marketing is a new marketing paradigm which challenges the straight-jacket marketing mix approach." Evaluate this statement and illustrate with examp

Bcg matrix, how we can compare our product with other company''s product in...

how we can compare our product with other company''s product in BCG matrix

Test Marketing, What is test marketing and various approaches followed by F...

What is test marketing and various approaches followed by FMCG companies

Marketing manager, As marketing manager you have been assigned to promote a...

As marketing manager you have been assigned to promote a new product of beer. Your competitors are Angkor & Cambodia beer. Describe the factor that you would have to deal with to

Ingredient branding, what are the examples for ingredient branding?

what are the examples for ingredient branding?

#, market testing

market testing

Analysis of the business environment, Any lady outfit looks great if it is ...

Any lady outfit looks great if it is designed with style and fits well. To take that outfit up a notch just adds accessories such as, amongst others, jewellery, handbags, scarves a

What is psychographic or psychological segmentation, What is Psychographic ...

What is Psychographic or Psychological Segmentation? Psychographic/Psychological Segmentation: A Psychographic or Psychological characteristic taken as to inner character

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