would you please answer all 6 question clear and precisely in an excel format with formula.

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 Items Net Sales Gender Type of Customer Method of Payment Marital Status Reguan 39.50 DO Mate Married PE Promotional 10240 Female Mamed Petitir Huary and ng Female Married napety and met TOOSID Fm Marned oprietary and method of payment meters to charges made using a National Clothing Gustomer warnadeia purchase using a discount coupon are referred to as Sonal customs customers who made a purchase but did not use a discount dan customers. Because the promotional coupons were not 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 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: UHV SBA BUSI 3304 Dr. Chen 1. Percent frequency distributions for each of the key variables: number of items purchased, net sales, method of payment, gender, marital status, and age. (20%) 2. Asorted bar chart showing the number of customer purchases attributable to the method of payment. (15%) 3. Acrosstabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities of differences observed. (15%) 4. A scatter chart to explore the relationship between net sales and customer age. (15%) 5. A chart (iescatter chart with trendline) to examine whether the relationship between net sales and age depends on the marital status of the customer. (20%) GAside-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%) G H 10 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 11 10 Regular 12 11 Regular 13 12 Promotional 14 13 Promotional 15 14 Promotional 16 15 Regular 17 16 Promotional 18 17 Promotional 19 18 Regular 20 19 Promotional 21 20 Promotional 22 21 Promotional 23 22 Promotional 24 23 Dromotional Data C D E F G Method of Marital Items Net Sales Payment Gender Status 1 39.50 Discover Male Married 102.40 Proprietary Card Female Married 1 22,50 Proprietary Card Female Married 5 100.40 Proprietary Card Female Married 2 54.00 MasterCard Female Married 1 44.50 MasterCard Female Married 2 78.00 Proprietary Card Female Married 1 22.50 Visa Female Married 2 56.52 Proprietary Card Female Married 1 44.50 Proprietary Card Female Married 1 29.50 Proprietary Card Female Married 1 31.60 Proprietary Card Female Married 9 160.40 Visa Female Married 2 64.50 Visa Female Married 1 49.50 Visa Male Single 2 71.40 Proprietary Card Male Single 3 94.00 Proprietary Card Female Single 3 54.50 Discover Female Married 2 38.50 Master Card Female Married 6 44.80 Proprietary Card Female Married 1 31.60 Proprietary Card Female Single 4 70.82 Proprietary Card Female Married 766.00 American Re Eemale Married Age 32 36 32 28 34 44 30 40 46 36 48 40 40 46 24 36 22 40 32 56 28 09 SSL 38 50 Ready Type here to search O i J13 7 2 H 50 42 48 60 54 42 32 70 28 A B 24 23 Promotional 25 24 Regular 26 25 Promotional 27 26 Promotional 28 27 Regular 29 28 Promotional 30 29 Promotional 31 30 Promotional 32 31 Promotional 33 32 Regular 34 33 Promotional 35 34 Regular 36 35 Promotional 37 36 Regular 38 37 Regular 39 38 Promotional 40 39 Promotional 41 40 Regular 42 41 Promotional 43 42 Promotional 44 43 Regular 45 44 Promotional 46 Promotional 47 46 Promotional 48 47 Remiar Data 2 1 1 5 3 1 2 1 3 1 5 1 2 6 5 2 13 4 2 1 2 2 D E F 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 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 23.00 MacterCard Female G Married Married Married Married Married Single Married Married Married Married Married Married Married Single Single Married Married Married Married Married Married Married Married Married Married 52 44 34 56 36 42 50 44 58 42 46 48 54 38 60 58 C- 15 1 Ready Type here to search ORA you PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Un J13 X fo H 60 46 30 32 CA 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 A B 46 Promotional 47 Regular 48 Promotional 49 Promotional 50 Promotional 51 Promotional 52 Promotional 53 Regular 54 Regular 55 Regular 56 Promotional 57 Promotional 58 Promotional 59 Promotional 60 Promotional 61 Promotional 62 Promotional 63 Promotional 64 Promotional 65 Promotional 66 Promotional 67 Promotional 68 Promotional 69 Promotional 70 Denmntional Data 2 1 3 1 9 6 5 1 2 2 3 6 2 4 D E F 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 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 05.05. Deonrietat Card Eemala G Married Married Married Married Married Married Married Single Single Married Married Married Married Married Single Married Single Married Single Married Married Married Married Married Married 38 68 78 20 32 38 54 48 46 50 46 30 54 42 48 62 34 28 46 51 1 3 5 1 2 1 2 Ready Type here to search O PRI PROTECTED VIEW Be careful files from the X Vfx J13 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 B 69 Promotional 70 Promotional 71 Promotional 72 Promotional 73 Regular 74 Promotional 75 Promotional 76 Promotional 77 Regular 78 Promotional 79 Promotional 80 Regular 81 Promotional 82 Promotional 83 Promotional 84 Promotional 85 Regular 86 Promotional 87 Regular 88 Regular 89 Promotional 90 Promotional 91 Promotional 92 Promotional 03 Ramalar Data 2 8 5 4 1 2 2 4 2 4 3 2 2 6 D E F 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 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 150 75 Dronnistarst Card Femala G Married Married Married Married Single Married Married Married Married Married Married Married Married Single Married Married Married Married Single Married Single Married Married Married Married H 46 54 30 32 22 32 74 62 42 28 38 54 68 30 36 44 4 44 co o 26 3 2 1 6 4 1 62 48 36 20 42 54 54 70 9 6 RUS 19 4 1 5 Ready Type here to search o RI S Search ( AQ PelicanStores (2) - Protected View - AutoSave OH T Data Review View Formulas Help Home Draw File Insert Page Layout D PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Vies fx J13 G 3 04 25 26 A 92 93 94 95 96 97 98 99 100 B Promotional Regular Promotional Regular Regular Promotional Promotional Promotional Promotional D E F 22.42 Proprietary Card Female 159.75 Proprietary Card Female 229.50 Proprietary Card Female 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 1 5 17 3 1 9 10 2 1 H 54 72 30 46 44 30 52 30 44 Married Married Married Married Married Married Married Married Married 28 99 300 101 302 103 104 105 106 107 108 109 110 111 112 113 114 115 116 1.17 Data Ready Type here to search o RI