I cant upload the Excel file itself nor can I format the question in a manner that resembles Excel because the question is too long apparently.

Name Box B D E F G H 1 Customer Items 2 2 1 Age 36 28 30 3 4 5 4 7 2 5 9 12 2 1 6 7 13 9 14 8 9 2 2 16 17 46 40 40 46 36 22 32 56 28 10 3 11 19 2 12 20 6 1 13 14 15 21 22 23 4 7 16 25 2 38 50 48 60 42 17 26 1 18 28 5 3 19 29 20 30 1 2 31 21 22 Type of Customer Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Method of Net Sales Payment Gender 102.40 Proprietary Card Female 100.40 Proprietary Card Female 78.00 Proprietary Card Female 56.52 Proprietary Card Female 31.60 Proprietary Card Female 160.40 Visa Female 64.50 Visa Female 71.40 Proprietary Card Male 94.00 Proprietary Card Female 38.50 MasterCard Female 44.80 Proprietary Card Female 31.60 Proprietary Card Female 70.82 Proprietary Card Female 266.00 American Express Female 39.50 Visa Male 30.02 Proprietary Card Female 192.80 Proprietary Card Female 71.20 Proprietary Card Female 18.00 Proprietary Card Female 63.20 MasterCard Female 63.20 Proprietary Card Female 105.50 MasterCard Female 117.50 Proprietary Card Female 13.23 Proprietary Card Female 198.80 Proprietary Card Female 19.50 Visa Female 62.40 Proprietary Card Female 23.80 Proprietary Card Female 39.60 Proprietary Card 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 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 Marital Status Married Married Married Married Married Married Married Single Single Married Married Single Married Married Married Married Single Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Single Married Single Married 32 70 28 44 56 50 33 3 23 35 5 6 24 38 25 39 5 41 13 26 27 44 42 46 54 42 4 28 44 1 29 45 2 30 46 2 38 60 30 32 31 48 3 49 1 32 33 9 50 51 46 38 34 6 35 52 5 68 36 56 3 38 54 37 57 6 38 58 2 39 59 4 40 60 4 48 46 50 46 30 54 41 61 62 1 3 42 43 63 5 64 1 42 44 45 2 48 65 66 46 1 Female Female Female Female Female 62 47 67 2 34 48 68 5 28 2 Male 46 49 50 69 70 8 54 5 30 4 32 71 72 74 75 2 32 2 74 4 62 76 78 4 28 3 38 79 81 2 68 82 6 30 4 36 83 84 3 44 1 62 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 86 89 90 1 20 6 42 Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Female Male Female Female Female Female Female Female 4 31.60 Proprietary Card 49.50 Proprietary Card 39.60 Proprietary Card 59.50 Proprietary Card 146.80 Proprietary Card 47.20 Proprietary Card 95.05 Proprietary Card 155.32 Proprietary Card 58.00 MasterCard 46.50 Proprietary Card 45.22 Proprietary Card 84.74 Proprietary Card 111.14 Proprietary Card 86.80 Proprietary Card 78.00 MasterCard 53.20 Proprietary Card 58.50 Visa 46.00 Proprietary Card 20.80 Proprietary Card 31.60 Proprietary Card 57.60 Proprietary Card 95.20 Proprietary Card 22.42 Proprietary Card 229.50 Proprietary Card 253.00 Proprietary Card 287.59 Proprietary Card 47.60 Proprietary Card 28.44 Proprietary Card 39.50 Discover 22.50 Proprietary Card 54.00 MasterCard 44.50 MasterCard 22.50 Visa 44.50 Proprietary Card 29.50 Proprietary Card 49.50 Visa 54.50 Discover 74.00 Proprietary Card 44.50 Proprietary Card 75.00 Proprietary Card 40.00 Proprietary Card 29.50 MasterCard 102.50 Visa Single Married Married Married Married Married Married Married Married Married Married Married Married Married Married Single Married Married Married Single Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Single Married Married Married Married Married Single Single 91 92 94 97 98 54 1 54 17 30 9 30 10 52 30 99 100 1 2 1 44 1 32 1 32 3 5 2 34 75 6 1 44 76 8 1 40 10 1 36 77 78 79 11 1 48 15 1 24 3 40 80 81 82 18 24 2 42 1 54 Male Female Female Female Female Female Male Female 1 52 27 32 34 36 37 1 83 84 85 86 34 1 36 2 42 40 2 58 87 88 43 2 48 89 1 46 90 47 53 54 1 78 20 2 55 2 32 1 22 73 77 80 Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular 2 52.50 Proprietary Card Female 123.50 Proprietary Card Female 25.00 MasterCard Female 58.00 Discover Female 74.00 Visa Female 49.50 MasterCard Female 69.00 Proprietary Card Female 39.00 Proprietary Card Female 89.00 Discover Female 37.50 Visa Female 144.00 MasterCard Female 107.00 Proprietary Card Female 159.75 Proprietary Card Female 66.00 American Express Female 39.50 MasterCard Female Married Married Married Single Single Married Single Married Married Married Single Married Married Married 91 92 93 94 95 96 97 98 99 100 101 42 2 54 44 85 2 87 6 48 4 88 93 36 72 5 95 3 46 96 1 Married 44 1. Percent frequency distribution for key variables Table 1: Method of payment Frequency % Frequency #NAME? American Express Discover MasterCard Proprietary Card Visa Total - - - 1 - - - 1