MAD on portuguese excel

**nkleite** · 11-09-2014, 01:12 AM

Probably someone asked this earlier, but I´d like to know if anyone knows how to calculate median absolute deviation in Excel. I have tried MAD(), but this is not actually available for the portuguese version of MS-Office.
Cheers,
Nei

**MarvinP** · 11-09-2014, 01:50 AM

Here is an example:

http://www.spiderfinancial.com/suppo...tive-stats/mad

**nkleite** · 11-09-2014, 08:14 AM

Hi MarvinP, I have checked this site before, but Excel couldn't convert the function automatically into portuguese.

I think I'll have to make this mechanically.

Cheers,

Nei