Please try again later. Learn how to use Excel 2010 to calculate the mean (or average) and standard deviation of a range of data. You can do this for two sets of data so that you can compare them to see if they are similar or different. 1  Education. 2  Standard YouTube License.
http://www.youtube.com/watch?v=62i1fqKhNhg
The Excel GEOMEAN function calculates the geometric mean of a supplied set of values. The format of the function is : GEOMEAN(number1, [number2], ... ). Where the number arguments are 1 or more positive numeric values, for which you want to calculate the geometric mean. These arguments can be supplied to the function either directly, as the results of other formulas, or as references to cells containing numeric values.
http://www.excelfunctions.net/Excel-Geomean-Function.html
Use the Data Analysis Add-in. Excel comes with a Data Analysis add-in that displays a complete set of descriptive statistics about a data set, which includes the mean. Select the Data tab, choose the Analysis group and select Data Analysis..
http://www.ehow.com/how_6776563_calculate-mean-excel-2007.html
Use the STDEV function to compute the standard deviation. Place your cursor where you wish to have it appear. 2. Click on Formulas and select the Insert Function (fx) tab again.
http://www.wikihow.com/Calculate-Mean-and-Standard-Deviation-With-Excel-2007
For example, you can calculate the average value, or mean, of a data set using Excel's built-in AVERAGE function. You can also calculate the middle value, or median, and the most common value, or mode, using Excel functions with the same names.
http://www.ehow.com/how_6776563_calculate-mean-excel-2007.html
Geomean Function Example. Cell B1 of the above spreadsheet on the right shows a simple example of the Excel Geomean Function, used to calculate the geometric mean of the values in cells A1-A5. In this example, the Geomean function returns the value 1.622671112.
http://www.excelfunctions.net/Excel-Geomean-Function.html
1 Standard deviation — =STDEV(Cell range) → e.g, =STDEV(D4:D13). 2  Be sure to include the equal sign when using this method, as that is what indicates to Excel that what is contained in a cell is a formula.
http://www.wikihow.com/Calculate-Mean-and-Standard-Deviation-With-Excel-2007
1 Mean — =AVERAGE(Cell range) → e.g., =AVERAGE(D4:D13). 2  Standard deviation — =STDEV(Cell range) → e.g, =STDEV(D4:D13). 3  Be sure to include the equal sign when using this method, as that is what indicates to Excel that what is contained in a cell is a formula.
http://www.wikihow.com/Calculate-Mean-and-Standard-Deviation-With-Excel-2007
Tips. 1  Once you become comfortable using these functions, you can skip the process of using the Insert function feature, and instead simply type the formulas directly into the cells as follows: 2  Mean — =AVERAGE(Cell range) → e.g., =AVERAGE(D4:D13). 3  Standard deviation — =STDEV(Cell range) → e.g, =STDEV(D4:D13).
http://www.wikihow.com/Calculate-Mean-and-Standard-Deviation-With-Excel-2007
Type =AVERAGE(5, 87, 2, 6) without the quotation marks into a cell to display 25, the average of the four numbers. If the values are stored in column A, from A2 to A32, you can calculate the mean by typing the following into cell A33: =AVERAGE(A2:A32). Formulas for the median and mode use the same syntax. For example, type =MEDIAN(A2:A32) to calculate the median, and type =MODE(A2:A32) to calculate the mode for the same series of numbers.
http://www.ehow.com/how_6776563_calculate-mean-excel-2007.html
how do you find the mean on excel
If the values are stored in column A, from A2 to A32, you can calculate the mean by typing the following into cell A33: =AVERAGE(A2:A32).