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

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 Z. A. in 25 mins
I am trying to complete a Network diagram model on publishing and need to find the activity times using (normal distribution) PSINormal in Solver. I have the mean and the standard deviation times and these times can vary by 50% of their mean values.
Solved by K. F. in 18 mins
Can you show me in excel how to work out this problem please? The duration of shoppers' time in BrowseWorld's new retail outlets is normally distributed with a mean of 31.9 minutes and a standard deviation of 14.5 minutes. How long must a visit be to put a shopper in the longest 30 percent?
Solved by F. H. in 21 mins
I am comparing three groups of people/data and these groups were given questions were they could answer from for example 1-4. So three groups with a bunch of 1-4 answers, now I am trying to chart this data, the values are normalized to percentages and I have managed to create a normal bar-chart. However I also want average & standard deviation to be shown in these graphs, right now I dont know how to implement this effectively, ive been trying out the box and whiskers plot but cant figure out how to retain the data I need. I can show some of my graph pictures to make more sense of it if possible.
Solved by M. H. in 15 mins
Can you show me how to solve this problem in excel please? Suppose the average commute time of your employees is unknown. The standard deviation of their commute time is estimated as 35.1 minutes. How many employees must be included in a sample to create a 95 percent confidence interval for the average commute time with a confidence interval width of no more than 18 minutes?
Solved by F. W. in 21 mins
Can you show me how to fix this file to solve this problem? Suppose you are working for a regional residential natural gas utility. For a sample of 80 customer visits, the staff time per reported gas leak has a mean of 209 minutes and standard deviation 33 minutes. The VP of network maintenance hypothesizes that the average staff time devoted to reported gas leaks is 217 minutes. At a 10 percent level of significance, what is the upper bound of the interval for determining whether to accept or reject the VP's hypothesis?
Solved by F. S. in 13 mins
A data set includes 103 body temperatures of healthy adult humans having a mean of 98.9degreesF and a standard deviation of 0.65degreesF. Construct a 99​% confidence interval estimate of the mean body temperature of all healthy humans. What does the sample suggest about the use of 98.6degreesF as the mean body​ temperature?
Solved by X. W. in 27 mins
Hi, I need some help coming up with the best way to display data, averages, std. deviation, and graphs. Please look at tab "TriPoint". Each row represents one patient,there are 25,776 rows. I need to know how many patients come per month (Column L), Day (Column L for month and D for day - 365). I also need to compare averages for six specific days/holidays (05/29, 07/04, 09/04, 11/23, 12/25 and 01/01 - column L/Column D).
Solved by B. B. in 27 mins
Complete the Statistics Table, at the bottom of the sheet, by calculating the average, standard deviation, median. How do you find the maximum or minimum value of a function (rows 103 – 107) for AS1, AS2, AS3 and the Overall Average columns
Solved by M. E. in 30 mins
I'm trying to find the mean,range,mode and standard deviation of a sample
Solved by M. Q. in 30 mins