Case 1 (Accounting Application) Use the tabular graphical methods of descriptive
ID: 2922649 • Letter: C
Question
Case 1 (Accounting Application) Use the tabular graphical methods of descriptive statistics to summarize the sample data in the data set named PelicanStores. The managerial report should contain summaries such as: 1. A frequency and relative frequency distributions for the methods of payment (different cards). (20%) 2. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from regular customers. (20%) 3. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from married female. (20%) 4. Apply the location method to calculate the 75th percentile manually of net sales for each method (card) of payment. Please indicate which card has the highest 75th percentile and show the process. (20%) 5. Apply Chebyshev’s Theorem to calculate the range (i.e. $ to $) of at least 80% of the net sales must fall within for the Proprietary Card payment. (20%) (Hint: What is the z-score for at least z-score for at least 80% of data range?)
Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 3 Regular 1 22.50 Proprietary Card Female Married 32 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 1 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 8 Regular 1 22.50 Visa Female Married 40 9 Promotional 2 56.52 Proprietary Card Female Married 46 10 Regular 1 44.50 Proprietary Card Female Married 36 11 Regular 1 29.50 Proprietary Card Female Married 48 12 Promotional 1 31.60 Proprietary Card Female Married 40 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2 64.50 Visa Female Married 46 15 Regular 1 49.50 Visa Male Single 24 16 Promotional 2 71.40 Proprietary Card Male Single 36 17 Promotional 3 94.00 Proprietary Card Female Single 22 18 Regular 3 54.50 Discover Female Married 40 19 Promotional 2 38.50 MasterCard Female Married 32 20 Promotional 6 44.80 Proprietary Card Female Married 56 21 Promotional 1 31.60 Proprietary Card Female Single 28 22 Promotional 4 70.82 Proprietary Card Female Married 38 23 Promotional 7 266.00 American Express Female Married 50 24 Regular 2 74.00 Proprietary Card Female Married 42 25 Promotional 2 39.50 Visa Male Married 48 26 Promotional 1 30.02 Proprietary Card Female Married 60 27 Regular 1 44.50 Proprietary Card Female Married 54 28 Promotional 5 192.80 Proprietary Card Female Single 42 29 Promotional 3 71.20 Proprietary Card Female Married 32 30 Promotional 1 18.00 Proprietary Card Female Married 70 31 Promotional 2 63.20 MasterCard Female Married 28 32 Regular 1 75.00 Proprietary Card Female Married 52 33 Promotional 3 63.20 Proprietary Card Female Married 44 34 Regular 1 40.00 Proprietary Card Female Married 34 35 Promotional 5 105.50 MasterCard Female Married 56 36 Regular 1 29.50 MasterCard Male Single 36 37 Regular 2 102.50 Visa Female Single 42 38 Promotional 6 117.50 Proprietary Card Female Married 50 39 Promotional 5 13.23 Proprietary Card Female Married 44 40 Regular 2 52.50 Proprietary Card Female Married 58 41 Promotional 13 198.80 Proprietary Card Female Married 42 42 Promotional 4 19.50 Visa Female Married 46 43 Regular 2 123.50 Proprietary Card Female Married 48 44 Promotional 1 62.40 Proprietary Card Female Married 54 45 Promotional 2 23.80 Proprietary Card Female Married 38 46 Promotional 2 39.60 Proprietary Card Female Married 60 47 Regular 1 25.00 MasterCard Female Married 46 48 Promotional 3 63.64 Proprietary Card Female Married 30 49 Promotional 1 14.82 Proprietary Card Female Married 32 50 Promotional 9 145.20 MasterCard Female Married 46 51 Promotional 6 176.62 Proprietary Card Female Married 38 52 Promotional 5 118.80 Proprietary Card Male Married 68 53 Regular 1 58.00 Discover Female Single 78 54 Regular 2 74.00 Visa Female Single 20 55 Regular 2 49.50 MasterCard Female Married 32 56 Promotional 3 141.60 Proprietary Card Female Married 38 57 Promotional 6 123.10 Proprietary Card Female Married 54 58 Promotional 2 80.40 Proprietary Card Female Married 48 59 Promotional 4 65.20 MasterCard Female Married 46 60 Promotional 4 113.00 Proprietary Card Female Single 50 61 Promotional 1 108.80 Proprietary Card Female Married 46 62 Promotional 3 59.91 Proprietary Card Female Single 30 63 Promotional 5 53.60 Proprietary Card Female Married 54 64 Promotional 1 31.60 Proprietary Card Female Single 42 65 Promotional 2 49.50 Proprietary Card Female Married 48 66 Promotional 1 39.60 Proprietary Card Female Married 62 67 Promotional 2 59.50 Proprietary Card Female Married 34 68 Promotional 5 146.80 Proprietary Card Female Married 28 69 Promotional 2 47.20 Proprietary Card Male Married 46 70 Promotional 8 95.05 Proprietary Card Female Married 54 71 Promotional 5 155.32 Proprietary Card Female Married 30 72 Promotional 4 58.00 MasterCard Female Married 32 73 Regular 1 69.00 Proprietary Card Female Single 22 74 Promotional 2 46.50 Proprietary Card Female Married 32 75 Promotional 2 45.22 Proprietary Card Female Married 74 76 Promotional 4 84.74 Proprietary Card Female Married 62 77 Regular 2 39.00 Proprietary Card Female Married 42 78 Promotional 4 111.14 Proprietary Card Female Married 28 79 Promotional 3 86.80 Proprietary Card Female Married 38 80 Regular 2 89.00 Discover Female Married 54 81 Promotional 2 78.00 MasterCard Female Married 68 82 Promotional 6 53.20 Proprietary Card Female Single 30 83 Promotional 4 58.50 Visa Female Married 36 84 Promotional 3 46.00 Proprietary Card Female Married 44 85 Regular 2 37.50 Visa Female Married 44 86 Promotional 1 20.80 Proprietary Card Female Married 62 87 Regular 6 144.00 MasterCard Female Single 48 88 Regular 4 107.00 Proprietary Card Female Married 36 89 Promotional 1 31.60 Proprietary Card Female Single 20 90 Promotional 6 57.60 Proprietary Card Female Married 42 91 Promotional 4 95.20 Proprietary Card Female Married 54 92 Promotional 1 22.42 Proprietary Card Female Married 54 93 Regular 5 159.75 Proprietary Card Female Married 72 94 Promotional 17 229.50 Proprietary Card Female Married 30 95 Regular 3 66.00 American Express Female Married 46 96 Regular 1 39.50 MasterCard Female Married 44 97 Promotional 9 253.00 Proprietary Card Female Married 30 98 Promotional 10 287.59 Proprietary Card Female Married 52 99 Promotional 2 47.60 Proprietary Card Female Married 30 100 Promotional 1 28.44 Proprietary Card Female Married 44Explanation / Answer
a)
Method of Payment Frequency Relative Frequency
American Express 2 2.00
Discover 4 4.00
MasterCard 14 14.00
Proprietary Card 70 70.00
Visa 10 10.00
N= 100
b) Descriptive Statistics: Net Sales
Type of
Variable Customer Mean StDev Q1 Median Q3
Net Sales Promotional 84.29 61.46 43.50 63.42 109.38
Regular 61.99 35.07 39.38 51.00 74.25
c) Descriptive Statistics: Net Sales
Results for Marital Status = Married
Variable Gender Mean StDev Q1 Median Q3
Net Sales Female 78.87 58.51 39.70 60.95 101.90
d) Descriptive Statistics: Net Sales
Variable Method of Payment Q3
Net Sales American Express *
Discover 81.3
MasterCard 84.9
Proprietary Card 107.45
Visa 81.1
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.