# Thread: Mean Function (Excel 2003)

1. ## Mean Function (Excel 2003)

I was chatting with someone in the stats department recently, and they were chatting about excels median, mode and mean functions. A while later I went to check out these functions and could not find the mean function. Where is it? or is it under a different name? I notice Google simply refers to average. So I guess my question here would be to ask, "How would one work out the mean?"

TX

2. ## Re: Mean Function (Excel 2003)

For the "mean" Excel uses the more common name: "Average", even though technically the mean, mode, and median are are all "averages"

Steve

3. ## Re: Mean Function (Excel 2003)

I should be explict: AVERAGE gives the "arithmatic mean" (sum of items / number of items). There is also other less used means: geometric (the nth root of the product of the items), harmonic (number of points divided by the sum of the reciprocals) as well as others [See Mean - Wikipedia, the free encyclopedia for other ones]

Typically when "average" or "mean" is used they are are referring to the "aritmatic mean".

Steve

4. ## Re: Mean Function (Excel 2003)

Tx Steve.
Cheers

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•