Analyze how the value of a loyal customer (VLC) will change if the average customer defection rate varies between 15 and 40 percent (in increments of 5 percent) and the frequency of repurchase varies between three and nine times per year (in increments of one year). Sketch graphs (or use Excel charts) to illustrate the impact of these assumptions on the VLC. What’s the best way to graph this in excelling?