How to calculate moving average in Excel

Moving average in Excel is used to see the trend of change, movement of a certain value over each period such as stocks, sales or certain data. With this moving average, the user can predict how it will develop, how it will go up or down. The following article will guide you to calculate a moving average in Excel.

Instructions for calculating moving average in Excel

Step 1:

First of all you need to click on File and then select Options to open the setup interface of Excel.

Step 2:

In this new interface, users click continue on Add-ins mục to choose to install additional utilities for Excel.

Click Add-ins in Excel

Looking at the content next to us we will see Manage item with Excel Add-ins content, friend Click Go to continue.

Excel Add-ins

Step 3:

Display the selection interface to install Add-in for Excel we click Analysis ToolPak and click Ok to install.

Click the Analysis ToolPak

Step 4:

You have returned to the interface on Excel Click on the Data tab, then you will see the option Data Analysis as below.

Data Analysis Excel

When clicking on this option will bring out data analysis tools, we click Moving Average then click OK to save.

Moving Average Excel

Step 5:

Now display the dialog interface for us to adjust. First at Input Range friend Click on the square icon to select the data area need to calculate the moving average.

Select Excel data range

Then below at Output Range, Click on any box to insert analysis data after that. Final press OK to perform calculations and data analysis.

Select output area data

Step 6:

The final result to display will show moving average as below, showing the trend of the subject in the past cycles.

Moving Average

You can also change the look of the moving average again, like when editing and changing the insert chart in Excel.

Change the moving average interface


Related Posts

Leave a Reply

Your email address will not be published.