Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    MEAN function in Excel 2010

    Hi,

    I am pretty sure that I was able to use the MEAN function in Excel 2003 and in Excel 2007. However, I was not able to find it in Excel 2010. Does anyone know why it was left out and how I can add the MEAN function to the group of statistical functions in Excel 2010?

    Thank you.

    Moon

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    did you look for the average function

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Manchester, United Kingdom
    Posts
    116
    Thanks
    8
    Thanked 17 Times in 16 Posts
    No mean() in my 2003 or 2007 - are you sure you were not using a user-defined function or a statistics add-in?

    If you were, you need to copy over your old startup sheet or install the add-in. I know many people were unhappy with Excel's stats functions and such libraries were commonly used.

  4. #4
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Search for MEAN in Excel 2007 returns hits under Statistical Functions. Some examples:

    AVERAGE function
    Returns the average (arithmetic mean) of the arguments

    Also listed:
    AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
    AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
    GEOMEAN Returns the geometric mean
    HARMEAN Returns the harmonic mean

    HTH
    PJ in FL

  5. #5
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Thank you for your responses. I lthink that average is used instead of its synonym, mean.

Posting Permissions

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