Exercício 3: Dada a Tabela 2 (peso e estatura coletados no início do ano em uma
turma do ensino médio).
54
INFORMÁTICA INSTRUMENTAL
UNIDADE 3 | PLANILHA ELETRÔNICA
1 64,0 1,58 51 83,0 1,58
2 54,7 1,58 52 56,0 1,58
3 80,0 1,61 53 53,0 1,61
4 64,3 1,71 54 64,3 1,75
5 60,8 1,65 55 64,0 1,65
6 62,5 1,72 56 62,5 1,47
7 110,0 1,74 57 130,0 1,74
8 63,6 1,75 58 63,6 1,77
9 92,0 1,68 59 65,0 1,68
10 70,0 1,72 60 80,0 1,72
11 61,0 1,58 61 63,0 1,59
12 54,7 1,59 62 52,0 1,58
13 90,0 1,62 63 50,0 1,61
14 64,3 1,80 64 64,3 1,75
15 66,0 1,65 65 69,0 1,65
16 62,5 1,66 66 63,0 1,72
17 64,0 1,74 67 134,0 1,74
18 64,0 1,75 68 63,6 1,74
19 94,0 1,68 69 65,0 1,68
20 75,0 1,72 70 85,0 1,72
21 64,0 1,58 71 84,0 1,58
22 54,7 1,59 72 58,0 1,58
23 67,0 1,61 73 54,0 1,61
24 64,3 1,72 74 64,3 1,76
25 65,0 1,65 75 62,0 1,65
26 62,5 1,56 76 62,5 1,50
27 59,0 1,74 77 66,0 1,74
28 65,0 1,75 78 63,6 1,70
29 95,0 1,68 79 65,0 1,79
30 76,0 1,72 80 88,0 1,72
31 68,0 1,58 81 60,7 1,60
32 54,7 1,60 82 54,7 1,58
33 54,0 1,61 83 55,0 1,61
34 64,3 1,73 84 64,3 1,70
35 67,0 1,65 85 60,8 1,65
36 62,5 1,58 86 62,5 1,72
37 63,0 1,75 87 63,0 1,74
38 65,5 1,75 88 63,6 1,75
39 97,0 1,68 89 66,0 1,68
40 77,0 1,72 90 87,0 1,72
41 80,0 1,58 91 60,7 1,57
42 55,0 1,58 92 54,7 1,58
43 98,0 1,63 93 52,5 1,61
44 64,3 1,74 94 64,3 1,70
45 90,0 1,65 95 60,8 1,65
46 62,5 1,59 96 62,5 1,72
47 120,0 1,74 97 65,0 1,74
48 63,0 1,75 98 63,6 1,75
49 66,0 1,68 99 65,0 1,67
50 78,0 1,72 100 89,0 1,72