This is the information and question I was given (verbatim).

4. (6 points) a. Key the payment rates into Excel from the 1993-2005 period as shown in Tables 4 and 5 and create line graph containing both of those data series. Give it a title, make sure the axis values are appropriate and it is understandable and professional. Paste that graph here.

b. Are these values stable over the time period? Explain any fluctuations (or lack of) you see. Take into account economic events that occurred during those years and other information that you might see in the graphs and tables.

Table 4 Estimated protability of the last bagel eaten (when both products delivered). Year 1993 1994 1995 1996 1997 1998 1999 2000 200] 2002 2003 2004 2005 Average over all years [1) Average posted price of bagel 0.647 0.750 0.750 0.750 0.750 0.787 0.850 0.850 0.850 0.850 0.954 [000 l.000 0.843 (2) Marginal cost of bagel 0.210 0.200 0.202. 0.211 0.221 0.253 0.282 0.294 0.307 0.301 0.334 0.369 0.373 0.281 (3) Payment rate 0.908 0.894 0.888 0.884 0.882. 0.874 0.883 0.882 0.880 0.900 0.894 0.893 0.902 0.890 (4) Probability all but one bagel eaten 0.456 0.426 0.466 0.472 0.463 0.469 0.563 0.634 0.605 0.560 0.522 0.585 0.575 0.530 [5) Probability all bagels eaten 0.365 0.328 0.354 0.354 0.358 0.360 0.430 0.487 0.447 0.411 0.373 0.412 0.405 0.395 Table 5 Estimated profitability of the last donut eaten (when both products delivered). (1) (2) (3) (4) (5) Year Average Marginal Payment rate Probability all Probability posted cost of but one donut all donuts price of donut eaten eaten donut 1993 0.500 0.204 0.908 0.853 0.723 1994 0.500 0.214 0.894 0.840 0.700 1995 0.500 0.215 0.888 0.841 0.695 1996 0.500 0.224 0.884 0.822 0.670 1997 0.500 0.228 0.882 0.853 0.703 1998 0.500 0.227 0.874 0.832 0.670 1999 0.500 0.229 0.883 0.777 0.615 2000 0.500 0.263 0.882 0.756 0.605 2001 0.500 0.197 0.880 0.653 0.512 2002 0.500 0.197 0.900 0.660 0.520 2003 0.500 0.211 0.894 0.676 0.545 2004 0.500 0.209 0.893 0.692 0.553 2005 0.575 0.225 0.902 0.630 0.471 Average 0.507 0.219 0.890 0.751 0.605 over all yearsBagel and Donut Payment Rate by Year 0.920 0.910 0.900 0.890 Payment Rate 0.880 0.870 0.860 0.850 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 Series1 0.908 0.894 0.888 0.884 0.882 0.874 0.883 0.882 0.880 0.900 0.894 0.893 0.902 Series2 0.908 0.894 0.888 0.884 0.882 0.874 0.883 0.882 0.880 0.900 0.894 0.893 0.902 Years Series1 Series2