Chlorex, a household products company, has developed a natural, cold-water detergent called Nature Clean. The companys marketing

Chlorex, a household products company, has developed a natural, cold-water detergent called €œNature Clean.€ The company€™s marketing department thinks that sales jump when there are several major environmental (i.e., sustainability) episodes in the national media, such as an oil spill or the government issuing a major pollution report. Thus, the marketing department wants to develop a linear regression forecasting model that relates the number of €œgreen€ episodes reported monthly in the national media to monthly sales of the detergent. The marketing department had several staff members go through various media sources for the last two years and count the number of major national green episodes reported on, which, with monthly sales, is shown in the following table

Develop a linear regression model and determine the sales forecast if three green episodes are reported in the media. Discuss the value and usefulness of this type of relational forecast for Chlorex€™s detergentsales.

Transcribed Image Text:

Green Green Month Sales Episodes Month Sales Episodes 134,175 2 28,366 3 41,819 27,666 5 31,299 37,456 7 52,444 46,712 9 37,222 44,981 40,006 12 47,321 13 55,732 26,004 49,188 40,005 1738.,912 18 31,777 19 30,367 20 34,566 29,078 45,876 23 48,556 51,022 14 15 16 4 21 10 4 24