Please read the following scenario and answer the questions below. Use the data set below to complete this assignment. You may create your assignment using either Microsoft Word or Excel. When you have completed your assignment, use the following naming convention to name your file: The course number, your first initial, your last name, the unit number and the assignment. For example: MTH140_C_Smith_U1 App Assign.doc Scenario 10 bags of a certain candy were opened. The candy comes in 3 different colors: red, blue, and green. The number of each color of candy per bag was counted and recorded. Bag Red Blue Green 1 3 5 1 2 7 3 2 3 1 1 4 4 2 7 0 5 0 5 2 6 0 2 2 7 4 3 2 8 3 2 3 9 1 4 3 10 5 4 3 Analyze the data by calculating the following: What was the total number of candies in each bag? What was the average number of each color? What the average total? What was the variance and standard deviation of each color? What was the variance and standard deviation for the total number of candies? Suppose a new bag was opened with the following numbers: Red Blue Green 3 2 2 Compute the z-scores for this bag for each color and for the total number of candies. Hint: Parts 1-5 can be done using Microsoft Excel. Use the following functions: sum(), average(), var.s(), stdev.s()