Average formula

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I need a formula that would look at a month's worth of
information and throw out any info that is unusual -
(st.Deviation?) I really only want business days.

Denise
 
You mean like putting this in column B

=IF(Abs((A1-Ave)/StdDev)>1,"This looks dodgy","")

I have assumed that the data is in column A, you calculated the average of
the data and put it in a cell named Ave, and you calculated the std dev and
put it in a cell named StdDev.

You can use the built-in formulae to calc average and std dev
 
Denise -
I need a formula that would look at a month's worth of information and
Click to expand...
throw out any info that is unusual - (st.Deviation?) I really only want
business days. <

I recommend plotting the data (e.g., histogram) so you can look at the data
to detect outliers.

Or, use a z-score ((value-mean)/std dev) for each data point to identify
possible outliers.

Less desirable: see the TRIMMEAN worksheet function.

- Mike Middleton, www.usfca.edu/~middleton
 
Back
Top