6.7 Visualizing Data Curriculum Page
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.
Answer
Formula: AVERAGE(J2:J88) Result: 705.2783563
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?
Answer
The dataset shows that there are more female than male butterflies. The data in the chart shows the percentage of male and female butterflies.
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?
Answer
The data in this chart shows the environment that the butterflies like to live in and the percentage of the butterflies that live there.
4. Activity 2) Come up with a 3rd question and use charting to answer it. Include the screenshot. What kind of data is in your chart?
Answer
What is the most common range of wingspans for the butterflies? The data in the chart shows the range of wingspans for the butterflies. The most common wingspans are 50.00-53.33.
5. (Activity 3) Include a screenshot and link of the map you created for this data.
Answer
https://drive.google.com/open?id=1rWx0YWyCVJ1DxFmivtaSXjFlQ1ZT93uP&usp=sharing