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'm using the indirect function to calculate standard deviation and its not working =(INDIRECT("'eVestment Data'!"&SUBSTITUTE(ADDRESS(1,((Y2-D3+1)*12+2),4),"1","")&ROW('eVestment Data'!A60)&":"&SUBSTITUTE(ADDRESS(1,MATCH($C3,'eVestment Data'!59:59,0),4),"1","")&60)) this formula works but as soon as i add product( 1+ Indirect...) it doesnt work
Solved by Z. C. in 27 mins
A credit bureau analysis of undergraduate students credit rcords found that the average number of credit cards in am undergraduate's wallet was 4.09. It was also reported that in a randomly selected sample of 132 undergraduates, the sample mean number of credit cards that students carried was 2.6 and the standard deviation was 1.2. Is there enough evidence that the mean number of credit cards that undergraduates carry is less than the credit bureau's figure of 4.09? Use a hypothesis test to support your answer. Be sure to show the claim, test statistis, p-value, and the conclusion. I am totally lost as to how to set this up in excel
Solved by F. H. in 17 mins
Hello, my excel is not showing the possible functions available. For example when i type in to cell =av it will not give me the option to click =Average instead i have to spell it out fully. This becomes difficult when I have to try to type exact function needed for square roots and strandard deviation.
Solved by O. B. in 16 mins
I need help inputting "standard deviation" data into the "specify value" option when trying to create custom error bars on excel
Solved by C. U. in 20 mins
I am having issues creating the one way data table to show the means and standard deviations when you change the proportion of portfolio 1. I have the mean formula and the standard deviation formula at the top and -1 through 1 down the left side. I highlight all of it and create a data table. I reference the "proportion of portfolio 1" cell in the column input box but when the data table comes out it has all the same numbers all they way down the table.
Solved by G. Q. in 30 mins
I am trying to create a graph of the means and standard deviations of a lab including six different means for each point on the horizontal axis. I have attempted this, and I believe I have the points in the correct places, but I still need help inserting error bars with the standard deviation. A picture of the graph needed is posted as well.
Solved by M. S. in 19 mins
Assistance creating error bars for a standard deviation on a scatter plot of means.
Solved by T. S. in 18 mins
Here's the question, ''for participants estimates for the jar with 100 jelly beans calculate and present the mean, median, ​and standard deviation. In addition, calculate the proportion of estimates that were closer than the mean to the correct answer.'' I've already calculated the mean, median and standard deviation but don't know how to do the 2nd part of the question, which is the proportion part.
Solved by B. H. in 25 mins
Hi I'm having trouble with Binomial and Trinomial trees in excel. I need to find the mean and standard deviation for them using factorial formulas, but that is where my understanding of excel is letting me down.
Solved by M. F. in 12 mins
use the excel sheet name part 2 to answer the question and round the answer to 4 decimal places . Information from the American institute of insurance indicates that mean amount of life insurance per household in the united states is $100,000 with a standard deviation of $40,000 assume the population distribution is normal. A random sample of 100 household is taken What is the probability that sample mean will be more than $120,000? What is the probability that sample mean will be between $100,000 and $120,000?
Solved by B. Y. in 21 mins