Question
Select three related variables and make a visualization to represent their interaction. Copy the required data into a new worksheet and make your visualization. Be
Select three related variables and make a visualization to represent their interaction. Copy the required data into a new worksheet and make your visualization. Be able to draw a conclusion about the interaction of the three variables that would be of interest to your business.
Keep in mind that you are not visualizing one variable with three values, but three separate variables, each with their own set of values.
Some suggestions include Comparative box plots or a bubble chart. (Examples are included with the in-class exercises. Other suggestions are acquiring a mapping app and using that. As well, you could use heat/area charts, line charts, and other forms of visualization
Toy ID | Product | Average Price | Type | Total Units Manufactred (Finished) | Avg. Units Manufactured (Per Day) | Avg. Units Manufactured (in hours) | Main Material Used | Total Earnings | Avg. earned per day | Sold in Total | Avg. Sold Per Day | Age Group Suitable | Target Gender | Popularity |
1001 | Yo-yo | $ 8.75 | Creative | 8030 | 22.00 | 0.92 | Plastic | $ 34,965.00 | $ 95.79 | 3996 | 10.95 | 4+ | Neutral | Average |
1002 | Lego (Per Piece) | $ 0.18 | Creative | 183,960,000,000 | 504000000 | 21000000.00 | Plastic | $ 248,346,000.00 | $ 680,400.00 | 1,379,700,000 | 3780000.00 | 8+ | Neutral | Very High |
1003 | Magic 8 Ball | $ 11.00 | Creative | 6,935 | 19.00 | 0.79 | Plastic | $ 34,320.00 | $ 94.03 | 3120 | 8.55 | 4+ | Neutral | Average |
1004 | Play-Doh (per oz) | $ 0.25 | Creative | 352225 | 965.00 | 40.21 | Clay | $ 59,030.25 | $ 161.73 | 236,121 | 646.91 | 2+ | Neutral | High |
1005 | Barbie | $ 35.00 | Doll | 5840 | 16.00 | 0.67 | Plastic | $ 175,070.00 | $ 479.64 | 5002 | 13.70 | 4+ | Girl | Very High |
1006 | Nerf gun | $ 12.00 | Physical Activity | 8760 | 24.00 | 1.00 | Plastic | $ 72,324.00 | $ 198.15 | 6027 | 16.51 | 6+ | Neutral | High |
1007 | Furby | $ 32.00 | Soft Toy | 7300 | 20.00 | 0.83 | Polyester | $ 75,712.00 | $ 207.43 | 2366 | 6.48 | 3+ | Neutral | Low |
1008 | Bratz | $ 45.00 | Doll | 5840 | 16.00 | 0.67 | Plastic | $ 245,340.00 | $ 672.16 | 5452 | 14.94 | 4+ | Girl | Very High |
1009 | Hula Hoop | $ 15.00 | Creative | 13140 | 36.00 | 1.50 | Plastic | $ 66,285.00 | $ 181.60 | 4419 | 12.11 | 4+ | Neutral | Average |
1010 | Troll Doll | $ 5.00 | Doll | 8395 | 23.00 | 0.96 | Plastic | $ 12,560.00 | $ 34.41 | 2512 | 6.88 | 3+ | Girl | Low |
1011 | G.I. Joe | $ 20.00 | Action Figure | 5475 | 15.00 | 0.63 | Plastic | $ 37,260.00 | $ 102.08 | 1863 | 5.10 | 4+ | Boy | Low |
1012 | Baby | $ 35.00 | Doll | 6935 | 19.00 | 0.79 | Plastic | $ 162,820.00 | $ 446.08 | 4652 | 12.75 | 5+ | Girl | High |
1013 | Rubik's Cube | $ 10.00 | Creative | 9855 | 27.00 | 1.13 | Plastic | $ 74,110.00 | $ 203.04 | 7411 | 20.30 | 3+ | Neutral | Very High |
1014 | Buzz Lightyear | $ 40.00 | Action Figure | 5475 | 15.00 | 0.63 | Plastic | $ 158,480.00 | $ 434.19 | 3962 | 10.85 | 4+ | Boy | Average |
1015 | Hot Wheels | $ 5.00 | Car | 15330 | 42.00 | 1.75 | Plastic | $ 57,460.00 | $ 157.42 | 11,492 | 31.48 | 5+ | Boy | Very High |
1016 | Jenga (per block) | $ 0.22 | Creative | 262800 | 720.00 | 30.00 | Wood | $ 37,579.08 | $ 102.96 | 170,814 | 467.98 | 5+ | Neutral | High |
1017 | Uno (per card) | $ 0.27 | Cards | 1140625 | 3125.00 | 130.21 | Paper | $ 200,338.11 | $ 548.87 | 741,993 | 2032.86 | 8+ | Neutral | High |
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