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
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started