| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Empirical Rule for Data???
I have 3 columns of data and I have to use the empirical rule for all 3 columns to find the upper limits and get rid of all oulier data points. Is there any easy way to do this? -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=513905 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Empirical Rule for Data???
Hello ddawg09, Is each column a separate sample or total population, or are the columns one sample or a population? Is the upper limit Z-score 1 (68%) or something else? Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=513905 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Empirical Rule for Data???
Leith Ross Wrote: Hello ddawg09, Is each column a separate sample or total population, or are the columns one sample or a population? Is the upper limit Z-score 1 (68%) or something else? Sincerely, Leith Ross Yeah, each of my 3 columns is separate and so I have to use the Empirical Formula for all 3. I just wanted to see if there was an easier way then finding the average and standard dev. and then finding the % of points in each range. -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=513905 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Empirical Rule for Data???
Hello ddawg09, The Empirical Formula is dependent on a Normal (Gaussian) distribution. Excel has all the functions built in to solve for Standard Deviation, Average, and Normal Distrbution. Here is a list of Worksheet Formulas that should help make it easier. STDEV Finds Standard Deviation of a Population Sample (unbiased) STDEVP Finds the Standard Deviation of a Population AVERAGE Returns the Arithmetic Mean of a number series NORMDIST Returns the normal cumulative distribution for the specified mean and standard deviation. NORMSDIST Takes a Z value. Z is the value for which you want the distribution. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=513905 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill but with a custom rule?? | Excel Discussion (Misc queries) | |||
| How do I set a rule to add a number, but only if it is positive? | Excel Worksheet Functions | |||
| validation rule | Excel Worksheet Functions | |||
| How to edit in every cell with a common rule | Excel Discussion (Misc queries) | |||
Linear Mode
