I have a formula that I have been manually calculating for too long. Recently, I have gotten most of it to calculate in vba which is great, but I still need help with the last two steps. The first one is that:
I need in M18 of a worksheet for vba to calculate a standard deviation off of 90% of the records in column L. Now column L will always have a different base size from file to file, but the records always start in L28 and go down x records, where x can be as little as one and as great as 1000. Column L is already sorted, and I want the 90% to only exclude the high results (or rather, the formula will always include L28)
For example if there are 10 respondents in row L, than I want the formula in M18 to be
=STDEV(L28:L36)
The standard deviation in "descriptive statistics" in "data analysis" is sample standard deviation not population SD. How can I get the population SD?
Hi all,
I have encountered a scenario that I need to calculate sample size out of a population of 10k. I heard that Excel can do it, but not too sure where to do it. Is it possible for Excel to do it?
Thanks!
How you do use excel to calculate a sample size using the population, error limit, confidence level and upper error limit rates?
Does anyone know of a fuction that will calculate the appropriate sample size for a value?
Hello
Im looking to do a study on how we evaluate sales ppl by their sales. usually, there is becoming a wide gap is what's reported and what transpires.
there are approx 175 employees, and so is it a fair estimate to use my sample size of 10%? yes i realize if i do a true sample size (stats), using confidence interval and standard dev.; i get a sample size of 121 based on my population of 175.
so i guess what im asking is, is 10% of the population a sufficient sample size to based a study on? i really appreciate the input thxs.
I am testing inventory records for accuracy. How many records do I have to
test before I can say with 98 % confidence that the sample results are the
same as the total would be had I tested them all?
I need to forecast commission estimates. I want to apply a range of results for orders per hour for say 50 agents, and apply that range of results to a different number of agents, so that the results have the same proportions, regardless of the number of agents that I plug in for the forecast. I realize there are probrably several ways to approach this.
any suggestions?
I am computing the average of anywhere from 5-10 numbers. When the numbers are not inserted there is nothing left in the cell. The problem is I get a value that is close to the average but not the real average. (Also the cells I am using are N37:Q41 for the first 5 samples which is constant the next 5 are not always constant W37:Z41) Here is the formula I am using:
=IF((W37="")+(W38="")+(W39="")+(W40="")+(W41=""),AVERAGE(N37:Q41),IF((W38="")+(W39="")+(W40="")+(W41=""),AVERAGE(N37:Q41,W37),IF((W39="")+(W40="")+(W41=""),AVERAGE(N37:Q41,W37:Z38),IF((W40="")+(W41=""),AVERAGE(N37:Q41,W37:Z39),IF(W41="",AVERAGE(N37:Q41,W37:Z40),AVERAGE(N37:Q41,W37:Z41))))))
I have the same problem with a standard deviation formula and the same group of numbers (I get something close but a few points off). Can not figure this out for the life of me. ??? Any help greatly appreciated!
=IF((W37="")+(W38="")+(W39="")+(W40="")+(W41=""),STDEV(N37:Q41),IF((W38="")+(W39="")+(W40="")+(W41=""),STDEV(N37:Q41,W37),IF((W39="")+(W40="")+(W41=""),STDEV(N37:Q41,W37:Z38),IF((W40="")+(W41=""),STDEV(N37:Q41,W37:Z39),IF(W41="",STDEV(N37:Q41,W37:Z40),STDEV(N37:Q41,W37:Z41))))))
