Question: Use the data from the Product Buy Data for Graphs table and provide visual representations of the data. Copy each graph into your word document.
Use the data from the "Product Buy Data for Graphs" table and provide visual representations of the data. Copy each graph into your word document. Graph and explain the results for each of the following visual representations of the data: Create a pie chart to showcase purchases Create a bar chart to showcase product Create a bar chart to showcase sales representatives Create a scatterplot to showcase loyalty Create a line chart to showcase wait time (in minutes) VARIABLE CODING (Data file: Product Buy Data for Graphs.xls) Purchase 0 No Buy 1 Buy Product 1 Not Happy 2 Somewhat Happy 3 Happy 4 Very Happy 5 Extremely Happy Sales Representation 1 Very Unfavorable 7 Very Favorable Frequency of Visits 1 Never 2 Rarely 3 Occasionally 4 Often 5 Very Often Loyal Customer 0 Strongly Disagree 10 Strongly Agree Main Source of Information 0 Social Media 1 TV Wait Time (Minutes)
"Product Buy Data for Graphs" Table:
| Purchase | Product | Sales_rep | Frequency | Loyal_cust | AGE | Information | Wait_time |
| 1 | 1 | 1 | 1 | 0 | 47 | 1 | 14.29 |
| 1 | 1 | 2 | 2 | 0 | 42 | 1 | 13.03 |
| 1 | 1 | 1 | 1 | 0 | 36 | 1 | 18.70 |
| 1 | 2 | 3 | 2 | 0 | 39 | 0 | 18.04 |
| 1 | 2 | 5 | 2 | 0 | 43 | 0 | 16.47 |
| 1 | 2 | 4 | 2 | 0 | 36 | 0 | 18.33 |
| 1 | 3 | 1 | 1 | 1 | 41 | 1 | 21.21 |
| 1 | 2 | 4 | 1 | 2 | 39 | 0 | 15.82 |
| 1 | 1 | 1 | 1 | 2 | 48 | 1 | 21.48 |
| 1 | 1 | 1 | 1 | 2 | 35 | 1 | 14.37 |
| 1 | 3 | 5 | 2 | 2 | 42 | 0 | 21.83 |
| 1 | 5 | 3 | 3 | 2 | 55 | 0 | 13.06 |
| 1 | 2 | 4 | 1 | 3 | 38 | 0 | 15.11 |
| 1 | 1 | 2 | 2 | 3 | 48 | 1 | 16.66 |
| 1 | 1 | 1 | 1 | 3 | 48 | 1 | 21.38 |
| 1 | 1 | 1 | 3 | 3 | 41 | 1 | 16.61 |
| 1 | 3 | 4 | 4 | 3 | 35 | 0 | 17.46 |
| 1 | 1 | 1 | 1 | 4 | 49 | 1 | 21.92 |
| 1 | 1 | 1 | 3 | 4 | 37 | 1 | 17.04 |
| 1 | 1 | 1 | 1 | 4 | 44 | 1 | 23.25 |
| 0 | 2 | 1 | 3 | 4 | 37 | 1 | 13.16 |
| 1 | 3 | 6 | 5 | 4 | 40 | 0 | 18.34 |
| 1 | 4 | 6 | 3 | 4 | 46 | 0 | 16.03 |
| 1 | 2 | 1 | 1 | 4 | 40 | 1 | 18.99 |
| 0 | 5 | 6 | 5 | 4 | 36 | 0 | 12.75 |
| 1 | 2 | 2 | 1 | 4 | 38 | 1 | 16.36 |
| 1 | 3 | 5 | 4 | 4 | 50 | 0 | 14.03 |
| 1 | 2 | 3 | 1 | 5 | 46 | 1 | 19.78 |
| 1 | 1 | 2 | 1 | 5 | 51 | 1 | 19.08 |
| 1 | 3 | 1 | 1 | 5 | 33 | 1 | 17.18 |
| 0 | 4 | 4 | 5 | 5 | 42 | 0 | 14.00 |
| 1 | 3 | 1 | 1 | 5 | 43 | 1 | 16.20 |
| 0 | 4 | 5 | 3 | 5 | 41 | 0 | 16.68 |
| 0 | 5 | 6 | 5 | 5 | 38 | 0 | 14.04 |
| 1 | 2 | 4 | 2 | 6 | 51 | 0 | 19.11 |
| 1 | 1 | 2 | 2 | 6 | 49 | 1 | 21.28 |
| 0 | 1 | 2 | 1 | 6 | 30 | 1 | 20.60 |
| 0 | 4 | 5 | 5 | 6 | 42 | 0 | 21.16 |
| 0 | 3 | 2 | 1 | 6 | 30 | 1 | 19.81 |
| 0 | 4 | 6 | 5 | 6 | 42 | 0 | 11.23 |
| 0 | 4 | 4 | 3 | 6 | 41 | 1 | 13.40 |
| 1 | 4 | 4 | 2 | 6 | 35 | 0 | 17.75 |
| 1 | 5 | 6 | 4 | 6 | 47 | 0 | 20.36 |
| 0 | 4 | 5 | 3 | 6 | 46 | 0 | 16.96 |
| 1 | 4 | 4 | 3 | 6 | 44 | 1 | 20.41 |
| 1 | 2 | 1 | 1 | 7 | 32 | 1 | 18.89 |
| 0 | 1 | 1 | 1 | 7 | 48 | 1 | 21.56 |
| 0 | 1 | 1 | 2 | 7 | 42 | 1 | 13.52 |
| 1 | 1 | 6 | 2 | 7 | 46 | 0 | 18.13 |
| 1 | 5 | 6 | 4 | 7 | 35 | 0 | 18.31 |
| 0 | 4 | 5 | 4 | 10 | 44 | 0 | 15.89 |
| 0 | 3 | 3 | 5 | 10 | 53 | 0 | 20.19 |
| 0 | 3 | 5 | 5 | 10 | 48 | 0 | 24.09 |
| 0 | 1 | 3 | 1 | 10 | 51 | 0 | 17.76 |
| 0 | 1 | 3 | 3 | 10 | 51 | 0 | 14.08 |
| 0 | 4 | 6 | 3 | 10 | 38 | 0 | 13.31 |
| 0 | 5 | 6 | 4 | 10 | 40 | 0 | 14.74 |
| 0 | 4 | 5 | 3 | 10 | 39 | 0 | 20.67 |
| 0 | 4 | 4 | 3 | 10 | 43 | 0 | 22.75 |
| 0 | 5 | 6 | 5 | 10 | 60 | 0 | 21.37 |
| 0 | 4 | 6 | 4 | 10 | 48 | 0 | 11.92 |
| 0 | 4 | 5 | 4 | 10 | 38 | 0 | 18.95 |
| 0 | 3 | 2 | 2 | 10 | 52 | 0 | 15.87 |
| 0 | 5 | 6 | 5 | 10 | 29 | 0 | 15.60 |
| 0 | 4 | 3 | 4 | 10 | 39 | 0 | 12.19 |
| 0 | 4 | 4 | 4 | 10 | 50 | 0 | 18.46 |
| 0 | 3 | 6 | 4 | 10 | 45 | 0 | 18.67 |
| 0 | 4 | 4 | 5 | 10 | 56 | 0 | 17.13 |
| 0 | 3 | 5 | 4 | 10 | 52 | 0 | 18.20 |
| 0 | 5 | 6 | 5 | 10 | 42 | 0 | 15.63 |
| 0 | 4 | 5 | 5 | 10 | 54 | 0 | 18.89 |
| 0 | 4 | 5 | 4 | 10 | 36 | 0 | 19.21 |
| 0 | 5 | 6 | 5 | 10 | 39 | 0 | 16.31 |
| 0 | 5 | 6 | 3 | 10 | 59 | 0 | 13.45 |
| 0 | 5 | 6 | 3 | 10 | 43 | 0 | 23.47 |
| 0 | 1 | 4 | 2 | 10 | 31 | 0 | 18.54 |
| 0 | 4 | 5 | 4 | 10 | 51 | 0 | 18.24 |
| 0 | 4 | 6 | 3 | 10 | 24 | 0 | 7.66 |
| 0 | 4 | 5 | 3 | 10 | 46 | 0 | 16.27 |
| 0 | 3 | 4 | 3 | 10 | 48 | 0 | 17.19 |
| 0 | 4 | 5 | 5 | 10 | 45 | 0 | 14.76 |
| 0 | 5 | 6 | 5 | 10 | 41 | 0 | 17.00 |
| 0 | 5 | 6 | 5 | 10 | 39 | 0 | 15.83 |
| 0 | 4 | 5 | 4 | 10 | 54 | 0 | 14.50 |
| 0 | 2 | 3 | 3 | 10 | 42 | 0 | 20.20 |
| 0 | 2 | 5 | 5 | 10 | 40 | 0 | 16.78 |
| 0 | 1 | 3 | 3 | 10 | 47 | 0 | 16.99 |
| 0 | 4 | 5 | 5 | 10 | 47 | 0 | 22.18 |
| 0 | 3 | 5 | 3 | 10 | 44 | 0 | 21.05 |
| 0 | 4 | 5 | 4 | 10 | 55 | 0 | 10.47 |
| 0 | 4 | 3 | 4 | 10 | 47 | 0 | 16.65 |
| 0 | 4 | 5 | 5 | 10 | 37 | 0 | 21.09 |
| 0 | 3 | 5 | 2 | 10 | 42 | 0 | 19.13 |
| 0 | 3 | 3 | 2 | 10 | 35 | 0 | 16.46 |
| 0 | 4 | 6 | 5 | 10 | 38 | 0 | 14.67 |
| 0 | 3 | 6 | 5 | 10 | 28 | 0 | 15.66 |
| 0 | 5 | 6 | 4 | 10 | 56 | 0 | 12.90 |
| 0 | 5 | 6 | 4 | 10 | 38 | 0 | 18.50 |
| 0 | 5 | 5 | 3 | 10 | 46 | 0 | 18.45 |
| 0 | 3 | 5 | 3 | 10 | 38 | 0 | 13.99 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help