Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started