Analysis

1. What is the percentage of growth for base total stats each Generation?

There was a unique trend on the percentage growth between each Generation's base total stats. From Gen 1 to Gen 2, it would have -1% decrease and would increase at around 2% from Gen 2 to Gen 3. Then there would be more noticeable changes, where Gen 3 to Gen 4 would have base total stats increase to 7%. But then, it would decrease at -5% from Gen 4 Pokemon to Gen 5. Finally, from the crossing of Gen 5 to Gen 6 and Gen 6 to Gen 7, it would have the same 2% increase for base total stats.

2. Which type has the highest base stat total?

From all the types in Pokemon, the Dragon type came out with the highest base stat total. Averaging at 428.12 in base stat total across all Dragon type Pokemon. There were also some runner ups such as Ghost and Fairy types being in between 426-427 on average as well.

3. What are the 5 Pokemon with the lowest HP?

1. Shedinja (1 HP/Health)

2. Diglett (10 HP)

3. Magikarp (20 HP)

4. Pichu (20 HP)

5. Shuckle (20 HP)

*Runner ups for 5th place include Feebas, Duskull, and Mime Jr., who all have 20 HP as well.

4. What is the most common Pokemon type?

When adding each type together from both charts (left one for primary type and the right one for secondary type), Water turned out to be the most common one of them all, with a combined total of 131 Water types. With Normal types being a not-so close runner up at a total of 109.

5. (Complex) Do Legendary Pokemon show a significantly different Total Stat profile compared to Non-Legendary Pokemon, and does this difference vary across Generations?

Though the Non-Legendary Pokemon tend to come in large numbers than Legendary Pokemon in each generation, on average, Legendary Pokemon have consistently shown a significant total base stat difference than regular Pokemon.

***Link for further details on other generations: pokemon_dataset.csv.xlsx on Legendary Vs. Non-Legendary Worksheet and other Worksheets created for other questions

6. (Complex)Is there a strong correlation between a Pokémon's base total stats and its catch rate? 

There is a strong negative correlation. Due to the value being close to -1, this indicates a strong negative linear relationship where if the base total stats increases, the capture rate tends to decrease majorly.

7. (Complex) Which type is the strongest overall and which is the weakest?

When referring to question 2 and the image it has on this page, it was stated that Dragon types had the highest base stat total. Though this is true, it has more weaknesses than strengths (3:1 ratio). When it came down finding out which type was strongest overall, the best candidate for that title would go to Ground types due to having more strengths than weaknesses (5:3) and being on the top 5 types with the highest base stat total based on the image from question 2. When it came down to finding the weakest type, turns out the Bug type is the worst. It doesn't have the worst strength to weakness ratio (3:3), but it has the worst average base stat total (415.79).