“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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