Atividade 4
Carolina Sanchez
09/11/2022
library(readxl)
library(flextable)
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionload("C:/Users/Carolina/Documents/TRABALHOS DE ESTATISTICA/Base_de_dados-master/df_pokemon.RData")
pokemon <- df
pokemon## # A tibble: 718 x 22
## id pokemon species_id height weight base_experience type_1 type_2 attack
## <dbl> <chr> <int> <int> <int> <int> <chr> <chr> <int>
## 1 1 bulbasaur 1 7 69 64 grass poison 49
## 2 2 ivysaur 2 10 130 142 grass poison 62
## 3 3 venusaur 3 20 1000 236 grass poison 82
## 4 4 charmand~ 4 6 85 62 fire <NA> 52
## 5 5 charmele~ 5 11 190 142 fire <NA> 64
## 6 6 charizard 6 17 905 240 fire flying 84
## 7 7 squirtle 7 5 90 63 water <NA> 48
## 8 8 wartortle 8 10 225 142 water <NA> 63
## 9 9 blastoise 9 16 855 239 water <NA> 83
## 10 10 caterpie 10 3 29 39 bug <NA> 30
## # ... with 708 more rows, and 13 more variables: defense <int>, hp <int>,
## # special_attack <int>, special_defense <int>, speed <int>, color_1 <chr>,
## # color_2 <chr>, color_f <chr>, egg_group_1 <chr>, egg_group_2 <chr>,
## # url_image <chr>, x <dbl>, y <dbl>data.frame(pokemon$type_1, pokemon$special_attack)## pokemon.type_1 pokemon.special_attack
## 1 grass 65
## 2 grass 80
## 3 grass 100
## 4 fire 60
## 5 fire 80
## 6 fire 109
## 7 water 50
## 8 water 65
## 9 water 85
## 10 bug 20
## 11 bug 25
## 12 bug 90
## 13 bug 20
## 14 bug 25
## 15 bug 45
## 16 normal 35
## 17 normal 50
## 18 normal 70
## 19 normal 25
## 20 normal 50
## 21 normal 31
## 22 normal 61
## 23 poison 40
## 24 poison 65
## 25 electric 50
## 26 electric 90
## 27 ground 20
## 28 ground 45
## 29 poison 40
## 30 poison 55
## 31 poison 75
## 32 poison 40
## 33 poison 55
## 34 poison 85
## 35 fairy 60
## 36 fairy 95
## 37 fire 50
## 38 fire 81
## 39 normal 45
## 40 normal 85
## 41 poison 30
## 42 poison 65
## 43 grass 75
## 44 grass 85
## 45 grass 110
## 46 bug 45
## 47 bug 60
## 48 bug 40
## 49 bug 90
## 50 ground 35
## 51 ground 50
## 52 normal 40
## 53 normal 65
## 54 water 65
## 55 water 95
## 56 fighting 35
## 57 fighting 60
## 58 fire 70
## 59 fire 100
## 60 water 40
## 61 water 50
## 62 water 70
## 63 psychic 105
## 64 psychic 120
## 65 psychic 135
## 66 fighting 35
## 67 fighting 50
## 68 fighting 65
## 69 grass 70
## 70 grass 85
## 71 grass 100
## 72 water 50
## 73 water 80
## 74 rock 30
## 75 rock 45
## 76 rock 55
## 77 fire 65
## 78 fire 80
## 79 water 40
## 80 water 100
## 81 electric 95
## 82 electric 120
## 83 normal 58
## 84 normal 35
## 85 normal 60
## 86 water 45
## 87 water 70
## 88 poison 40
## 89 poison 65
## 90 water 45
## 91 water 85
## 92 ghost 100
## 93 ghost 115
## 94 ghost 130
## 95 rock 30
## 96 psychic 43
## 97 psychic 73
## 98 water 25
## 99 water 50
## 100 electric 55
## 101 electric 80
## 102 grass 60
## 103 grass 125
## 104 ground 40
## 105 ground 50
## 106 fighting 35
## 107 fighting 35
## 108 normal 60
## 109 poison 60
## 110 poison 85
## 111 ground 30
## 112 ground 45
## 113 normal 35
## 114 grass 100
## 115 normal 40
## 116 water 70
## 117 water 95
## 118 water 35
## 119 water 65
## 120 water 70
## 121 water 100
## 122 psychic 100
## 123 bug 55
## 124 ice 115
## 125 electric 95
## 126 fire 100
## 127 bug 55
## 128 normal 40
## 129 water 15
## 130 water 60
## 131 water 85
## 132 normal 48
## 133 normal 45
## 134 water 110
## 135 electric 110
## 136 fire 95
## 137 normal 85
## 138 rock 90
## 139 rock 115
## 140 rock 55
## 141 rock 65
## 142 rock 60
## 143 normal 65
## 144 ice 95
## 145 electric 125
## 146 fire 125
## 147 dragon 50
## 148 dragon 70
## 149 dragon 100
## 150 psychic 154
## 151 psychic 100
## 152 grass 49
## 153 grass 63
## 154 grass 83
## 155 fire 60
## 156 fire 80
## 157 fire 109
## 158 water 44
## 159 water 59
## 160 water 79
## 161 normal 35
## 162 normal 45
## 163 normal 36
## 164 normal 76
## 165 bug 40
## 166 bug 55
## 167 bug 40
## 168 bug 60
## 169 poison 70
## 170 water 56
## 171 water 76
## 172 electric 35
## 173 fairy 45
## 174 normal 40
## 175 fairy 40
## 176 fairy 80
## 177 psychic 70
## 178 psychic 95
## 179 electric 65
## 180 electric 80
## 181 electric 115
## 182 grass 90
## 183 water 20
## 184 water 60
## 185 rock 30
## 186 water 90
## 187 grass 35
## 188 grass 45
## 189 grass 55
## 190 normal 40
## 191 grass 30
## 192 grass 105
## 193 bug 75
## 194 water 25
## 195 water 65
## 196 psychic 130
## 197 dark 60
## 198 dark 85
## 199 water 100
## 200 ghost 85
## 201 psychic 72
## 202 psychic 33
## 203 normal 90
## 204 bug 35
## 205 bug 60
## 206 normal 65
## 207 ground 35
## 208 steel 55
## 209 fairy 40
## 210 fairy 60
## 211 water 55
## 212 bug 55
## 213 bug 10
## 214 bug 40
## 215 dark 35
## 216 normal 50
## 217 normal 75
## 218 fire 70
## 219 fire 80
## 220 ice 30
## 221 ice 60
## 222 water 65
## 223 water 65
## 224 water 105
## 225 ice 65
## 226 water 80
## 227 steel 40
## 228 dark 80
## 229 dark 110
## 230 water 95
## 231 ground 40
## 232 ground 60
## 233 normal 105
## 234 normal 85
## 235 normal 20
## 236 fighting 35
## 237 fighting 35
## 238 ice 85
## 239 electric 65
## 240 fire 70
## 241 normal 40
## 242 normal 75
## 243 electric 115
## 244 fire 90
## 245 water 90
## 246 rock 45
## 247 rock 65
## 248 rock 95
## 249 psychic 90
## 250 fire 110
## 251 psychic 100
## 252 grass 65
## 253 grass 85
## 254 grass 105
## 255 fire 70
## 256 fire 85
## 257 fire 110
## 258 water 50
## 259 water 60
## 260 water 85
## 261 dark 30
## 262 dark 60
## 263 normal 30
## 264 normal 50
## 265 bug 20
## 266 bug 25
## 267 bug 100
## 268 bug 25
## 269 bug 50
## 270 water 40
## 271 water 60
## 272 water 90
## 273 grass 30
## 274 grass 60
## 275 grass 90
## 276 normal 30
## 277 normal 50
## 278 water 55
## 279 water 85
## 280 psychic 45
## 281 psychic 65
## 282 psychic 125
## 283 bug 50
## 284 bug 80
## 285 grass 40
## 286 grass 60
## 287 normal 35
## 288 normal 55
## 289 normal 95
## 290 bug 30
## 291 bug 50
## 292 bug 30
## 293 normal 51
## 294 normal 71
## 295 normal 91
## 296 fighting 20
## 297 fighting 40
## 298 normal 20
## 299 rock 45
## 300 normal 35
## 301 normal 55
## 302 dark 65
## 303 steel 55
## 304 steel 40
## 305 steel 50
## 306 steel 60
## 307 fighting 40
## 308 fighting 60
## 309 electric 65
## 310 electric 105
## 311 electric 85
## 312 electric 75
## 313 bug 47
## 314 bug 73
## 315 grass 100
## 316 poison 43
## 317 poison 73
## 318 water 65
## 319 water 95
## 320 water 70
## 321 water 90
## 322 fire 65
## 323 fire 105
## 324 fire 85
## 325 psychic 70
## 326 psychic 90
## 327 normal 60
## 328 ground 45
## 329 ground 50
## 330 ground 80
## 331 grass 85
## 332 grass 115
## 333 normal 40
## 334 dragon 70
## 335 normal 60
## 336 poison 100
## 337 rock 95
## 338 rock 55
## 339 water 46
## 340 water 76
## 341 water 50
## 342 water 90
## 343 ground 40
## 344 ground 70
## 345 rock 61
## 346 rock 81
## 347 rock 40
## 348 rock 70
## 349 water 10
## 350 water 100
## 351 normal 70
## 352 normal 60
## 353 ghost 63
## 354 ghost 83
## 355 ghost 30
## 356 ghost 60
## 357 grass 72
## 358 psychic 95
## 359 dark 75
## 360 psychic 23
## 361 ice 50
## 362 ice 80
## 363 ice 55
## 364 ice 75
## 365 ice 95
## 366 water 74
## 367 water 94
## 368 water 114
## 369 water 45
## 370 water 40
## 371 dragon 40
## 372 dragon 60
## 373 dragon 110
## 374 steel 35
## 375 steel 55
## 376 steel 95
## 377 rock 50
## 378 ice 100
## 379 steel 75
## 380 dragon 110
## 381 dragon 130
## 382 water 150
## 383 ground 100
## 384 dragon 150
## 385 steel 100
## 386 psychic 150
## 387 grass 45
## 388 grass 55
## 389 grass 75
## 390 fire 58
## 391 fire 78
## 392 fire 104
## 393 water 61
## 394 water 81
## 395 water 111
## 396 normal 30
## 397 normal 40
## 398 normal 50
## 399 normal 35
## 400 normal 55
## 401 bug 25
## 402 bug 55
## 403 electric 40
## 404 electric 60
## 405 electric 95
## 406 grass 50
## 407 grass 125
## 408 rock 30
## 409 rock 65
## 410 rock 42
## 411 rock 47
## 412 bug 29
## 413 bug 79
## 414 bug 94
## 415 bug 30
## 416 bug 80
## 417 electric 45
## 418 water 60
## 419 water 85
## 420 grass 62
## 421 grass 87
## 422 water 57
## 423 water 92
## 424 normal 60
## 425 ghost 60
## 426 ghost 90
## 427 normal 44
## 428 normal 54
## 429 ghost 105
## 430 dark 105
## 431 normal 42
## 432 normal 64
## 433 psychic 65
## 434 poison 41
## 435 poison 71
## 436 steel 24
## 437 steel 79
## 438 rock 10
## 439 psychic 70
## 440 normal 15
## 441 normal 92
## 442 ghost 92
## 443 dragon 40
## 444 dragon 50
## 445 dragon 80
## 446 normal 40
## 447 fighting 35
## 448 fighting 115
## 449 ground 38
## 450 ground 68
## 451 poison 30
## 452 poison 60
## 453 poison 61
## 454 poison 86
## 455 grass 90
## 456 water 49
## 457 water 69
## 458 water 60
## 459 grass 62
## 460 grass 92
## 461 dark 45
## 462 electric 130
## 463 normal 80
## 464 ground 55
## 465 grass 110
## 466 electric 95
## 467 fire 125
## 468 fairy 120
## 469 bug 116
## 470 grass 60
## 471 ice 130
## 472 ground 45
## 473 ice 70
## 474 normal 135
## 475 psychic 65
## 476 rock 75
## 477 ghost 65
## 478 ice 80
## 479 electric 95
## 480 psychic 75
## 481 psychic 105
## 482 psychic 125
## 483 steel 150
## 484 water 150
## 485 fire 130
## 486 normal 80
## 487 ghost 100
## 488 psychic 75
## 489 water 80
## 490 water 100
## 491 dark 135
## 492 grass 100
## 493 normal 120
## 494 psychic 100
## 495 grass 45
## 496 grass 60
## 497 grass 75
## 498 fire 45
## 499 fire 70
## 500 fire 100
## 501 water 63
## 502 water 83
## 503 water 108
## 504 normal 35
## 505 normal 60
## 506 normal 25
## 507 normal 35
## 508 normal 45
## 509 dark 50
## 510 dark 88
## 511 grass 53
## 512 grass 98
## 513 fire 53
## 514 fire 98
## 515 water 53
## 516 water 98
## 517 psychic 67
## 518 psychic 107
## 519 normal 36
## 520 normal 50
## 521 normal 65
## 522 electric 50
## 523 electric 80
## 524 rock 25
## 525 rock 50
## 526 rock 60
## 527 psychic 55
## 528 psychic 77
## 529 ground 30
## 530 ground 50
## 531 normal 60
## 532 fighting 25
## 533 fighting 40
## 534 fighting 55
## 535 water 50
## 536 water 65
## 537 water 85
## 538 fighting 30
## 539 fighting 30
## 540 bug 40
## 541 bug 50
## 542 bug 70
## 543 bug 30
## 544 bug 40
## 545 bug 55
## 546 grass 37
## 547 grass 77
## 548 grass 70
## 549 grass 110
## 550 water 80
## 551 ground 35
## 552 ground 45
## 553 ground 65
## 554 fire 15
## 555 fire 30
## 556 grass 106
## 557 bug 35
## 558 bug 65
## 559 dark 35
## 560 dark 45
## 561 psychic 103
## 562 ghost 55
## 563 ghost 95
## 564 water 53
## 565 water 83
## 566 rock 74
## 567 rock 112
## 568 poison 40
## 569 poison 60
## 570 dark 80
## 571 dark 120
## 572 normal 40
## 573 normal 65
## 574 psychic 55
## 575 psychic 75
## 576 psychic 95
## 577 psychic 105
## 578 psychic 125
## 579 psychic 125
## 580 water 44
## 581 water 87
## 582 ice 65
## 583 ice 80
## 584 ice 110
## 585 normal 40
## 586 normal 60
## 587 electric 75
## 588 bug 40
## 589 bug 60
## 590 grass 55
## 591 grass 85
## 592 water 65
## 593 water 85
## 594 water 40
## 595 bug 57
## 596 bug 97
## 597 grass 24
## 598 grass 54
## 599 steel 45
## 600 steel 70
## 601 steel 70
## 602 electric 45
## 603 electric 75
## 604 electric 105
## 605 psychic 85
## 606 psychic 125
## 607 ghost 65
## 608 ghost 95
## 609 ghost 145
## 610 dragon 30
## 611 dragon 40
## 612 dragon 60
## 613 ice 60
## 614 ice 70
## 615 ice 95
## 616 bug 40
## 617 bug 100
## 618 ground 81
## 619 fighting 55
## 620 fighting 95
## 621 dragon 60
## 622 ground 35
## 623 ground 55
## 624 dark 40
## 625 dark 60
## 626 normal 40
## 627 normal 37
## 628 normal 57
## 629 dark 45
## 630 dark 55
## 631 fire 105
## 632 bug 48
## 633 dark 45
## 634 dark 65
## 635 dark 125
## 636 bug 50
## 637 bug 135
## 638 steel 90
## 639 rock 72
## 640 grass 90
## 641 flying 125
## 642 electric 125
## 643 dragon 150
## 644 dragon 120
## 645 ground 115
## 646 dragon 130
## 647 water 129
## 648 normal 128
## 649 bug 120
## 650 grass 48
## 651 grass 56
## 652 grass 74
## 653 fire 62
## 654 fire 90
## 655 fire 114
## 656 water 62
## 657 water 83
## 658 water 103
## 659 normal 32
## 660 normal 50
## 661 normal 40
## 662 fire 56
## 663 fire 74
## 664 bug 27
## 665 bug 27
## 666 bug 90
## 667 fire 73
## 668 fire 109
## 669 fairy 61
## 670 fairy 75
## 671 fairy 112
## 672 grass 62
## 673 grass 97
## 674 fighting 46
## 675 fighting 69
## 676 normal 65
## 677 psychic 63
## 678 psychic 83
## 679 steel 35
## 680 steel 45
## 681 steel 50
## 682 fairy 63
## 683 fairy 99
## 684 fairy 59
## 685 fairy 85
## 686 dark 37
## 687 dark 68
## 688 rock 39
## 689 rock 54
## 690 poison 60
## 691 poison 97
## 692 water 58
## 693 water 120
## 694 electric 61
## 695 electric 109
## 696 rock 45
## 697 rock 69
## 698 rock 67
## 699 rock 99
## 700 fairy 110
## 701 fighting 74
## 702 electric 81
## 703 rock 50
## 704 dragon 55
## 705 dragon 83
## 706 dragon 110
## 707 steel 80
## 708 ghost 50
## 709 ghost 65
## 710 ghost 44
## 711 ghost 58
## 712 ice 32
## 713 ice 44
## 714 flying 45
## 715 flying 97
## 716 fairy 131
## 717 dark 131
## 718 dragon 81TABELA: ATAQUE ESPECIAL POR TIPO 1
pokemon %>%
select(type_1,special_attack) %>%
group_by(type_1) %>%
summarise(média=mean(special_attack),
mediana=median(special_attack),
desvio_padrão=sd(special_attack)) %>%
flextable() %>% theme_zebra()type_1 | média | mediana | desvio_padrão |
|---|---|---|---|
bug | 54.03175 | 50.0 | 27.31475 |
dark | 70.50000 | 62.5 | 31.37645 |
dragon | 82.45833 | 75.0 | 36.40948 |
electric | 83.08333 | 80.5 | 26.46332 |
fairy | 78.52941 | 75.0 | 28.54846 |
fighting | 48.56000 | 40.0 | 22.19812 |
fire | 82.45652 | 80.0 | 25.11282 |
flying | 89.00000 | 97.0 | 40.59557 |
ghost | 80.43478 | 83.0 | 28.33858 |
grass | 74.33333 | 74.5 | 24.57099 |
ground | 51.73333 | 45.0 | 20.97935 |
ice | 75.69565 | 75.0 | 25.58308 |
normal | 54.45161 | 50.0 | 22.87134 |
poison | 60.42857 | 60.0 | 19.32266 |
psychic | 89.30435 | 90.0 | 29.89528 |
rock | 59.05000 | 55.0 | 23.66752 |
steel | 63.54545 | 55.0 | 28.28886 |
water | 71.71429 | 70.0 | 25.98066 |
BOXPLOT: ATAQUE ESPECIAL POR TIPO 1
par(mar=c(9, 9, 3, 5), mgp=c(7,1,0))
boxplot( pokemon$special_attack ~ pokemon$type_1,
col=c("#4347fa","#17d17a"),
main="Gráfico 1 - Boxplot ataque especial por tipo de pokemon",
las=2,
ylab = "Ataque especial",
xlab = "Tipo 1" )
CONCLUSÃO
- No gráfico acima pode-se observar que apenas 7 tipos de pokemon possuem outliers, sendo eles bug, fighting, ground, normal, rock, steel e water. Ou seja, os tipos possuem valores discrepantes, indicando diferenças na distribuição de dados.
- Os tipos de pokemon sinalizados no gráfico de boxplot são assimétricos.
- A máxima do pokemon tipo psychic é maior que os outros tipos de pokemons.
- Os pontos de distribuição da máxima, minima, primeiro quartil, mediana e o terceiro quartil do pokemon tipo flying são maiores que todos os outros tipos de pokemons, porém a máxima do tipo flying é menor do que do tipo psychic.