Question

SHOW USING EXCEL FORMULAS PLEASE Information from the American Institute of Insurance indicates the mean amount...

SHOW USING EXCEL FORMULAS PLEASE

Information from the American Institute of Insurance indicates the mean amount of life insurance per household in the United States is $110,000 with a standard deviation of $40,000. Assume the population distribution is normal. A random sample of 100 households is taken.

  1. What is the probability that sample mean will be more than $120,000?

  2. What is the probability that sample mean will be between $100,000 and $120,000?

Homework Answers

Answer #1

Thank you,

If you're satisfied then like me.

Given- u=110000 6=40000 n=100 PCX 120000) = NORM DIST(120.000, 110000 400 false) Oooooo PC 10o00o < X < 120000) =NORNDIST (120000, 110000, 4000, Tue) NORM DIST (100 000, 110000, 400 E1-0.0000 = 1 + True

Sorry by mistake now I am using standard deviation 4000

P(xbar>120000)=NORMDIST(120000,110000,4000, FALSE )= 0.0062

P(xbar>120000)=NORMDIST(120000,110000,4000, FALSE ) - NORMDIST(100000,110000,4000, FALSE )= 0.9938 - 0.0062 = 0.9876

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
xercise 7-42 The mean amount of life insurance per household is $118,000. This distribution is positively...
xercise 7-42 The mean amount of life insurance per household is $118,000. This distribution is positively skewed. The standard deviation of the population is $45,000. Use Appendix B.1 for the z-values. a. A random sample of 40 households revealed a mean of $120,000. What is the standard error of the mean? (Round the final answer to 2 decimal places.) Standard error of the mean            b. Suppose that you selected 120,000 samples of households. What is the expected shape...
1 . A study of 5,000 American women was taken to determine the mean number of...
1 . A study of 5,000 American women was taken to determine the mean number of children per household. Samples of 100 were taken by state. The average American household, as reported by women, contains 2.1 children with a standard deviation of 1.87. What would be the mean of the sampling distribution of the sample means? (If rounding is necessary, round to four decimal places). 2 . A study of 5,000 American women was taken to determine the mean number...
USING EXCEL A survey conducted for the Northwestern National Life Insurance Company revealed that 70% of...
USING EXCEL A survey conducted for the Northwestern National Life Insurance Company revealed that 70% of American workers say job stress caused frequent health problems. Suppose a random sample of 10 American workers is selected. What is the probability that more than seven of them say job stress caused frequent health problems? What is the probability that exactly five say job stress caused frequent health problems? What is the expected [mean] number of workers that would say job stress caused...
Show work in Excel workbook. Maggies Restaurants has noted that they have a mean average ticket...
Show work in Excel workbook. Maggies Restaurants has noted that they have a mean average ticket price for food and drinks of $67. suppose a random sample of 80 tickets is taken to determine the total cost of their meal and drinks. The population standard deviation of total meal cost is know to be $22. What is the probability the sample mean will be within $3 of the population mean cost per ticket? (to 4 decimals)
Using the Empirical Rules: The Heights of North American women are normally distributed with a mean...
Using the Empirical Rules: The Heights of North American women are normally distributed with a mean of 64 Inches and a standard deviation of 2 inches. Answer the following questions based on mean = 64 and SD=2: Tip: We don't need to have a sample size >= 30 to be normal since it is assumed "normally distributed" .   QUESTION 3 We want to know what is the probability that the mean of random selected 4 North American women is taller...
The following problem is based on information taken from Academe, Bulletin of the American Association of...
The following problem is based on information taken from Academe, Bulletin of the American Association of University Professors. Let x represent the average annual salary of college and university professors (in thousands of dollars) in the United States. For all colleges and universities in the United States, the population variance of x is approximately σ2 = 47.1. However, a random sample of 19 colleges and universities in Kansas showed that x has a sample variance s2 = 82.6. Use a...
SHOW ALL WORK IN EXCEL For this assignment, submit one Excel file. Part 1 sheet is...
SHOW ALL WORK IN EXCEL For this assignment, submit one Excel file. Part 1 sheet is kept blank. Use Part 1 sheet to answer question 1. Put a box around your answer. Round your answer to 4 decimal places. The Statistical Abstract of the United States published by the U.S. Census Bureau reports that the average annual consumption of fresh fruit per person is 99.9 pounds. The standard deviation of fresh fruit consumption is about 30 pounds. Suppose a researcher...
*Please show your work *Be sure to round z-values to 2 decimal places and round any...
*Please show your work *Be sure to round z-values to 2 decimal places and round any probabilities to 4 decimal places *If doing a hypothesis test, be sure to sure state the Ho and Ha, you may choose the p-value or rejection region approach to hypothesis testing, unless otherwise noted in the question. *If you need to use the normal approximation, be sure to show the appropriate steps. 1. A survey of U.S. adults found that 8% say their favorite...
Question 21 Suppose a health insurance company is interested in carrying out an investigation as to...
Question 21 Suppose a health insurance company is interested in carrying out an investigation as to the annual expenditures per household on their healthcare costs. In order to most accurately report their figures, the company decides to ensure “virtual certainty” about their estimates by using a Z value of 3.0 for their calculations. The company conducts a SRS of 843 households and determines the sample average household expenditures on healthcare is $43,257.00. A) Assume the company uses a σ=$879.00. Calculate...
Unit 6    [Hypothesis Testing/Decision Making]        For all Hypothesis\Decision Making Problems, please do the following:            ...
Unit 6    [Hypothesis Testing/Decision Making]        For all Hypothesis\Decision Making Problems, please do the following:             1.         Answer: Is the data discrete or continuous?             2.        List the assumptions. 3.        State the null and alternate hypothesis.             4          Write down the proper test statistic, Show all calculations, i.e. impute the numbers.                       .               Set up Decision rules. Show the critical value.    Reject or Fail to reject.               5.         State your conclusions.                         6.1.1     According to the...