From the course: Excel: Market Research Strategies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Moving averages and product demand

Moving averages and product demand - Microsoft Excel Tutorial

From the course: Excel: Market Research Strategies

Start my 1-month free trial

Moving averages and product demand

“

- [Instructor] Moving averages are a simple but effective basic tool we can use to start understanding the level of demand that a particular product faces. Let's take a look at how we can apply this in excel. I'm in the 01_05_Begin excel file. Now we've done here is go through and take the forecasted level of demand for a hypothetical product, for a particular firm. In this case our hypothetical Red Tech 30, based on actual demands from the last few months. So perhaps we're trying to forecast total dollar sales, for instance, well, we've got dollar sales in October, November and December of 45,000 down through 26,000. I want to make this a little bit easier to read. So let's just quickly change the format here. So I'm going to highlight those three cells by holding down the shift key and then hitting the down arrow key three times. When I've done that, I'm now going to hold down Ctrl. and then the number one key, and then…

Contents