please answer question 5 and 6 clearly in an excel format.

Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in- store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file PelicanStores Table 3.13 shows a portion of the data set. Table 3.13 Data for a Sample of 100 Credit Card Purchases at Pelican Stores Customer Type of Customer Items Net Sales Gender Method of Payment Discover Marital Status 1 Regular 1 19.50 Male Married 2 Promotional 1 102.40 Proprietary Card Female Married Regular 22.50 Proprietary Card Female Marned Promotional 105.00 Female Mond Proprietary Card The Proprietary Card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. Pelican's management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons. Managerial Report Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following: 5. A chart (i.e., scatter chart with trendline) to examine whether the relationship between net sales and age depends on the marital status of the customer. (20%) 6. A side-by-side bar chart to examine the method of payment by customer type (regular or promotional). Comment on any differences you observe between the methods of payments used by the different types of customers. (15%) H B Type of 1 Customer Customer 2 1 Regular 3 2 Promotional 4 3 Regular 5 4 Promotional 6 5 Regular 7 6 Regular 8 7 Promotional 9 8 Regular 9 Promotional 10 Regular 12 11 Regular 12 Promotional 14 13 Promotional 15 14 Promotional 15 Regular 17 16 Promotional 18 17 Promotional 19 18 Regular C D E F Method of Items Net Sales Payment Gender 1 39.50 Discover Male 1 102.40 Proprietary Card Female 1 22.50 Proprietary Card Female 5 100.40 Proprietary Card Female 2 54.00 MasterCard Female 1 44.50 MasterCard Female 2 78.00 Proprietary Card Female 1 22.50 Visa Female 2 56.52 Proprietary Card Female 1 44.50 Proprietary Card Female 1 29.50 Proprietary Card Female 1 31.60 Proprietary Card Female 9 160.40 Visa Female 2 64.50 Visa Female 1 49.50 Visa Male 2 71.40 Proprietary Card Male 3 94.00 Proprietary Card Female 3 54.50 Discover Female G Marital Status Married Married Married Married Married Married Married Married Married Married Married Married Married Married Single Single Single Married 10 11 Age 32 36 32 28 34 44 30 40 46 36 48 40 40 46 24 36 22 40 32 13 16 Doa 00 20 21 22 23 24 25 26 27 28 A 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 B Promotional Promotional Promotional Promotional Promotional Regular Promotional Promotional Regular Promotional Promotional Promotional Promotional Regular Promotional Regular Promotional Regular Regular D E F 38.50 MasterCard Female 44.80 Proprietary Card Female 31.60 Proprietary Card Female 70.82 Proprietary Card Female 266.00 American Express Female 74.00 Proprietary Card Female 39.50 Visa Male 30.02 Proprietary Card Female 44.50 Proprietary Card Female 192.80 Proprietary Card Female 71.20 Proprietary Card Female 18.00 Proprietary Card Female 63.20 MasterCard Female 75.00 Proprietary Card Female 63.20 Proprietary Card Female 40.00 Proprietary Card Female 105.50 MasterCard Female 29.50 MasterCard Male 102.50 Visa Female G Married Married Single Married Married Married Married Married Married Single Married Married Married Married Married Married Married Single Single anged 2 6 1 4 7 2 2 1 1 5 3 1 2 1 3 1 5 1 2 32 56 28 38 50 42 48 60 54 42 32 70 28 52 44 34 56 36 42 50 & 29 30 31 32 33 34 35 36 37 38 VO 38 39 US ON 40 41 42 43 44 4 45 A 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 46 47 B Regular Promotional Promotional Regular Promotional Promotional Regular Promotional Promotional Promotional Regular Promotional Promotional Promotional Promotional Promotional Regular Regular Regular Promotional 2 6 5 2 13 4 2. 1 2 2 1 3 1 9 6 5 1 2 2. 3 D E F 102.50 Visa Female 117.50 Proprietary Card Female 13.23 Proprietary Card Female 52.50 Proprietary Card Female 198.80 Proprietary Card Female 19.50 Visa Female 123.50 Proprietary Card Female 62.40 Proprietary Card Female 23.80 Proprietary Card Female 39.60 Proprietary Card Female 25.00 MasterCard Female 63.64 Proprietary Card Female 14.82 Proprietary Card Female 145.20 MasterCard Female 176.62 Proprietary Card Female 118.80 Proprietary Card Male 58.00 Discover Female 74.00 Visa Female 49.50 MasterCard Female 141.60 Proprietary Card Female G Single Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married H 42 50 44 58 42 46 48 54 38 60 46 30 32 46 38 68 78 20 32 38 48 C 49 50 51 52 53 54 55 56 57 Single SOLO Single Married Married A 58 59 9800 S 986 60 61 62 63 64 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 65 66 67 68 69 70 71 B Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Regular Promotional Promotional Promotional 6 2 4 4 1 3 5 1 2 1 2 5 2 D E F 123.10 Proprietary Card Female 80.40 Proprietary Card Female 65.20 MasterCard Female 113.00 Proprietary Card Female 108.80 Proprietary Card Female 59.91 Proprietary Card Female 53.60 Proprietary Card Female 31.60 Proprietary Card Female 49.50 Proprietary Card Female 39.60 Proprietary Card Female 59.50 Proprietary Card Female 146.80 Proprietary Card Female 47.20 Proprietary Card Male 95.05 Proprietary Card Female 155.32 Proprietary Card Female 58.00 MasterCard Female 69.00 Proprietary Card Female 46.50 Proprietary Card Female 45.22 Proprietary Card Female 84.74 Proprietary Card Female G Married Married Married Single Married Single Married Single Married Married Married Married Married Married Married Married Single Married Married Married H 54 48 46 50 46 30 54 42 48 62 34 28 46 54 30 32 22 001 72 2 73 74 75 76 77 5 4 1 2 2 4 74 62 C C G 2 77 78 79 BO 81 82 83 84 A 76 77 78 79 80 81 82 83 84 85 4. 2 4 3 2 2 6 4 3 2 85 B Promotional Regular Promotional Promotional Regular Promotional Promotional Promotional Promotional Regular Promotional Regular Regular Promotional Promotional Promotional Promotional Regular Promotional D E F 84.74 Proprietary Card Female 39.00 Proprietary Card Female 111.14 Proprietary Card Female 86.80 Proprietary Card Female 89.00 Discover Female 78.00 MasterCard Female 53.20 Proprietary Card Female 58.50 Visa Female 46.00 Proprietary Card Female 37.50 Visa Female 20.80 Proprietary Card Female 144.00 MasterCard Female 107.00 Proprietary Card Female 31.60 Proprietary Card Female 57.60 Proprietary Card Female 95.20 Proprietary Card Female 22.42 Proprietary Card Female 159.75 Proprietary Card Female 229.50 Proprietary Card Female 66.00 American Express Female 88888888888 Married Married Married Married Married Married Single Married Married Married Married Single Married Single Married Married Married Married Married Married 86 87 88 89 90 91 92 93 86 H 62 42 28 38 54 68 30 36 44 44 62 48 36 20 42 54 54 72 30 46 1 87 6 4 1 6 4 89 90 91 92 93 94 4 1 5 17 UN 94 95 96 97 98 99 100 101 102 1103 A 95 96 97 98 99 100 B Regular Regular Promotional Promotional Promotional Promotional 3 1 9 10 2 1 D E F 66.00 American Express Female 39.50 MasterCard Female 253.00 Proprietary Card Female 287.59 Proprietary Card Female 47.60 Proprietary Card Female 28.44 Proprietary Card Female G Married Married Married Married Married Married H 46 44 30 52 30 44