7.03 Visualizing Data

7.3 Visualizing Data Curriculum Page

Activity 2: https://docs.google.com/spreadsheets/d/1ZKJO7hTUW6T_r6KUQ_ftyTTlBMakB-b4ztFCVm0EzHs/edit?usp=sharing

Activity 3: https://drive.google.com/open?id=1NMLhQqOMZ1Z-w3Jm0BY-uKfo7BNaz74S&usp=sharing

Visualizing Data: https://docs.google.com/document/d/1yASJfMzTvdD83Yr9ViBavH3DoqArLR7TAqESe14eBRU/edit?usp=sharing

1. (Activity 2) Write a spreadsheet formula that calculates the average elevation for the data in this spreadsheet. Write your formula and the result found in your portfolio.

Formula: =AVERAGE(J2:J88)

Result: 705.2873563

2. (Activity 2) Are there more male or female butterflies in this data set? Include a screenshot of your chart to answer this question. What kind of data is in your chart?

There are more females. This chart contains qualitative data on the percentage of males and females in the population.

3. (Activity 2) Which ecological environment (primary eco column) do these butterflies like to live in? There is no clear winner in this question so give the percentages in each ecological environment in a screenshot of your chart. What kind of data is in your chart?

The butterflies seem to prefer to live in cloud forests and rain forests, and do not like dry forests as much. This chart contains qualitative data on the percentage of butterflies from the population that live in each environment.

5. (Activity 3) Include a screenshot and link of the map you created for this data.