Jose Luis Excel
Jose Luis Excel
Jose Luis Excel
Li near (Y= 2+
-1.5 -2.5
20
-1 -1
-0.5 0.5 0
-10 -5 0 5 10 15 20 25 30 35
0 2 -20
0.5 3.5
X
1 5
1.5 6.5
2 8
2.5 9.5
3 11 DETERMINAR FUNCION
3.5 12.5
4 14
4.5 15.5
5 17 INDICAR MODELO Y R2
5.5 18.5
6 20
6.5 21.5
7 23
7.5 24.5
8 26
8.5 27.5
9 29
9.5 30.5
10 32
10.5 33.5
11 35
11.5 36.5
12 38
12.5 39.5
13 41
13.5 42.5
14 44
14.5 45.5
15 47
15.5 48.5
16 50
16.5 51.5
17 53
17.5 54.5
18 56
18.5 57.5
19 59
19.5 60.5
20 62
20.5 63.5
21 65
21.5 66.5
22 68
22.5 69.5
23 71
23.5 72.5
24 74
24.5 75.5
25 77
25.5 78.5
26 80
26.5 81.5
27 83
27.5 84.5
28 86
28.5 87.5
29 89
29.5 90.5
30 92
RCICIO 1
Y= 2+3X
Li near (Y= 2+3X)
35
FUNCION
LINEAL
1
EJERCICI
INDICAR MODELO Y R2
EJERCICIO 2
hart Title
Col umn C
Li near (Col umn C)
5 10 15
FUNCION
CUADRATICA
0.2033195
EJERCICIO
Y
-1.6 -9.4 R² = 0.5524354101
100000.0
-0.4 2.3 0.0
0.8 9.6 -15 -10 -5
-100000.0
0 5 10 15 20
2 54.0 -200000.0
3.2 376.0
X
4.4 1713.9
5.6 5602.0
6.8 14669.8
8 32940.0
9.2 66127.4 DETERMINAR FUNCION
10.4 121937.6
11.6 210365.3
12.8 343993.1
14 538290.0 INDICAR MODELO Y R2
EJERCICIO 3
Chart Title
0.0
0.0
0.0
0.0
Col umn C
0.0
14538.7179428571x + 25335.2201142857 Li near (Col umn C)
5524354101
0.0
0.0
0 5 10 15 20
0.0
0.0
FUNCION
CUADRATICA
0.55243541
EJERCICIO
FUNCION
intervalo -10 12
salto 1.2
X TABULAR Y GRAFICAR
-10 -24.6
-8.8 -22.3 Chart Title
-7.6 -20.1 30.0
-6.4 -17.9
f(x) =20.0
2.0575569853x - 3.6248661763
-5.2 -16.0 R² = 0.9559959447
-4 -14.5 10.0
-2.8 -15.9 0.0
Y
-1.6 5.3 -15 -10 -5 0 5 10 15 20
-10.0
-0.4 -1.7
0.8 -0.6 -20.0
2 1.3 -30.0
3.2 3.4
X
4.4 5.6
5.6 7.9
6.8 10.2
8 12.5
9.2 14.8 DETERMINAR FUNCION
10.4 17.2
11.6 19.6
12.8 21.9
14 24.3 INDICAR MODELO Y R2
EJERCICIO 4.1
Chart Title
0.0
2.0575569853x
0.0 - 3.6248661763
9559959447
0.0
Col umn C
0.0 Li near (Col umn C)
0 5 10 15 20
0.0
0.0
0.0
FUNCION
CUADRATICA
0.95599594
EJERCICIO
FUNCION
intervalo 4 12
salto 1.2
X TABULAR Y GRAFICAR
4 0.0
5.2 17.3 Chart Title
6.4 32.0 900.0
7.6 49.1 800.0
8.8 69.0 700.0
600.0 f(x) = 32.1211059342x - 213.797048066
10 91.7 R² = 0.9622485016
500.0
11.2 117.2
400.0
Y
12.4 145.5 300.0
13.6 176.8 200.0
14.8 210.9 100.0
0.0
16 247.9 0 5 10 15 20 25 30
17.2 287.7
X
18.4 330.5
19.6 376.1
20.8 424.6
22 475.9
23.2 530.2 DETERMINAR FUNCION
24.4 587.3
25.6 647.3
26.8 710.2
28 776.0 INDICAR MODELO Y R2
EJERCICIO 4.2
Chart Title
10 15 20 25 30
FUNCION
CUADRATICA
0.9622485
EJERCICIO
FUNCION
intervalo -10 12
salto 3
X TABULAR Y GRAFICAR
-10 -0.5
-7 -0.6 Chart Title
-4 -1.0 4.0
-1 -2.3 3.0
2 -4.5 2.0
5 2.7
Y
1.0
8 1.1 f(x) = 0.0209727818x - 0.4727445777
0.0
-20 -10 R² = 0.0827109808
11 0.7 -1.0 0 10 20 30 40 50 60
-2.0
14 0.5
-3.0
17 0.4
-4.0
20 0.3 -5.0
23 0.3 X
26 0.3
29 0.2
32 0.2
35 0.2
38 0.2 DETERMINAR FUNCION
41 0.2
44 0.1
47 0.1
50 0.1 INDICAR MODELO Y R2
EJERCICIO 4.3
Chart Title
FUNCION
CUADRATICA
0.08271098
EJERCI
FUNCION
intervalo 0 12
salto 1
X TABULAR Y GRAFICAR
0 1.0 1
1 1.7 3 Chart T
2 2.2 5 7.0
3 2.6 7 f(x) = 0.2458641289x + 1.86564681
6.0 R² = 0.9634593838
4 3.0 9
5.0
5 3.3 11
4.0
6 3.6 13
3.0
Y
7 3.9 15
2.0
8 4.1 17
1.0
9 4.4 19
0.0
10 4.6 21 0 5 10 15 20
11 4.8 23
X
12 5.0 25
13 5.2 27
14 5.4 29
15 5.6 31
16 5.7 33 DETERMINAR FUNCION
17 5.9 35
18 6.1 37
19 6.2 39
20 6.4 41 INDICAR MODELO Y R2
EJERCICIO 4.4
Chart Title
.0
f(x) = 0.2458641289x + 1.8656468103
.0 R² = 0.9634593838
.0
.0
Col umn C
.0 Li near (Col umn C)
.0
.0
.0
0 5 10 15 20 25
FUNCION
MINAR FUNCION
CUADRATICA
AR MODELO Y R2 0.96345938
EJERCICIO
FUNCION
intervalo -10 12
salto 1
X TABULAR Y GRAFICAR
-10 18216
-9 11760 Chart Title
-8 7182 25000
-7 4080
-6 2100 20000
-5 936 15000
-4 330
Y
10000
-3 72
-2 0 5000
f(x) = 64.8x + 4538
-1 0 R² = 0.0040874985
0
0 6 -15 -10 -5 0 5 10 15
1 0
X
2 12
3 120
4 450
5 1176
6 2520 DETERMINAR FUNCION
7 4752
8 8190
9 13200
10 20196 INDICAR MODELO Y R2
EJERCICIO 4.5
Chart Title
25000
20000
15000
Col umn C
10000 Li near (Col umn C)
5000
64.8x + 4538
0.0040874985
0
5 0 5 10 15
FUNCION
CUADRATICA
0.0040875
EJERCICIO
FUNCION
intervalo -10 12
salto 1
X TABULAR Y GRAFICAR
-10 1012
-9 630 Chart Title
-8 342 1500
-7 136 1000
-6 0 500
f(x) = - 104.6x - 274.6666666667
R² = 0.7011321165 0
-5 -78 -15 -10 -5
-500
0 5
-4 -110
Y
-1000
-3 -108 -1500
-2000
-2 -84 -2500
-1 -50 -3000
0 -18
1 0 X
2 -8
3 -54
4 -150
5 -308
6 -540 DETERMINAR FUNCION
7 -858
8 -1274
9 -1800
10 -2448 INDICAR MODELO Y R2
EJERCICIO 4.6
Chart Title
1500
1000
500
f(x) = - 104.6x - 274.6666666667
R² = 0.7011321165 0
-5 0 5 10 15
-500
-1000
-1500
-2000
-2500
-3000
X Col umn C
FUNCION
CUADRATICA
0.70113212
EJERCICIO 4.7
FUNCION
intervalo -10 12
salto 1
X TABULAR Y GRAFICAR Y
-10 15
-9 13 Chart Title
-8 12 20
-7 11 15
-6 10 f(x) = - 1.25x + 2.1875
R² = 1 10
-5 8 5
-4 7
Y
0
-15 -10 -5 0 5
-3 6 -5
-2 5 -10
-1 3 -15
0 2
1 1 X
2 0
3 -2
4 -3
5 -4
6 -5 DETERMINAR FUNCION
7 -7
8 -8
9 -9
10 -10 INDICAR MODELO Y R2
RCICIO 4.7
hart Title
20
15
2.1875
10
5
0
0 5 10 15
-5
-10
-15
X Col umn C
1.25 2.1875
-14.6875
FUNCION
CUADRATICA
1
EJERCICIO
FUNCION
intervalo -10 12
salto 1
X TABULAR Y GRAFICAR
-10 15
-9 13 Chart Title
-8 12 20
-7 11 15
-6 10 f(x) = - 1.25x + 2.1875
R² = 1 10
-5 8 5
-4 7
Y
0
-15 -10 -5 0 5
-3 6 -5
-2 5 -10
-1 3 -15
0 2
1 1 X
2 0
3 -2
4 -3
5 -4
6 -5 DETERMINAR FUNCION
7 -7
8 -8
9 -9
10 -10 INDICAR MODELO Y R2
EJERCICIO 4.8
Chart Title
20
15
f(x) = - 1.25x + 2.1875
R² = 1 10
5
0
-5 0 5 10 15
-5
-10
-15
X Col umn C
1.25
-14.6875
FUNCION
CUADRATICA
1
2.1875
EJERCICIO 4
FUNCION
intervalo 0 12
salto 1
X y TABULAR Y GRAFICAR
0 0
1 7 y
2 16
600
3 27
4 40 500
5 55 400
6 72
Axis Title
300
7 91
8 112 200
9 135
100
10 160
11 187 0
0 5 10 15 20
12 216 Axis Title
13 247
14 280
15 315
16 352 DETERMINAR FUNCION
17 391
18 432
19 475
20 520 INDICAR MODELO Y R2
EJERCICIO 4.9
y
Li near (y)
5 10 15 20 25
Axis Title 1.25
-2.1875
FUNCION
CUADRATICA
0.95868394
2.1875