Problem: The marketing department at Pepsi is trying to determine if the organization should allocate more money in the future for advertising new beverages. Another brand was recently added to the Pepsi brand portfolio, Pepsi Jazz. Data was collected over the past 20 months to ascertain the actual amount spent and the amount of case sales the organization has realized. The marketing department wants these figures analyzed in order to appropriately allocate advertising funds for future product release.
First we need to determine the relationship between advertising and sales.
Perform regression analysis, showing all work.
Analysis of results and recommendations regarding how much money should be spent on advertising.
Data is included within the attachment.© BrainMass Inc. brainmass.com March 4, 2021, 7:51 pm ad1c9bdddf
This solution performs regression analysis.