I would like to have the following sample questions answered in EXCEL format, so that I can see the formulas used.

Thanks in advance!

1. The mean score of a college entrance exam is 500; the standard deviation is 75. The score are normally distributed. What percent of the students scored below 320?

2. On a very hot summer day, 5 percent of the production employees at Midland State Steel are absent from work. The production employees are to be selected at random for a special in-depth study on absenteeism. What is the probability of selecting 10 production employees at random on a hot summer day and finding the none of them are absent?

3. For the normal distribution, the mean plus and minus 1.96 standard deviations will include about what percent of the observations?

4. Sweetwater and Associates write weekend trip insurance at a very nominal charge. Records show that the probability that a motorist will have an accident during the weekend and file a claim is 0.05.

Suppose they wrote 20 policies for the coming weekend, what is probability that exactly two claims will be filed?

5. Chances are 50-50 that a newborn baby will be a girl. For families with 5 children, what is the probability that all the children are girls?

Solution Summary

The solution gives detailed on solving 5 questions using either normal distribution or binomial distribution using Excel.

7.11 A simple random sample of n = 300 full-time
employees is selected from a company list containing the
names of all, N = 5,000 full-time employees in order to
evaluate job satisfaction.
a. Give an example of possible coverage error.
b. Give an example of possible nonresponse error.
c. Give an example of possible samplin

The following table (see problem #7 on page 310 of attachment) lists the results of one question taken from a survey conducted for Joe's Bar and Grill. The Grill has recently undergone renovations, and with the new look, management has decided to change the menu. They are interested in knowing how well customers like the new men

Can someone please provide some assistance with these questions. It's for an MBA course. The maximum number of characters it can be is 60,000 for each question. They are worth a good part of my grade. There are three questions.... Explain the importance of sampling from a managerial perspective? Explain the central limit theorem

Please give answers with steps.
1) The accounting firm of Ahmadi & Associates was commissioned to audit a population of 500 accounts. For this audit, Ahmadi & Associates selected a simple random sample of 64 accounts. The sample showed a mean discrepancy of $120 with a standard deviation of $24. Develop an approximate 95% co

Suppose that 55 percent of the people in a population of 500,000 support your candidate. If you conduct a poll of 1,000 people, what is the interval that has a 95 percent chance of containing the results of your poll?
Suppose you have 60 red marbles and 40 blue marbles in a box. If you pick out 10 marbles without replacemen

1.Which of the following statements about the sampling distribution of the sample mean is incorrect?
a. The sampling distribution of the sample mean is approximately normal whenever the sample size is sufficiently large (n>30).
b. The sampling distribution of the sample mean is generated by repeatedly taking samples of size n

See the data in the attached file and answer the following questions.
Question 1
Construct a 95% confidence interval for an average value of y given that x = 4. Remember the format is (x.xx, x.xx)
Question 2
Construct a 95% prediction interval for y given that x = 4.

We will be constructing confidence intervals for the proportion of each color as well as the mean number of candies per bag.
Construct a 95% Confidence Interval for the proportion of blue M&Ms® candies.
Construct a 95% Confidence Interval for the proportion of orange M&Ms® candies.
Construct a 95% Confidence Interva

Please help answer the following multiple choice questions.
Which of the following sampling techniques can assure that the profile of the sample matches the profile of the population?
Simple random sampling
Systematic sampling
Cluster sampling
Stratified sampling
Which of the following types of level mea