Business analysis of Amazon Sales and Marketing: The effect of changes in advertising budget on sales.  VBA coding.

3000 words

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)