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

need to use excel data analysis plug in for z score for one-tailed where you are not given the data set. have std dev, mean, and # of observations

Solved by D. A. in 30 mins

I need to calculate the median & mean number of calls to a lead before that lead was first marked as
interested?

Solved by V. F. in 13 mins

Trying to add something to a formula that will mean the cell remains blank until a figure is inputted?

Solved by S. Y. in 22 mins

Is there a formula to find a mean or median of the same column in multiple (≥200) sheets?

Solved by S. Q. in 27 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

What does this formula in April b5 mean =INDEX(C7:AF7,SUM(-1, MATCH(TRUE,INDEX(ISBLANK(C7:AF7),0),0))) - June!AF7

Solved by D. F. in 11 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

Trying one more time. I paid my $20.
I need to use Solver to find the activity time by using column F with (PSINormal formula) with a start date of 0 and the first finish date = start + activity time. Activity times can vary by 50% of their mean.

Solved by F. L. in 14 mins

Trying one more time. I paid my $20.
I need to use Solver to find the activity time by using column F with (PSINormal formula) with a start date of 0 and the first finish date = start + activity time. Activity times can vary by 50% of their mean.
I do not understand how you guys consider yourselves experts. Do any of you know how to use Excel Solver?

Solved by A. W. in 13 mins

Is it possible to sort a pivot table by a field that is included in the data source table but one that is not included in the pivot table itself? If the answer to this is 'no' then alternatively is their a way of including it (to be able to sort by it) and then hiding it as it is not needed in the pivot table (except only to be able sort by it - if you see what I mean)!

Solved by S. Q. in 27 mins