Using the Average function you can easily calculate a series of averages or a moving average of the required interval of timeperiod of a given data range of 12 months sales. It is split into two parts one is 10 days in hometown and 5 days in the USA. Use your cursor to select the function and press the Tab Select the values you want to calculate the average C2C11 and press Enter.
To find out an average of certain numbers you can supply them directly in your Excel average formula.
To calculate a weighted average in Excel use SUMPRODUCT and SUM. Start by selecting the cell where you want the result to. The most commonly derived measure of central tendency is the simple average mean. You can calculate the moving average by using the following methods in Excel.