HELP - difference of Average and median

[pentameggy]

HELP: how do i write a function usinf the worksheet function to fin
the difference between the average and the median of a data set??? an
help appriciated.

thanks!

megg

 

[ksnapp]

=average(THE RANGE YOU NEED TO ANALYZE)-MEDIAN(THE RANGE YOU NEED T
ANALYZE

 

[pentameggy]

how would i write it as a macro

 

[Guest]

assuming your data is in cells E1 to E7

=AVERAGE(E1:E7)-MEDIAN(E1:E7)


Alby

 

[JulieD]

Hi Meggy

as long as i'm not doing your home work for you????

Public Function MEDAVE(medrange As Range)

MEDAVE = Application.WorksheetFunction.Median(medrange) -
Application.WorksheetFunction.Average(medrange)

End Function

creates a function called MEDAVE

Cheers
JulieD