The mean of a set of numbers is calculated using the harmonic mean.When there are outliers in the set of numbers, the mean is most appropriate.Most people are familiar with the method of calculating the arithmetic mean, in which the sum of values is divided by a number.The calculation of the mean is more difficult.If you work with a small set of numbers, you can use the formula to solve it.You can use Microsoft excel to find the mean.
Step 1: The formula for the mean should be set.
The formula is n1a1+1a2+3...
Step 2: Determine the values you need to find.
This can be any number.You need to find the mean for the numbers 10, 12, 16, and 8.
Step 3: The value of display style is plugged into the formula.
The number of values in your set will be equal to this.If you are looking for the mean of the numbers 10, 12, 16, and 8, the numerator of your formula will be 4:41a1
Step 4: Plug the values into your formula.
When you add the whole number to the formula, it becomes a fraction.If the values in your set are 10, 12, 16, and 8, you would place the fractions.
Step 5: The fractions should be in the denominator.
You can either use a calculator or hand it over.If you don't use a calculator, find a common denominator first.If you want to learn more about adding fractions, read Add Fractions.For example:4110+112+116+18 is a display style.
Step 6: The numerator should be divided by the denominator.
The same is true of dividing by a fraction.There is a display style called 4frac89240=40-24089.
Step 7: To find the mean of your numbers, convert to a decimal.
If you want to convert a fraction to a decimal, divide it by the numerator.The mean of the numbers 10, 12, 16, and 8 is 10.79.
Step 8: You can enter the values into your spreadsheet.
It's important to only place one value in each cell.If you need to find the mean of 10, 12, 16, and 8, you can type each of them into a separate cell in the spreadsheet.
Step 9: The function is for the mean.
The function is called HARMEAN(number 1, [number 2])Double-click on the function when it pops up if you want to select it from a blank cell.Double-clicking on the function will take you to cell A5 of the spreadsheet.
Step 10: The cells contain the values you are averaging.
The enter key needs to be hit.If you want to see the mean in the spreadsheet, you have to calculate it.Hit enter if you highlight cells A1-A4 of your spreadsheet.The mean will be calculated by the excel program.