A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		LinReg
4
5		Category:	Mathematical Calculations
6		Family:	Statistics
7		Arguments:	LRSwitch, YValues, XValues
8		Meaning:	Linear Regression
9		Description:	Solves the slope and intercept of a Linear Regression problem.
10
11		XValues	1.16%	17.13%	18.09%	6.58%	4.71%	0.75%	12.23%	0.41%	3.06%
12		YValues	2.12%	13.84%	12.79%	6.87%	4.20%	2.41%	14.15%	1.22%	7.18%
13
14
15					LR Switch	LinReg	LinReg			EXCEL
16						Function	Array			Functions
17							Function
18		R Squared Correlation Coefficient				0.87	0.87			0.87
19		Intercept			1	2.24%	2.24%			2.24%
20		Slope			2	0.70	0.70			0.70
21		CoVariance			3	0.34%	0.34%			0.34%	*
22		Variance (y)			4	0.27%	0.27%			0.27%
23		Variance (x)			5	0.49%	0.49%			0.49%
24
25
26
27
28									* Excel's COVAR function returns the population,
29									not the sample, covariance.
30									We've adjusted it here.
31
32		Note:
33		n We generated the XValues and YValues input data using the Partial Depe
34		The formulae we used were:			Cell D11:	=RAND()/5
35					Cell D12:	=PartialDependency({-0.1,0,0.2}, D11, {-0.05,0,0.1}, {0,0.05,0.15}, {0.05,0.1,0.2}, 1)
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80