Computer Science Assignment work

Week4-CorrelationExamples.xlsx

Sheet1

	Var A	Var B
Student	GPA	Motovation		Correl =	0.641486711		0.641486711
Joe	2	50
Lisa	2	48
Mary	2	100
Sam	2	12							Height CM	Weight Kg
Deana	2.3	34							110	44
Sarah	2.6	30							116	31
Jennifer	2.6	78							124	43
Gregory	3	87							129	45
Thomas	3.1	84							131	56
Cindy	3.2	75							138	79
Martha	3.6	83							142	57
Steve	3.8	90							150	56
Jamell	3.8	90							153	58
Tammie	4	98							155	92
									156	78
									159	64
									164	88
		0.8463123788							168	112
									174	101
Height CM	Weight Kg
110	44		Correl	0.8463123788
116	31
124	43
129	45
131	56
138	79
142	57
150	56
153	58
155	92
156	78
159	64
164	88
168	112
174	101
			Correlation Matrix
Var a	Var b
1	2			Var1	Var2	Var3	Var4	Var5
1.2	3		Var1	1	0.33	0.22	0.44	0.66
1.5	3		Var2	0.8	1	0.44	0.66	0.67
2	4		Var3	0.7	0.44	1	0.77	0.2
3	5		Var4	0.5	0.66	0.55	1	0.1
1.2	3		Var5	0.44	0.77	0.77	0.88	1
1	2
2	3
4	2		V	B0 + B1X1 + B2X2+B3X3 + B4X4 + B5X5
1.5	3
4	5		Sales = Marketing + Price + Quality of the product + availablity
5	4
6	5
1	2
1	2

Motovation 2 2 2 2 2.2999999999999998 2.6 2.6 3 3.1 3.2 3.6 3.8 3.8 4 50 48 100 12 34 30 78 87 84 75 83 90 90 98

Weight Kg 110 116 124 129 131 138 142 150 153 155 156 159 164 168 174 44 31 43 45 56 79 57 56 58 92 78 64 88 112 101

Correlation Coefficients
Scatterplots
Correlation Matirx				Spearman corre = covar(a,b)/(std a * std)
			0.6425717704	0.6425717704
Student	GPA	Motovation	Covar	std dev GPA	std dev Moti
Joe	4	50	10.6571428571	0.6102859818	27.1760135834
Lisa	3	48
Mary	3	100	0.6425717704
Sam	2	12
Deana	2.3	34
Sarah	2.6	30
Jennifer	2.6	78
Gregory	3	87
Thomas	3.1	84
Cindy	3.2	75
Martha	3.6	83
Steve	3.8	90
Jamell	3.8	90
Tammie	4	98