Moving Average

[TexEth]

What is the Excel formula to compute the moving average? Thanks

Example:

Region	2000​	2001​	2002​	2003​	2004​		Moving Average (2002-2004)
AL	50​	60​	70​	80​	90​
AK	105​	106​	107​	108​	100​
AR	40​	43​	48​	53​	63​

 

[offthelip]

A simple moving average is just an average so the function needed is:
AVERAGE()
To get a moving average you just apply it to successive groups of cells, so for a 3 year moving average you can put this in cell g2 and copy it to h2 and i2
AVERAGE(B2:D2)
This gives you a 3 year moving average for the first line of data
All assuming the first column is A

 

[awoohaw]

something like this:

mr excel questions 17.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Region	2000	2001	2002	2003	2004		2000 - 2002	2001 - 2003	2002 - 2004
2	AL	50	60	70	80	90		60.00	70.00	80.00
3	AK	10	10	10	10	10		10.00	10.00	10.00
4	AR	40	43	48	53	63		43.67	48.00	54.67
TexEth

Cell Formulas
Range	Formula
H1:J1	H1	=B1& " - " & D1
H2:J4	H2	=AVERAGE(B2:D2)

 

[AhoyNC]

The attached link will show how to calculate a moving average using an Excel formula or using the "moving average" option in the Data Analysis.

https://www.statisticshowto.com/probability-and-statistics/statistics-definitions/moving-average/

 

[TexEth]

You confirmed my hunch. I appreciate your time and help.

Thank you!!