This is a project to practice Excel skills.
The problem is that my candy store is losing sales, kids like my candies taste but the color is boring. I use Excel to create data and figure out how to save the store.
Candy In The Package
So when I counted the candy I found out pink is the most used color in the package!
This is my survey on which color (flavor) kids like most. I see yellow, pink, and green are the most popular while black, orange, and brown are the least.
My Plan to Save the Factory
I won’t add more candy into the bag because it’s more money for the factory and it wasn’t the problem. I will take the non-fun colors out (orange, black, and brown), and the problem will be fixed. I’ll add more yellow, green, pink, red, and blue.