Business Finance - Accounting assignment

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							a =	ERROR:#DIV/0!		b	J6
	2							b =	ERROR:#DIV/0!		DependentVariable	D5:D34
	3										Estimate	E5:E34
	4										EstimationError	F5:F34
	5							Estimator			IndependentVariable	C5:C34
	6							If x =			SquareOfError	G5:G34
	7										x	J10
	8							then y=	ERROR:#DIV/0!		y	J12
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30

Independent Variable

Dependent Variable