exemple reg lin simple(1).xlsx

	A	B	C	D	E	F	G	H	J	K	L	N	O
1		0,7225
2
3
4		131,78
5		182
6
7		13,49073756
8
9
10
11
12
13		154,7303
14
15
16
17		0,8516754637
18
19
20
21
22		8,6747
23		8,688
24
25		-0,0133
26
27
28
29	obs	x (scol)	y (salaire)	xi-xbar	yi-ybar	carre xi-xbar	carre yi-ybar	cov	Ychap	Yi-Ychap	carre
30	1	6	4,4567	-6	-4,218007692	36	17,79158889	25,30804615	4,330127472	0,1265725278	0,01602060479	-4,34458022	18,87537729
31	2	7	5,77	-5	-2,904707692	25	8,437326776	14,52353846	5,054224176	0,7157758245	0,5123350309	-3,620483516	13,10790089
32	3	8	5,9787	-4	-2,696007692	16	7,268457475	10,78403077	5,778320879	0,2003791212	0,04015179221	-2,896386813	8,389056572
33	4	9	7,3317	-3	-1,343007692	9	1,803669661	4,029023076	6,502417582	0,8292824179	0,6877093286	-2,17229011	4,718844322
34	5	10	7,3182	-2	-1,356507692	4	1,840113118	2,713015384	7,226514285	0,09168571459	0,008406270261	-1,448193407	2,097264143
35	6	11	6,5844	-1	-2,090307692	1	4,369386247	2,090307692	7,950610989	-1,366210989	1,866532466	-0,7240967033	0,5243160357
36	7	12	7,8182	0	-0,856507692	0	0,7336054265	0	8,674707692	-0,856507692	0,7336054265	0	0
37	8	13	7,8351	1	-0,839607692	1	0,7049410765	-0,839607692	9,398804395	-1,563704395	2,445171436	0,7240967033	0,5243160357
38	9	14	11,0223	2	2,347592308	4	5,511189645	4,695184616	10,1229011	0,8993989014	0,8089183839	1,448193407	2,097264143
39	10	15	10,6738	3	1,999092308	9	3,996370056	5,997276924	10,8469978	-0,1731978019	0,02999747858	2,17229011	4,718844322
40	11	16	10,8361	4	2,161392308	16	4,671616709	8,645569232	11,57109451	-0,7349945052	0,5402169227	2,896386813	8,389056572
41	12	17	13,615	5	4,940292308	25	24,40648809	24,70146154	12,29519121	1,319808792	1,741895246	3,620483516	13,10790089
42	13	18	13,531	6	4,856292308	36	23,58357498	29,13775385	13,01928791	0,5117120882	0,2618492612	4,34458022	18,87537729
43	Moyenne	12	8,674707692			182	105,1183281	131,7856			9,692809647		95,4255185
44	ET	3,741657387	2,84359372				SCT				SCR
45		beta2	0,7240967033
46		beta1	-0,01445274756
47		SCT	105,11
48					R2	0,9077914402		0,9527808983
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100