FIN 4934 Duke University Financial Modeling Excel Tasks

User Generated

qebfr007O

Business Finance

Fin 4934

Duke University

FIN

Description

Unformatted Attachment Preview

Task 1: (1) The daily returns of five different stocks as well as the daily returns of the S&P 500 are given. Convert the data to an Excel table and rename the table "TableDailyReturns." In the space provided, give the reason for why the source data should be converted to an Excel table. (2) Create a scatter plot of stock returns (y-axis) and market returns (S&P 500; x-axis) and use option buttons to dynamically select the stock for the plot. (The y-axis should not move as a different stock is selected.) (3) Add a linear trend line (the characteristic line) that also displays R2 and equation. (4) Make sure the chart title automatically changes when you select a different stock. The title must include the company name and the beta of the stock selected. (For example, "Amazon Characteristic Line with Beta = 1.62.") Date SnP500 Amazon Boing CitiGroup Dunkin Donuts Ebay 1/2/2018 0.83% 1.67% 0.65% -0.07% 1.68% 0.85% 1/3/2018 0.64% 1.28% 0.32% 0.31% 0.73% 3.05% 1/4/2018 0.40% 0.45% -0.38% 1.23% -1.64% -1.66% 1/5/2018 0.70% 1.62% 4.10% -0.13% -0.85% 2.90% 1/8/2018 0.17% 1.44% 0.42% -1.17% -0.02% 0.28% 1/9/2018 0.13% 0.47% 2.67% 1.05% -1.16% -0.68% 1/10/2018 -0.11% 0.13% 0.57% 0.45% -0.96% -4.63% 1/11/2018 0.70% 1.78% 2.45% -0.12% 0.27% 0.29% 1/12/2018 0.67% 2.23% 2.47% 1.69% 1.88% 0.56% 1/16/2018 -0.35% -0.03% -0.31% 0.35% -1.07% -0.89% 1/17/2018 0.94% -0.76% 4.73% 0.47% 0.14% 0.82% 1/18/2018 -0.16% -0.13% -3.09% -0.10% 2.04% 1.97% 1/19/2018 0.44% 0.10% -0.71% 1.18% -0.81% -0.80% 1/22/2018 0.81% 2.53% 0.08% 0.37% 0.31% 2.99% 1/23/2018 0.22% 2.65% -0.71% -0.05% 2.96% 0.48% 1/24/2018 -0.06% -0.37% -0.27% 1.15% 1.48% 0.13% 1/25/2018 0.06% 1.51% 2.52% -0.01% 1.05% 0.50% 1/26/2018 1.18% 1.75% 0.03% 0.81% -0.29% 2.17% 1/29/2018 -0.67% 1.11% -0.70% -0.15% -2.38% -0.22% 1/30/2018 -1.09% 1.42% -0.91% -1.68% -1.59% -0.98% 1/31/2018 0.05% 0.91% 4.93% -0.18% -1.30% 0.45% 2/1/2018 -0.06% -4.20% 0.73% 0.92% -0.57% 13.82% 2/2/2018 -2.12% 2.87% -2.25% -2.75% -3.02% -4.09% 2/5/2018 -4.10% -2.79% -5.74% -4.87% -2.41% -4.36% 2/6/2018 1.74% 3.80% 3.66% 2.12% -1.86% 0.99% 2/7/2018 -0.50% -1.81% 2.11% 0.23% -1.42% -1.08% 2/8/2018 -3.75% -4.68% -5.30% -4.16% 0.51% -3.09% 2/9/2018 1.49% -0.81% 0.96% 2.52% -1.00% 1.56% 2/12/2018 1.39% 3.48% 3.30% 1.47% 1.18% 1.58% 2/13/2018 0.26% 2.04% -0.19% 0.56% 0.57% -0.40% 2/14/2018 1.34% 2.58% 0.49% 2.04% 2.90% 0.69% Type your answe 2/15/2018 2/16/2018 2/20/2018 2/21/2018 2/22/2018 2/23/2018 2/26/2018 2/27/2018 2/28/2018 3/1/2018 3/2/2018 3/5/2018 3/6/2018 3/7/2018 3/8/2018 3/9/2018 3/12/2018 3/13/2018 3/14/2018 3/15/2018 3/16/2018 3/19/2018 3/20/2018 3/21/2018 3/22/2018 3/23/2018 3/26/2018 3/27/2018 3/28/2018 3/29/2018 4/2/2018 4/3/2018 4/4/2018 4/5/2018 4/6/2018 4/9/2018 4/10/2018 4/11/2018 4/12/2018 4/13/2018 4/16/2018 4/17/2018 4/18/2018 4/19/2018 4/20/2018 4/23/2018 4/24/2018 1.21% 0.04% -0.58% -0.55% 0.10% 1.60% 1.18% -1.27% -1.11% -1.33% 0.51% 1.10% 0.26% -0.05% 0.45% 1.74% -0.13% -0.64% -0.57% -0.08% 0.17% -1.42% 0.15% -0.18% -2.52% -2.10% 2.72% -1.73% -0.29% 1.38% -2.23% 1.26% 1.16% 0.69% -2.19% 0.33% 1.67% -0.55% 0.83% -0.29% 0.81% 1.07% 0.08% -0.57% -0.85% 0.01% -1.34% 0.74% -0.89% 1.36% 0.99% 0.16% 0.99% 1.46% -0.66% 0.03% -1.26% 0.46% 1.56% 0.92% 0.48% 0.44% 1.74% 1.24% -0.64% 0.18% -0.55% -0.67% -1.70% 2.69% -0.29% -2.34% -3.19% 4.03% -3.78% -4.38% 1.11% -5.21% 1.46% 1.33% 2.92% -3.20% 0.06% 2.14% -0.64% 1.50% -1.22% 0.75% 4.32% 1.60% 1.90% -1.89% -0.63% -3.81% 3.37% -0.40% -0.48% -0.28% 1.01% 0.21% 1.91% 0.32% -0.67% -3.46% -1.44% 2.34% -1.09% -0.54% 0.49% 1.66% -2.91% -1.60% -2.48% -0.08% 0.15% 0.39% 1.77% -0.16% -5.19% 0.43% 2.48% -2.39% -0.34% 2.46% -1.66% 2.60% -1.02% 2.74% -3.06% -1.12% 3.83% -2.23% 3.09% -2.43% 0.76% 1.49% 1.27% -0.11% -0.58% 0.05% -2.89% 0.48% -0.34% -0.47% 0.71% -0.95% 1.06% 0.74% -1.64% -1.17% -2.42% 0.03% 1.00% -0.48% -0.19% 0.26% 2.70% -0.12% -1.46% -1.92% -0.18% 0.18% -1.05% 0.30% 0.55% -4.11% -3.43% 2.77% -2.15% -0.03% -1.11% 0.31% 1.14% 1.21% 1.31% -2.31% 1.22% 1.54% -0.88% 3.21% -1.55% -1.32% -0.47% -1.09% 1.88% -0.40% -0.74% -0.52% 4.16% -1.94% -0.78% -2.33% 1.00% 1.09% -0.16% -0.94% -2.30% -2.47% 1.56% 0.22% 0.05% -0.08% 0.99% 0.78% -0.46% -0.78% -0.74% -0.07% 0.79% 0.25% 0.95% 0.73% -2.36% -0.66% 2.69% -2.01% 0.64% -0.20% -2.66% 1.46% 1.78% 0.27% -0.78% 0.65% 0.23% 0.10% 0.83% -0.74% -0.15% 0.00% 0.63% 0.64% -0.15% 0.79% -0.29% 1.34% 0.77% 0.12% -0.62% -0.67% 1.98% 0.34% -1.55% -0.67% -1.38% 1.61% 0.56% -0.12% 1.83% -0.57% 0.30% 0.21% -2.46% 0.02% -0.56% -0.31% -0.87% -0.31% -0.69% -2.62% -2.14% 3.27% -1.93% -0.27% 0.32% -2.19% 0.64% 0.45% 0.60% -2.35% -0.54% 1.83% 0.61% 1.76% -1.55% 0.73% 1.05% 2.81% 0.86% 0.21% -1.42% -1.01% 4/25/2018 4/26/2018 4/27/2018 4/30/2018 5/1/2018 5/2/2018 5/3/2018 5/4/2018 5/7/2018 5/8/2018 5/9/2018 5/10/2018 5/11/2018 5/14/2018 5/15/2018 5/16/2018 5/17/2018 5/18/2018 5/21/2018 5/22/2018 5/23/2018 5/24/2018 5/25/2018 5/29/2018 5/30/2018 5/31/2018 6/1/2018 6/4/2018 6/5/2018 6/6/2018 6/7/2018 6/8/2018 6/11/2018 6/12/2018 6/13/2018 6/14/2018 6/15/2018 6/18/2018 6/19/2018 6/20/2018 6/21/2018 6/22/2018 6/25/2018 6/26/2018 6/27/2018 6/28/2018 6/29/2018 0.18% 1.04% 0.11% -0.82% 0.25% -0.72% -0.23% 1.28% 0.35% -0.03% 0.97% 0.94% 0.17% 0.09% -0.68% 0.41% -0.09% -0.26% 0.74% -0.31% 0.32% -0.20% -0.24% -1.16% 1.27% -0.69% 1.08% 0.45% 0.07% 0.86% -0.07% 0.31% 0.11% 0.17% -0.40% 0.25% -0.10% -0.21% -0.40% 0.17% -0.63% 0.19% -1.37% 0.22% -0.86% 0.62% 0.08% 0.01% 3.96% 3.60% -0.41% 1.03% -0.80% 0.15% 0.56% 1.21% -0.48% 0.98% 0.07% -0.38% -0.09% -1.59% 0.71% -0.35% -0.47% 0.70% -0.26% 1.29% 0.08% 0.44% 0.17% 0.75% 0.29% 0.73% 1.45% 1.87% -0.04% -0.38% -0.31% 0.30% 0.57% 0.36% 1.11% -0.46% 0.46% 0.64% 0.88% -1.13% -0.84% -3.06% 1.68% -1.81% 2.47% -0.10% 4.19% -0.02% -0.56% -2.15% -1.21% -1.62% 2.00% 1.13% 1.79% -0.61% 1.81% -0.12% -0.47% 0.62% -0.72% -0.34% 0.93% 2.06% 3.61% -2.45% 1.18% -0.06% 0.30% -2.11% 1.62% -1.68% 1.29% 1.12% -0.17% 3.18% -0.82% 0.26% 0.39% -0.09% -1.83% -0.39% -1.25% -0.88% -3.84% 0.46% -1.47% 0.37% -2.27% 0.03% -0.45% 1.46% 0.26% 0.35% -0.26% -0.27% -1.04% -0.03% -0.38% -0.07% 0.00% 0.82% 3.65% 1.34% 0.86% 0.40% -0.33% 0.08% -1.00% -0.54% -2.24% 0.67% 0.92% -1.18% -1.32% -1.26% -3.99% 1.48% 0.01% 0.88% 0.09% -0.86% 2.20% 0.32% 0.03% -0.53% -0.73% -0.47% -1.68% 0.27% 0.62% 0.04% 0.90% 0.37% -0.64% -2.16% 0.85% -1.28% 2.17% 0.06% 1.62% -0.31% -2.29% 0.59% 2.21% -0.47% -0.08% 2.81% 0.61% 1.03% -1.24% 0.16% 1.70% -0.08% -0.22% 0.85% 0.49% 0.12% 0.27% -1.13% 1.04% 0.06% -1.36% -2.13% 0.64% -0.23% -0.39% 1.05% 1.04% 1.58% 1.32% 0.54% -0.45% 1.28% 0.04% 0.74% 0.09% 0.67% -0.22% 0.00% 0.71% 0.62% -0.79% -0.40% 0.33% -0.03% -0.10% -0.51% -5.59% -1.16% -0.92% -0.13% -1.72% 1.24% 0.96% -0.53% 0.79% 0.34% 0.71% -0.62% 0.34% -0.81% 0.71% 0.13% 0.00% -0.29% -1.36% 0.71% -0.66% 0.40% -1.08% 0.85% -0.34% 1.64% 1.90% 2.48% -0.22% 1.25% -0.40% 0.50% -0.10% -2.77% -0.84% -0.28% -0.08% 0.82% 0.20% -3.18% 0.21% -2.57% -0.11% -2.08% -0.44% 0.33% 7/2/2018 7/2/2018 7/5/2018 7/6/2018 7/9/2018 7/10/2018 7/11/2018 7/12/2018 7/13/2018 7/16/2018 7/17/2018 7/18/2018 7/19/2018 7/20/2018 7/23/2018 7/24/2018 7/25/2018 7/26/2018 7/27/2018 7/30/2018 7/31/2018 8/1/2018 8/2/2018 8/3/2018 8/6/2018 8/7/2018 8/8/2018 8/9/2018 8/10/2018 8/13/2018 8/14/2018 8/15/2018 8/16/2018 8/17/2018 8/20/2018 8/21/2018 8/22/2018 8/23/2018 8/24/2018 8/27/2018 8/28/2018 8/29/2018 8/30/2018 8/31/2018 9/4/2018 9/5/2018 9/6/2018 0.31% -0.49% 0.86% 0.85% 0.88% 0.35% -0.71% 0.87% 0.11% -0.10% 0.40% 0.22% -0.40% -0.09% 0.18% 0.48% 0.91% -0.30% -0.66% -0.58% 0.49% -0.10% 0.49% 0.46% 0.35% 0.28% -0.03% -0.14% -0.71% -0.40% 0.64% -0.76% 0.79% 0.33% 0.24% 0.21% -0.04% -0.17% 0.62% 0.77% 0.03% 0.57% -0.44% 0.01% -0.17% -0.28% -0.37% 0.82% -1.16% 0.34% 0.64% 1.66% 0.23% 0.68% 2.37% 0.91% 0.52% 1.18% -0.05% -1.63% 0.04% -0.65% 1.51% 1.88% -2.98% 0.51% -2.09% -0.10% 1.11% 2.07% -0.60% 1.34% 0.80% 1.29% 0.64% -0.64% 0.52% 1.24% -1.93% 0.21% -0.23% -0.29% 0.36% 1.14% -0.10% 0.13% 1.17% 0.27% 3.38% 0.21% 0.52% 1.33% -2.19% -1.83% 0.17% -0.94% 0.08% 0.44% 2.18% 1.53% -1.89% 1.59% 1.38% 1.51% 0.22% 0.94% -1.36% -0.12% -0.46% 1.42% -0.66% 0.96% 0.37% -2.66% 1.49% -0.99% -0.86% -0.37% -0.54% 1.21% -0.85% -1.17% -1.25% -0.31% 0.23% -2.18% 4.29% 0.12% 1.25% 0.86% -1.06% -0.73% 0.55% 1.25% -0.72% -0.29% -0.94% -1.18% 1.01% 0.12% 1.32% 0.36% -1.64% 0.76% 0.87% 2.68% -1.03% -0.47% 0.88% -2.20% 3.67% -0.16% 0.72% -1.23% 0.33% 1.43% 1.22% 0.91% -0.53% 0.49% 0.84% -0.55% 0.06% -0.13% 0.77% 0.01% 0.01% 0.66% -1.25% -2.39% -1.57% 1.23% -1.94% 1.33% 0.16% 1.23% 1.01% -0.17% -0.44% -0.20% 2.43% -0.01% 0.21% -1.48% -0.31% 0.22% -0.32% -1.49% -0.43% -0.31% 0.64% 1.70% 0.54% 0.62% 0.42% -0.97% 1.18% 0.34% 0.70% -0.17% 0.28% 1.04% -0.75% -1.78% -0.37% 0.41% -2.26% -1.01% 1.09% 0.07% 1.31% -0.11% -0.09% 0.51% 0.73% 0.43% -0.15% -1.43% 2.44% -0.11% 0.29% -0.08% 0.33% -1.17% 0.08% -0.22% -0.22% -0.04% 0.91% -0.35% -0.11% 1.63% 4.35% -0.71% 0.33% 1.13% -0.08% 1.06% 0.97% 1.39% -2.29% -0.16% 1.54% 0.16% 0.32% 0.21% 0.37% -10.12% 0.26% -1.20% -0.80% 1.10% 1.59% -1.80% -0.41% -0.65% -1.08% 0.39% 1.32% 0.98% -0.62% 0.18% 0.92% -0.18% -0.62% 1.53% -1.57% -0.27% 0.71% 0.03% 1.50% 0.49% -0.86% 0.38% 0.14% 0.46% 0.55% -0.37% -0.55% 0.55% -1.93% -1.38% 9/7/2018 9/10/2018 9/11/2018 9/12/2018 9/13/2018 9/14/2018 9/17/2018 9/18/2018 9/19/2018 9/20/2018 9/21/2018 9/24/2018 9/25/2018 9/26/2018 9/27/2018 9/28/2018 10/1/2018 10/2/2018 10/3/2018 10/4/2018 10/5/2018 10/8/2018 10/9/2018 10/10/2018 10/11/2018 10/12/2018 10/15/2018 10/16/2018 10/17/2018 10/18/2018 10/19/2018 10/22/2018 10/23/2018 10/24/2018 10/25/2018 10/26/2018 10/29/2018 10/30/2018 10/31/2018 11/1/2018 11/2/2018 11/5/2018 11/6/2018 11/7/2018 11/8/2018 11/9/2018 11/12/2018 -0.22% 0.19% 0.37% 0.04% 0.53% 0.03% -0.56% 0.54% 0.13% 0.78% -0.04% -0.35% -0.13% -0.33% 0.28% 0.00% 0.36% -0.04% 0.07% -0.82% -0.55% -0.04% -0.14% -3.29% -2.06% 1.42% -0.59% 2.15% -0.03% -1.44% -0.04% -0.43% -0.55% -3.09% 1.86% -1.73% -0.66% 1.57% 1.09% 1.06% -0.63% 0.56% 0.63% 2.12% -0.25% -0.92% -1.97% -0.32% -0.67% 2.48% 0.14% -0.01% -0.99% -3.16% 1.73% -0.75% 0.93% -1.51% 1.01% 2.08% 0.02% 1.93% -0.50% 0.07% -1.65% -0.94% -2.22% -1.04% -1.34% 0.32% -6.15% -2.04% 4.03% -1.55% 3.35% 0.65% -3.33% -0.38% 1.43% -1.15% -5.91% 7.09% -7.82% -6.33% -0.55% 4.42% 4.23% 0.00% -2.27% 0.92% 6.86% -0.03% -2.42% -4.41% -0.57% -2.12% 0.99% 2.36% 0.58% 1.22% -1.07% 2.14% 0.45% 0.61% 1.30% -1.14% -0.21% -0.60% 0.65% 1.23% 2.79% 1.07% 1.53% -0.59% -0.90% -0.18% -0.09% -4.66% -2.55% 0.56% -0.34% 2.61% -0.75% -1.68% -0.86% -0.08% -1.67% 1.31% 2.57% -1.24% -6.59% 4.27% 1.41% 2.31% -1.47% 1.18% 1.24% 1.51% -0.34% -0.39% -3.33% -0.67% -0.01% -0.29% 1.56% -0.51% 0.56% 0.48% 0.68% 3.31% 1.45% -0.86% -0.42% -0.45% -1.44% 0.69% -1.66% 0.26% -0.18% 0.78% 0.36% -0.28% 0.23% -0.96% -2.70% -2.24% 2.14% -0.90% 0.72% 0.19% -1.75% 0.35% -3.30% -1.29% -2.94% 1.83% -1.17% 0.22% 0.28% 1.44% 0.57% 0.14% 2.09% -0.92% 2.37% -0.70% -2.98% -2.36% 0.99% -0.27% -0.63% 0.49% -0.24% -2.30% -1.52% 0.97% 0.24% 0.14% -1.12% -0.65% 1.33% 0.26% -0.12% -0.23% -1.30% -1.48% -0.86% 0.59% -0.21% 0.28% 2.61% -1.85% -1.51% 1.48% 1.61% 1.41% 0.30% -1.10% -1.35% -0.17% 0.11% -3.06% 4.78% -1.30% -2.61% 3.50% -1.04% -1.16% 0.54% -0.17% 1.32% 1.07% 1.42% -0.35% -1.50% 0.98% -0.82% 1.19% 0.44% 0.53% -0.99% 0.29% -0.23% 0.29% 0.06% -0.58% -0.94% -2.85% 2.50% -0.71% -0.96% -1.54% 0.15% 0.58% -0.37% -1.20% 1.05% 2.15% -4.84% -0.85% 1.02% 0.44% 1.22% -0.71% -1.47% -8.87% -0.90% -1.05% -3.19% 2.82% -2.57% -1.90% 2.24% 5.87% 1.69% 1.19% -0.77% 1.05% -0.30% -0.07% -0.70% -2.26% 11/13/2018 11/14/2018 11/15/2018 11/16/2018 11/19/2018 11/20/2018 11/21/2018 11/22/2018 11/26/2018 11/27/2018 11/28/2018 11/29/2018 11/30/2018 12/3/2018 12/4/2018 12/6/2018 12/7/2018 12/10/2018 12/11/2018 12/12/2018 12/13/2018 12/14/2018 12/17/2018 12/18/2018 12/19/2018 12/20/2018 12/21/2018 12/23/2018 12/26/2018 12/27/2018 12/28/2018 -0.15% -0.76% 1.06% 0.22% -1.66% -1.82% 0.30% -0.66% 1.55% 0.33% 2.30% -0.22% 0.82% 1.09% -3.24% -0.15% -2.33% 0.18% -0.04% 0.54% -0.02% -1.91% -2.08% 0.01% -1.54% -1.58% -2.06% -2.71% 4.96% 0.86% -0.12% -0.35% -1.97% 1.28% -1.61% -5.09% -1.11% 1.42% -0.97% 5.28% 0.01% 6.09% -0.25% 0.99% 4.86% -5.87% 1.85% -4.12% 0.73% 0.13% 1.24% -0.31% -4.01% -4.46% 2.01% -3.64% -2.29% -5.71% -2.43% 9.45% -0.63% 1.12% -2.11% -1.37% -0.91% -1.65% -4.47% -1.01% -0.12% -1.58% 1.29% 0.53% 4.86% 2.72% 1.23% 3.81% -4.85% -3.09% -2.62% 0.97% -1.32% 1.45% -0.37% -2.06% -0.82% 3.77% -2.59% -2.03% -2.72% -3.41% 6.72% 1.02% -0.24% 0.89% -1.98% 1.73% 0.54% -0.51% -3.23% 0.54% -1.78% 3.21% -0.42% 3.34% -1.04% -0.17% 0.57% -4.45% -3.53% -2.85% -2.19% -1.49% -0.43% -0.38% -1.34% -1.40% -0.59% -2.06% -1.04% -3.88% -1.95% 4.43% 0.64% 0.12% -1.47% 0.06% -1.17% 2.41% -2.68% 0.18% 0.36% -0.92% 0.76% 0.10% 1.97% 0.70% 0.65% 1.07% -2.22% 0.48% -2.52% 0.31% -2.63% 1.01% 0.18% -1.92% -3.92% 0.21% -0.96% -2.54% -0.39% -3.67% 3.78% -1.31% -0.02% -2.97% -0.75% 1.00% -0.18% -0.57% 0.72% 0.64% 0.35% 1.27% -0.21% 3.55% -0.81% 1.12% 1.17% -3.11% 0.72% -1.39% -0.28% 0.24% -0.03% -0.07% -0.38% -1.49% 0.07% -0.70% -1.10% -5.04% -1.66% 6.54% 0.65% 0.75% Type your answer to part (1) here: Task 2: (1) The dataset below contains sales information for company XYZ. Convert the dataset to an Excel table and use it to generate a pivot table to show the relationship between average income and the product purchased. Format the pivot table to show $ sign and round to the second decimal place. Sort the outcome by average income from the highest to the lowest but exclude "Other." (2) Generate another pivot table to show the impact of home ownership and number of childern on the total amount of purchases made. Make sure the summary values are displayed in $ as well as in % of the grand total. (3) Add a calculated field to show purchase as a percentage of income, name it "Spending Over Income." Use a pivot table to show the average Spending Over Income by gender and marital status. (4) In the space provided, write your conclusion from the results of (1), (2), and (3) above. (5) Create a histogram with pivot chart of average purchases against income, where income is grouped from $10,000 to $190,000 with every $10,000 as a group. Insert a timeline to help filter the data by date. Customer No. Product Gender CN1001 Clothing F CN1002 Other F CN1003 Clothing M CN1004 Furniture M CN1005 Other M CN1006 Furniture F CN1007 Garden F CN1008 Clothing F CN1009 Furniture M CN1010 Furniture M CN1011 Furniture M CN1012 Electronics M CN1013 Furniture M CN1014 Clothing M CN1015 Electronics F CN1016 Clothing F CN1017 Clothing F CN1018 Furniture M CN1019 Other F CN1020 Other M CN1021 Other F CN1022 Other M CN1023 Garden F CN1024 Clothing F CN1025 Other M CN1026 Electronics M CN1027 Garden F CN1028 Garden F CN1029 Furniture F CN1030 Clothing M Own HomeMarital Status Customer Income Children Credit Card No S New 18000 1 Other Yes M Repeat 120000 3 Am EX Yes M New 108000 1 Am EX Yes M New 30000 0 Visa MC No S New 12000 0 Other No S New 48000 4 Am EX No S New 39000 0 Visa MC Yes M Repeat 89000 0 Other Yes S New 67000 0 Visa MC Yes M Repeat 69000 0 Other No M New 105000 1 Visa MC Yes M Repeat 82000 0 Am EX Yes S New 51000 2 Am EX No S Repeat 58000 1 Other Yes M New 91000 1 Other Yes M New 85000 2 Other Yes M New 88000 3 Visa MC Yes M New 74000 0 Other No S New 14000 1 Other No M New 58000 1 Am EX Yes S Repeat 31000 0 Other Yes S Repeat 60000 0 Visa MC No S New 32000 0 Other No S New 18000 0 Am EX No S New 56000 3 Visa MC No S Repeat 20000 1 Other Yes S New 57000 0 Visa MC Yes M New 83000 0 Visa MC Yes M New 98000 0 Visa MC Yes M Repeat 88000 1 Other CN1031 CN1032 CN1033 CN1034 CN1035 CN1036 CN1037 CN1038 CN1039 CN1040 CN1041 CN1042 CN1043 CN1044 CN1045 CN1046 CN1047 CN1048 CN1049 CN1050 CN1051 CN1052 CN1053 CN1054 CN1055 CN1056 CN1057 CN1058 CN1059 CN1060 CN1061 CN1062 CN1063 CN1064 CN1065 CN1066 CN1067 CN1068 CN1069 CN1070 CN1071 CN1072 CN1073 CN1074 CN1075 CN1076 CN1077 Garden F Clothing M Clothing F Other F Garden M Furniture F Garden M Clothing M Electronics F Electronics F Electronics M Other M Furniture M Electronics M Other M Garden M Furniture F Electronics F Electronics F Furniture F Garden F Furniture M Electronics F Clothing F Electronics M Electronics F Garden M Electronics M Other F Clothing F Clothing F Furniture F Other F Furniture M Other M Other F Other F Furniture M Clothing M Clothing M Electronics F Other M Other F Clothing F Electronics F Furniture F Other M Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes No No Yes No Yes Yes Yes Yes Yes Yes No No Yes Yes Yes No No Yes Yes No Yes Yes No No No No No Yes S M S S S S M S S M M S M M M M M M S S S S S M M S S S M M S S S M M M S S M M M M M M S S S Repeat New Repeat New Repeat Repeat New New New New New New New Repeat Repeat Repeat New New New New New New Repeat New Repeat Repeat New New New New New Repeat New New New Repeat New New Repeat Repeat New Repeat New New Repeat Repeat New 61000 106000 15000 46000 73000 33000 55000 82000 44000 41000 57000 66000 119000 101000 83000 17000 67000 91000 40000 52000 31000 63000 14000 24000 108000 24000 64000 73000 70000 42000 12000 27000 53000 97000 131000 33000 14000 70000 46000 84000 83000 80000 41000 81000 17000 22000 71000 0 3 2 1 1 3 0 1 0 4 0 0 2 3 0 0 0 3 0 0 1 2 0 0 2 0 1 0 2 0 2 1 1 0 1 0 4 0 0 0 0 3 1 1 0 1 3 Other Visa MC Am EX Am EX Visa MC Am EX Other Am EX Other Other Visa MC Other Visa MC Visa MC Am EX Visa MC Other Other Other Visa MC Visa MC Visa MC Visa MC Am EX Other Other Visa MC Am EX Other Other Am EX Am EX Other Am EX Am EX Other Visa MC Other Visa MC Am EX Am EX Am EX Am EX Am EX Other Am EX Other CN1078 CN1079 CN1080 CN1081 CN1082 CN1083 CN1084 CN1085 CN1086 CN1087 CN1088 CN1089 CN1090 CN1091 CN1092 CN1093 CN1094 CN1095 CN1096 CN1097 CN1098 CN1099 CN1100 CN1101 CN1102 CN1103 CN1104 CN1105 CN1106 CN1107 CN1108 CN1109 CN1110 CN1111 CN1112 CN1113 CN1114 CN1115 CN1116 CN1117 CN1118 CN1119 CN1120 CN1121 CN1122 CN1123 CN1124 Furniture F Other F Furniture F Other F Other F Electronics M Other M Other F Furniture F Other M Garden M Clothing F Electronics F Other F Electronics M Clothing F Furniture M Electronics M Furniture F Garden M Other F Garden M Garden F Furniture F Other F Clothing M Clothing F Electronics M Electronics M Clothing F Clothing F Clothing M Garden M Electronics M Garden M Furniture M Electronics F Other F Clothing F Other F Electronics M Garden M Electronics M Other F Electronics F Garden M Furniture F No Yes No Yes No No Yes Yes Yes No No No No Yes No No No Yes Yes Yes No No Yes Yes Yes Yes No No No Yes No No No Yes Yes No No Yes No Yes Yes Yes Yes No Yes Yes Yes M M M M S S M S M S S M M S M S S S S M S S M M S M S M S M M M S M S S S S M S M S M S M M M New New New New New Repeat New New Repeat New New New New New Repeat New New New New New Repeat New Repeat New New New New Repeat New Repeat New New New New New New Repeat Repeat New New Repeat New New New New Repeat New 88000 91000 71000 131000 15000 50000 51000 49000 122000 70000 69000 59000 47000 29000 22000 52000 21000 51000 36000 107000 16000 60000 90000 54000 34000 139000 15000 67000 48000 143000 131000 41000 15000 113000 85000 24000 18000 71000 107000 65000 133000 76000 93000 15000 61000 46000 145000 0 0 1 3 1 1 0 2 0 0 0 0 3 2 1 0 0 4 3 0 1 0 0 3 0 0 1 1 1 0 1 0 0 1 1 0 0 2 0 0 3 0 2 1 0 0 3 Am EX Am EX Am EX Visa MC Am EX Am EX Visa MC Other Am EX Visa MC Other Other Other Visa MC Visa MC Am EX Visa MC Visa MC Other Am EX Visa MC Visa MC Other Visa MC Visa MC Other Other Am EX Am EX Visa MC Visa MC Other Am EX Am EX Visa MC Visa MC Am EX Other Am EX Other Visa MC Visa MC Other Other Visa MC Other Visa MC CN1125 CN1126 CN1127 CN1128 CN1129 CN1130 CN1131 CN1132 CN1133 CN1134 CN1135 CN1136 CN1137 CN1138 CN1139 CN1140 CN1141 CN1142 CN1143 CN1144 CN1145 CN1146 CN1147 CN1148 CN1149 CN1150 CN1151 CN1152 CN1153 CN1154 CN1155 CN1156 CN1157 CN1158 CN1159 CN1160 CN1161 CN1162 CN1163 CN1164 CN1165 CN1166 CN1167 CN1168 CN1169 CN1170 CN1171 Garden F Other F Other M Other M Other M Other M Electronics M Furniture F Clothing M Other F Garden M Garden M Furniture F Clothing F Electronics M Clothing M Garden F Other M Other M Other F Furniture M Other M Clothing M Clothing F Garden F Electronics M Garden M Clothing M Garden M Garden M Other F Other M Electronics F Furniture M Other M Clothing M Other F Electronics F Electronics M Furniture F Electronics F Furniture M Clothing M Furniture M Garden F Other F Furniture F No Yes Yes Yes Yes No No No No Yes No No No No Yes No No No Yes Yes Yes Yes Yes No No No Yes No No Yes No Yes Yes No Yes No No Yes No No No No Yes No Yes Yes No M M M S M S S S S S M S M M S S S S M M S M M S S S M S S M S M M S M S M M M S S S M S S M S New New New New New New New Repeat Repeat Repeat New New Repeat Repeat New New New New New New Repeat New New New New New New New Repeat New New New New Repeat New New New New Repeat New New Repeat New New Repeat New New 44000 104000 92000 62000 79000 64000 66000 26000 12000 53000 85000 16000 58000 48000 74000 61000 12000 63000 65000 114000 79000 81000 78000 13000 26000 44000 62000 51000 22000 78000 11000 93000 81000 45000 70000 16000 94000 95000 93000 30000 47000 17000 75000 17000 62000 94000 12000 0 2 2 1 1 0 2 2 4 0 1 1 0 3 0 2 2 0 0 3 0 0 1 1 3 1 0 0 0 2 3 0 1 1 2 3 0 2 1 2 0 0 1 0 3 1 2 Other Other Visa MC Other Other Visa MC Am EX Visa MC Am EX Other Other Am EX Am EX Am EX Visa MC Other Am EX Visa MC Am EX Other Other Am EX Am EX Other Visa MC Am EX Am EX Am EX Other Other Am EX Am EX Other Am EX Am EX Other Am EX Visa MC Am EX Other Visa MC Visa MC Am EX Other Visa MC Visa MC Other CN1172 CN1173 CN1174 CN1175 CN1176 CN1177 CN1178 CN1179 CN1180 CN1181 CN1182 CN1183 CN1184 CN1185 CN1186 CN1187 CN1188 CN1189 CN1190 CN1191 CN1192 CN1193 CN1194 CN1195 CN1196 CN1197 CN1198 CN1199 CN1200 CN1201 CN1202 CN1203 CN1204 CN1205 CN1206 CN1207 CN1208 CN1209 CN1210 CN1211 CN1212 CN1213 CN1214 CN1215 CN1216 CN1217 CN1218 Clothing F Clothing M Electronics M Other M Clothing F Other F Electronics F Furniture F Electronics F Clothing M Electronics F Furniture F Garden F Electronics M Clothing F Other M Electronics F Furniture F Furniture F Furniture M Other F Garden M Garden M Other M Garden F Furniture M Furniture M Clothing F Other F Electronics F Clothing F Garden M Other F Other M Electronics F Clothing M Other F Other F Clothing F Furniture F Other M Clothing F Electronics F Other M Clothing M Clothing F Clothing M No Yes No No Yes Yes Yes Yes Yes No Yes No No Yes Yes Yes No No No Yes Yes Yes No No Yes No Yes No No No Yes No No Yes Yes No No No Yes No No Yes No No Yes No No M M M S S S S S M S M S S M M M S S S M M M M S M S M S S M M S S M S S S M M M M S S M M S S Repeat New New New New New New New Repeat New New New New New New Repeat Repeat New New New New New New New New Repeat New New New Repeat Repeat New New New New Repeat New New New New Repeat New New New New New New 98000 97000 119000 30000 52000 55000 39000 39000 93000 29000 55000 15000 16000 122000 140000 112000 13000 40000 25000 118000 125000 107000 98000 49000 48000 23000 26000 52000 35000 37000 78000 19000 29000 121000 19000 58000 37000 68000 46000 60000 74000 80000 44000 41000 107000 13000 35000 0 0 2 1 2 2 0 0 0 0 2 1 3 2 1 3 0 2 2 0 0 0 2 0 0 0 0 0 1 1 0 0 1 0 0 0 4 1 0 1 0 0 3 0 3 0 1 Other Other Am EX Other Visa MC Other Visa MC Am EX Visa MC Other Other Am EX Am EX Other Am EX Am EX Am EX Other Am EX Am EX Other Other Am EX Am EX Am EX Visa MC Visa MC Other Other Other Visa MC Visa MC Other Other Am EX Other Visa MC Other Visa MC Am EX Am EX Other Am EX Other Visa MC Other Visa MC CN1219 CN1220 CN1221 CN1222 CN1223 CN1224 CN1225 CN1226 CN1227 CN1228 CN1229 CN1230 CN1231 CN1232 CN1233 CN1234 CN1235 CN1236 CN1237 CN1238 CN1239 CN1240 CN1241 CN1242 CN1243 CN1244 CN1245 CN1246 CN1247 CN1248 CN1249 CN1250 CN1251 CN1252 CN1253 CN1254 CN1255 CN1256 CN1257 CN1258 CN1259 CN1260 CN1261 CN1262 CN1263 CN1264 CN1265 Garden F Clothing F Garden M Clothing M Clothing F Garden F Furniture F Other F Other F Electronics F Furniture M Garden M Furniture M Electronics F Other M Clothing M Electronics M Garden M Electronics F Furniture M Electronics F Garden M Electronics M Other M Furniture M Clothing M Other M Clothing M Garden F Clothing F Furniture M Other M Furniture F Clothing M Furniture F Electronics M Garden M Furniture F Electronics M Garden F Electronics M Other F Furniture F Other F Furniture M Other M Furniture M Yes No No No Yes No Yes No Yes No No Yes Yes Yes Yes No No Yes No No No Yes Yes Yes Yes Yes Yes No No Yes No Yes No No No Yes Yes Yes No No Yes No Yes No Yes Yes Yes M M M M M M M S S M S M M S S M S M M M S M S M M S S S S S M S S S S M M M M S S S M M S S S New New New New Repeat New New New New New New Repeat New New New New New Repeat New Repeat New New Repeat New New New Repeat New New New New New Repeat New Repeat Repeat New New Repeat New New Repeat New Repeat New New New 92000 45000 73000 44000 88000 45000 71000 47000 36000 76000 67000 145000 81000 26000 59000 60000 62000 58000 88000 72000 16000 111000 53000 119000 95000 70000 62000 61000 52000 40000 118000 55000 12000 50000 23000 106000 124000 55000 54000 16000 92000 14000 49000 81000 66000 66000 45000 0 1 2 0 0 2 1 3 0 0 1 0 0 0 1 1 0 0 0 2 1 1 2 2 0 2 0 0 1 0 3 3 3 1 0 3 0 0 2 0 0 1 1 0 0 1 2 Am EX Other Other Am EX Visa MC Other Other Am EX Other Other Am EX Other Visa MC Visa MC Am EX Other Am EX Am EX Am EX Am EX Other Visa MC Other Am EX Visa MC Visa MC Am EX Other Other Visa MC Am EX Visa MC Other Am EX Other Am EX Other Visa MC Am EX Visa MC Visa MC Am EX Visa MC Visa MC Visa MC Am EX Am EX CN1266 CN1267 CN1268 CN1269 CN1270 CN1271 CN1272 CN1273 CN1274 CN1275 CN1276 CN1277 CN1278 CN1279 CN1280 CN1281 CN1282 CN1283 CN1284 CN1285 CN1286 CN1287 CN1288 CN1289 CN1290 CN1291 CN1292 CN1293 CN1294 CN1295 CN1296 CN1297 CN1298 CN1299 CN1300 CN1301 CN1302 CN1303 CN1304 CN1305 CN1306 CN1307 CN1308 CN1309 CN1310 CN1311 CN1312 Other M Electronics F Other F Electronics F Clothing M Electronics M Other F Garden M Electronics F Clothing F Other F Other M Furniture F Clothing F Clothing M Furniture M Other M Garden F Other M Clothing M Clothing F Garden F Garden F Other F Garden F Electronics F Garden M Electronics M Furniture F Electronics M Clothing M Electronics M Furniture F Garden F Other F Clothing M Furniture F Electronics M Clothing F Furniture M Furniture F Clothing M Garden M Electronics F Furniture F Other M Other M Yes No Yes Yes No No Yes Yes No No No Yes Yes No No No No Yes No No No No No Yes No No No Yes Yes Yes Yes Yes No No No Yes Yes Yes No Yes No Yes Yes No No No Yes S S S S M M S S M S S S M S M S S S S S S M M S S S M M S S M M M S M M M M S M M S S S M S M New Repeat New New Repeat New New New New New New New New New New Repeat New New Repeat Repeat New Repeat New New New New New New New New New New Repeat Repeat New Repeat Repeat New New Repeat New New Repeat New New Repeat New 70000 25000 60000 37000 70000 97000 30000 73000 117000 22000 16000 53000 120000 65000 90000 45000 28000 52000 24000 15000 29000 80000 85000 23000 13000 19000 67000 119000 41000 77000 92000 108000 103000 50000 56000 73000 92000 131000 48000 115000 46000 50000 50000 49000 26000 23000 137000 3 0 3 1 3 2 2 3 3 0 1 0 2 1 3 0 0 3 2 0 2 0 0 1 2 0 0 0 0 2 2 1 1 1 4 3 1 2 3 1 1 0 1 0 1 0 0 Am EX Other Other Other Am EX Am EX Visa MC Visa MC Visa MC Other Am EX Visa MC Other Am EX Visa MC Visa MC Am EX Visa MC Am EX Visa MC Other Visa MC Other Am EX Visa MC Visa MC Other Other Am EX Visa MC Visa MC Other Other Other Other Am EX Am EX Am EX Am EX Other Am EX Visa MC Am EX Visa MC Other Visa MC Visa MC CN1313 CN1314 CN1315 CN1316 CN1317 CN1318 CN1319 CN1320 CN1321 CN1322 CN1323 CN1324 CN1325 CN1326 CN1327 CN1328 CN1329 CN1330 CN1331 CN1332 CN1333 CN1334 CN1335 CN1336 CN1337 CN1338 CN1339 CN1340 CN1341 CN1342 CN1343 CN1344 CN1345 CN1346 CN1347 CN1348 CN1349 CN1350 CN1351 CN1352 CN1353 CN1354 CN1355 CN1356 CN1357 CN1358 CN1359 Other F Electronics M Electronics F Other M Electronics M Electronics M Furniture F Clothing F Clothing M Electronics M Other M Furniture F Electronics M Furniture M Clothing M Clothing F Electronics M Electronics M Garden M Clothing M Other F Furniture F Electronics M Furniture M Clothing M Electronics M Garden M Furniture F Clothing F Garden F Other F Clothing M Other M Garden F Garden M Garden F Clothing M Electronics M Garden M Garden F Clothing M Furniture M Electronics M Furniture F Electronics F Furniture F Garden M No No Yes Yes No Yes Yes No Yes No Yes No Yes No No No Yes Yes No No No Yes No Yes Yes Yes No Yes Yes No No Yes Yes Yes Yes Yes No Yes No No Yes No No Yes Yes Yes No S M S M S S M S M M S S M S S M M S S S S M S M S S M M S S M M S M M S S M M S M S M M M S M New New Repeat New New New New New New New Repeat Repeat New New New New New New New Repeat New Repeat Repeat New New New New New New New Repeat New New New Repeat New Repeat New Repeat Repeat New New New New New Repeat Repeat 50000 62000 62000 107000 36000 67000 81000 21000 83000 38000 84000 13000 34000 46000 24000 67000 117000 71000 18000 63000 18000 42000 47000 108000 33000 62000 83000 76000 58000 19000 58000 78000 68000 79000 81000 37000 65000 61000 71000 14000 136000 26000 46000 77000 122000 74000 97000 0 3 0 2 1 0 0 1 0 3 0 3 0 0 0 3 1 0 2 0 0 0 1 0 3 0 2 2 2 1 0 0 2 1 0 4 2 0 1 1 1 1 3 4 1 3 2 Other Other Am EX Other Visa MC Other Visa MC Am EX Visa MC Am EX Visa MC Other Other Other Am EX Other Visa MC Other Visa MC Other Visa MC Am EX Visa MC Other Other Am EX Visa MC Visa MC Am EX Am EX Am EX Other Am EX Visa MC Other Other Visa MC Visa MC Other Visa MC Other Visa MC Other Other Other Visa MC Visa MC CN1360 CN1361 CN1362 CN1363 CN1364 CN1365 CN1366 CN1367 CN1368 CN1369 CN1370 CN1371 CN1372 CN1373 CN1374 CN1375 CN1376 CN1377 CN1378 CN1379 CN1380 CN1381 CN1382 CN1383 CN1384 CN1385 CN1386 CN1387 CN1388 CN1389 CN1390 CN1391 CN1392 CN1393 CN1394 CN1395 CN1396 CN1397 CN1398 CN1399 CN1400 CN1401 CN1402 CN1403 CN1404 CN1405 CN1406 Garden M Electronics M Garden F Other F Electronics M Other M Garden M Electronics M Electronics M Furniture M Electronics F Garden M Clothing M Electronics M Electronics F Furniture F Furniture F Clothing M Electronics M Furniture F Electronics M Clothing M Furniture M Other M Electronics M Electronics M Garden M Electronics M Clothing M Furniture M Electronics F Garden F Other M Other M Electronics F Other M Clothing M Other F Clothing F Other F Electronics F Electronics F Electronics M Furniture M Garden F Furniture M Garden M Yes Yes No Yes Yes No Yes No No Yes No No Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes No No No No Yes Yes No No Yes No Yes Yes No Yes Yes No No Yes Yes No Yes Yes Yes S M S S M M M S M M S M M M S M S S S M S S M M M S S S M M S S M S S M M M S S S S M S M S M Repeat Repeat New New Repeat Repeat New Repeat New Repeat New New New New Repeat New Repeat New New New New New New New Repeat Repeat New New New Repeat Repeat New New Repeat New Repeat New New New New New New Repeat New New New New 90000 136000 22000 48000 37000 74000 107000 62000 71000 92000 16000 46000 92000 95000 20000 70000 15000 67000 35000 124000 75000 32000 94000 94000 75000 57000 26000 24000 100000 94000 15000 25000 60000 43000 39000 126000 117000 83000 67000 13000 19000 51000 115000 71000 73000 55000 71000 2 0 1 1 0 0 1 1 2 2 0 0 0 1 1 0 3 0 3 0 0 0 0 3 3 0 0 1 0 2 0 2 1 1 2 1 3 0 1 0 2 2 1 1 2 1 2 Visa MC Other Other Am EX Am EX Other Visa MC Visa MC Other Other Other Other Visa MC Am EX Visa MC Visa MC Am EX Visa MC Am EX Other Am EX Visa MC Other Visa MC Visa MC Other Visa MC Visa MC Am EX Am EX Visa MC Visa MC Am EX Visa MC Other Visa MC Visa MC Other Other Visa MC Am EX Am EX Visa MC Other Other Visa MC Am EX CN1407 CN1408 CN1409 CN1410 CN1411 CN1412 CN1413 CN1414 CN1415 CN1416 CN1417 CN1418 CN1419 CN1420 CN1421 CN1422 CN1423 CN1424 CN1425 CN1426 CN1427 CN1428 CN1429 CN1430 CN1431 CN1432 CN1433 CN1434 CN1435 CN1436 CN1437 CN1438 CN1439 CN1440 CN1441 CN1442 CN1443 CN1444 CN1445 CN1446 CN1447 CN1448 CN1449 CN1450 CN1451 CN1452 CN1453 Furniture M Garden F Electronics F Furniture M Garden M Furniture M Clothing M Electronics M Other M Electronics F Clothing F Clothing F Other F Electronics M Garden F Electronics M Other F Garden M Electronics F Clothing M Garden F Other F Other M Clothing F Other M Furniture M Other F Clothing F Other F Furniture F Garden M Furniture F Other M Other F Clothing F Electronics F Other M Electronics M Garden F Electronics F Furniture M Clothing F Furniture F Other F Other F Furniture M Clothing M Yes Yes No Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes No No Yes Yes Yes Yes Yes No No Yes No No Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes No No No No No Yes S S S S M S S S S S S S M M M M M S S S M S M S M M S M M M M M M M S S S S S S M S S S S S M Repeat New New New New New New New New Repeat Repeat Repeat Repeat New Repeat Repeat New New New New New New Repeat Repeat New New New New New New New Repeat Repeat New Repeat New New Repeat New New New Repeat New New New New New 66000 50000 44000 37000 111000 65000 39000 59000 68000 24000 22000 36000 110000 122000 25000 85000 108000 49000 55000 79000 11000 40000 126000 26000 98000 108000 24000 90000 128000 89000 119000 88000 139000 41000 14000 73000 23000 55000 28000 23000 94000 35000 56000 17000 14000 58000 108000 2 1 1 0 1 4 1 1 0 3 3 0 0 1 0 2 3 0 1 0 1 1 3 2 2 1 1 2 0 3 1 0 3 1 1 1 0 0 0 0 0 3 1 1 1 0 2 Other Visa MC Other Other Other Other Other Other Other Other Other Am EX Other Other Other Am EX Visa MC Visa MC Visa MC Visa MC Am EX Other Other Visa MC Other Other Am EX Am EX Other Other Visa MC Other Visa MC Other Am EX Am EX Visa MC Other Visa MC Visa MC Visa MC Visa MC Other Other Other Visa MC Am EX CN1454 CN1455 CN1456 CN1457 CN1458 CN1459 CN1460 CN1461 CN1462 CN1463 CN1464 CN1465 CN1466 CN1467 CN1468 CN1469 CN1470 CN1471 CN1472 CN1473 CN1474 CN1475 CN1476 CN1477 CN1478 CN1479 CN1480 CN1481 CN1482 CN1483 CN1484 CN1485 CN1486 CN1487 CN1488 CN1489 CN1490 CN1491 CN1492 CN1493 CN1494 CN1495 CN1496 CN1497 CN1498 CN1499 CN1500 Electronics M Furniture M Other F Furniture M Other F Other M Furniture F Furniture M Clothing F Garden F Other F Furniture M Furniture F Garden M Other F Garden M Clothing M Clothing M Garden M Furniture F Other M Garden F Garden M Furniture M Garden F Other F Garden M Clothing M Clothing F Clothing M Other F Garden M Garden F Electronics M Furniture M Furniture F Electronics F Electronics M Garden F Other M Clothing M Clothing M Other F Electronics M Garden M Other M Electronics M No No No No No Yes No No No No No Yes No No No Yes Yes No No No Yes No Yes Yes No No Yes Yes No No No Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes S S S M M M S S M S S M M S S M M M S M M S M M M S M S S S S M M S M M S M S M M M M M M M S New New Repeat New New New New New Repeat New New New Repeat New New Repeat New New New New New New New New New New New New New New Repeat Repeat New New New New Repeat New Repeat New New New Repeat New New New New 56000 62000 32000 120000 52000 114000 17000 43000 67000 19000 41000 72000 75000 17000 25000 61000 69000 63000 23000 74000 74000 15000 60000 114000 47000 17000 138000 65000 17000 16000 19000 86000 73000 81000 98000 58000 53000 83000 31000 65000 90000 116000 97000 85000 71000 133000 63000 0 1 0 2 0 0 4 0 0 0 1 2 1 0 3 0 0 0 0 2 3 1 1 1 0 0 2 0 2 0 1 1 0 0 2 3 0 0 0 0 0 0 0 2 3 2 3 Visa MC Other Visa MC Am EX Visa MC Am EX Am EX Other Other Other Am EX Visa MC Other Other Am EX Other Other Other Other Am EX Am EX Other Other Am EX Visa MC Visa MC Other Visa MC Am EX Other Other Other Other Am EX Visa MC Am EX Visa MC Other Visa MC Am EX Am EX Visa MC Visa MC Other Other Am EX Other CN1501 CN1502 CN1503 CN1504 CN1505 CN1506 CN1507 CN1508 CN1509 CN1510 CN1511 CN1512 CN1513 CN1514 CN1515 CN1516 CN1517 CN1518 CN1519 CN1520 CN1521 CN1522 CN1523 CN1524 CN1525 CN1526 CN1527 CN1528 CN1529 CN1530 CN1531 CN1532 CN1533 CN1534 CN1535 CN1536 CN1537 CN1538 CN1539 CN1540 CN1541 CN1542 CN1543 CN1544 CN1545 CN1546 CN1547 Garden M Electronics M Garden F Electronics M Furniture F Furniture F Electronics M Garden M Electronics M Clothing F Furniture M Electronics M Furniture F Garden M Electronics M Garden F Furniture F Clothing M Furniture F Furniture F Other F Furniture M Furniture F Furniture F Other M Clothing F Other F Other M Garden F Garden F Garden F Electronics M Electronics F Furniture F Furniture M Clothing M Other F Other M Electronics F Clothing F Clothing F Electronics M Clothing F Other F Clothing F Furniture F Other M No No Yes No Yes Yes No No Yes No No No Yes No Yes No Yes Yes No No No Yes No No No Yes Yes No No Yes No No Yes Yes Yes No No No No Yes Yes No No No Yes Yes No M M M S M M S S M S S S M M M M M M S M S M M M M S M M M M S S M M M M S S M M S S S S M S M New New Repeat New New New New New New Repeat New New Repeat New New New New Repeat New Repeat New New New Repeat Repeat New New Repeat New New New New Repeat Repeat New New Repeat Repeat Repeat New New New New New New New New 75000 74000 102000 20000 109000 85000 52000 24000 92000 40000 48000 80000 100000 41000 86000 79000 68000 41000 28000 60000 53000 107000 84000 91000 93000 34000 84000 28000 46000 39000 39000 49000 49000 64000 108000 107000 26000 75000 60000 47000 59000 52000 16000 14000 107000 17000 49000 0 0 0 1 0 0 0 1 0 3 4 0 1 1 0 3 0 0 3 0 0 1 1 0 2 0 0 0 0 0 0 0 0 0 0 1 2 0 1 1 2 1 1 3 0 0 1 Visa MC Other Visa MC Am EX Am EX Other Visa MC Am EX Other Other Am EX Visa MC Visa MC Other Other Other Visa MC Am EX Other Am EX Visa MC Other Visa MC Am EX Am EX Other Visa MC Am EX Other Am EX Other Other Am EX Other Am EX Visa MC Other Visa MC Visa MC Am EX Visa MC Other Visa MC Am EX Am EX Am EX Visa MC CN1548 CN1549 CN1550 CN1551 CN1552 CN1553 CN1554 CN1555 CN1556 CN1557 CN1558 CN1559 CN1560 CN1561 CN1562 CN1563 CN1564 CN1565 CN1566 CN1567 CN1568 CN1569 CN1570 CN1571 CN1572 CN1573 CN1574 CN1575 CN1576 CN1577 CN1578 CN1579 CN1580 CN1581 CN1582 CN1583 CN1584 CN1585 CN1586 CN1587 CN1588 CN1589 CN1590 CN1591 CN1592 CN1593 CN1594 Other F Other F Garden F Other F Clothing M Furniture F Furniture F Garden M Clothing F Clothing F Clothing M Furniture F Furniture M Clothing F Clothing M Garden M Electronics F Electronics F Garden F Furniture M Furniture M Furniture M Furniture F Garden F Furniture F Clothing F Clothing F Other F Furniture F Garden F Electronics M Other M Clothing M Clothing M Garden F Furniture F Clothing M Garden F Other F Furniture M Furniture F Clothing M Electronics M Clothing M Garden F Furniture M Garden F Yes Yes Yes No No Yes No Yes Yes No Yes No Yes Yes No No No Yes No No Yes Yes Yes Yes Yes No No No No No No Yes No Yes No Yes Yes Yes No Yes Yes Yes Yes No No No No S S S S M M S M M S M M S M M S M S M M M M S M S S M S S M M M S M S M S M S M M S M S S M M New New New New New Repeat New New Repeat Repeat Repeat New Repeat New New New New Repeat New New New New Repeat New New Repeat New Repeat Repeat New New Repeat Repeat Repeat New Repeat Repeat New New Repeat New New New New Repeat Repeat Repeat 48000 41000 32000 36000 103000 45000 24000 80000 75000 23000 103000 45000 68000 123000 91000 21000 82000 69000 54000 78000 100000 83000 36000 76000 24000 42000 101000 13000 20000 80000 43000 89000 20000 125000 20000 58000 67000 90000 24000 114000 101000 50000 95000 14000 36000 51000 134000 0 1 0 2 1 0 0 0 0 1 3 2 2 0 1 0 1 3 0 0 0 2 1 1 2 0 2 0 2 0 2 1 4 0 1 1 0 1 1 1 1 2 0 3 1 1 1 Other Visa MC Visa MC Other Visa MC Visa MC Other Visa MC Am EX Visa MC Other Other Other Other Other Am EX Visa MC Visa MC Visa MC Visa MC Am EX Visa MC Am EX Am EX Visa MC Other Other Am EX Other Other Other Am EX Am EX Other Visa MC Visa MC Other Am EX Other Am EX Other Am EX Visa MC Other Visa MC Am EX Visa MC CN1595 CN1596 CN1597 CN1598 CN1599 CN1600 CN1601 CN1602 CN1603 CN1604 CN1605 CN1606 CN1607 CN1608 CN1609 CN1610 CN1611 CN1612 CN1613 CN1614 CN1615 CN1616 CN1617 CN1618 CN1619 CN1620 CN1621 CN1622 CN1623 CN1624 CN1625 CN1626 CN1627 CN1628 CN1629 CN1630 CN1631 CN1632 CN1633 CN1634 CN1635 CN1636 CN1637 CN1638 CN1639 CN1640 CN1641 Garden F Electronics M Garden F Garden F Other M Furniture F Garden F Electronics M Furniture M Furniture F Garden M Clothing F Clothing M Other F Electronics M Clothing M Other M Electronics F Electronics M Clothing F Furniture F Clothing M Electronics F Electronics M Clothing F Garden F Garden M Electronics F Clothing M Furniture F Garden F Furniture M Garden F Furniture F Clothing M Garden F Clothing M Other F Clothing M Other F Clothing M Electronics F Furniture F Furniture F Electronics F Other M Furniture M Yes Yes No Yes Yes No Yes Yes No No No Yes No Yes Yes No Yes Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes Yes Yes No Yes Yes Yes Yes No Yes No Yes No No Yes No Yes No No M M S M M S M S M S S S S M M M S M M M S S M M M S M S M M M M M S M S S M S M S S S S M S S New New New New New Repeat Repeat Repeat Repeat Repeat New New New New Repeat New New New New Repeat New New New New New New New New New New New New Repeat New New New New New Repeat New Repeat New New Repeat New Repeat New 103000 114000 46000 25000 114000 49000 37000 43000 46000 20000 16000 51000 38000 85000 111000 55000 70000 48000 118000 83000 21000 54000 117000 101000 117000 20000 110000 20000 85000 73000 71000 103000 37000 31000 93000 54000 51000 79000 15000 112000 29000 30000 58000 42000 83000 16000 19000 3 0 3 0 3 1 0 1 3 4 3 3 0 3 1 0 0 0 0 0 1 1 1 0 1 3 1 0 1 0 3 1 2 3 3 2 0 0 1 1 0 1 0 2 1 1 4 Am EX Other Am EX Am EX Am EX Am EX Am EX Am EX Am EX Other Other Am EX Visa MC Visa MC Am EX Visa MC Am EX Visa MC Am EX Am EX Visa MC Am EX Other Other Am EX Visa MC Visa MC Am EX Am EX Other Am EX Other Visa MC Visa MC Am EX Other Am EX Other Am EX Am EX Other Visa MC Visa MC Visa MC Other Am EX Am EX CN1642 CN1643 CN1644 CN1645 CN1646 CN1647 CN1648 CN1649 CN1650 CN1651 CN1652 CN1653 CN1654 CN1655 CN1656 CN1657 CN1658 CN1659 CN1660 CN1661 CN1662 CN1663 CN1664 CN1665 CN1666 CN1667 CN1668 CN1669 CN1670 CN1671 CN1672 CN1673 CN1674 CN1675 CN1676 CN1677 CN1678 CN1679 CN1680 CN1681 CN1682 CN1683 CN1684 CN1685 CN1686 CN1687 CN1688 Garden F Clothing F Clothing F Garden M Furniture F Garden F Furniture M Other F Other F Electronics M Other M Garden M Garden F Furniture F Garden M Other F Clothing F Clothing F Clothing M Garden F Garden M Garden F Garden F Garden M Electronics M Garden F Electronics F Electronics F Electronics M Furniture F Furniture F Furniture M Other M Garden M Clothing M Furniture F Garden F Clothing F Furniture M Electronics M Garden F Electronics M Electronics F Electronics M Garden F Other F Furniture F Yes Yes No No Yes No No Yes Yes Yes No Yes No Yes No No Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes No No No No No No No No Yes No Yes Yes Yes No Yes No Yes No M S M M S M S M M M M M S M S S M S S M M S S M S S M M M S M S M S M S S M S M M M S M S M S New New New Repeat Repeat New Repeat New New Repeat New New New New Repeat New New New New New New Repeat New Repeat New Repeat Repeat Repeat Repeat New New New Repeat New New New New New New Repeat Repeat Repeat New Repeat New New New 67000 75000 151000 70000 24000 127000 25000 92000 115000 126000 61000 61000 21000 93000 67000 60000 99000 14000 56000 75000 70000 38000 48000 90000 32000 31000 14000 98000 68000 45000 77000 59000 74000 60000 76000 28000 23000 132000 20000 99000 94000 99000 13000 73000 20000 92000 45000 1 1 1 0 2 1 1 1 0 0 1 0 1 1 0 2 0 3 3 3 3 2 1 0 0 1 2 1 1 1 2 0 0 0 0 1 2 0 4 2 1 0 1 0 2 2 1 Visa MC Other Visa MC Visa MC Visa MC Am EX Am EX Visa MC Visa MC Visa MC Am EX Other Visa MC Am EX Other Visa MC Am EX Visa MC Am EX Am EX Visa MC Visa MC Am EX Am EX Am EX Visa MC Am EX Am EX Other Am EX Visa MC Visa MC Other Visa MC Other Visa MC Other Am EX Am EX Other Am EX Am EX Other Visa MC Visa MC Other Visa MC CN1689 CN1690 CN1691 CN1692 CN1693 CN1694 CN1695 CN1696 CN1697 CN1698 CN1699 CN1700 CN1701 CN1702 CN1703 CN1704 CN1705 CN1706 CN1707 CN1708 CN1709 CN1710 CN1711 CN1712 CN1713 CN1714 CN1715 CN1716 CN1717 CN1718 CN1719 CN1720 CN1721 CN1722 CN1723 CN1724 CN1725 CN1726 CN1727 CN1728 CN1729 CN1730 CN1731 CN1732 CN1733 CN1734 CN1735 Electronics M Furniture F Garden F Other F Furniture M Electronics F Other M Other M Garden F Clothing M Garden M Clothing M Other F Electronics F Furniture M Garden F Clothing M Clothing M Electronics F Garden F Clothing F Other M Furniture M Garden M Other M Other F Other F Electronics M Furniture F Furniture F Other F Furniture M Garden F Other M Garden M Garden F Garden M Furniture F Furniture F Furniture M Other M Furniture M Electronics M Furniture F Other M Other F Clothing M Yes Yes Yes No Yes Yes Yes Yes Yes No Yes No No Yes Yes No No Yes No No No No No No Yes Yes No Yes Yes No No No Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes No M S S M M S S S S S M S M M S M M M M S S S S M S M S M M S S M S M S S M S S S S M S M S M S New New New New Repeat New New New Repeat New New Repeat New New Repeat New New New Repeat New Repeat New New Repeat New New New Repeat Repeat New New New Repeat Repeat New Repeat New New New New New New Repeat New Repeat Repeat New 78000 50000 53000 70000 96000 16000 70000 26000 58000 60000 111000 56000 108000 39000 44000 52000 91000 110000 84000 16000 22000 48000 16000 48000 62000 120000 37000 110000 90000 22000 13000 88000 31000 78000 24000 47000 132000 17000 30000 29000 62000 30000 66000 41000 69000 76000 17000 0 1 1 0 1 0 0 4 2 1 2 1 0 0 0 0 0 3 1 1 2 0 0 1 3 1 1 0 0 1 4 0 1 1 0 0 1 1 2 1 0 1 0 2 0 0 3 Am EX Other Visa MC Other Am EX Other Other Visa MC Visa MC Am EX Other Am EX Visa MC Am EX Visa MC Other Other Am EX Am EX Visa MC Other Am EX Other Visa MC Am EX Am EX Visa MC Am EX Visa MC Visa MC Visa MC Am EX Am EX Am EX Am EX Visa MC Am EX Other Visa MC Visa MC Am EX Am EX Other Visa MC Other Visa MC Visa MC CN1736 CN1737 CN1738 CN1739 CN1740 CN1741 CN1742 CN1743 CN1744 CN1745 CN1746 CN1747 CN1748 CN1749 CN1750 CN1751 CN1752 CN1753 CN1754 CN1755 CN1756 CN1757 CN1758 CN1759 CN1760 CN1761 CN1762 CN1763 CN1764 CN1765 CN1766 CN1767 CN1768 CN1769 CN1770 CN1771 CN1772 CN1773 CN1774 CN1775 CN1776 CN1777 CN1778 CN1779 CN1780 CN1781 CN1782 Electronics F Garden M Other F Garden F Furniture M Garden F Other M Furniture M Garden F Furniture M Clothing F Furniture M Other M Electronics F Other F Furniture M Other F Garden F Clothing F Electronics M Other F Furniture F Other F Furniture F Electronics F Garden F Garden F Electronics M Clothing M Garden F Garden M Furniture F Electronics M Furniture F Electronics M Electronics M Electronics F Garden M Garden F Garden M Garden M Clothing M Furniture M Other M Electronics F Furniture F Other F No Yes Yes No No Yes Yes Yes No No No Yes No No Yes No Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes No No Yes Yes No No No Yes Yes No No Yes Yes No No No Yes No No M M S S S M M S S M S M M M M M M S S M M S S M S M M M S S S M M M M M S S S M M M S S M S S Repeat New Repeat Repeat New New New Repeat New New Repeat New Repeat New New New Repeat New Repeat New New Repeat Repeat Repeat New New Repeat New New New New New Repeat New New New New New New New New New New Repeat New New New 50000 63000 18000 51000 16000 80000 141000 78000 15000 132000 43000 156000 57000 44000 101000 100000 113000 27000 51000 47000 91000 35000 28000 62000 53000 74000 131000 86000 32000 47000 35000 66000 80000 67000 41000 99000 57000 67000 32000 88000 88000 41000 38000 22000 96000 13000 27000 3 0 0 0 0 2 2 0 0 0 3 3 0 4 0 0 1 1 1 0 2 0 1 1 0 2 1 2 3 0 0 1 3 2 0 1 0 0 4 2 2 0 1 0 1 3 2 Visa MC Other Other Visa MC Other Other Visa MC Visa MC Visa MC Visa MC Other Other Visa MC Am EX Other Other Other Visa MC Visa MC Other Visa MC Other Other Other Am EX Other Other Am EX Other Visa MC Other Other Other Am EX Visa MC Other Other Visa MC Am EX Other Other Other Other Other Other Other Other CN1783 CN1784 CN1785 CN1786 CN1787 CN1788 CN1789 CN1790 CN1791 CN1792 CN1793 CN1794 CN1795 CN1796 CN1797 CN1798 CN1799 CN1800 CN1801 CN1802 CN1803 CN1804 CN1805 CN1806 CN1807 CN1808 CN1809 CN1810 CN1811 CN1812 CN1813 CN1814 CN1815 CN1816 CN1817 CN1818 CN1819 CN1820 CN1821 CN1822 CN1823 CN1824 CN1825 CN1826 CN1827 CN1828 CN1829 Other M Furniture F Electronics F Clothing M Clothing M Other F Electronics F Other M Garden M Clothing M Other M Clothing M Furniture F Garden F Other M Furniture M Furniture M Electronics F Furniture M Furniture F Clothing F Electronics F Electronics M Clothing M Garden F Garden F Garden M Electronics M Other F Electronics F Other M Clothing M Clothing F Garden M Electronics M Garden M Other F Clothing F Garden M Furniture M Electronics M Clothing F Clothing F Garden M Garden F Electronics F Electronics F Yes Yes No No No No Yes No No Yes No Yes No Yes Yes Yes Yes Yes Yes No Yes No Yes Yes No No Yes Yes No No No Yes No No Yes No No No Yes Yes No No Yes No No No No M M M S S S M M S M S M S M M S M S S M S M M M M S M M S S S M S S S S M M M S S M M M S M S Repeat New New Repeat New New Repeat Repeat New New Repeat New New New New New Repeat New New New Repeat New New New New Repeat New New Repeat Repeat New New New New New Repeat New Repeat New New Repeat Repeat New New Repeat New Repeat 137000 80000 79000 23000 58000 19000 108000 61000 23000 114000 60000 109000 45000 93000 149000 83000 124000 44000 71000 44000 72000 89000 86000 109000 104000 55000 141000 106000 20000 15000 49000 74000 21000 60000 51000 21000 28000 72000 91000 57000 73000 67000 86000 77000 19000 74000 23000 1 0 0 2 0 2 3 0 0 1 0 0 3 0 0 0 3 0 0 4 3 1 0 0 1 2 0 2 1 2 0 0 2 0 0 0 2 0 1 0 0 1 0 1 0 1 1 Other Visa MC Visa MC Am EX Am EX Other Visa MC Visa MC Visa MC Visa MC Visa MC Am EX Other Visa MC Am EX Am EX Am EX Am EX Visa MC Am EX Other Visa MC Other Am EX Am EX Other Visa MC Visa MC Am EX Am EX Visa MC Other Visa MC Am EX Am EX Other Visa MC Visa MC Am EX Am EX Am EX Am EX Other Am EX Other Visa MC Visa MC CN1830 CN1831 CN1832 CN1833 CN1834 CN1835 CN1836 CN1837 CN1838 CN1839 CN1840 CN1841 CN1842 CN1843 CN1844 CN1845 CN1846 CN1847 CN1848 CN1849 CN1850 CN1851 CN1852 CN1853 CN1854 CN1855 CN1856 CN1857 CN1858 CN1859 CN1860 CN1861 CN1862 CN1863 CN1864 CN1865 CN1866 CN1867 CN1868 CN1869 CN1870 CN1871 CN1872 CN1873 CN1874 CN1875 CN1876 Clothing F Clothing M Other M Other M Garden F Other M Furniture M Clothing M Other M Clothing F Electronics F Garden F Other F Other M Garden F Other F Electronics M Electronics M Electronics F Clothing F Clothing F Furniture F Clothing F Other F Garden F Other M Clothing M Clothing F Garden M Other F Furniture M Electronics F Clothing F Furniture F Furniture F Other M Garden F Garden F Other M Electronics F Clothing F Furniture F Electronics F Furniture M Garden M Garden F Electronics M No Yes Yes No No No Yes Yes No No Yes Yes Yes No Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes Yes No No Yes Yes No No Yes No No No Yes No No No No Yes Yes No S M M S S S M M S S M S M S M M S M M S M S M S S S M M S M M M S M S M S S M S M M S M M M S New New New New Repeat New New New Repeat Repeat New New New New New Repeat Repeat New Repeat New New New Repeat Repeat Repeat Repeat Repeat Repeat New New New Repeat Repeat Repeat New New New New New Repeat New New New Repeat New New New 15000 86000 73000 24000 22000 20000 129000 126000 28000 15000 108000 76000 146000 22000 57000 52000 41000 93000 88000 54000 69000 41000 86000 20000 11000 58000 120000 114000 77000 29000 51000 111000 18000 36000 36000 80000 30000 18000 51000 37000 81000 107000 19000 59000 67000 30000 71000 4 0 1 0 0 0 1 2 0 1 1 0 3 0 0 1 1 0 0 0 3 1 3 1 2 0 3 2 0 1 4 0 0 1 2 1 1 1 0 2 3 2 1 2 3 0 0 Other Visa MC Am EX Visa MC Am EX Other Am EX Am EX Other Visa MC Am EX Visa MC Am EX Am EX Am EX Other Other Am EX Am EX Other Am EX Other Other Visa MC Other Other Other Other Am EX Other Other Am EX Other Visa MC Visa MC Other Other Other Visa MC Visa MC Visa MC Am EX Visa MC Other Visa MC Am EX Other CN1877 CN1878 CN1879 CN1880 CN1881 CN1882 CN1883 CN1884 CN1885 CN1886 CN1887 CN1888 CN1889 CN1890 CN1891 CN1892 CN1893 CN1894 CN1895 CN1896 CN1897 CN1898 CN1899 CN1900 CN1901 CN1902 CN1903 CN1904 CN1905 CN1906 CN1907 CN1908 CN1909 CN1910 CN1911 CN1912 CN1913 CN1914 CN1915 CN1916 CN1917 CN1918 CN1919 CN1920 CN1921 CN1922 CN1923 Garden F Clothing F Electronics F Furniture M Other M Other F Electronics M Electronics M Garden F Clothing F Garden M Electronics M Clothing F Furniture M Electronics M Furniture M Other M Furniture M Other M Electronics M Garden F Furniture M Clothing F Furniture F Clothing F Electronics F Other M Other M Garden M Electronics F Furniture F Clothing M Electronics M Electronics M Furniture F Other F Electronics M Electronics F Garden M Electronics F Garden F Electronics F Electronics F Electronics F Furniture M Electronics M Clothing F Yes No No Yes Yes No Yes Yes Yes No No Yes No No No Yes No No Yes No No No Yes Yes Yes No No Yes No Yes Yes Yes No Yes Yes No No No No No No No No No No No Yes S S M S S M S M M S S S S S M M S S M S S S M M S M S M S S S M S M M S S S S M S M S M M S S New New New Repeat New New Repeat New New Repeat New Repeat New New Repeat New New Repeat Repeat New Repeat New New Repeat New New New Repeat New New New New New New New New New Repeat New New New New New New Repeat New New 30000 30000 97000 76000 67000 53000 68000 94000 97000 24000 20000 56000 47000 46000 60000 108000 11000 54000 83000 22000 15000 47000 58000 79000 27000 76000 12000 88000 20000 48000 31000 108000 43000 61000 70000 32000 11000 16000 78000 89000 14000 94000 16000 15000 80000 55000 59000 2 3 3 1 3 0 0 0 0 3 0 1 0 3 3 0 0 0 0 2 0 0 1 0 0 0 0 1 0 0 3 0 1 0 0 3 2 2 0 1 1 2 1 0 1 0 3 Other Other Other Other Am EX Visa MC Other Am EX Visa MC Other Am EX Am EX Am EX Visa MC Other Am EX Am EX Other Am EX Other Visa MC Visa MC Visa MC Other Other Visa MC Am EX Visa MC Am EX Other Visa MC Visa MC Other Am EX Other Visa MC Visa MC Other Visa MC Am EX Other Visa MC Visa MC Am EX Am EX Other Other CN1924 CN1925 CN1926 CN1927 CN1928 CN1929 CN1930 CN1931 CN1932 CN1933 CN1934 CN1935 CN1936 CN1937 CN1938 CN1939 CN1940 CN1941 CN1942 CN1943 CN1944 CN1945 CN1946 CN1947 CN1948 CN1949 CN1950 CN1951 CN1952 CN1953 CN1954 CN1955 CN1956 CN1957 CN1958 CN1959 CN1960 CN1961 CN1962 CN1963 CN1964 CN1965 CN1966 CN1967 CN1968 CN1969 CN1970 Clothing M Garden M Electronics M Furniture F Clothing F Electronics F Furniture F Garden M Clothing M Furniture F Clothing F Furniture M Other F Furniture F Garden F Clothing M Electronics M Garden F Garden F Clothing M Clothing M Electronics M Electronics F Garden F Other M Furniture M Garden M Garden F Clothing M Furniture M Electronics F Other M Clothing M Garden F Garden F Other F Electronics F Furniture F Electronics F Clothing M Electronics M Clothing F Other F Electronics F Clothing M Furniture M Furniture F Yes No Yes No No No No Yes No Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes No Yes No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No Yes No No No No No Yes M M M S M S S M M S M S S S S M M M S M M M S M M M M M M M S M S S M S S S S M M S S S M S S New New New New Repeat Repeat Repeat New New Repeat New Repeat New New New Repeat Repeat New New New New New New New New New Repeat New New New New New New New Repeat New Repeat New New Repeat New New Repeat New New New Repeat 132000 63000 121000 26000 68000 28000 17000 188000 55000 45000 124000 19000 72000 37000 25000 26000 156000 107000 16000 109000 92000 85000 48000 80000 131000 80000 132000 69000 120000 84000 60000 107000 43000 13000 122000 16000 16000 54000 14000 108000 107000 12000 16000 24000 38000 20000 62000 1 2 3 3 3 2 4 0 0 2 1 0 0 3 0 0 0 1 2 0 3 0 3 0 0 0 2 0 3 0 3 0 0 0 0 1 1 1 2 1 0 0 0 2 0 0 1 Other Other Am EX Other Am EX Visa MC Other Other Other Other Other Am EX Other Am EX Am EX Visa MC Visa MC Other Other Am EX Visa MC Other Am EX Am EX Am EX Am EX Other Am EX Am EX Other Am EX Visa MC Other Am EX Other Visa MC Am EX Other Visa MC Other Visa MC Visa MC Other Am EX Am EX Other Other CN1971 CN1972 CN1973 CN1974 CN1975 CN1976 CN1977 CN1978 CN1979 CN1980 CN1981 CN1982 CN1983 CN1984 CN1985 CN1986 CN1987 CN1988 CN1989 CN1990 CN1991 CN1992 CN1993 CN1994 CN1995 CN1996 CN1997 CN1998 CN1999 CN2000 Other F Clothing M Garden M Garden M Furniture F Electronics M Clothing M Electronics F Clothing M Electronics F Garden F Furniture M Furniture F Furniture M Furniture M Garden F Electronics F Garden M Clothing M Electronics F Garden F Other M Garden M Other M Furniture M Other F Garden F Furniture M Electronics F Electronics M Yes Yes Yes Yes No No Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No Yes Yes No Yes No Yes M M S M M S M S S S S S S M M M M M S S S M M S S S S M M M New New Repeat Repeat New Repeat New New New Repeat New New Repeat Repeat Repeat New New Repeat New Repeat New New Repeat New New New New New New New 123000 103000 80000 126000 98000 17000 81000 41000 69000 15000 15000 71000 46000 96000 78000 137000 29000 90000 46000 14000 16000 73000 66000 20000 47000 60000 24000 114000 104000 114000 3 1 4 2 3 1 0 2 0 0 1 0 1 0 1 1 4 0 0 3 3 1 0 0 0 0 0 0 1 1 Am EX Other Other Visa MC Other Other Am EX Other Visa MC Other Am EX Visa MC Visa MC Am EX Am EX Other Visa MC Am EX Am EX Am EX Visa MC Visa MC Am EX Visa MC Other Visa MC Visa MC Other Visa MC Other Type your answer to part (4) here: aset to an Excel table me and the product er of childern on the as well as in % of the ending Over Income." e income is grouped ilter the data by date. Purchases 282 3422 3961 564 137 986 2098 2580 2718 3437 1574 4055 540 2305 1972 694 259 1586 297 1367 1212 1541 1079 527 203 765 1850 3222 3573 2962 Date 12/28/2008 12/8/2008 11/4/2008 7/26/2008 8/2/2008 12/2/2008 12/5/2008 11/11/2008 12/19/2008 12/12/2008 7/9/2008 6/22/2008 5/26/2008 7/27/2008 10/14/2008 9/15/2008 6/4/2008 6/12/2008 4/24/2008 11/22/2008 7/5/2008 6/11/2008 6/15/2008 6/15/2008 4/16/2008 12/4/2008 12/3/2008 11/10/2008 12/10/2008 11/11/2008 2227 881 538 1211 2976 1006 1075 1655 805 1083 1681 2208 2036 2944 2460 386 2071 1143 569 1251 290 696 313 578 2989 956 1307 1876 882 684 511 463 1040 2072 2734 689 299 2512 2197 3184 1916 2353 971 636 452 1287 533 10/8/2008 1/22/2008 3/20/2008 6/16/2008 6/19/2008 8/1/2008 12/22/2008 12/20/2008 12/9/2008 1/13/2008 5/24/2008 3/19/2008 12/3/2008 6/25/2008 12/17/2008 8/22/2008 7/13/2008 5/19/2008 1/15/2008 4/9/2008 8/15/2008 5/13/2008 10/6/2008 7/30/2008 6/14/2008 4/30/2008 12/14/2008 1/24/2008 10/14/2008 10/8/2008 5/21/2008 5/18/2008 1/19/2008 6/20/2008 1/12/2008 4/15/2008 9/13/2008 5/25/2008 12/9/2008 12/12/2008 3/24/2008 5/25/2008 11/25/2008 10/4/2008 9/23/2008 5/5/2008 1/12/2008 1528 2339 1330 755 306 1031 2139 464 7233 2482 1502 2077 136 583 649 710 375 941 224 2064 506 1826 3691 1189 1380 5341 211 1628 1591 5193 3484 1482 551 1222 1378 358 263 2073 4118 1275 2503 1501 699 185 1824 2580 2691 3/12/2008 9/9/2008 6/5/2008 5/3/2008 11/4/2008 7/6/2008 6/29/2008 1/26/2008 3/16/2008 12/26/2008 9/24/2008 7/21/2008 2/12/2008 2/13/2008 12/8/2008 4/7/2008 12/7/2008 7/15/2008 5/27/2008 7/1/2008 11/12/2008 12/13/2008 4/20/2008 3/15/2008 5/25/2008 5/6/2008 8/23/2008 7/21/2008 9/25/2008 7/5/2008 12/13/2008 10/4/2008 10/11/2008 9/18/2008 6/10/2008 12/19/2008 12/23/2008 11/6/2008 12/4/2008 12/7/2008 7/20/2008 7/21/2008 4/27/2008 7/27/2008 6/5/2008 9/7/2008 12/13/2008 1308 4002 762 3322 829 1493 753 605 529 1101 3167 519 2648 930 1530 1073 148 1135 1578 712 1252 2202 2731 116 102 535 1115 1804 742 1465 258 4347 2598 1394 822 566 3410 1163 3070 318 1193 838 1524 421 689 2374 671 12/27/2008 7/9/2008 5/22/2008 12/20/2008 11/15/2008 2/3/2008 8/10/2008 9/20/2008 12/19/2008 5/9/2008 12/19/2008 9/19/2008 6/27/2008 6/8/2008 10/9/2008 7/15/2008 7/15/2008 3/24/2008 6/3/2008 7/3/2008 6/14/2008 5/25/2008 2/25/2008 12/3/2008 2/28/2008 12/14/2008 5/28/2008 1/29/2008 4/26/2008 7/5/2008 8/11/2008 12/21/2008 8/20/2008 11/14/2008 5/17/2008 5/23/2008 2/24/2008 3/26/2008 8/5/2008 5/13/2008 12/22/2008 4/6/2008 10/17/2008 6/30/2008 10/20/2008 4/23/2008 5/20/2008 4721 1655 789 348 1498 616 788 1075 3523 586 797 294 60 1131 2454 3689 701 657 357 2284 2419 3360 680 1527 1360 337 451 1177 464 2130 3392 755 495 2393 215 1939 745 2094 1276 631 2674 4261 309 937 410 250 618 9/4/2008 6/29/2008 8/20/2008 2/12/2008 6/5/2008 12/24/2008 7/22/2008 3/23/2008 7/10/2008 11/28/2008 2/9/2008 9/19/2008 8/11/2008 8/31/2008 4/19/2008 11/27/2008 3/3/2008 2/27/2008 4/11/2008 9/2/2008 9/9/2008 10/1/2008 10/1/2008 10/27/2008 3/14/2008 5/2/2008 12/4/2008 12/13/2008 2/8/2008 4/4/2008 4/18/2008 10/21/2008 8/23/2008 4/2/2008 10/30/2008 11/4/2008 2/3/2008 11/22/2008 1/27/2008 4/14/2008 8/21/2008 7/23/2008 2/9/2008 4/3/2008 2/8/2008 9/30/2008 5/17/2008 3912 1250 750 1314 2660 808 1731 301 1147 1744 1028 4474 2056 570 3011 1264 1279 3307 2146 3815 595 2921 1249 1552 4394 915 2322 1762 1078 1250 613 272 159 908 666 3355 2777 1401 2140 297 2006 217 914 2696 1207 1848 1555 7/27/2008 1/16/2008 2/11/2008 12/23/2008 2/15/2008 4/7/2008 1/29/2008 12/24/2008 2/19/2008 2/19/2008 1/17/2008 1/30/2008 12/2/2008 11/1/2008 1/22/2008 12/7/2008 12/7/2008 11/5/2008 4/15/2008 3/15/2008 2/1/2008 7/8/2008 5/21/2008 9/7/2008 4/24/2008 7/7/2008 7/24/2008 7/20/2008 5/10/2008 7/11/2008 7/14/2008 12/17/2008 1/13/2008 1/18/2008 8/1/2008 12/9/2008 7/28/2008 5/8/2008 5/10/2008 12/8/2008 10/28/2008 12/18/2008 11/10/2008 4/7/2008 12/112/2008 9/5/2008 12/8/2008 919 1123 445 802 1830 3547 237 250 584 748 185 2131 1965 811 262 2124 343 205 249 740 224 3989 2881 395 241 856 1255 1930 875 3619 943 1143 2847 866 834 1086 3595 1204 423 3465 676 1841 1172 1235 209 1127 4772 9/25/2008 10/17/2008 4/9/2008 3/4/2008 12/26/2008 7/2/2008 5/5/2008 9/21/2008 2/28/2008 4/5/2008 9/21/2008 7/12/2008 9/2/2008 12/24/2008 11/18/2008 1/8/2008 10/14/2008 10/28/2008 3/21/2008 3/4/2008 11/19/2008 2/25/2008 5/21/2008 5/29/2008 12/112/2008 3/17/2008 12/5/2008 2/10/2008 3/26/2008 5/12/2008 2/3/2008 3/8/2008 3/6/2008 10/17/2008 2/7/2008 12/26/2008 12/12/2008 3/19/2008 1/16/2008 5/12/2008 12/13/2008 12/8/2008 7/22/2008 3/18/2008 6/12/2008 11/17/2008 7/2/2008 1255 280 2010 5090 670 1774 978 400 2558 1685 3540 405 643 1093 538 399 4556 1755 191 2413 653 2051 1037 3687 758 1237 916 1949 1510 428 1013 2057 1258 1032 3373 1347 1285 1102 2017 548 6478 655 2123 3144 2935 2727 2194 4/26/2008 1/26/2008 9/29/2008 5/10/2008 7/29/2008 10/6/2008 1/20/2008 4/17/2008 5/4/2008 1/22/2008 8/31/2008 2/22/2008 10/23/2008 11/16/2008 5/29/2008 12/7/2008 7/26/2008 12/16/2008 1/9/2008 12/23/2008 11/26/2008 1/18/2008 5/2/2008 7/13/2008 1/12/2008 2/3/2008 9/16/2008 9/1/2008 4/27/2008 7/4/2008 1/11/2008 7/12/2008 10/10/2008 12/3/2008 12/1/2008 11/18/2008 7/26/2008 12/212/2008 7/25/2008 6/30/2008 12/12/2008 1/25/2008 12/11/2008 11/11/2008 12/3/2008 12/10/2008 2/27/2008 3177 3131 499 1326 1272 2915 2481 1067 3017 2646 249 1576 1117 3166 414 734 165 1642 350 3263 1843 958 2024 3515 1575 2578 482 427 2543 2142 665 364 1405 1312 302 6696 395 2208 2272 446 140 543 3040 2108 1219 2120 859 1/29/2008 12/12/2008 5/23/2008 9/27/2008 1/14/2008 8/14/2008 4/19/2008 8/11/2008 12/25/2008 9/28/2008 11/2/2008 8/18/2008 10/7/2008 4/5/2008 5/19/2008 12/9/2008 3/24/2008 12/11/2008 3/17/2008 7/25/2008 11/12/2008 2/11/2008 12/23/2008 11/27/2008 12/17/2008 8/15/2008 7/15/2008 4/1/2008 4/14/2008 11/2/2008 2/9/2008 4/13/2008 2/17/2008 5/7/2008 1/28/2008 5/31/2008 7/15/2008 8/17/2008 4/26/2008 2/5/2008 9/15/2008 4/7/2008 4/15/2008 5/5/2008 8/6/2008 2/20/2008 3/26/2008 1581 582 762 737 1132 1078 547 1151 2166 424 237 1627 7154 3012 587 4198 276 1746 1097 2005 121 1761 2327 1023 1434 1845 613 1318 4675 383 2367 4417 3297 1924 475 1129 715 3697 826 261 3694 1413 1222 272 139 1113 1510 7/25/2008 12/212/2008 4/3/2008 12/26/2008 9/28/2008 9/19/2008 8/29/2008 8/6/2008 8/26/2008 9/21/2008 2/20/2008 8/3/2008 2/10/2008 7/29/2008 3/4/2008 12/14/2008 1/16/2008 3/8/2008 12/29/2008 7/7/2008 7/19/2008 12/4/2008 7/11/2008 2/27/2008 4/18/2008 12/12/2008 6/7/2008 5/19/2008 8/4/2008 3/14/2008 10/7/2008 3/4/2008 12/1/2008 12/5/2008 3/24/2008 10/31/2008 2/22/2008 12/112/2008 7/2/2008 4/1/2008 11/27/2008 2/23/2008 10/4/2008 11/4/2008 1/16/2008 5/19/2008 3/11/2008 1337 1181 1176 2890 1277 3095 608 836 3026 448 482 746 1967 223 677 2812 1751 2089 839 999 371 238 984 1608 1112 356 4597 1923 443 426 495 2356 1010 2829 1402 204 981 1925 1539 1913 2412 3427 4685 1144 310 2716 416 7/18/2008 10/25/2008 9/29/2008 11/14/2008 11/28/2008 12/26/2008 12/21/2008 9/7/2008 8/15/2008 9/27/2008 4/30/2008 2/17/2008 3/30/2008 10/3/2008 5/24/2008 11/29/2008 1/8/2008 7/8/2008 12/212/2008 7/2/2008 5/13/2008 3/22/2008 9/19/2008 6/30/2008 9/16/2008 8/11/2008 3/14/2008 12/25/2008 8/4/2008 1/9/2008 3/30/2008 11/1/2008 4/18/2008 7/13/2008 7/28/2008 4/6/2008 8/16/2008 1/27/2008 1/27/2008 1/10/2008 8/10/2008 5/26/2008 3/19/2008 11/18/2008 4/26/2008 2/28/2008 8/17/2008 1408 1703 3187 348 2793 1272 2063 1006 2312 1124 1198 1917 3801 321 2734 510 2404 1104 663 3238 1016 1405 3513 4752 2727 1120 2003 769 1817 1420 1779 1152 3281 2200 1915 2369 594 2894 2830 1515 1111 759 271 113 1894 355 1204 5/1/2008 1/21/2008 8/2/2008 1/13/2008 2/13/2008 9/14/2008 7/19/2008 2/19/2008 11/7/2008 1/26/2008 9/13/2008 7/8/2008 9/11/2008 9/1/2008 4/25/2008 10/30/2008 5/15/2008 10/23/2008 12/3/2008 7/24/2008 3/16/2008 9/18/2008 9/18/2008 5/5/2008 6/12/2008 1/11/2008 9/10/2008 9/30/2008 12/13/2008 4/3/2008 1/29/2008 12/20/2008 7/14/2008 7/13/2008 7/12/2008 10/9/2008 8/27/2008 6/5/2008 5/9/2008 12/16/2008 11/14/2008 5/29/2008 9/23/2008 8/24/2008 5/4/2008 7/27/2008 12/5/2008 2059 688 807 526 2216 1799 647 3239 3801 611 1359 748 1613 3194 2389 228 840 1197 2057 3592 2527 1070 1715 1063 638 1918 920 342 419 3968 244 4398 964 8082 280 2644 2541 2077 748 4921 1450 307 3279 56 1195 1764 7578 5/10/2008 8/7/2008 4/28/2008 7/25/2008 7/29/2008 10/31/2008 10/15/2008 10/12/2008 7/28/2008 9/6/2008 3/2/2008 5/30/2008 10/8/2008 5/13/2008 2/14/2008 8/11/2008 7/1/2008 6/2/2008 10/11/2008 9/1/2008 5/10/2008 8/25/2008 11/8/2008 5/21/2008 4/28/2008 8/25/2008 6/11/2008 5/31/2008 7/31/2008 2/24/2008 6/20/2008 3/18/2008 9/29/2008 12/2/2008 5/22/2008 3/26/2008 6/29/2008 3/27/2008 12/22/2008 6/5/2008 7/18/2008 3/4/2008 4/9/2008 5/14/2008 10/2/2008 4/25/2008 12/10/2008 850 3169 289 1231 1914 2157 798 1301 1708 579 399 1480 831 3774 4538 2200 1958 890 2439 2345 524 1652 4368 4117 2315 80 1954 291 1859 1867 472 3437 1046 742 1757 685 931 2794 478 2325 1178 1315 1491 1540 915 488 431 6/19/2008 4/12/2008 9/21/2008 2/14/2008 11/22/2008 11/18/2008 8/31/2008 10/22/2008 2/27/2008 3/28/2008 9/12/2008 3/2/2008 10/8/2008 12/15/2008 6/14/2008 10/9/2008 3/5/2008 11/9/2008 3/15/2008 3/21/2008 5/13/2008 12/13/2008 9/1/2008 12/26/2008 5/14/2008 3/28/2008 8/9/2008 4/13/2008 3/28/2008 7/31/2008 12/22/2008 2/18/2008 8/4/2008 10/17/2008 9/26/2008 3/15/2008 11/16/2008 9/29/2008 7/25/2008 11/30/2008 1/9/2008 2/15/2008 10/22/2008 12/18/2008 10/23/2008 9/17/2008 10/26/2008 797 884 3569 2738 632 2568 1058 2279 4392 4254 1301 1619 238 3345 2995 1551 1932 268 926 462 229 972 650 3944 625 1161 213 3331 2046 1144 759 2236 1331 1495 3592 547 234 2828 354 3501 3993 6771 186 2510 212 854 819 9/19/2008 4/26/2008 9/27/2008 8/25/2008 3/6/2008 5/9/2008 9/12/2008 11/19/2008 12/26/2008 4/3/2008 5/9/2008 3/6/2008 7/17/2008 11/20/2008 12/15/2008 7/12/2008 11/2/2008 11/13/2008 11/17/2008 2/19/2008 8/28/2008 11/1/2008 2/10/2008 12/27/2008 1/10/2008 6/4/2008 9/3/2008 6/1/2008 5/17/2008 1/14/2008 7/2/2008 1/14/2008 9/25/2008 5/5/2008 5/12/2008 2/18/2008 9/30/2008 7/12/2008 4/4/2008 3/7/2008 8/13/2008 12/20/2008 11/11/2008 8/6/2008 2/26/2008 1/14/2008 12/1/2008 2566 652 860 1965 1631 607 3329 693 1699 955 2075 1403 3378 615 1410 913 1194 3635 2378 237 429 1191 799 1050 555 1473 416 4064 3900 351 182 2292 748 2788 541 2326 3982 177 579 642 1252 361 3956 848 4281 4794 49 10/29/2008 4/19/2008 11/9/2008 12/23/2008 9/16/2008 8/10/2008 2/5/2008 8/16/2008 6/23/2008 4/7/2008 7/21/2008 4/30/2008 6/12/2008 8/27/2008 3/25/2008 4/1/2008 1/23/2008 1/11/2008 7/11/2008 5/24/2008 2/21/2008 8/14/2008 11/5/2008 8/12/2008 11/8/2008 3/3/2008 9/19/2008 4/26/2008 10/30/2008 7/23/2008 9/24/2008 2/26/2008 2/25/2008 3/16/2008 10/2/2008 4/19/2008 11/27/2008 5/10/2008 4/1/2008 12/25/2008 8/7/2008 6/10/2008 3/23/2008 6/10/2008 1/26/2008 5/26/2008 5/11/2008 1563 2089 411 1717 325 928 2599 2213 384 3420 379 1301 1406 744 1121 2838 3316 285 2110 703 754 1117 586 1024 1417 707 3253 738 236 2279 800 1853 1353 531 949 3182 1634 910 723 2048 871 762 679 732 2226 203 470 8/8/2008 10/23/2008 9/16/2008 6/30/2008 3/3/2008 9/2/2008 8/23/2008 4/5/2008 9/9/2008 2/17/2008 5/13/2008 7/10/2008 11/30/2008 11/5/2008 1/18/2008 8/31/2008 2/19/2008 12/3/2008 12/14/2008 1/20/2008 11/28/2008 5/27/2008 1/26/2008 7/17/2008 8/11/2008 11/2/2008 2/13/2008 7/2/2008 1/23/2008 5/29/2008 7/21/2008 9/18/2008 4/4/2008 1/10/2008 7/11/2008 2/26/2008 9/28/2008 7/11/2008 1/29/2008 1/13/2008 2/23/2008 8/13/2008 2/5/2008 5/18/2008 8/22/2008 12/24/2008 10/26/2008 7641 2399 2190 585 2168 365 4006 1510 384 3205 2344 1837 301 2056 5925 1497 2685 792 2134 797 2487 1353 2409 2644 1853 1553 2367 1051 861 207 787 1414 221 1378 925 555 180 2867 1700 902 2985 1859 2605 1862 533 1535 714 12/4/2008 11/8/2008 10/31/2008 3/16/2008 2/14/2008 7/4/2008 12/8/2008 12/17/2008 1/17/2008 3/5/2008 2/10/2008 11/23/2008 5/5/2008 9/28/2008 7/18/2008 10/31/2008 3/27/2008 2/11/2008 4/19/2008 3/12/2008 11/29/2008 11/14/2008 6/4/2008 7/12/2008 11/17/2008 2/23/2008 3/18/2008 4/1/2008 3/5/2008 3/12/2008 11/26/2008 8/6/2008 4/12/2008 9/2/2008 4/21/2008 5/27/2008 3/27/2008 4/11/2008 2/20/2008 12/26/2008 12/1/2008 4/19/2008 6/19/2008 8/17/2008 8/3/2008 7/2/2008 10/31/2008 408 1278 1321 879 696 513 3867 2020 768 453 1663 1695 3692 513 1332 1653 1583 2237 2903 1289 2754 822 1114 394 277 2481 2404 2909 1920 314 635 4034 467 1659 354 1557 596 611 980 788 327 1600 321 1204 441 1455 1713 7/28/2008 8/10/2008 8/19/2008 5/24/2008 10/28/2008 8/5/2008 12/8/2008 12/15/2008 12/14/2008 2/16/2008 9/5/2008 3/17/2008 9/3/2008 3/29/2008 7/23/2008 3/22/2008 8/27/2008 9/18/2008 12/15/2008 10/20/2008 4/28/2008 12/7/2008 7/16/2008 5/17/2008 2/3/2008 6/10/2008 6/18/2008 6/13/2008 1/10/2008 9/29/2008 5/16/2008 2/21/2008 6/6/2008 10/18/2008 5/25/2008 1/19/2008 11/4/2008 7/26/2008 10/1/2008 6/14/2008 5/13/2008 11/11/2008 2/29/2008 3/30/2008 11/1/2008 11/21/2008 1/31/2008 568 316 3179 2208 1772 831 1266 2150 2898 920 318 1391 1074 390 2028 1506 470 1980 1837 272 248 1366 869 896 638 2155 245 2475 393 1876 529 2124 704 1870 1824 827 433 251 1020 1514 262 1240 500 472 2706 1214 659 1/17/2008 7/6/2008 10/3/2008 3/15/2008 3/25/2008 2/21/2008 10/1/2008 5/19/2008 12/8/2008 12/6/2008 7/8/2008 5/15/2008 6/26/2008 3/29/2008 3/11/2008 4/7/2008 2/27/2008 12/6/2008 8/5/2008 10/20/2008 9/11/2008 10/14/2008 7/29/2008 8/25/2008 9/18/2008 8/6/2008 7/1/2008 4/15/2008 10/31/2008 10/10/2008 2/11/2008 5/7/2008 4/17/2008 12/27/2008 7/14/2008 10/23/2008 11/13/2008 2/16/2008 7/9/2008 3/15/2008 3/22/2008 7/25/2008 9/20/2008 11/16/2008 7/29/2008 7/2/2008 12/8/2008 2019 893 1432 1000 1510 553 491 1965 1001 897 3042 613 1687 910 334 556 6362 1773 256 4295 2759 935 292 2530 2287 1805 5123 1509 825 963 306 1867 1958 335 5563 289 288 1894 84 3772 4913 253 532 502 1042 521 2019 3/4/2008 3/20/2008 9/16/2008 10/7/2008 1/26/2008 2/8/2008 7/15/2008 11/21/2008 12/24/2008 3/31/2008 11/2/2008 2/4/2008 8/25/2008 7/19/2008 12/26/2008 5/21/2008 1/12/2008 6/5/2008 12/23/2008 12/1/2008 10/8/2008 6/23/2008 1/9/2008 8/25/2008 2/16/2008 3/30/2008 6/25/2008 6/28/2008 2/7/2008 2/14/2008 4/14/2008 4/12/2008 4/1/2008 3/13/2008 3/14/2008 3/20/2008 1/14/2008 10/15/2008 5/11/2008 12/3/2008 9/2/2008 10/20/2008 12/6/2008 11/20/2008 3/20/2008 10/13/2008 3/24/2008 1420 2782 5436 4207 274 548 1994 668 2057 464 239 1722 998 3497 1595 2459 757 3500 835 266 199 1405 2413 379 850 1095 314 3309 1977 3203 4/2/2008 2/20/2008 7/19/2008 2/10/2008 9/21/2008 8/1/2008 12/23/2008 1/19/2008 12/21/2008 7/10/2008 12/7/2008 5/14/2008 6/24/2008 11/30/2008 3/20/2008 8/19/2008 12/26/2008 7/24/2008 10/6/2008 5/19/2008 3/20/2008 5/31/2008 1/27/2008 7/23/2008 7/23/2008 10/25/2008 5/4/2008 9/15/2008 6/23/2008 6/2/2008 Task 3: 1. Use a stacked column chart to create a fundraising meter. 2. Add a scroll bar (which works the same way as a spin button) and link it to the amount raised. a. The amount to be raised should be a formula. b. The vertical axis should not move as the amount raised changes. FundraisingGoal AmountRaised Amount to be raised $1,000,000 400,000
Purchase answer to see full attachment
Explanation & Answer:
3 Excel Tasks
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

NM - got it! I had to use an ActiveX scroll bar. This is done!!

Task 1:
(1) The daily returns of five different stocks as well as the daily returns of the S&P 500 are given.
Convert the data to an Excel table and rename the table "TableDailyReturns." In the space provided,
give the reason for why the source data should be converted to an Excel table.
(2) Create a scatter plot of stock returns (y-axis) and market returns (S&P 500; x-axis) and use option
buttons to dynamically select the stock for the plot. (The y-axis should not move as a different stock is
selected.)
(3) Add a linear trend line (the characteristic line) that also displays R2 and equation.
(4) Make sure the chart title automatically changes when you select a different stock. The title must
include the company name and the beta of the stock selected. (For example, "Amazon Characteristic
Line with Beta = 1.62.")

Date
SnP500
Amazon
Boing
CitiGroup
Dunkin Donuts Ebay
1/2/2018
0.83%
1.67%
0.65%
-0.07%
1.68%
0.85%
1/3/2018
0.64%
1.28%
0.32%
0.31%
0.73%
3.05%
1/4/2018
0.40%
0.45%
-0.38%
1.23%
-1.64%
-1.66%
1/5/2018
0.70%
1.62%
4.10%
-0.13%
-0.85%
2.90%
1/8/2018
0.17%
1.44%
0.42%
-1.17%
-0.02%
0.28%
1/9/2018
0.13%
0.47%
2.67%
1.05%
-1.16%
-0.68%
1/10/2018
-0.11%
0.13%
0.57%
0.45%
-0.96%
-4.63%
1/11/2018
0.70%
1.78%
2.45%
-0.12%
0.27%
0.29%
1/12/2018
0.67%
2.23%
2.47%
1.69%
1.88%
0.56%
1/16/2018
-0.35%
-0.03%
-0.31%
0.35%
-1.07%
-0.89%
1/17/2018
0.94%
-0.76%
4.73%
0.47%
0.14%
0.82%
1/18/2018
-0.16%
-0.13%
-3.09%
-0.10%
2.04%
1.97%
1/19/2018
0.44%
0.10%
-0.71%
1.18%
-0.81%
-0.80%
1/22/2018
0.81%
2.53%
0.08%
0.37%
0.31%
2.99%
1/23/2018
0.22%
2.65%
-0.71%
-0.05%
2.96%
0.48%
1/24/2018
-0.06%
-0.37%
-0.27%
1.15%
1.48%
0.13%
1/25/2018
0.06%
1.51%
2.52%
-0.01%
1.05%
0.50%
1/26/2018
1.18%
1.75%
0.03%
0.81%
-0.29%
2.17%
1/29/2018
-0.67%
1.11%
-0.70%
-0.15%
-2.38%
-0.22%
1/30/2018
-1.09%
1.42%
-0.91%
-1.68%
-1.59%
-0.98%
1/31/2018
0.05%
0.91%
4.93%
-0.18%
-1.30%
0.45%
2/1/2018
-0.06%
-4.20%
0.73%
0.92%
-0.57%
13.82%
2/2/2018
-2.12%
2.87%
-2.25%
-2.75%
-3.02%
-4.09%
2/5/2018
-4.10%
-2.79%
-5.74%
-4.87%
-2.41%
-4.36%
2/6/2018
1.74%
3.80%
3.66%
2.12%
-1.86%
0.99%
2/7/2018
-0.50%
-1.81%
2.11%
0.23%
-1.42%
-1.08%
2/8/2018
-3.75%
-4.68%
-5.30%
-4.16%
0.51%
-3.09%
2/9/2018
1.49%
-0.81%
0.96%
2.52%
-1.00%
1.56%
2/12/2018
1.39%
3.48%
3.30%
1.47%
1.18%
1.58%
2/13/2018
0.26%
2.04%
-0.19%
0.56%
0.57%
-0.40%
2/14/2018
1.34%
2.58%
0.49%
2.04%
2.90%
0.69%

2/15/2018
2/16/2018
2/20/2018
2/21/2018
2/22/2018
2/23/2018
2/26/2018
2/27/2018
2/28/2018
3/1/2018
3/2/2018
3/5/2018
3/6/2018
3/7/2018
3/8/2018
3/9/2018
3/12/2018
3/13/2018
3/14/2018
3/15/2018
3/16/2018
3/19/2018
3/20/2018
3/21/2018
3/22/2018
3/23/2018
3/26/2018
3/27/2018
3/28/2018
3/29/2018
4/2/2018
4/3/2018
4/4/2018
4/5/2018
4/6/2018
4/9/2018
4/10/2018
4/11/2018
4/12/2018
4/13/2018
4/16/2018
4/17/2018
4/18/2018
4/19/2018
4/20/2018
4/23/2018
4/24/2018

1.21%
0.04%
-0.58%
-0.55%
0.10%
1.60%
1.18%
-1.27%
-1.11%
-1.33%
0.51%
1.10%
0.26%
-0.05%
0.45%
1.74%
-0.13%
-0.64%
-0.57%
-0.08%
0.17%
-1.42%
0.15%
-0.18%
-2.52%
-2.10%
2.72%
-1.73%
-0.29%
1.38%
-2.23%
1.26%
1.16%
0.69%
-2.19%
0.33%
1.67%
-0.55%
0.83%
-0.29%
0.81%
1.07%
0.08%
-0.57%
-0.85%
0.01%
-1.34%

0.74%
-0.89%
1.36%
0.99%
0.16%
0.99%
1.46%
-0.66%
0.03%
-1.26%
0.46%
1.56%
0.92%
0.48%
0.44%
1.74%
1.24%
-0.64%
0.18%
-0.55%
-0.67%
-1.70%
2.69%
-0.29%
-2.34%
-3.19%
4.03%
-3.78%
-4.38%
1.11%
-5.21%
1.46%
1.33%
2.92%
-3.20%
0.06%
2.14%
-0.64%
1.50%
-1.22%
0.75%
4.32%
1.60%
1.90%
-1.89%
-0.63%
-3.81%

3.37%
-0.40%
-0.48%
-0.28%
1.01%
0.21%
1.91%
0.32%
-0.67%
-3.46%
-1.44%
2.34%
-1.09%
-0.54%
0.49%
1.66%
-2.91%
-1.60%
-2.48%
-0.08%
0.15%
0.39%
1.77%
-0.16%
-5.19%
0.43%
2.48%
-2.39%
-0.34%
2.46%
-1.66%
2.60%
-1.02%
2.74%
-3.06%
-1.12%
3.83%
-2.23%
3.09%
-2.43%
0.76%
1.49%
1.27%
-0.11%
-0.58%
0.05%
-2.89%

0.48%
-0.34%
-0.47%
0.71%
-0.95%
1.06%
0.74%
-1.64%
-1.17%
-2.42%
0.03%
1.00%
-0.48%
-0.19%
0.26%
2.70%
-0.12%
-1.46%
-1.92%
-0.18%
0.18%
-1.05%
0.30%
0.55%
-4.11%
-3.43%
2.77%
-2.15%
-0.03%
-1.11%
0.31%
1.14%
1.21%
1.31%
-2.31%
1.22%
1.54%
-0.88%
3.21%
-1.55%
-1.32%
-0.47%
-1.09%
1.88%
-0.40%
-0.74%
-0.52%

4.16%
-1.94%
-0.78%
-2.33%
1.00%
1.09%
-0.16%
-0.94%
-2.30%
-2.47%
1.56%
0.22%
0.05%
-0.08%
0.99%
0.78%
-0.46%
-0.78%
-0.74%
-0.07%
0.79%
0.25%
0.95%
0.73%
-2.36%
-0.66%
2.69%
-2.01%
0.64%
-0.20%
-2.66%
1.46%
1.78%
0.27%
-0.78%
0.65%
0.23%
0.10%
0.83%
-0.74%
-0.15%
0.00%
0.63%
0.64%
-0.15%
0.79%
-0.29%

1.34%
0.77%
0.12%
-0.62%
-0.67%
1.98%
0.34%
-1.55%
-0.67%
-1.38%
1.61%
0.56%
-0.12%
1.83%
-0.57%
0.30%
0.21%
-2.46%
0.02%
-0.56%
-0.31%
-0.87%
-0.31%
-0.69%
-2.62%
-2.14%
3.27%
-1.93%
-0.27%
0.32%
-2.19%
0.64%
0.45%
0.60%
-2.35%
-0.54%
1.83%
0.61%
1.76%
-1.55%
0.73%
1.05%
2.81%
0.86%
0.21%
-1.42%
-1.01%

4/25/2018
4/26/2018
4/27/2018
4/30/2018
5/1/2018
5/2/2018
5/3/2018
5/4/2018
5/7/2018
5/8/2018
5/9/2018
5/10/2018
5/11/2018
5/14/2018
5/15/2018
5/16/2018
5/17/2018
5/18/2018
5/21/2018
5/22/2018
5/23/2018
5/24/2018
5/25/2018
5/29/2018
5/30/2018
5/31/2018
6/1/2018
6/4/2018
6/5/2018
6/6/2018
6/7/2018
6/8/2018
6/11/2018
6/12/2018
6/13/2018
6/14/2018
6/15/2018
6/18/2018
6/19/2018
6/20/2018
6/21/2018
6/22/2018
6/25/2018
6/26/2018
6/27/2018
6/28/2018
6/29/2018

0.18%
1.04%
0.11%
-0.82%
0.25%
-0.72%
-0.23%
1.28%
0.35%
-0.03%
0.97%
0.94%
0.17%
0.09%
-0.68%
0.41%
-0.09%
-0.26%
0.74%
-0.31%
0.32%
-0.20%
-0.24%
-1.16%
1.27%
-0.69%
1.08%
0.45%
0.07%
0.86%
-0.07%
0.31%
0.11%
0.17%
-0.40%
0.25%
-0.10%
-0.21%
-0.40%
0.17%
-0.63%
0.19%
-1.37%
0.22%
-0.86%
0.62%
0.08%

0.01%
3.96%
3.60%
-0.41%
1.03%
-0.80%
0.15%
0.56%
1.21%
-0.48%
0.98%
0.07%
-0.38%
-0.09%
-1.59%
0.71%
-0.35%
-0.47%
0.70%
-0.26%
1.29%
0.08%
0.44%
0.17%
0.75%
0.29%
0.73%
1.45%
1.87%
-0.04%
-0.38%
-0.31%
0.30%
0.57%
0.36%
1.11%
-0.46%
0.46%
0.64%
0.88%
-1.13%
-0.84%
-3.06%
1.68%
-1.81%
2.47%
-0.10%

4.19%
-0.02%
-0.56%
-2.15%
-1.21%
-1.62%
2.00%
1.13%
1.79%
-0.61%
1.81%
-0.12%
-0.47%
0.62%
-0.72%
-0.34%
0.93%
2.06%
3.61%
-2.45%
1.18%
-0.06%
0.30%
-2.11%
1.62%
-1.68%
1.29%
1.12%
-0.17%
3.18%
-0.82%
0.26%
0.39%
-0.09%
-1.83%
-0.39%
-1.25%
-0.88%
-3.84%
0.46%
-1.47%
0.37%
-2.27%
0.03%
-0.45%
1.46%
0.26%

0.35%
-0.26%
-0.27%
-1.04%
-0.03%
-0.38%
-0.07%
0.00%
0.82%
3.65%
1.34%
0.86%
0.40%
-0.33%
0.08%
-1.00%
-0.54%
-2.24%
0.67%
0.92%
-1.18%
-1.32%
-1.26%
-3.99%
1.48%
0.01%
0.88%
0.09%
-0.86%
2.20%
0.32%
0.03%
-0.53%
-0.73%
-0.47%
-1.68%
0.27%
0.62%
0.04%
0.90%
0.37%
-0.64%
-2.16%
0.85%
-1.28%
2.17%
0.06%

1.62%
-0.31%
-2.29%
0.59%
2.21%
-0.47%
-0.08%
2.81%
0.61%
1.03%
-1.24%
0.16%
1.70%
-0.08%
-0.22%
0.85%
0.49%
0.12%
0.27%
-1.13%
1.04%
0.06%
-1.36%
-2.13%
0.64%
-0.23%
-0.39%
1.05%
1.04%
1.58%
1.32%
0.54%
-0.45%
1.28%
0.04%
0.74%
0.09%
0.67%
-0.22%
0.00%
0.71%
0.62%
-0.79%
-0.40%
0.33%
-0.03%
-0.10%

-0.51%
-5.59%
-1.16%
-0.92%
-0.13%
-1.72%
1.24%
0.96%
-0.53%
0.79%
0.34%
0.71%
-0.62%
0.34%
-0.81%
0.71%
0.13%
0.00%
-0.29%
-1.36%
0.71%
-0.66%
0.40%
-1.08%
0.85%
-0.34%
1.64%
1.90%
2.48%
-0.22%
1.25%
-0.40%
0.50%
-0.10%
-2.77%
-0.84%
-0.28%
-0.08%
0.82%
0.20%
-3.18%
0.21%
-2.57%
-0.11%
-2.08%
-0.44%
0.33%

7/2/2018
7/2/2018
7/5/2018
7/6/2018
7/9/2018
7/10/2018
7/11/2018
7/12/2018
7/13/2018
7/16/2018
7/17/2018
7/18/2018
7/19/2018
7/20/2018
7/23/2018
7/24/2018
7/25/2018
7/26/2018
7/27/2018
7/30/2018
7/31/2018
8/1/2018
8/2/2018
8/3/2018
8/6/2018
8/7/2018
8/8/2018
8/9/2018
8/10/2018
8/13/2018
8/14/2018
8/15/2018
8/16/2018
8/17/2018
8/20/2018
8/21/2018
8/22/2018
8/23/2018
8/24/2018
8/27/2018
8/28/2018
8/29/2018
8/30/2018
8/31/2018
9/4/2018
9/5/2018
9/6/2018

0.31%
-0.49%
0.86%
0.85%
0.88%
0.35%
-0.71%
0.87%
0.11%
-0.10%
0.40%
0.22%
-0.40%
-0.09%
0.18%
0.48%
0.91%
-0.30%
-0.66%
-0.58%
0.49%
-0.10%
0.49%
0.46%
0.35%
0.28%
-0.03%
-0.14%
-0.71%
-0.40%
0.64%
-0.76%
0.79%
0.33%
0.24%
0.21%
-0.04%
-0.17%
0.62%
0.77%
0.03%
0.57%
-0.44%
0.01%
-0.17%
-0.28%
-0.37%

0.82%
-1.16%
0.34%
0.64%
1.66%
0.23%
0.68%
2.37%
0.91%
0.52%
1.18%
-0.05%
-1.63%
0.04%
-0.65%
1.51%
1.88%
-2.98%
0.51%
-2.09%
-0.10%
1.11%
2.07%
-0.60%
1.34%
0.80%
1.29%
0.64%
-0.64%
0.52%
1.24%
-1.93%
0.21%
-0.23%
-0.29%
0.36%
1.14%
-0.10%
0.13%
1.17%
0.27%
3.38%
0.21%
0.52%
1.33%
-2.19%
-1.83%

0.17%
-0.94%
0.08%
0.44%
2.18%
1.53%
-1.89%
1.59%
1.38%
1.51%
0.22%
0.94%
-1.36%
-0.12%
-0.46%
1.42%
-0.66%
0.96%
0.37%
-2.66%
1.49%
-0.99%
-0.86%
-0.37%
-0.54%
1.21%
-0.85%
-1.17%
-1.25%
-0.31%
0.23%
-2.18%
4.29%
0.12%
1.25%
0.86%
-1.06%
-0.73%
0.55%
1.25%
-0.72%
-0.29%
-0.94%
-1.18%
1.01%
0.12%
1.32%

0.36%
-1.64%
0.76%
0.87%
2.68%
-1.03%
-0.47%
0.88%
-2.20%
3.67%
-0.16%
0.72%
-1.23%
0.33%
1.43%
1.22%
0.91%
-0.53%
0.49%
0.84%
-0.55%
0.06%
-0.13%
0.77%
0.01%
0.01%
0.66%
-1.25%
-2.39%
-1.57%
1.23%
-1.94%
1.33%
0.16%
1.23%
1.01%
-0.17%
-0.44%
-0.20%
2.43%
-0.01%
0.21%
-1.48%
-0.31%
0.22%
-0.32%
-1.49%

-0.43%
-0.31%
0.64%
1.70%
0.54%
0.62%
0.42%
-0.97%
1.18%
0.34%
0.70%
-0.17%
0.28%
1.04%
-0.75%
-1.78%
-0.37%
0.41%
-2.26%
-1.01%
1.09%
0.07%
1.31%
-0.11%
-0.09%
0.51%
0.73%
0.43%
-0.15%
-1.43%
2.44%
-0.11%
0.29%
-0.08%
0.33%
-1.17%
0.08%
-0.22%
-0.22%
-0.04%
0.91%
-0.35%
-0.11%
1.63%
4.35%
-0.71%
0.33%

1.13%
-0.08%
1.06%
0.97%
1.39%
-2.29%
-0.16%
1.54%
0.16%
0.32%
0.21%
0.37%
-10.12%
0.26%
-1.20%
-0.80%
1.10%
1.59%
-1.80%
-0.41%
-0.65%
-1.08%
0.39%
1.32%
0.98%
-0.62%
0.18%
0.92%
-0.18%
-0.62%
1.53%
-1.57%
-0.27%
0.71%
0.03%
1.50%
0.49%
-0.86%
0.38%
0.14%
0.46%
0.55%
-0.37%
-0.55%
0.55%
-1.93%
-1.38%

9/7/2018
9/10/2018
9/11/2018
9/12/2018
9/13/2018
9/14/2018
9/17/2018
9/18/2018
9/19/2018
9/20/2018
9/21/2018
9/24/2018
9/25/2018
9/26/2018
9/27/2018
9/28/2018
10/1/2018
10/2/2018
10/3/2018
10/4/2018
10/5/2018
10/8/2018
10/9/2018
10/10/2018
10/11/2018
10/12/2018
10/15/2018
10/16/2018
10/17/2018
10/18/2018
10/19/2018
10/22/2018
10/23/2018
10/24/2018
10/25/2018
10/26/2018
10/29/2018
10/30/2018
10/31/2018
11/1/2018
11/2/2018
11/5/2018
11/6/2018
11/7/2018
11/8/2018
11/9/2018
11/12/2018

-0.22%
0.19%
0.37%
0.04%
0.53%
0.03%
-0.56%
0.54%
0.13%
0.78%
-0.04%
-0.35%
-0.13%
-0.33%
0.28%
0.00%
0.36%
-0.04%
0.07%
-0.82%
-0.55%
-0.04%
-0.14%
-3.29%
-2.06%
1.42%
-0.59%
2.15%
-0.03%
-1.44%
-0.04%
-0.43%
-0.55%
-3.09%
1.86%
-1.73%
-0.66%
1.57%
1.09%
1.06%
-0.63%
0.56%
0.63%
2.12%
-0.25%
-0.92%
-1.97%

-0.32%
-0.67%
2.48%
0.14%
-0.01%
-0.99%
-3.16%
1.73%
-0.75%
0.93%
-1.51%
1.01%
2.08%
0.02%
1.93%
-0.50%
0.07%
-1.65%
-0.94%
-2.22%
-1.04%
-1.34%
0.32%
-6.15%
-2.04%
4.03%
-1.55%
3.35%
0.65%
-3.33%
-0.38%
1.43%
-1.15%
-5.91%
7.09%
-7.82%
-6.33%
-0.55%
4.42%
4.23%
0.00%
-2.27%
0.92%
6.86%
-0.03%
-2.42%
-4.41%

-0.57%
-2.12%
0.99%
2.36%
0.58%
1.22%
-1.07%
2.14%
0.45%
0.61%
1.30%
-1.14%
-0.21%
-0.60%
0.65%
1.23%
2.79%
1.07%
1.53%
-0.59%
-0.90%
-0.18%
-0.09%
-4.66%
-2.55%
0.56%
-0.34%
2.61%
-0.75%
-1.68%
-0.86%
-0.08%
-1.67%
1.31%
2.57%
-1.24%
-6.59%
4.27%
1.41%
2.31%
-1.47%
1.18%
1.24%
1.51%
-0.34%
-0.39%
-3.33%

-0.67%
-0.01%
-0.29%
1.56%
-0.51%
0.56%
0.48%
0.68%
3.31%
1.45%
-0.86%
-0.42%
-0.45%
-1.44%
0.69%
-1.66%
0.26%
-0.18%
0.78%
0.36%
-0.28%
0.23%
-0.96%
-2.70%
-2.24%
2.14%
-0.90%
0.72%
0.19%
-1.75%
0.35%
-3.30%
-1.29%
-2.94%
1.83%
-1.17%
0.22%
0.28%
1.44%
0.57%
0.14%
2.09%
-0.92%
2.37%
-0.70%
-2.98%
-2.36%

0.99%
-0.27%
-0.63%
0.49%
-0.24%
-2.30%
-1.52%
0.97%
0.24%
0.14%
-1.12%
-0.65%
1.33%
0.26%
-0.12%
-0.23%
-1.30%
-1.48%
-0.86%
0.59%
-0.21%
0.28%
2.61%
-1.85%
-1.51%
1.48%
1.61%
1.41%
0.30%
-1.10%
-1.35%
-0.17%
0.11%
-3.06%
4.78%
-1.30%
-2.61%
3.50%
-1.04%
-1.16%
0.54%
-0.17%
1.32%
1.07%
1.42%
-0.35%
-1.50%

0.98%
-0.82%
1.19%
0.44%
0.53%
-0.99%
0.29%
-0.23%
0.29%
0.06%
-0.58%
-0.94%
-2.85%
2.50%
-0.71%
-0.96%
-1.54%
0.15%
0.58%
-0.37%
-1.20%
1.05%
2.15%
-4.84%
-0.85%
1.02%
0.44%
1.22%
-0.71%
-1.47%
-8.87%
-0.90%
-1.05%
-3.19%
2.82%
-2.57%
-1.90%
2.24%
5.87%
1.69%
1.19%
-0.77%
1.05%
-0.30%
-0.07%
-0.70%
-2.26%

11/13/2018
11/14/2018
11/15/2018
11/16/2018
11/19/2018
11/20/2018
11/21/2018
11/22/2018
11/26/2018
11/27/2018
11/28/2018
11/29/2018
11/30/2018
12/3/2018
12/4/2018
12/6/2018
12/7/2018
12/10/2018
12/11/2018
12/12/2018
12/13/2018
12/14/2018
12/17/2018
12/18/2018
12/19/2018
12/20/2018
12/21/2018
12/23/2018
12/26/2018
12/27/2018
12/28/2018

-0.15%
-0.76%
1.06%
0.22%
-1.66%
-1.82%
0.30%
-0.66%
1.55%
0.33%
2.30%
-0.22%
0.82%
1.09%
-3.24%
-0.15%
-2.33%
0.18%
-0.04%
0.54%
-0.02%
-1.91%
-2.08%
0.01%
-1.54%
-1.58%
-2.06%
-2.71%
4.96%
0.86%
-0.12%

-0.35%
-1.97%
1.28%
-1.61%
-5.09%
-1.11%
1.42%
-0.97%
5.28%
0.01%
6.09%
-0.25%
0.99%
4.86%
-5.87%
1.85%
-4.12%
0.73%
0.13%
1.24%
-0.31%
-4.01%
-4.46%
2.01%
-3.64%
-2.29%
-5.71%
-2.43%
9.45%
-0.63%
1.12%

-2.11%
-1.37%
-0.91%
-1.65%
-4.47%
-1.01%
-0.12%
-1.58%
1.29%
0.53%
4.86%
2.72%
1.23%
3.81%
-4.85%
-3.09%
-2.62%
0.97%
-1.32%
1.45%
-0.37%
-2.06%
-0.82%
3.77%
-2.59%
-2.03%
-2.72%
-3.41%
6.72%
1.02%
-0.24%

0.89%
-1.98%
1.73%
0.54%
-0.51%
-3.23%
0.54%
-1.78%
3.21%
-0.42%
3.34%
-1.04%
-0.17%
0.57%
-4.45%
-3.53%
-2.85%
-2.19%
-1.49%
-0.43%
-0.38%
-1.34%
-1.40%
-0.59%
-2.06%
-1.04%
-3.88%
-1.95%
4.43%
0.64%
0.12%

-1.47%
0.06%
-1.17%
2.41%
-2.68%
0.18%
0.36%
-0.92%
0.76%
0.10%
1.97%
0.70%
0.65%
1.07%
-2.22%
0.48%
-2.52%
0.31%
-2.63%
1.01%
0.18%
-1.92%
-3.92%
0.21%
-0.96%
-2.54%
-0.39%
-3.67%
3.78%
-1.31%
-0.02%

-2.97%
-0.75%
1.00%
-0.18%
-0.57%
0.72%
0.64%
0.35%
1.27%
-0.21%
3.55%
-0.81%
1.12%
1.17%
-3.11%
0.72%
-1.39%
-0.28%
0.24%
-0.03%
-0.07%
-0.38%
-1.49%
0.07%
-0.70%
-1.10%
-5.04%
-1.66%
6.54%
0.65%
0.75%

500 are given.
e space provided,

Type your answer to part (1) here:
With the data in table format, we can easily filter to see infomration from a specific date to
quickly see how the market performed on any given day.

is) and use option
a different stock is

ck. The title must
zon Characteristic

Amazon

Boeing Characteristic Line with Beta = -2
20.00%
15.00%
10.00%
5.00%

-6.00%

-4.00%

0.00%
-2.00%
0.00%
-5.00%

Boing
y = 1.309x + 0.0008
R² = 0.5039

CitiGroup
2.00%

-10.00%
Boing

4.00%

6.00%

Dunkin Donuts
Linear (Boing)

Ebay

CitiGroup

Dunkin Donuts

SnP500
0.83%
0.64%
0.40%
0.70%
0.17%
0.13%
-0.11%
0.70%
0.67%
-0.35%
0.94%
-0.16%
0.44%
0.81%
0.22%
-0.06%
0.06%
1.18%
-0.67%
-1.09%
0.05%
-0.06%
-2.12%
-4.10%
1.74%
-0.50%
-3.75%
1.49%
1.39%
0.26%
1.34%
1.21%
0.04%
-0.58%
-0.55%
0.10%
1.60%
1.18%
-1.27%
-1.11%
-1.33%
0.51%
1.10%
0.26%
-0.05%
0.45%

1.74%
-0.13%
-0.64%
-0.57%
-0.08%
0.17%
-1.42%
0.15%
-0.18%
-2.52%
-2.10%
2.72%
-1.73%
-0.29%
1.38%
-2.23%
1.26%
1.16%
0.69%
-2.19%
0.33%
1.67%
-0.55%
0.83%
-0.29%
0.81%
1.07%
0.08%
-0.57%
-0.85%
0.01%
-1.34%
0.18%
1.04%
0.11%
-0.82%
0.25%
-0.72%
-0.23%
1.28%
0.35%
-0.03%
0.97%
0.94%
0.17%
0.09%
-0.68%

0.41%
-0.09%
-0.26%
0.74%
-0.31%
0.32%
-0.20%
-0.24%
-1.16%
1.27%
-0.69%
1.08%
0.45%
0.07%
0.86%
-0.07%
0.31%
0.11%
0.17%
-0.40%
0.25%
-0.10%
-0.21%
-0.40%
0.17%
-0.63%
0.19%
-1.37%
0.22%
-0.86%
0.62%
0.08%
0.31%
-0.49%
0.86%
0.85%
0.88%
0.35%
-0.71%
0.87%
0.11%
-0.10%
0.40%
0.22%
-0.40%
-0.09%
0.18%

0.48%
0.91%
-0.30%
-0.66%
-0.58%
0.49%
-0.10%
0.49%
0.46%
0.35%
0.28%
-0.03%
-0.14%
-0.71%
-0.40%
0.64%
-0.76%
0.79%
0.33%
0.24%
0.21%
-0.04%
-0.17%
0.62%
0.77%
0.03%
0.57%
-0.44%
0.01%
-0.17%
-0.28%
-0.37%
-0.22%
0.19%
0.37%
0.04%
0.53%
0.03%
-0.56%
0.54%
0.13%
0.78%
-0.04%
-0.35%
-0.13%
-0.33%
0.28%

0.00%
0.36%
-0.04%
0.07%
-0.82%
-0.55%
-0.04%
-0.14%
-3.29%
-2.06%
1.42%
-0.59%
2.15%
-0.03%
-1.44%
-0.04%
-0.43%
-0.55%
-3.09%
1.86%
-1.73%
-0.66%
1.57%
1.09%
1.06%
-0.63%
0.56%
0.63%
2.12%
-0.25%
-0.92%
-1.97%
-0.15%
-0.76%
1.06%
0.22%
-1.66%
-1.82%
0.30%
-0.66%
1.55%
0.33%
2.30%
-0.22%
0.82%
1.09%
-3.24%

-0.15%
-2.33%
0.18%
-0.04%
0.54%
-0.02%
-1.91%
-2.08%
0.01%
-1.54%
-1.58%
-2.06%
-2.71%
4.96%
0.86%
-0.12%

Amazon Boing
CitiGroup Dunkin Donuts
Ebay
1.67%
0.65%
-0.07%
1.68%
0.85%
1.28%
0.32%
0.31%
0.73%
3.05%
0.45%
-0.38%
1.23%
-1.64%
-1.66%
1.62%
4.10%
-0.13%
-0.85%
2.90%
1.44%
0.42%
-1.17%
-0.02%
0.28%
0.47%
2.67%
1.05%
-1.16%
-0.68%
0.13%
0.57%
0.45%
-0.96%
-4.63%
1.78%
2.45%
-0.12%
0.27%
0.29%
2.23%
2.47%
1.69%
1.88%
0.56%
-0.03%
-0.31%
0.35%
-1.07%
-0.89%
-0.76%
4.73%
0.47%
0.14%
0.82%
-0.13%
-3.09%
-0.10%
2.04%
1.97%
0.10%
-0.71%
1.18%
-0.81%
-0.80%
2.53%
0.08%
0.37%
0.31%
2.99%
2.65%
-0.71%
-0.05%
2.96%
0.48%
-0.37%
-0.27%
1.15%
1.48%
0.13%
1.51%
2.52%
-0.01%
1.05%
0.50%
1.75%
0.03%
0.81%
-0.29%
2.17%
1.11%
-0.70%
-0.15%
-2.38%
-0.22%
1.42%
-0.91%
-1.68%
-1.59%
-0.98%
0.91%
4.93%
-0.18%
-1.30%
0.45%
-4.20%
0.73%
0.92%
-0.57%
13.82%
2.87%
-2.25%
-2.75%
-3.02%
-4.09%
-2.79%
-5.74%
-4.87%
-2.41%
-4.36%
3.80%
3.66%
2.12%
-1.86%
0.99%
-1.81%
2.11%
0.23%
-1.42%
-1.08%
-4.68%
-5.30%
-4.16%
0.51%
-3.09%
-0.81%
0.96%
2.52%
-1.00%
1.56%
3.48%
3.30%
1.47%
1.18%
1.58%
2.04%
-0.19%
0.56%
0.57%
-0.40%
2.58%
0.49%
2.04%
2.90%
0.69%
0.74%
3.37%
0.48%
4.16%
1.34%
-0.89%
-0.40%
-0.34%
-1.94%
0.77%
1.36%
-0.48%
-0.47%
-0.78%
0.12%
0.99%
-0.28%
0.71%
-2.33%
-0.62%
0.16%
1.01%
-0.95%
1.00%
-0.67%
0.99%
0.21%
1.06%
1.09%
1.98%
1.46%
1.91%
0.74%
-0.16%
0.34%
-0.66%
0.32%
-1.64%
-0.94%
-1.55%
0.03%
-0.67%
-1.17%
-2.30%
-0.67%
-1.26%
-3.46%
-2.42%
-2.47%
-1.38%
0.46%
-1.44%
0.03%
1.56%
1.61%
1.56%
2.34%
1.00%
0.22%
0.56%
0.92%
-1.09%
-0.48%
0.05%
-0.12%
0.48%
-0.54%
-0.19%
-0.08%
1.83%
0.44%
0.49%
0.26%
0.99%
-0.57%

2
Boeing Characteristic Line with Beta = -2

1.74%
1.24%
-0.64%
0.18%
-0.55%
-0.67%
-1.70%
2.69%
-0.29%
-2.34%
-3.19%
4.03%
-3.78%
-4.38%
1.11%
-5.21%
1.46%
1.33%
2.92%
-3.20%
0.06%
2.14%
-0.64%
1.50%
-1.22%
0.75%
4.32%
1.60%
1.90%
-1.89%
-0.63%
-3.81%
0.01%
3.96%
3.60%
-0.41%
1.03%
-0.80%
0.15%
0.56%
1.21%
-0.48%
0.98%
0.07%
-0.38%
-0.09%
-1.59%

1.66%
-2.91%
-1.60%
-2.48%
-0.08%
0.15%
0.39%
1.77%
-0.16%
-5.19%
0.43%
2.48%
-2.39%
-0.34%
2.46%
-1.66%
2.60%
-1.02%
2.74%
-3.06%
-1.12%
3.83%
-2.23%
3.09%
-2.43%
0.76%
1.49%
1.27%
-0.11%
-0.58%
0.05%
-2.89%
4.19%
-0.02%
-0.56%
-2.15%
-1.21%
-1.62%
2.00%
1.13%
1.79%
-0.61%
1.81%
-0.12%
-0.47%
0.62%
-0.72%

2.70%
-0.12%
-1.46%
-1.92%
-0.18%
0.18%
-1.05%
0.30%
0.55%
-4.11%
-3.43%
2.77%
-2.15%
-0.03%
-1.11%
0.31%
1.14%
1.21%
1.31%
-2.31%
1.22%
1.54%
-0.88%
3.21%
-1.55%
-1.32%
-0.47%
-1.09%
1.88%
-0.40%
-0.74%
-0.52%
0.35%
-0.26%
-0.27%
-1.04%
-0.03%
-0.38%
-0.07%
0.00%
0.82%
3.65%
1.34%
0.86%
0.40%
-0.33%
0.08%

0.78%
-0.46%
-0.78%
-0.74%
-0.07%
0.79%
0.25%
0.95%
0.73%
-2.36%
-0.66%
2.69%
-2.01%
0.64%
-0.20%
-2.66%
1.46%
1.78%
0.27%
-0.78%
0.65%
0.23%
0.10%
0.83%
-0.74%
-0.15%
0.00%
0.63%
0.64%
-0.15%
0.79%
-0.29%
1.62%
-0.31%
-2.29%
0.59%
2.21%
-0.47%
-0.08%
2.81%
0.61%
1.03%
-1.24%
0.16%
1.70%
-0.08%
-0.22%

0.30%
0.21%
-2.46%
0.02%
-0.56%
-0.31%
-0.87%
-0.31%
-0.69%
-2.62%
-2.14%
3.27%
-1.93%
...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags