Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different length moving averages
Hello;
I have several thousand data points listed consecutively in column A of my spreadsheet. In column B, I am going to create a short term moving average. Then I am going to graph the average and study it. I have to repeat this task many times, with different length moving averages, because I am doing a "what-if" study to find the optimum length moving average. Is there a way to write an equation in the moving average cells that references a single value I supply in the top cell of the moving average column, so I don't have to cut and paste different length AVERAGE arguments in every single cell? I guess I'm trying to figure out how to write a macro that will take a number I supply and create that length moving average in all the cells of column B. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating moving averages.. | Excel Worksheet Functions | |||
moving averages | Charts and Charting in Excel | |||
How do I set up moving averages in exel | New Users to Excel | |||
Calculating dynamic moving averages | Excel Worksheet Functions | |||
Moving averages in Excel | Excel Discussion (Misc queries) |