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

The pythagorean theorem, Write an equation you could use to find the length...

Write an equation you could use to find the length of the missing side of each right triangle. Then find the missing length. Round to the nearest tenth if neccessary...

Casestudy, How should Shoppers? Stop develop its demand forecasts?

How should Shoppers? Stop develop its demand forecasts?

Oligopoly market, Oligopoly Market The majority of the world’s diamonds com...

Oligopoly Market The majority of the world’s diamonds comes from Country A and Country B. Suppose that the marginal cost of mining a diamond is $1,000 per diamond and that the dema

Define the publicity - promotion, Define the Publicity - Promotion Th...

Define the Publicity - Promotion This is a non-paid process of generating wide range of communication to contribute a favourable attitude towards product and organisation.  Y

Consumer surplus, Initially supply falls as goods may be destroyed. As the ...

Initially supply falls as goods may be destroyed. As the disaster strikes, the demand also rises in anticipation of more supply disruptions as people want to 'stock up' on the good

What is meant by marketing research, QUESTION (a) What should managemen...

QUESTION (a) What should management do at the time of Maturity stage to avoid decline of a product? Explain your answer with the help of different approaches at this stage. Sug

Define the media-frequency in advertisement, Q. Define the Media-Frequency ...

Q. Define the Media-Frequency in advertisement? Media-Frequency: Media-frequency demotes to average number of times the audience is exposed to media-vehicle in a specific per

Marketing, identify and briefly describe four treands in the macro/market

identify and briefly describe four treands in the macro/market

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