Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.

1] Using Data Analysis Tool Pack In this method, we will use the Data Analysis Tool Pack in Excel to calculate the moving average. MS Excel comes with a tool to calculate simple moving averages.

For example: Sales analysis: Apply the function to a vertical array of sales data to calculate monthly moving averages and identify trends.