Below is that statistics for sales of a particular product T

Below is that statistics for sales of a particular product. The manager wants to use a linear trend model to forcast the number of sales for February 2013.

a) provide the desired forecast based on a linear trend model. Show the linear trend equation

b) What percent of the variation in sales is explained by the linear trend model?

c)Calculate the MAD value for this linear trend model

Year	Month	Month Number	Calls Received
2010	Jan	1	23,500
	Feb	2	21,700
	Mar	3	18,750
	Apr	4	22,000
	May	5	23,000
	Jun	6	26,200
	Jul	7	27,300
	Aug	8	29,300
	Sep	9	31,200
	Oct	10	34,200
	Nov	11	39,500
	Dec	12	43,400
2011	Jan	13	23,500
	Feb	14	23,400
	Mar	15	21,400
	Apr	16	24,200
	May	17	26,900
	Jun	18	29,700
	Jul	19	31,100
	Aug	20	32,400
	Sep	21	34,500
	Oct	22	35,700
	Nov	23	42,000
	Dec	24	42,600
2012	Jan	25	31,000
	Feb	26	30,400
	Mar	27	29,800
	Apr	28	32,500
	May	29	34,500
	Jun	30	33,800
	Jul	31	34,200
	Aug	32	36,700
	Sep	33	39,700
	Oct	34	42,400
	Nov	35	43,600
	Dec	36	47,400

Regression Analysis

Regression Analysis

	r

Below is that statistics for sales of a particular product. The manager wants to use a linear trend model to forcast the number of sales for February 2013. a) p

Below is that statistics for sales of a particular product T

Solution

Get Help Now

Submit a Take Down Notice