Excel to calculate probability | Management homework help

 Watch the videos in which I solve problems 2-14, 2-17, 2-21 and 2-22 from the text, here https://video.emporia.edu/media/Problems_2-14_2-17_2-21_2-22_A/1_r1uqel1p . Answer the questions posed in the table below. Use an Excel spreadsheet to create the table and answer all questions. This assignment is due by the end of the day (23:59 CST) January 31st. 


The Problem:

A manufacturer produces multi-colored candies for sale during the holidays. You will need to generate the numbers of each candy color produced over the last five holiday seasons. Use the random number generator at this address [https://passwordsgenerator.net/ (Links to an external site.)]. Deselect all boxes except INCLUDE NUMBERS and select a PASSWORD length of 6. Generate a different six-digit number for each color of candy (RED, BLUE, GREEN, ORANGE and PURPLE). Enter the numbers in the PRODUCED column.

In your table, calculate the total number of candies produced, the probability [P(x)] for each color and sum all columns using Excel formulas. Then answer the following questions (round to three decimals [e.g., 0.250]):

  • If an inspector were to randomly select a candy from a bin during a quality control review, what is the probability that she would select an orange candy?
  • What is the probability that she would select a blue candy or a red candy?
  • What is the probability that she would NOT select a green candy?

Color            Produced          Probability P(X)

Red              RRRRRR       

Blue             BBBBBB

Green          GGGGGG

Orange        OOOOOO

Purple          PPPPPP


Calculate your essay price
(550 words)

Approximate price: $22

How it Works


It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.


Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.


After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.


Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!