Pregunta 1 17

17
18
18
18
18
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
20
20
20
20
20
20
20
21
21
21
21
21
21
21
21
21
21
22
22
22
22
22
22
22
22
 22
23
23
24
24
25
1.760682
Pregunta 2
Minutos
5
7
10
15
25
30
30
30
30
30
30
30
30
35
35
40
40
40
40
40
40
45
45
50
50
60
60
60
60
60
60
60
60
60
60
60
60
75
75
80
90
90
90
90
90
90
90
90
 90
90
90
100
117
120
120
120
Promedio: 59.267857
Desviación estándar 29.985749
Pregunta 3

2
2
3
3
3
4
5
5 Promedio 14.30909
5 Desviacion Estándar 7.85487
5
5
5
6
6
6
6
7
10
10
10
11
12
12
14
15
15
15
15
16
16
16
18
18
18
19
19
20
20
20
20
20
21
21
21
21
21
22
22
23
23
24
24
25
30
32
Pregunta 4

Horas de trabajo autonomo x Materias que está repitiendo Y

0 0
0 0
1 0
1 0
1 0
1 0
1 0
2 0
2 0
2 0
2 0
2 0
2 0
2 0
2 0
3 0
3 0
3 0
3 0
3 0
3 0
4 0
5 0
5 0
5 0
5 0
5 0
5 1
5 1
5 1
5 1
6 1
6 1
6 1
6 1
6 1
7 1
8 1
8 1
8 1
8 2
8 2
9 2
 9 2
10 2
10 2
10 3
15 3
15 3
20 3
20 3
24 4
25 4
35 4
40 20
7.4 1.30909090909091

Coeficiente de correlación 0.823307953391358

Por lo tanto, podemos decir que existe una correlación fuerte positiva.
X - X̄ Y-Ȳ (X - X̄ )(Y - Ȳ(X - X̄ )^2 (Y - Ȳ)^2
-7.4 -1.309091 9.687272727 54.76 1.713719
-7.4 -1.309091 9.687272727 54.76 1.713719
-6.4 -1.309091 8.378181818 40.96 1.713719
-6.4 -1.309091 8.378181818 40.96 1.713719
-6.4 -1.309091 8.378181818 40.96 1.713719
-6.4 -1.309091 8.378181818 40.96 1.713719
-6.4 -1.309091 8.378181818 40.96 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-5.4 -1.309091 7.069090909 29.16 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-4.4 -1.309091 5.76 19.36 1.713719
-3.4 -1.309091 4.450909091 11.56 1.713719
-2.4 -1.309091 3.141818182 5.76 1.713719
-2.4 -1.309091 3.141818182 5.76 1.713719
-2.4 -1.309091 3.141818182 5.76 1.713719
-2.4 -1.309091 3.141818182 5.76 1.713719
-2.4 -1.309091 3.141818182 5.76 1.713719
-2.4 -0.309091 0.741818182 5.76 0.095537
-2.4 -0.309091 0.741818182 5.76 0.095537
-2.4 -0.309091 0.741818182 5.76 0.095537
-2.4 -0.309091 0.741818182 5.76 0.095537
-1.4 -0.309091 0.432727273 1.96 0.095537
-1.4 -0.309091 0.432727273 1.96 0.095537
-1.4 -0.309091 0.432727273 1.96 0.095537
-1.4 -0.309091 0.432727273 1.96 0.095537
-1.4 -0.309091 0.432727273 1.96 0.095537
-0.4 -0.309091 0.123636364 0.16 0.095537
0.6 -0.309091 -0.18545455 0.36 0.095537
0.6 -0.309091 -0.18545455 0.36 0.095537
0.6 -0.309091 -0.18545455 0.36 0.095537
0.6 0.690909 0.414545455 0.36 0.477355
0.6 0.690909 0.414545455 0.36 0.477355
1.6 0.690909 1.105454545 2.56 0.477355
 1.6 0.690909 1.105454545 2.56 0.477355
2.6 0.690909 1.796363636 6.76 0.477355
2.6 0.690909 1.796363636 6.76 0.477355
2.6 1.690909 4.396363636 6.76 2.859174
7.6 1.690909 12.85090909 57.76 2.859174
7.6 1.690909 12.85090909 57.76 2.859174
12.6 1.690909 21.30545455 158.76 2.859174
12.6 1.690909 21.30545455 158.76 2.859174
16.6 2.690909 44.66909091 275.56 7.240992
17.6 2.690909 47.36 309.76 7.240992
27.6 2.690909 74.26909091 761.76 7.240992
32.6 18.69091 609.3236364 1062.76 349.3501
1032.2 3607.2 435.7455
Pregunta 5

Materias cursadas Horas de clase X - X̄ Y-Ȳ (X - X̄ )(Y - Ȳ(X - X̄ )^2 (Y - Ȳ)^2

1 2 -3.872727 -12.30909 47.66975207 14.99802 151.5137
1 2 -3.872727 -12.30909 47.66975207 14.99802 151.5137
1 3 -3.872727 -11.30909 43.79702479 14.99802 127.8955
1 3 -3.872727 -11.30909 43.79702479 14.99802 127.8955
1 3 -3.872727 -11.30909 43.79702479 14.99802 127.8955
1 4 -3.872727 -10.30909 39.92429752 14.99802 106.2774
1 5 -3.872727 -9.309091 36.05157025 14.99802 86.65917
1 5 -3.872727 -9.309091 36.05157025 14.99802 86.65917
1 5 -3.872727 -9.309091 36.05157025 14.99802 86.65917
2 5 -2.872727 -9.309091 26.74247934 8.252562 86.65917
2 5 -2.872727 -9.309091 26.74247934 8.252562 86.65917
3 5 -1.872727 -9.309091 17.43338843 3.507107 86.65917
3 6 -1.872727 -8.309091 15.56066116 3.507107 69.04099
3 6 -1.872727 -8.309091 15.56066116 3.507107 69.04099
4 6 -0.872727 -8.309091 7.251570248 0.761653 69.04099
4 6 -0.872727 -8.309091 7.251570248 0.761653 69.04099
4 7 -0.872727 -7.309091 6.378842975 0.761653 53.42281
4 10 -0.872727 -4.309091 3.760661157 0.761653 18.56826
4 10 -0.872727 -4.309091 3.760661157 0.761653 18.56826
5 10 0.127273 -4.309091 -0.54842975 0.016198 18.56826
5 11 0.127273 -3.309091 -0.42115702 0.016198 10.95008
5 12 0.127273 -2.309091 -0.2938843 0.016198 5.331901
5 12 0.127273 -2.309091 -0.2938843 0.016198 5.331901
5 14 0.127273 -0.309091 -0.03933884 0.016198 0.095537
5 15 0.127273 0.690909 0.087933884 0.016198 0.477355
5 15 0.127273 0.690909 0.087933884 0.016198 0.477355
5 15 0.127273 0.690909 0.087933884 0.016198 0.477355
5 15 0.127273 0.690909 0.087933884 0.016198 0.477355
5 16 0.127273 1.690909 0.215206612 0.016198 2.859174
5 16 0.127273 1.690909 0.215206612 0.016198 2.859174
5 16 0.127273 1.690909 0.215206612 0.016198 2.859174
5 18 0.127273 3.690909 0.469752066 0.016198 13.62281
5 18 0.127273 3.690909 0.469752066 0.016198 13.62281
6 18 1.127273 3.690909 4.160661157 1.270744 13.62281
6 19 1.127273 4.690909 5.287933884 1.270744 22.00463
6 19 1.127273 4.690909 5.287933884 1.270744 22.00463
6 20 1.127273 5.690909 6.415206612 1.270744 32.38645
6 20 1.127273 5.690909 6.415206612 1.270744 32.38645
6 20 1.127273 5.690909 6.415206612 1.270744 32.38645
6 20 1.127273 5.690909 6.415206612 1.270744 32.38645
6 20 1.127273 5.690909 6.415206612 1.270744 32.38645
6 21 1.127273 6.690909 7.542479339 1.270744 44.76826
6 21 1.127273 6.690909 7.542479339 1.270744 44.76826
7 21 2.127273 6.690909 14.23338843 4.525289 44.76826
 7 21 2.127273 6.690909 14.23338843 4.525289 44.76826
7 21 2.127273 6.690909 14.23338843 4.525289 44.76826
7 22 2.127273 7.690909 16.36066116 4.525289 59.15008
7 22 2.127273 7.690909 16.36066116 4.525289 59.15008
7 23 2.127273 8.690909 18.48793388 4.525289 75.5319
7 23 2.127273 8.690909 18.48793388 4.525289 75.5319
7 24 2.127273 9.690909 20.61520661 4.525289 93.91372
8 24 3.127273 9.690909 30.3061157 9.779835 93.91372
8 25 3.127273 10.69091 33.43338843 9.779835 114.2955
9 30 4.127273 15.69091 64.76066116 17.03438 246.2046
15 32 10.12727 17.69091 179.1606612 102.5617 312.9683
4.87272727272727 14.3090909091 1008.163636 354.1091

Hallamos la pendiente

La pendiente m es 2.84704251386

Calculamoes el valor de b

el valor de b es 0.43622920518

y=2,8470x+0,4362
 Chart Title
35
30
25
20
15
10
5
0
0 2 4 6 8 10 12 14 16

Column B
20
15
10
5
0
0 2 4 6 8 10 12 14 16

Column B