Use a real-life example to illustrate the process of validation of a regression using Microsoft Excel. Build a model to predict sales of a cold drink. For example, a model to predict sales of Coca-Cola based on multiple regression and then interpret the results.

• Do research to identify at least three of the most important determining factors which influence the sale of cold drinks.

• Create 20 hypothetical sets of sales data and determine the factors in the Excel sheet.