How to Calculate the Geometric Mean

The Geometric Mean of a data set  is given by:

NB: The geometric mean of a data set is less than the data set's arithmetic mean unless all members of the data set are equal, in which case the geometric and arithmetic means are equal.

Worked Example

A maths tutor observed that during the last academic year a student increased his score by 20% in the first semester, 30% in the second semester and 50% in the third semester. What is the average increase in the performance of the student?

Solution 1

Arithmetic Mean

Solution 2

Geometric Mean

How to Calculate the Mean or Average ( Arithmetic Mean)

The mean is the average of the data set which is given by the sum of all measurements divided by the number of observations in the data set. 

The mean is given by the formula:

Worked Example

The amount of money spent daily on food by a certain family for a particular week were respectively as follows:

$65 , $45 , $ 40,  $45, $45, $ 50, $ 60.

Find how much the family expects to spend on food on a given day.

Solution

Using Microsoft Office Excel for Data Analysis - Overview of Microsoft Excel

Screenshot of Microsoft Excel Worksheet

Microsoft Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Office Excel , combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server, provides significant improvements for sharing data with greater security. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Microsoft Office Excel and Excel Services, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.

Create Better Spreadsheets

• Take advantage of the Office Fluent user interface
• Enjoy increased spreadsheet row and column capacity (1 million rows by 16,000 columns)
• Quickly format cells and tables
• Formulas authoring experience 
• Create professional-looking charts 
• Use Page Layout View 

Improve Spreadsheet Analysis

• Use conditional formatting 
• Sorting and filtering 
• Create a PivotTable or PivotChart view 
• Full support for Microsoft SQL Server Analysis Services

Share spreadsheets and business information with others

• Use Microsoft Office Excel and Excel Services to more securely share spreadsheets with others
• Create business dashboards from spreadsheets and share within a portal
• Save as XPS or PDF for easier sharing
• New Excel XML Format enables a more efficient exchange of information

Manage business information more effectively

• Centrally manage sensitive information by publishing spreadsheets to Office SharePoint Server
• Protect confidential business information 
• Connect to external sources of information using the Data Connection Library
• Take advantage of the Excel calculation engine in other applications

Source: Microsoft Office Excel Product Overview