Weighted moving average formula12/24/2023 ![]() Please note that weight values don't need to be normalized. Enter the WMA formula, and click the "fx" button.įor the weights, select the cell range that contains the weights. Next, let's do the same as before, but use a predefined set of weights. Plot the moving average and notice how it lags behind the sample data. Now, copy the formula to the other forecast points. Edit the formula to include only the cell range in the input data. Go to the end of the cell range and copy the formula to the next one. Next, let's do a simple forecast using the moving average. Now, copy the formula to the remaining cells. We need to change the input reference cell to include all data up to this point, so let's select all the data from the C4 to C5 cell. Drag the cell to copy the formula, then select the cell and click on the "fx" button. The function returned #N/A because we don't have enough data points. For the forecast time or horizon go ahead and type zero or reference the A4 cell. ![]() When the WMA function window pops up, specify the window size. As an example we'll be using monthly sales figures from a hypothetical company for the past 24 months, let's start now.įirst, I'll create a simple four month moving average, type the WMA formula in the tool bar and press on the "fx" button on the left. In this video we will demonstrate the use of the WMA function in NumXL to smooth out time series data and create a sample forecast. Welcome to the weighted moving average tutorial. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |