Get instant live Excel expert help to learn how to create a statistical function in Excel?

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. (a) What is the probability that sample mean will be more than $120,00? (b) What is the probability that sample mean will be between $100,000 and $120,000? Round your answer to 4 decimal places. ( use part 2 sheet to answer this question)

The file name sheet part two is kept blank, use part 2 sheet to answer this question. Put a box around your answers. Round your answer to 4 decimal places. Information from the American institute of insurance indicates the mean amount of life insurance per household in the unites states is $110,00 with a standard deviation of $40,000. Assume the population distribution is normal. A random sample of 100 households is taken. A. what is the probability that sample mean will be more than $120,000? B. what is the probability that sample mean will be between $100,00 and $120,000?

The data is presented in the Price sheet. Use the price data and a population standard deviation (σ) of 0.113 to determine a point estimate for the national retail price of the product. Construct a 90% confidence interval to estimate this price. Round your answer to 2 decimal places.

I am wanting to graph 5 sets of data "clouds" but it seems there is just too much data to be able to compare them. Is there a simple/easy way to create an outline of a 3 standard deviation spread? The data is between 7,000 points of data to 10,000 points of data. In the attached example I would like to compare all the XA's and all the XB's.

Hi I am trying to get excel to produce for me a normal distribution curve for a set of data. I would like it to show me the mean and the standard deviation too so that I can compare two groups.

I need a set of functions that will color my calendar for work shifts, according to a rolling schedule; 5 on, 2 off, 5 on, 3 off. It restarts whenever there's any deviation in the shift, so I need the option to change the start dates.

Hi, I have a list of numbers in one column and an condition (0/1) in another column I want to check the standard deviation only if the condition is 1 I'm using excel 2016 and I did not find an stdevif function similar to averageif but could anyone recommend a clever way in solving my problem? I've googled and lots of answers are using the CSE equation {=STDEV(IF(B2:B100="Y",A2:A100))} I did enter the equation using ctrl+shift+enter but what I got is an error: #DIV/0! ...Also, what should I do if I want to compute the SD under more than one columns of conditions (in my file, condition 1 & condition2)? Thanks.

Hi! I'm making a diagram for my thesis. I would like to have a different standard deviation per bar, but I don't know how to do that. I figured out how to change standard deviation for all bars, but not how to change each bar seperately.

Hi! I'm making a diagram for my thesis. I would like to have a different standard deviation per bar, but I don't know how to do that. I figured out how to change standard deviation for all bars, but not how to change each bar seperately.

I need to find the analyst deviation based on actual prices, estimates, and differences for a certain stock. I have the answer but I have no idea how to get it. The deviation is negative on the answer sheet but I dont know how to get a negative deviation.