 # Get instant live Excel expert help to learn how to create a statistical function in Excel? “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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)
Solved by F. Y. in 19 mins
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?
Solved by C. F. in 29 mins
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.
Solved by A. L. in 20 mins
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.
Solved by O. B. in 26 mins
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.
Solved by M. B. in 26 mins
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.
Solved by G. J. in 21 mins
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.
Solved by B. A. in 28 mins
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.
Solved by T. W. in 22 mins
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.
Solved by B. B. in 27 mins
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.
Solved by B. B. in 17 mins