Purchase Solution

Regression model to forecast sales of cold beverages for the

Not what you're looking for?

Ask Custom Question

Need to come up with a regression model to forecast monthly sales of cold beverages for the next year. What variables might be included in the model?

Please explain regression model(s) and the reason for the variables for the model.

Purchase this Solution

Solution Summary

The solution provides detailed explanations and answer for the problem including work in the Excel file.

Solution Preview

The monthly sales of cold beverages can be a function of the following variable:
1. Weather (W), i.e. average monthly temperature.
2. The seasonality (S), i.e. December (Christmas/NewYear), Summer.
3. The variability (V) of products on offer.
That's all I think of at the moment. If you have more you can certainly account for them.
Any regression model should be a multi-variable regression. So sales of cold beverage can be expressed as:
Sales = a*W + b*S + c*V + d

To help you understand better. I'm including an example. For problem description, please see posting 78450 in the solution library. In this ...

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.