The Excel table below represents the sample of 100 in store credit transaction at one day pelican stores. The variables represented in the data are customer type, items purchased, net sales, method of payment, gender, marital status, and age.

Most of the variables in the data file are self-explanatory, but two of the variables require some clarification:

Items: The total number of items purchased?

Net sales: The total amount ($) charged to the card

Pelicans management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

1. Determine the Percent frequency distributions for each of the key variables : number of items purchased, net sales, method of payment, gender, marital status, and age?

1. Percent frequency distributions created in Excel using PivotTables for each of the key variables: number of items purchased, net sales, method of payment, gender, marital status, and age?

2. A sorted bar chart showing the number of customer purchases attributable to the method of payment?

3. A crosstabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences observed. 4. A scatter chart with a trendline to explore the relationship between net sales and customer age?

5. A chart to examine whether the relationship between net sales and age depends on the marital status of the customer?

6. A clustered 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?

Can please Explain step by step how you get the answer. Excel data sheet below suppose to be one page but it was too long so I took image.

Marital 36 2 3 4 7 1 1 1 3 2 1 2 1 2 1 1 1 9 Married Married Married Married Married Married Married Married Married Married Mamed Mar Married Married 4 10 40 9 Customer Customer 1 Peter Promotional | Popular Promo 5 G Popular Promotional Popular Promote Peter Popular Protector Promotional 14 Promotional 15 | Popular Promotional 17 Promotional | Popular 19 Promotional 20 Promotional 21 Promotional 22 Promotional 23 Promotional 24 Regular 25 Protector Promotional 36 10 11 12 13 40 24 16 22 Mamed Mamed Married Mard Mar Mar Mard Married Married Sales Method of Payment Gender 22.50 DO Make 102.00 Proprietary Card Fortale 22.50 Proprietary Card Female 1000 Proprietary Card Female 51.00 MasterCard Ferra 40 MerCard Ferra TIL. 00 Proprietary Card Ferna 22.30 V Ferra 5652 Proprietary Card Ferra LSO Proprietary Card Ferra 22.50 Proprietary Card Ferra 31. Proprietary Card Female 1600 W Ferra GAL 50 W Ferra 49.50 W Male 71.40 Proprietary Card Male 91100 Proprietary Card Ferale 54.30 DO Ferale 30 Mard Ferale O Proprietary Card Ferale 31. Proprietary Card Ferale 7012 Proprietary Card Ferale 206.00 Anerkantpre Fera 7.00 Proprietary Card Ferra Male 30.02 Proprietary Card Fortale 1.50 Proprietary Card Female 19.2. Proprietary Card Female 71.20 Proprietary Card Female 11.00 Proprietary Card Female 63.20 MasterCard Female 75.00 Proprietary Card Female 62.20 Proprietary Card Female 20.00 Proprietary Card Female 105.50 MasterCard Ferra 22.50 MasterCard Mail 102.50 W Female 117.50 Proprietary Card Ferra 11.23 Proprietary Card Ferra 52.50 Proprietary Card Ferra 19. Proprietary Card Ferra 19.50 V Ferra 121.50 Proprietary Card Ferra 2.0 Proprietary Card Ferra 21.6. Proprietary Card Ferra 22. Proprietary Card Female 23.00 MasterCard Ferra GIGA Proprietary Card Ferra 14.02 Proprietary Card Ferra 146.20 MasterCard Ferra 2 1 2 3 3 2 G 1 4 7 2 2 1 1 5 3 1 2 1 3 1 5 1 2 G 5 2 13 Promotional Promotional Promotional Promotional Married Married Married Married Married Married Married GRAQOBNNUMMEN Promotional SENARAR Prartition Peter Promotional Promotional Regular Promotional Promotional Regular Promotional Promotional Promotional Peter Promotional Promotional Promotional 1 Married Married Married Married Married Mar Mar Mar Married Mar Married Married Married 1 3 1 90 51 32 Promotional Promotional Popular G 3 Married Married 70 20 1 2 2 3 90 2 54 57 Married Married Married Married Married G 2 39 4 4 90 Married 10 Married Popular Promotional Promotional Promotional Promotional Promotor Promotion Promotional Prartition Promotional | Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Peter Promotional Promotional Promotional Peter Promotional Promotional M Ferrae Make Ferra Ferra Ferra Ferra Ferra Ferra Ferra Ferale Ferale Ferra Ferra Female Female Ferra Female Ferra Male Ferra Female Female Ferra Female Female Fermale Female Married Married Married Mare Married Married Married Married 54 74 &&&&&&GUREAZAARBECURB 8888 1 3 3 1 2 1 2 3 2 . 5 4 1 2 2 4 2 4 3 2 2 G 4 3 2 1 G 4 1 G 176. Proprietary Card 11. Proprietary Card 5.00 h 711,00 12.50 MasterCard 141. Proprietary Card 121.10 Proprietary Card m. Proprietary Card 65.20 MasterCard 113. Proprietary Card 10. Proprietary Card 50.91 Proprietary Card 51. Proprietary Card 31. Go Proprietary Card 12.50 Proprietary Card 32.60 Proprietary Card 59.30 Proprietary Card 146. Proprietary Card 47.20 Proprietary Card 35. Proprietary Card 155.32 Proprietary Card 500 M Card 69.00 Proprietary Card 6.50 Proprietary Card 15.22 Proprietary Card 1. Proprietary Card 39.00 Proprietary Card 111.14 Proprietary Card 4. Bo Proprietary Card 9.00 Dcover TIL O0 MasterCard 51.2. Proprietary Card 8.00 Proprietary Card 37.50 V 2. Proprietary Card 14.00 MasterCard 107.. Proprietary Card 31. Go Proprietary Card 57.co Proprietary Card 95.20 Proprietary Card 22. Proprietary Card 152.7 Proprietary Card 28. Proprietary Card 66.00 American barem 12.50 MasterCard 251.00 Proprietary Card 2017.59 Proprietary Card 47.60 Proprietary Card 21 Proprietary Card Married Mamed Mamed Mamed Marie Mamed Mar Married Promotional Promotional Promotional Promotional Mamed Mamed Mamed Mamed Promotional Married Fert Ferale Ferra Ferale Female Ferale Female Female Female Female Fortale Ferra Ferra Ferra Ferra Ferra Ferra Female Ferra Ferra Fera Ferra Promotional Promotion Promotional Promotional Regular Promotional 90 91 1 5 17 54 72 10 Mamed Married Married Married Married Married Married Married Married Mamed Married 1 97 10 10 Promotional Prorical Promotional Promotional 100 1 Marital 36 2 3 4 7 1 1 1 3 2 1 2 1 2 1 1 1 9 Married Married Married Married Married Married Married Married Married Married Mamed Mar Married Married 4 10 40 9 Customer Customer 1 Peter Promotional | Popular Promo 5 G Popular Promotional Popular Promote Peter Popular Protector Promotional 14 Promotional 15 | Popular Promotional 17 Promotional | Popular 19 Promotional 20 Promotional 21 Promotional 22 Promotional 23 Promotional 24 Regular 25 Protector Promotional 36 10 11 12 13 40 24 16 22 Mamed Mamed Married Mard Mar Mar Mard Married Married Sales Method of Payment Gender 22.50 DO Make 102.00 Proprietary Card Fortale 22.50 Proprietary Card Female 1000 Proprietary Card Female 51.00 MasterCard Ferra 40 MerCard Ferra TIL. 00 Proprietary Card Ferna 22.30 V Ferra 5652 Proprietary Card Ferra LSO Proprietary Card Ferra 22.50 Proprietary Card Ferra 31. Proprietary Card Female 1600 W Ferra GAL 50 W Ferra 49.50 W Male 71.40 Proprietary Card Male 91100 Proprietary Card Ferale 54.30 DO Ferale 30 Mard Ferale O Proprietary Card Ferale 31. Proprietary Card Ferale 7012 Proprietary Card Ferale 206.00 Anerkantpre Fera 7.00 Proprietary Card Ferra Male 30.02 Proprietary Card Fortale 1.50 Proprietary Card Female 19.2. Proprietary Card Female 71.20 Proprietary Card Female 11.00 Proprietary Card Female 63.20 MasterCard Female 75.00 Proprietary Card Female 62.20 Proprietary Card Female 20.00 Proprietary Card Female 105.50 MasterCard Ferra 22.50 MasterCard Mail 102.50 W Female 117.50 Proprietary Card Ferra 11.23 Proprietary Card Ferra 52.50 Proprietary Card Ferra 19. Proprietary Card Ferra 19.50 V Ferra 121.50 Proprietary Card Ferra 2.0 Proprietary Card Ferra 21.6. Proprietary Card Ferra 22. Proprietary Card Female 23.00 MasterCard Ferra GIGA Proprietary Card Ferra 14.02 Proprietary Card Ferra 146.20 MasterCard Ferra 2 1 2 3 3 2 G 1 4 7 2 2 1 1 5 3 1 2 1 3 1 5 1 2 G 5 2 13 Promotional Promotional Promotional Promotional Married Married Married Married Married Married Married GRAQOBNNUMMEN Promotional SENARAR Prartition Peter Promotional Promotional Regular Promotional Promotional Regular Promotional Promotional Promotional Peter Promotional Promotional Promotional 1 Married Married Married Married Married Mar Mar Mar Married Mar Married Married Married 1 3 1 90 51 32 Promotional Promotional Popular G 3 Married Married 70 20 1 2 2 3 90 2 54 57 Married Married Married Married Married G 2 39 4 4 90 Married 10 Married Popular Promotional Promotional Promotional Promotional Promotor Promotion Promotional Prartition Promotional | Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Peter Promotional Promotional Promotional Peter Promotional Promotional M Ferrae Make Ferra Ferra Ferra Ferra Ferra Ferra Ferra Ferale Ferale Ferra Ferra Female Female Ferra Female Ferra Male Ferra Female Female Ferra Female Female Fermale Female Married Married Married Mare Married Married Married Married 54 74 &&&&&&GUREAZAARBECURB 8888 1 3 3 1 2 1 2 3 2 . 5 4 1 2 2 4 2 4 3 2 2 G 4 3 2 1 G 4 1 G 176. Proprietary Card 11. Proprietary Card 5.00 h 711,00 12.50 MasterCard 141. Proprietary Card 121.10 Proprietary Card m. Proprietary Card 65.20 MasterCard 113. Proprietary Card 10. Proprietary Card 50.91 Proprietary Card 51. Proprietary Card 31. Go Proprietary Card 12.50 Proprietary Card 32.60 Proprietary Card 59.30 Proprietary Card 146. Proprietary Card 47.20 Proprietary Card 35. Proprietary Card 155.32 Proprietary Card 500 M Card 69.00 Proprietary Card 6.50 Proprietary Card 15.22 Proprietary Card 1. Proprietary Card 39.00 Proprietary Card 111.14 Proprietary Card 4. Bo Proprietary Card 9.00 Dcover TIL O0 MasterCard 51.2. Proprietary Card 8.00 Proprietary Card 37.50 V 2. Proprietary Card 14.00 MasterCard 107.. Proprietary Card 31. Go Proprietary Card 57.co Proprietary Card 95.20 Proprietary Card 22. Proprietary Card 152.7 Proprietary Card 28. Proprietary Card 66.00 American barem 12.50 MasterCard 251.00 Proprietary Card 2017.59 Proprietary Card 47.60 Proprietary Card 21 Proprietary Card Married Mamed Mamed Mamed Marie Mamed Mar Married Promotional Promotional Promotional Promotional Mamed Mamed Mamed Mamed Promotional Married Fert Ferale Ferra Ferale Female Ferale Female Female Female Female Fortale Ferra Ferra Ferra Ferra Ferra Ferra Female Ferra Ferra Fera Ferra Promotional Promotion Promotional Promotional Regular Promotional 90 91 1 5 17 54 72 10 Mamed Married Married Married Married Married Married Married Married Mamed Married 1 97 10 10 Promotional Prorical Promotional Promotional 100 1