Using Probability in Business Analysis

See the attachments.

I. Complete the frequency table found in the Excel spreadsheet attachment. (see attached)

II. Using the data found on the OnlyTheBestDiamonds tab in FinalData.xlsx Excel spreadsheet, find the mean, median, mode and standard deviation for the:

a. metal value (1 = sterling silver, 2 = gold, 3 = platinum)

b. size

c. carat weight

III. Using the data found on the OnlyTheBestDiamonds tab in FinalData.xlsx Excel spreadsheet, sort the data found by ring size and create a column chart that would represent the size data. Looking at this chart, what can you tell about the sizes of rings purchased? (see attached)

IV. The real estate investors association assumes that investment in real property is normally distributed. Suppose that an investment in the fund by RealVEst, Inc. has an average annual return of 12.3% with a standard deviation of 27.2%. NOTE: A 0% return is breaking even, while a negative return is a loss and a positive return is a gain.

a. What percent of the years does this fund lose money?

b. What percent of the years does this fund make money or break even?

c. What minimal annual return (as a percentage) would place the annual return in the top 20% of annual returns?

V. Assuming that the weights of the packages handled by USPS follow a nearly normal distribution with mean 10.5 pounds and standard deviation 3.2 pounds. USPS charges an additional fee for packages that weigh in excess of 14 pounds. Determine what percent of customers sending packages incur this fee.

VI. Data collected by ACME, INC. shows the following data in terms of sick leave days taken by employees. The following data also appears in ACMESickLeave tab in FinalData.xlsx (see attached).

a. What is the percentage of employees that take 5 or more sick leave days?

b. What is the probability that an employee chosen at random doesn't take any sick leave days?

c. What is the probability that an employee chosen at random takes no more than two sick leave days?

d. What is the probability that an employee chosen at random takes three or more sick leave days?

e. If a husband and wife both work for ACME, INC. What is the probability that neither of them take any sick leave?

VII. The table in the Excel attachment shows the results of the preference conducted with 2000 customers about their salsa preference. Find the correct totals for the chart (see attached).

a. What is the probability that a randomly chosen male prefers Clint's Texas Salsa Hot?

b. What is the probability that a randomly chosen female prefers Goldwater's Rio Verde?

c. What is the probability that a man and a woman who are dating both have no preference/prefer another salsa than one listed? Note any assumption you make and evaluate whether you think that assumption is reasonable.

d. What is the probability that a randomly chosen person prefers Goldwater's Rio Verde or that person is male?