Embedded Files
1. 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.
Answer
=AVERAGE(J1:J88)
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
See below
There are more female butterflies in this data set.
3. 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 ecological environment that these butterflies like to live in is the rainforest. See the attached image below (fig 2).
4. 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 prevalent species type? (see figure 3)
Species type is in my visualization.
5. Include a screenshot and link of the map you created for this data.
Answer
See fig 4
Google Sites
Report abuse