Business analysis of Amazon Sales and Marketing: The effect of changes in advertising budget on sales. VBA coding.
you need to analyse Ad Price Index
Sales & Marketing Notes for Amazon
Your data file contains information on the log of Sales, log of Advertising Budget, and other variables for the Amazon Kindle. The demographic variables pertain to the population living in the 400 regions that were sampled at one point in time. Note that the Ad Price Index variable is an index for the price of advertising in each region. You should assume this index has no impact on Sales per se. Treat these data as a sample provided to you by the company.
please find the attached file for Ad Price Index Variable (in log values)