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
Get step-by-step solutions from verified subject matter experts
Study Help