# 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

Total

## How it Works

1

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.

2

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.

3

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.

4

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