220429_Examen.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Estudiante	NotaDeExamen	HorasDeEstudio_mins	y_i	x_i	y_i x_i	x_i^2	Y_^	error	error^2	y_i^2	X^2
2	1	60	120	-20	-201	4020	40401	60.82	-0.82	0.67	400	14400
3	2	80	300	0	-21	0	441	78.00	2.00	4.02	0	90000
4	3	85	350	5	29	145	841	82.77	2.23	4.98	25	122500
5	4	100	400	20	79	1580	6241	87.54	12.46	155.29	400	160000
6	5	90	375	10	54	540	2916	85.15	4.85	23.49	100	140625
7	6	70	200	-10	-121	1210	14641	68.45	1.55	2.39	100	40000
8	7	60	375	-20	54	-1080	2916	85.15	-25.15	632.67	400	140625
9	8	95	450	15	129	1935	16641	92.31	2.69	7.24	225	202500
10	9	75	250	-5	-71	355	5041	73.22	1.78	3.15	25	62500
11	10	85	390	5	69	345	4761	86.58	-1.58	2.51	25	152100
12	Suma	800	3210	0	0	9050	94840		0.00	836.41	1700.00	1125250.00
13	Promedio	80	321
14
15
16
17
18		y = a + bx
19		y = 49.1 + 0.10x
20
21		b = suma x_i y_i / suma x_i^2	0.10
22		a = promedio y - b * promedio x	49.4
23
24		R^2	50.80%
25
26		coefficiente de correlación	0.7127
27			0.7127
28
29		varianza residual	104.5517
30
31		varianza_a	124.0477131
32		varianza_b	0.001102401361
33
34		desviación estándar a	11.1376709
35		desviación estándar b	0.03320243004
36
37		t_a	4.43260872
38		t_b	2.874002646
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100