Purchase Solution

Excel: binomial distribution, normal distribution, uniform

Not what you're looking for?

Ask Custom Question

I need assistance solving these problem sets in excel format.

A large company must hire a new president. The Board of Directors prepares a list of five candidates, all of whom are equally qualified. Two of these candidates are members of a minority group. To avoid bias in the selection of the candidate, the company decides to select the president by lottery.

a. What is the probability one of the minority candidates is hired? (Round your answer to 1 decimal place.)

Probability

b. Which concept of probability did you use to make this estimate?

QUESTION 2
The chair of the board of directors says, "There is a 50% chance this company will earn a profit, a 30% chance it will break even, and a 20% chance it will lose money next quarter."

a. Use an addition rule to find the probability the company will not lose money next quarter. (Round your answer to 2 decimal places.)

=

b. Use the complement rule to find the probability it will not lose money next quarter. (Round your answer to 2 decimal places.)

=

QUESTION 3
A National Park Service survey of visitors to the Rocky Mountain region revealed that 50% visit Yellowstone Park, 40% visit the Tetons, and 35% visit both.

a. What is the probability a vacationer will visit at least one of these attractions? (Round your answer to 2 decimal places.)

Probability

b. What is the probability .35 called?

c. Are the events mutually exclusive?

QUESTION 4
P(A1) = .20, P(A2) = .40, and P(A3) = .40. P(B1|A1) = .25. P(B1|A2) = .05, and P(B1|A3) = .10.

Use Bayes' theorem to determine P(A3|B1). (Round your answer to 4 decimal places.)

P(A3|B1)

QUESTION 5
Solve the following:
a.

b.
9P 3

c.
7C 2

QUESTION 6
The U.S. Postal Service reports 95% of first-class mail within the same city is delivered within 2 days of the time of mailing. Six letters are randomly sent to different locations.

a. What is the probability that all six arrive within 2 days? (Round your answer to 4 decimal places.)

Probability

b. What is the probability that exactly five arrive within 2 days? (Round your answer to 4 decimal places.)

Probability

c. Find the mean number of letters that will arrive within 2 days. (Round your answer to 1 decimal place.)

Number of letters

d-1. Compute the variance of the number that will arrive within 2 days. (Round your answer to 3 decimal places.)

Variance

d-2. Compute the standard deviation of the number that will arrive within 2 days. (Round your answer to 4 decimal places.)

Standard Deviation

QUESTION 7
The U.S. Postal Service reports 95% of first-class mail within the same city is delivered within 2 days of the time of mailing. Six letters are randomly sent to different locations.

a. What is the probability that all six arrive within 2 days? (Round your answer to 4 decimal places.)

Probability

b. What is the probability that exactly five arrive within 2 days? (Round your answer to 4 decimal places.)

Probability

c. Find the mean number of letters that will arrive within 2 days. (Round your answer to 1 decimal place.)

Number of letters

d-1. Compute the variance of the number that will arrive within 2 days. (Round your answer to 3 decimal places.)

Variance

d-2. Compute the standard deviation of the number that will arrive within 2 days. (Round your answer to 4 decimal places.)

Standard Deviation

QUESTION 8
In a binomial distribution, n = 12 and π = .60.

a. Find the probability for x = 5? (Round your answer to 3 decimal places.)

Probability

b. Find the probability for x ≤ 5? (Round your answer to 3 decimal places.)

Probability

c. Find the probability for x ≥ 6? (Round your answer to 3 decimal places.)

Probability

QUESTION 9
A population consists of 15 items, 10 of which are acceptable.

In a sample of four items, what is the probability that exactly three are acceptable? Assume the samples are drawn without replacement. (Round your answer to 4 decimal places.)

Probability

QUESTION 10
According to the Insurance Institute of America, a family of four spends between $400 and $3,800 per year on all types of insurance. Suppose the money spent is uniformly distributed between these amounts.

a. What is the mean amount spent on insurance?

Mean $

b. What is the standard deviation of the amount spent? (Round your answer to 2 decimal places.)

Standard deviation $

c. If we select a family at random, what is the probability they spend less than $2,000 per year on insurance per year? (Round your answer to 4 decimal places.)

Probability

d. What is the probability a family spends more than $3,000 per year? (Round your answer to 4 decimal places.)

Probability

QUESTION 11
The mean of a normal probability distribution is 60; the standard deviation is 5. (Round your answers to 2 decimal places.)

a. About what percent of the observations lie between 55 and 65?

Percentage of observations %

b. About what percent of the observations lie between 50 and 70?

Percentage of observations %

c. About what percent of the observations lie between 45 and 75?

Percentage of observations %

QUESTION 12
A normal population has a mean of 12.2 and a standard deviation of 2.5.

a. Compute the z value associated with 14.3. (Round your answer to 2 decimal places.)

Z

b. What proportion of the population is between 12.2 and 14.3? (Round your answer to 4 decimal places.)

Proportion

c. What proportion of the population is less than 10.0? (Round your answer to 4 decimal places.)

Proportion

QUESTION 13
A normal population has a mean of 80.0 and a standard deviation of 14.0.

a. Compute the probability of a value between 75.0 and 90.0. (Round intermediate calculations to 2 decimal places. Round final answer to 4 decimal places.)

Probability

b. Compute the probability of a value of 75.0 or less. (Round intermediate calculations to 2 decimal places. Round final answer to 4 decimal places.)

Probability

c. Compute the probability of a value between 55.0 and 70.0. (Round intermediate calculations to 2 decimal places. Round final answer to 4 decimal places.)

Probability

QUESTION 14
For the most recent year available, the mean annual cost to attend a private university in the United States was $26,889. Assume the distribution of annual costs follows the normal probability distribution and the standard deviation is $4,500.

Ninety-five percent of all students at private universities pay less than what amount? (Round z value to 2 decimal places and your final answer to the nearest whole number.)

Amount $

Purchase this Solution
Solution Summary

The solution gives detailed steps on solving a series of statistical questions using excel: binomial distribution, normal distribution, uniform distribution, probability and so on.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Statistics Problem Set: Uniform and Exponential Distribution

    Since np=25*0.4=10>5, n*(1-p)=25*(1-0.4)=15>5, we could use normal distribution to approximate the binomial probability. 142. a) P=8/(10-0)=0.8 b) P=(5-2)/(10-0)=0.3 The expert examines a uniform and exponential distribution.

  • Chi square distribution

    A distribution in which each outcome of a class of outcomes is equally likely to occur is called a ___________ distribution. a. binomial b. normal c. chi-square d. uniform e. t Test 53.

  • MCQs & True or False Questions: Probability

    The mean (m) divides the normal curve into two identical halves. TRUE OR FALSE 13. The shape of any uniform probability distribution is - Negatively Skewed Positively Skewed Rectangular Bell Shaped???? 14.

  • Explain the difference between a discrete and a continuous random variable.

    Binomial distribution, Poisson's distribution. A continuous random variable can take in all real values, e.g., normal distribution, uniform distribution. 2.)

  • Using Normal approximation to binomial distribution

    To use normal approximation to binomial distribution, z value=(x-mean)/standard deviation. So P(less than 20 welds)=P(X<20)=(Z<(20-15)/3.775)=P(Z<1.32)=0.9066 I got 0.9066 using normalcdf function in excel.

  • Discrete and Continuious Probability Distribution

    141631 Discrete and Continuious Probability Distribution Practice Problems 5.3 Used the binomial distribution table to callculate the following probabilites for a binomial random variable where n = 20 and p = 0.40 a. p(x = 10) b. p(7< x <12) c.

  • Probability distribution

    Normal A uniform probability distribution is a. Symmetric around the mean b. Bell shaped c. Asymptotic to the X-axis d. All of the above If we use z scores to convert any normal distribution, the new distribution is a.

  • Binomial, Normal & Uniform Probabilities

    408211 Three Statistics Problems: Sample probability, normal distribution, uniform distribution In a recent survey 35 percent indicated chocolate was their favorite flavor of ice cream.

  • Probability: Binomial & Normal

    Workings are given in the excel sheet. The solution provides step by step method for the calculation of binomial and normal probabilities. Workings are given in the excel sheet.

View More Related Solutions