Calculation of erratic samples in data row

**Ranpak** · 10-15-2009, 09:20 AM

Is there a way of calculation erratic samples in a data row?

Data analysis does not offer this function.

Ranpak

**Palmetto** · 10-15-2009, 09:25 AM

Could you post a sample workbook and provide a better explanation of what you mean?

**Ranpak** · 10-15-2009, 09:45 AM

e.g. data row: 4, 3, 5, 5, 1, 9, 6,

is 9 erratic?

Some statistical methods are available: Dixon method, Box-plot method

**shg** · 10-15-2009, 09:54 AM

See, for example, http://www.statisticaloutsourcingser...m/Outlier2.pdf.

Pick a method you like, and someone can help with formulas or code.

**Ranpak** · 10-28-2009, 04:49 AM

Thanks. Conclusion no direct statistical method available in Excel, mwhhhaa

Re: Calculation of erratic samples in data row