excel with all analysis

Average change

	Month	Visits	Change
2008	Jan	39
	Feb	41	2
	Mar	34	-7
	Apr	39	5
	May	38	-1
	Jun	19	-19
	Jul	28	9
	Aug	29	1
	Sep	37	8
	Oct	39	2
	Average	34.3	0
	Midpoint of changes		5
	Nov	34.3

Percent Average change

		visits	Percent change
2008	Jan	39
	Feb	41	5.13%
	Mar	34	-17.07%
	Apr	39	14.71%
	May	38	-2.56%
	Jun	19	-50.00%
	Jul	28	47.37%
	Aug	29	3.57%
	Sep	37	27.59%
	Oct	39	5.41%
	Average		3.79%
	November		40.48

Critical interval

Year	Month	Visits
2008	Jan	39
	Feb	41
	Mar	34
	Apr	39
	May	38
	Jun	19
	Jul	28
	Aug	29
	Sep	37
	Oct	39
	average	34.3
	std dev	6.9450221982
	Z-Crit	1.960
	LCL	20.6880066197
	UCL	48
	FM Nov	27

Moving Averages

Month	Visits	n=2	n=3	n=4	n=5	n=6	n=7	n=8	n=9	n=10
Jan	39
Feb	41
Mar	34	40
Apr	39	38	38
May	38	37	38	38
Jun	19	39	37	38	38
Jul	28	29	32	33	34	35
Aug	29	24	28	31	32	33	34
Sep	37	29	25	29	31	31	33	33
Oct	39	33	31	28	30	32	32	33	34
Nov		38	35	33	30	32	33	33	34	34

Exponential Smoothing.

Month	Visits	Forecast
Jan	39
Feb	41	ERROR:#N/A
Mar	34	39
Apr	39	40.2
May	38	36.48
Jun	19	37.992
Jul	28	37.9968
Aug	29	26.59872
Sep	37	27.439488
Oct	39	28.3757952
Nov		33.55031808

Exponential Smoothing

Forecast Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov #N/A 39 40.200000000000003 36.480000000000004 37.992000000000004 37.996800000000007 26.598720000000004 27.439488000000004 28.375795199999999 Visits Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 39 41 34 39 38 19 28 29 37 39

Month

Visits