calculate mean square error

Question

the following table shows thenumber of public sector industries failures in india during the period of 2004-2010.  using i four year moving average method, calculate mean square error (MSE) for this data.

year	number of failures
2004	32
2005	26
2006	30
2007	28
2008	24
2009	22
2010	26

 

Answer 1

mueving yeer averaej =2 much werk

all the data (6 yeers):

sum=188

averaej=26.85714

raenj=10

varians=10.12245...(sum av squares av differ)/ (how many)

std deviashun=3.18158 = square root av varians

Answer 2

 

the following table shows thenumber of public sector industries failures in india during the period of 2004-2010.  using i four year moving average method, calculate mean square error (MSE) for this data.

year	number of failures
2004	32
2005	26
2006	30
2007	28
2008	24
2009	22
2010	26