CUTTING EDGE CASE

Linear Regression

Template for Linear Regression
	Time	Independent	Dependent		Estimation	Square		Linear Regression Line			Range Name	Cells
	Period	Variable	Variable	Estimate	Error	of Error		y = a + bx			a	J5
	1	4,894	6,809	6,765	43.85	1,923		a =	-1,223.86		b	J6
	2	4,703	6,465	6,453	11.64	136		b =	1.63		DependentVariable	D5:D34
	3	4,748	6,569	6,527	42.18	1,780					Estimate	E5:E34
	4	5,844	8,266	8,316	49.93	2,493					EstimationError	F5:F34
	5	5,192	7,257	7,252	5.40	29		Estimator			IndependentVariable	C5:C34
	6	5,086	7,064	7,079	14.57	212		If x =	5,000		SquareOfError	G5:G34
	7	5,511	7,784	7,772	11.66	136					x	J10
	8	6,107	8,724	8,745	21.26	452		then y=	6,938.18		y	J12
	9	5,052	6,992	7,023	31.07	965
	10	4,985	6,822	6,914	91.70	8,408
	11	5,576	7,949	7,878	70.55	4,977
	12	6,647	9,650	9,627	23.24	540
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30

4894 4703 4748 5844 5192 5086 5511 6107 5052 4985 5576 6647 6809 6465 6569 8266 7257 7064 7784 8724 6992 6822 7949 9650

Independent Variable

Dependent Variable