Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. To analyze the total number of items purchased, construct an UNGROUPED frequency distribution, graph, and find the summary statistics (including the quartiles) by each

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

2. To analyze the total number of items purchased, construct an UNGROUPED frequency distribution, graph, and find the summary statistics (including the quartiles) by each type of customer (regular/promotion). Label the graphs completely. Describe the shape of the distribution for each type of customer, and discuss similarities or differences by interpreting the graphs and summary statistics. What can you conclude?

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Customer & \begin{tabular}{l} Type of \\ Customer \end{tabular} & Gender & \begin{tabular}{c} Marital \\ Status \end{tabular} & \begin{tabular}{l} Method of \\ Payment \end{tabular} & Age & Items & Net Sales \\ \hline 1 & Regular & Male & Married & Discover & 25 & 1 & 54.50 \\ \hline 3 & Regular & Male & Married & Proprietary Card & 25 & 1 & 37.50 \\ \hline 5 & Regular & Female & Married & MasterCard & 27 & 2 & 69.00 \\ \hline 6 & Regular & Female & Married & MasterCard & 37 & 1 & 59.50 \\ \hline 8 & Regular & Female & Married & Visa & 33 & 1 & 37.50 \\ \hline 10 & Regular & Female & Married & Proprietary Card & 29 & 1 & 59.50 \\ \hline 11 & Regular & Female & Married & Proprietary Card & 41 & 1 & 44.50 \\ \hline 15 & Regular & Male & Single & Visa & 17 & 1 & 64.50 \\ \hline 18 & Regular & Male & Married & Discover & 33 & 3 & 69.50 \\ \hline 24 & Regular & Female & Married & Proprietary Card & 35 & 2 & 89.00 \\ \hline 27 & Regular & Female & Married & Proprietary Card & 47 & 2 & 59.50 \\ \hline 32 & Regular & Female & Married & Proprietary Card & 45 & 2 & 90.00 \\ \hline 34 & Regular & Female & Married & Proprietary Card & 27 & 2 & 55.00 \\ \hline 36 & Regular & Male & Single & MasterCard & 29 & 1 & 44.50 \\ \hline 37 & Regular & Male & Single & Visa & 35 & 2 & 117.50 \\ \hline 40 & Regular & Female & Married & Proprietary Card & 51 & 2 & 67.50 \\ \hline 43 & Regular & Female & Married & Proprietary Card & 52 & 2 & 138.50 \\ \hline 47 & Regular & Female & Married & MasterCard & 39 & 1 & 40.00 \\ \hline 53 & Regular & Female & Single & Discover & 63 & 1 & 73.00 \\ \hline 54 & Regular & Female & Single & Visa & 13 & 2 & 89.00 \\ \hline 55 & Regular & Female & Married & MasterCard & 25 & 2 & 64.50 \\ \hline 73 & Regular & Female & Single & Proprietary Card & 15 & 1 & 84.00 \\ \hline 77 & Regular & Female & Married & Proprietary Card & 35 & 2 & 54.00 \\ \hline 80 & Regular & Female & Married & Discover & 47 & 2 & 104.00 \\ \hline 85 & Regular & Female & Married & Visa & 37 & 2 & 52.50 \\ \hline 87 & Regular & Female & Single & MasterCard & 41 & 5 & 159.00 \\ \hline 88 & Regular & Female & Married & Proprietary Card & 29 & 4 & 122.00 \\ \hline 93 & Regular & Female & Married & Proprietary Card & 65 & 5 & 174.75 \\ \hline 95 & Regular & Female & Married & American Express & 39 & 3 & 81.00 \\ \hline 96 & Regular & Female & Married & MasterCard & 37 & 1 & 54.50 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 2 & Promotional & Female & Married & Proprietary Card & 29 & 1 & 122.40 \\ \hline 4 & Promotional & Female & Married & Proprietary Card & 21 & 5 & 120.40 \\ \hline 7 & Promotional & Female & Married & Proprietary Card & 23 & 2 & 98.00 \\ \hline 9 & Promotional & Female & Married & Proprietary Card & 39 & 2 & 76.52 \\ \hline 12 & Promotional & Female & Married & Proprietary Card & 33 & 1 & 51.60 \\ \hline 13 & Promotional & Female & Married & Visa & 33 & 7 & 180.40 \\ \hline 14 & Promotional & Female & Married & Visa & 39 & 2 & 84.50 \\ \hline 16 & Promotional & Male & Single & Proprietary Card & 29 & 2 & 91.40 \\ \hline 17 & Promotional & Female & Single & Proprietary Card & 15 & 3 & 114.00 \\ \hline 19 & Promotional & Female & Married & MasterCard & 25 & 2 & 58.50 \\ \hline 20 & Promotional & Female & Married & Proprietary Card & 49 & 3 & 64.80 \\ \hline 21 & Promotional & Female & Single & Proprietary Card & 21 & 1 & 51.60 \\ \hline 22 & Promotional & Female & Married & Proprietary Card & 31 & 4 & 90.82 \\ \hline 23 & Promotional & Female & Married & American Express & 17 & 7 & 286.00 \\ \hline 25 & Promotional & Male & Married & Visa & 41 & 2 & 59.50 \\ \hline 26 & Promotional & Female & Married & Proprietary Card & 53 & 1 & 50.02 \\ \hline 28 & Promotional & Female & Single & Proprietary Card & 35 & 5 & 212.80 \\ \hline 29 & Promotional & Female & Married & Proprietary Card & 25 & 3 & 91.20 \\ \hline 30 & Promotional & Female & Married & Proprietary Card & 63 & 1 & 38.00 \\ \hline 31 & Promotional & Female & Married & MasterCard & 21 & 2 & 83.20 \\ \hline 33 & Promotional & Female & Married & Proprietary Card & 37 & 3 & 83.20 \\ \hline 35 & Promotional & Female & Married & MasterCard & 49 & 5 & 125.50 \\ \hline 38 & Promotional & Female & Married & Proprietary Card & 43 & 6 & 137.50 \\ \hline 39 & Promotional & Female & Married & Proprietary Card & 37 & 5 & 33.23 \\ \hline 41 & Promotional & Female & Married & Proprietary Card & 35 & 8 & 218.80 \\ \hline 42 & Promotional & Female & Married & Visa & 39 & 4 & 39.50 \\ \hline 44 & Promotional & Female & Married & Proprietary Card & 47 & 1 & 82.40 \\ \hline 45 & Promotional & Female & Married & Proprietary Card & 31 & 2 & 43.80 \\ \hline 46 & Promotional & Female & Married & Proprietary Card & 53 & 2 & 59.60 \\ \hline 48 & Promotional & Female & Married & Proprietary Card & 23 & 3 & 83.64 \\ \hline 49 & Promotional & Female & Married & Proprietary Card & 25 & 1 & 34.82 \\ \hline 50 & Promotional & Female & Married & MasterCard & 39 & 9 & 165.20 \\ \hline 51 & Promotional & Female & Married & Proprietary Card & 31 & 6 & 196.62 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 52 & Promotional & Male & Married & Proprietary Card & 61 & 5 & 138.80 \\ \hline 56 & Promotional & Female & Married & Proprietary Card & 31 & 3 & 161.60 \\ \hline 57 & Promotional & Female & Married & Proprietary Card & 47 & 6 & 143.10 \\ \hline 58 & Promotional & Female & Married & Proprietary Card & 41 & 2 & 100.40 \\ \hline 59 & Promotional & Female & Married & MasterCard & 39 & 4 & 85.20 \\ \hline 60 & Promotional & Female & Single & Proprietary Card & 43 & 4 & 133.00 \\ \hline 61 & Promotional & Female & Married & Proprietary Card & 39 & 1 & 128.80 \\ \hline 62 & Promotional & Female & Single & Proprietary Card & 23 & 3 & 79.91 \\ \hline 63 & Promotional & Female & Married & Proprietary Card & 47 & 5 & 73.60 \\ \hline 64 & Promotional & Female & Single & Proprietary Card & 35 & 1 & 51.60 \\ \hline 65 & Promotional & Female & Married & Proprietary Card & 41 & 2 & 69.50 \\ \hline 66 & Promotional & Female & Married & Proprietary Card & 55 & 1 & 59.60 \\ \hline 67 & Promotional & Female & Married & Proprietary Card & 27 & 2 & 79.50 \\ \hline 68 & Promotional & Female & Married & Proprietary Card & 21 & 5 & 166.80 \\ \hline 69 & Promotional & Male & Married & Proprietary Card & 39 & 2 & 67.20 \\ \hline 70 & Promotional & Female & Married & Proprietary Card & 47 & 8 & 115.05 \\ \hline 71 & Promotional & Female & Married & Proprietary Card & 23 & 5 & 175.32 \\ \hline 72 & Promotional & Female & Married & MasterCard & 25 & 4 & 78.00 \\ \hline 74 & Promotional & Female & Married & Proprietary Card & 25 & 2 & 66.50 \\ \hline 75 & Promotional & Female & Married & Proprietary Card & 67 & 2 & 65.22 \\ \hline 76 & Promotional & Female & Married & Proprietary Card & 55 & 4 & 104.74 \\ \hline 78 & Promotional & Female & Married & Proprietary Card & 21 & 4 & 131.14 \\ \hline 79 & Promotional & Female & Married & Proprietary Card & 31 & 3 & 106.80 \\ \hline 81 & Promotional & Female & Married & MasterCard & 61 & 2 & 98.00 \\ \hline 82 & Promotional & Female & Single & Proprietary Card & 23 & 6 & 73.20 \\ \hline 83 & Promotional & Female & Married & Visa & 29 & 4 & 78.50 \\ \hline 84 & Promotional & Female & Married & Proprietary Card & 37 & 3 & 66.00 \\ \hline 86 & Promotional & Female & Married & Proprietary Card & 55 & 1 & 40.80 \\ \hline 89 & Promotional & Female & Single & Proprietary Card & 13 & 1 & 51.60 \\ \hline 90 & Promotional & Female & Married & Proprietary Card & 35 & 6 & 77.60 \\ \hline 91 & Promotional & Female & Married & Proprietary Card & 47 & 4 & 115.20 \\ \hline 92 & Promotional & Female & Married & Proprietary Card & 47 & 1 & 42.42 \\ \hline 94 & Promotional & Female & Married & Proprietary Card & 23 & 15 & 249.50 \\ \hline \end{tabular} \begin{tabular}{rlllrrr} 97 Promotional & Female & Married & Proprietary Card & 23 & 9 & 273.00 \\ 98 Promotional & Female & Married & Proprietary Card & 18 & 10 & 307.59 \\ 99 Promotional & Female & Married & Proprietary Card & 23 & 2 & 67.60 \\ 100 Promotional & Female & Married & Proprietary Card & 37 & 1 & 48.44 \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting An Introduction To Concepts Methods And Uses

Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil, Sidney Davidson

7th Edition

0030259630, 978-0030259630

More Books

Students also viewed these Accounting questions