Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 Regular 1 49.5 Discover Male Married 22 2 Promotional 1 112.4 Proprietary Card Female Married 26 3 Regular 1 32.5 Proprietary Card Female Married 22 4 Promotional 5 110.4 Proprietary Card Female Married 18 5 Regular 2 64 MasterCard Female Married 24 6 Regular 1 54.5 MasterCard Female Married 34 7 Promotional 2 88 Proprietary Card Female Married 20 8 Regular 1 32.5 Visa Female Married 30 9 Promotional 2 66.52 Proprietary Card Female Married 36 10 Regular 1 54.5 Proprietary Card Female Married 26 11 Regular 1 39.5 Proprietary Card Female Married 38 12 Promotional 1 41.6 Proprietary Card Female Married 30 13 Promotional 9 170.4 Visa Female Married 30 14 Promotional 2 74.5 Visa Female Married 36 15 Regular 1 59.5 Visa Male Single 44 16 Promotional 2 81.4 Proprietary Card Male Single 26 17 Promotional 3 104 Proprietary Card Female Single 32 18 Regular 3 64.5 Discover Female Married 30 19 Promotional 2 48.5 MasterCard Female Married 22 20 Promotional 6 54.8 Proprietary Card Female Married 46 21 Promotional 1 41.6 Proprietary...

90.2K

Verified Solution

Question

Basic Math

CustomerType ofCustomerItemsNet SalesMethod ofPaymentGenderMaritalStatusAge
1Regular149.5DiscoverMaleMarried22
2Promotional1112.4Proprietary CardFemaleMarried26
3Regular132.5Proprietary CardFemaleMarried22
4Promotional5110.4Proprietary CardFemaleMarried18
5Regular264MasterCardFemaleMarried24
6Regular154.5MasterCardFemaleMarried34
7Promotional288Proprietary CardFemaleMarried20
8Regular132.5VisaFemaleMarried30
9Promotional266.52Proprietary CardFemaleMarried36
10Regular154.5Proprietary CardFemaleMarried26
11Regular139.5Proprietary CardFemaleMarried38
12Promotional141.6Proprietary CardFemaleMarried30
13Promotional9170.4VisaFemaleMarried30
14Promotional274.5VisaFemaleMarried36
15Regular159.5VisaMaleSingle44
16Promotional281.4Proprietary CardMaleSingle26
17Promotional3104Proprietary CardFemaleSingle32
18Regular364.5DiscoverFemaleMarried30
19Promotional248.5MasterCardFemaleMarried22
20Promotional654.8Proprietary CardFemaleMarried46
21Promotional141.6Proprietary CardFemaleSingle18
22Promotional480.82Proprietary CardFemaleMarried28
23Promotional7276American ExpressFemaleMarried40
24Regular284Proprietary CardFemaleMarried32
25Promotional249.5VisaMaleMarried38
26Promotional140.02Proprietary CardFemaleMarried50
27Regular154.5Proprietary CardFemaleMarried44
28Promotional5202.8Proprietary CardFemaleSingle32
29Promotional381.2Proprietary CardFemaleMarried22
30Promotional128Proprietary CardFemaleMarried60
31Promotional273.2MasterCardFemaleMarried18
32Regular185Proprietary CardFemaleMarried42
33Promotional373.2Proprietary CardFemaleMarried34
34Regular150Proprietary CardFemaleMarried24
35Promotional5115.5MasterCardFemaleMarried46
36Regular139.5MasterCardMaleSingle26
37Regular2112.5VisaFemaleSingle32
38Promotional6127.5Proprietary CardFemaleMarried40
39Promotional523.23Proprietary CardFemaleMarried34
40Regular262.5Proprietary CardFemaleMarried48
41Promotional13208.8Proprietary CardFemaleMarried32
42Promotional429.5VisaFemaleMarried36
43Regular2133.5Proprietary CardFemaleMarried38
44Promotional172.4Proprietary CardFemaleMarried44
45Promotional233.8Proprietary CardFemaleMarried28
46Promotional249.6Proprietary CardFemaleMarried50
47Regular135MasterCardFemaleMarried36
48Promotional373.64Proprietary CardFemaleMarried20
49Promotional124.82Proprietary CardFemaleMarried22
50Promotional9155.2MasterCardFemaleMarried36
51Promotional6186.62Proprietary CardFemaleMarried28
52Promotional5128.8Proprietary CardMaleMarried58
53Regular168DiscoverFemaleSingle68
54Regular284VisaFemaleSingle84
55Regular259.5MasterCardFemaleMarried22
56Promotional3151.6Proprietary CardFemaleMarried28
57Promotional6133.1Proprietary CardFemaleMarried44
58Promotional290.4Proprietary CardFemaleMarried38
59Promotional475.2MasterCardFemaleMarried36
60Promotional4123Proprietary CardFemaleSingle40
61Promotional1118.8Proprietary CardFemaleMarried36
62Promotional369.91Proprietary CardFemaleSingle20
63Promotional563.6Proprietary CardFemaleMarried44
64Promotional141.6Proprietary CardFemaleSingle32
65Promotional259.5Proprietary CardFemaleMarried38
66Promotional149.6Proprietary CardFemaleMarried52
67Promotional269.5Proprietary CardFemaleMarried24
68Promotional5156.8Proprietary CardFemaleMarried18
69Promotional257.2Proprietary CardMaleMarried36
70Promotional8105.05Proprietary CardFemaleMarried44
71Promotional5165.32Proprietary CardFemaleMarried20
72Promotional468MasterCardFemaleMarried22
73Regular179Proprietary CardFemaleSingle54
74Promotional256.5Proprietary CardFemaleMarried22
75Promotional255.22Proprietary CardFemaleMarried64
76Promotional494.74Proprietary CardFemaleMarried52
77Regular249Proprietary CardFemaleMarried32
78Promotional4121.14Proprietary CardFemaleMarried18
79Promotional396.8Proprietary CardFemaleMarried28
80Regular299DiscoverFemaleMarried44
81Promotional288MasterCardFemaleMarried58
82Promotional663.2Proprietary CardFemaleSingle20
83Promotional468.5VisaFemaleMarried26
84Promotional356Proprietary CardFemaleMarried34
85Regular247.5VisaFemaleMarried34
86Promotional130.8Proprietary CardFemaleMarried52
87Regular6154MasterCardFemaleSingle38
88Regular4117Proprietary CardFemaleMarried26
89Promotional141.6Proprietary CardFemaleSingle50
90Promotional667.6Proprietary CardFemaleMarried32
91Promotional4105.2Proprietary CardFemaleMarried44
92Promotional132.42Proprietary CardFemaleMarried44
93Regular5169.75Proprietary CardFemaleMarried62
94Promotional17239.5Proprietary CardFemaleMarried20
95Regular376American ExpressFemaleMarried36
96Regular149.5MasterCardFemaleMarried34
97Promotional9263Proprietary CardFemaleMarried20
98Promotional10297.59Proprietary CardFemaleMarried42
99Promotional257.6Proprietary CardFemaleMarried20
100Promotional138.44Proprietary CardFemaleMarried34

a) Using the empirical rule, 95% of female promotional customerages should be between what two values? Either show work or explainhow your answer was calculated.

b)Using the empirical rule, 68% of items purchased should bebetween what two values? Either show work or explain how youranswer was calculated.    

Answer & Explanation Solved by verified expert
3.9 Ratings (782 Votes)
We can use the excel to filter the given data set First copy the given data set into the excel then select allthe data set go to Data menu click on Filter Thenclick the filter symbol at Types of the customers Check the boxfor promotions and similarly click the filter symbol at Genderand check the box for femaleYou will get the filtered data set with ages of femalepromotional customersThen find    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students