How to Calculate Mean in Excel 2007

Microsoft Excel, a computer spreadsheet program, can be used by students and professionals to quickly calculate different aspects of a data set, such as the mean, also known as the average. The mean represents the sum of the values divided by the number of values. Using Excel to calculate the average allows you to change your data points to quickly see how the average would change. For example, if you calculated your average grade in a class, you could see how doing better or worse on an assignment would alter your grade.

Instructions

1. Enter your the data in column A. For example, if you have four numbers to enter, you would enter them in cells A1 through A4.

2. Determine the range for your data. For example, if you entered four data points, your range would be A1:A4.

3. Enter the formula "=AVERAGE(Range)" into cell B1 to have Excel automatically calculate the average of your data. In this example, since your range equals A1:A4, you would enter "=AVERAGE (A1:A4)" into cell B1 and the average will appear.

References

• University of Connecticut: Calculating the Mean and Standard Deviation with Excel