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

I am trying to enter error bars into a graph of two separate averages. I have used the =stdev.s to find the standard deviation of both, then go to error bars, more options, specify value, highlight the deviations for negative and positive, but it says error. What do I need to do to get the proper error bars?

Solved by B. B. in 22 mins

In cell B2, calculate the probability of selling the exact number of products calculated in cell A2, using the normal distribution function and the mean and sample standard deviation calculated in the prior step.

Solved by K. L. in 13 mins

How to calculate Mean, Standard deviation and Variance excel

Solved by G. L. in 26 mins

: You must decide on the appropriate test for the difference between the two population means. In section 10.1, we learned about hypothesis tests for the difference between two population means when the population standard deviations are known; that procedure is the z-Test: Two Sample for Means in Excel’s Data Analysis tool. In section 10.2, we learned about hypothesis tests for the difference between two population means when the population standard deviations are unknown; that procedure is the t-Test: Two-Sample Assuming Unequal Variances in Excel’s Data Analysis tool. Choose the appropriate test for this scenario and complete the analysis in Excel. Step-by-step directions for each of these tests are at the end of the respective sections in the book.

Solved by G. C. in 30 mins

: You must decide on the appropriate test for the difference between the two population means. the difference between two population means when the population standard deviations are known; that procedure is the z-Test: Two Sample for Means in Excel’s Data Analysis tool. hypothesis tests for the difference between two population means when the population standard deviations are unknown; that procedure is the t-Test: Two-Sample Assuming Unequal Variances in Excel’s Data Analysis tool. Choose the appropriate test for this scenario and complete the analysis in Excel.

Solved by E. E. in 29 mins

Create a table of means, standard deviations, and minimum and maximum values below

Solved by F. Q. in 11 mins

Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%].
Compare these outcome figures. How do the mean and SD change with sample size? [10%].

Solved by G. Q. in 15 mins

Question: calculate and present the mean and standard deviations for the two variables representing the proportions for knowledge questions and proportions for jelly bean estimates. Use a t-test and report the p-level.

Solved by M. D. in 19 mins

Now use the RANDBETWEEN function in Microsoft Excel to select two simple random samples of 10 days sample and 500 days sample from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [20%].

Solved by D. S. in 26 mins

In cell E11, calculate the number of monthly customers that would be 4 standard deviations from the mean. AutoFill the calculation down to E91.

Solved by M. Y. in 24 mins