Jose Luis Excel

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 28

EJERCICIO 1

FUNCION LINEAL f(x)=2+3X


intervalo -5 30
salto 0.5

X Y= 2+3X TABULAR Y GRAFICAR Y DAR FORMATO AL GR


-5 -13
-4.5 -11.5 Y= 2+3X
-4 -10 100
-3.5 -8.5 f(x) = 3x + 2
80
R² = 1
-3 -7
-2.5 -5.5 60
-2 -4 40
Y= 2+3X
Y

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

DAR FORMATO AL GRAFICO

Y= 2+3X
Li near (Y= 2+3X)

35

FUNCION
LINEAL

1
EJERCICI

FUNCION �(𝑥)= 3�^2+5X+4


intervalo -10 12
salto 1.25

X �= 3� ^�+5X+4 TABULAR Y GRAFICAR Y


-10 254.0
-8.75 189.9 Chart Title
-7.5 135.3 500.0
-6.25 89.9 450.0
-5 54.0 400.0
350.0
-3.75 27.4 300.0
-2.5 10.3 250.0
-1.25 2.4 Y 200.0+ 129
f(x) = 8.75x
R² = 0.2033195021
150.0
0 4.0 100.0
1.25 14.9 50.0
0.0
2.5 35.3 -15 -10 -5 0 5 10 15
3.75 64.9
X
5 104.0
6.25 152.4
7.5 210.3
8.75 277.4
10 354.0 DETERMINAR FUNCION
11.25 439.9

INDICAR MODELO Y R2
EJERCICIO 2

DAR FORMATO AL GRAFICO

hart Title

Col umn C
Li near (Col umn C)

5 10 15

FUNCION
CUADRATICA

0.2033195
EJERCICIO

�= 2�^�+ �^� +5X +4


FUNCION
intervalo -10 12
salto 1.2

X �= 2�^�+ �^� +5X+4


TABULAR Y GRAFICAR
-10 -99846.0
-8.8 -52658.3 Chart Title
-7.6 -25273.7 600000.0
-6.4 -10683.5 500000.0
-5.2 -3770.0 400000.0
-4 -1008.0 300000.0
-2.8 -166.4 200000.0
f(x) = 14538.7179428571x + 25335.2201142857

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

Y DAR FORMATO AL GRAFICO

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

Y DAR FORMATO AL GRAFICO

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

Y DAR FORMATO AL GRAFICO

Chart Title

f(x) = 32.1211059342x - 213.7970480664


R² = 0.9622485016
Col umn C
Li near (Col umn C)

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

Y DAR FORMATO AL GRAFICO

Chart Title

0209727818x - 0.4727445777 Col umn C


827109808
10 20 30 40 50 60 Li near (Col umn C)

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

AR Y GRAFICAR Y DAR FORMATO AL GRAFICO

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

Y DAR FORMATO AL GRAFICO

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

Y DAR FORMATO AL GRAFICO

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

DAR FORMATO AL GRAFICO

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

Y DAR FORMATO AL GRAFICO

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 DAR FORMATO AL GRAFICO

y
Li near (y)

5 10 15 20 25
Axis Title 1.25
-2.1875

FUNCION
CUADRATICA

0.95868394
2.1875

You might also like