In excel can you provide the following:
Total marketing effort is a term used to describe the critical decision factors that affect demand: price, advertising, distribution, and product quality. Let the variable x represent total marketing effort. A typical model that is used to predict demand as a function of total marketing effort is
D = axb
Suppose that a is a positive number. Different model forms result from varying the constant
b. Sketch the graphs of this model for b = 0, b = 1, 0 6 b 6 1, b 6 0, and b 7 1. What does each model tell you about the relationship between demand and marketing effort? What assumptions are implied? Are they reasonable? How would you go about selecting the appropriate model?